java:sql的后赋值问题

如果使用预编译的SQL语句

例如：

public void test() throws SQLException {
Connection connection = null;
PreparedStatement pstm = null;
connection = DriverManager.getConnection("jdbc:mysql://121.89.220.197:3306/smbms?useUnicode=true&characterEncoding=utf-8","root","123456");

String sql = "update smbms_user set userPassword = ? where id = ?";
Object[] params = {"123456789",1};

pstm = connection.prepareStatement(sql);
for (int i = 0; i < params.length; i++) {
pstm.setObject(i+1,params[i]);
}
int i = pstm.executeUpdate();//在这里需要注意两点：1,保证重载的函数正确，2.在函数executeUpdate()里面没有参数
System.out.println(i);

}

 

 

------------恢复内容开始------------

如果使用预编译的SQL语句

例如：

public void test() throws SQLException {
Connection connection = null;
PreparedStatement pstm = null;
connection = DriverManager.getConnection("jdbc:mysql://121.89.220.197:3306/smbms?useUnicode=true&characterEncoding=utf-8","root","123456");

String sql = "update smbms_user set userPassword = ? where id = ?";
Object[] params = {"123456789",1};

pstm = connection.prepareStatement(sql);
for (int i = 0; i < params.length; i++) {
pstm.setObject(i+1,params[i]);
}
int i = pstm.executeUpdate();//在这里需要注意两点：1,保证重载的函数正确，2.在函数executeUpdate()里面没有参数
System.out.println(i);

}

 

 

------------恢复内容结束------------