//第二个参数为给占位符赋值,可以理解为一个数组
//例如executeUpdate("select *from user where id=? and pwd =?","admin","123")
public int executeUpdate(String sql,Object...obj){
Connection conn = getConnection();PreparedStatement ps = null;
try {
ps = conn.prepareStatement(sql);
//给占位符赋值
if(obj.length>0){
for (int i = 0; i < obj.length; i++) {
ps.setObject(i+1, obj[i]);
}
}
return ps.executeUpdate(); //执行SQL并返回影响行数
} catch (Exception e) {
// TODO: handle exception
}finally{
closeAll(conn, ps, null);
}
return 0;
}