pstmt=con.prepareStatement("insert into testgo(?,name) values(?,?)"); pstme.setString(1,"id");
pstmt.setInt(2,55);
pstmt.setString(3,"xiedang");
这段代码运行时候出错,而改成以下代码却可以 pstmt=con.prepareStatement("insert into testgo(id,name) values(?,?)");
pstmt.setInt(1,55);
pstmt.setString(2,"xiedang");是怎么回事呢?
pstmt.setInt(2,55);
pstmt.setString(3,"xiedang");
这段代码运行时候出错,而改成以下代码却可以 pstmt=con.prepareStatement("insert into testgo(id,name) values(?,?)");
pstmt.setInt(1,55);
pstmt.setString(2,"xiedang");是怎么回事呢?
字段名是不可以拿来set的吧,value值可以,你试试
pstmt=con.prepareStatement("insert into testgo(id,name) values(?,?)");pstmt.setInt(1,55);
pstmt.setString(2,"xiedang");
pstmt.addBatch();
pstmt.executeBatch();
conn.commit();