UC知道jdbc更新oracle数据库的问题
来源：百度知道 编辑：UC知道 时间：2024/05/27 03:58:45
我用Preparedstement的setXXX方法存储数据时抛出异常：无效的列索引。
程序如下：
public class Test {
Connection conn;
Statement stmt;
PreparedStatement pstmt;
public static void main(String[] args) {
Test test = new Test();
try {
test.base();
test.insert();
} catch (SQLException e) {
e.printStackTrace();
}
}
private void insert() throws SQLException {
pstmt = conn.prepareStatement("insert into stu values");
pstmt.setInt(1,2);
pstmt.setString(2,"黄蓉");
pstmt.executeUpdate();
conn.commit();
}
public void base() throws SQLException{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl", "dbuser", "024420");
}
}
程序如下：
public class Test {
Connection conn;
Statement stmt;
PreparedStatement pstmt;
public static void main(String[] args) {
Test test = new Test();
try {
test.base();
test.insert();
} catch (SQLException e) {
e.printStackTrace();
}
}
private void insert() throws SQLException {
pstmt = conn.prepareStatement("insert into stu values");
pstmt.setInt(1,2);
pstmt.setString(2,"黄蓉");
pstmt.executeUpdate();
conn.commit();
}
public void base() throws SQLException{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl", "dbuser", "024420");
}
}
pstmt = conn.prepareStatement("insert into stu(xx,yy) values (?,?)");
pstmt.setInt(1,2);//1指第一个问号
pstmt.setString(2,"黄蓉");//2指第二个问号
不知道你的数据库里叫什么，我就用 xx yy代替 你自己改