ps.setObject(1 + i, params[i]) 参数设置不进去

[qq_28114887]

public int executeDML(String sql, Object... params) {
Connection conn = DBManager.getConn();
int count = 0;
PreparedStatement ps = null;
try {
ps = conn.prepareStatement(sql);
// ps.setObject(1,2 ); 参数可以设置进去
if (params != null) {
for (int i = 0; i < params.length; i++) {
ps.setObject(1 + i, params[i]);
}
System.out.println(ps);
count = ps.executeUpdate();

}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBManager.close(ps, conn);
}
return count;
}

控制台
com.mysql.jdbc.JDBC42PreparedStatement@6d5380c2: delete from emp where id=** STREAM DATA **

[bcsflilong]

能执行吗 正常应该可以设置进去

[qq_28114887]

能看到值 但是 sql里面 还是没有。。

com.mysql.jdbc.JDBC42PreparedStatement@6d5380c2: delete from emp where id=** STREAM DATA **