Question

java.sql.SQLException: 无效的列索引

public class DynamicCrud {
public static void main(String[] args) {
DynamicCrud dc = new DynamicCrud();
dc.add("中文",30);

}
Connection conn;
public void add(String name, int age) {
conn = ConnectionUtil.getOracleConn();
String sql = "insert into student1 (name,age) values (name=?,age=?)";
try {
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(2, name);
ps.setInt(3, age);
ps.execute();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

Answer 1

String sql = "insert into student1 (name,age) values (name=?,age=?)";--此处就指定了两个？
try {
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(2, name);--这个地方和
ps.setInt(3, age);--这个地方就错了哦
ps.execute();
应该改成：
ps.setString(1,name);--这个地方和
ps.setInt(2, age);--这个地方就错了哦

Answer 2

ps.setString(2, name);
ps.setInt(3, age);
你这个地方写错了，你一共就两个？，应该是
ps.setString(1, name);
ps.setInt(2, age);