sql预处理对象
PreparedStatement pst = null;
connection.prepareStatement(sql);
Object[] pars = {name,pwd};
for(int i =0 ;i<pars.lenth;i++){
pst.setObject(i+1,pars[i]);
}
public int update(String sql,Object[] pars){
getCon();
int x = 0;
//sql预处理对象 PreparedStatement pst = null;
try {
pst = connection.prepareStatement(sql);
//pst.setString(1,user.getName());
//pst.setString(2,user.getPwd()); for(int i =0 ;i<pars.length;i++){
pst.setObject(i+1,pars[i]);
}
x = pst.executeUpdate();
}catch(SQLExeception e){
e.printStackTrace()
}
return x;
}
执行失败返回-1 执行成功有多少返回多少
session.getsession()
session.setsession()