public int insertAndUpdate(String sql,Student stu,boolean isEdit)throws SQLException,Exception{
int result=0;
con=DBC.getCon();
try{
pst=con.prepareStatement(sql);
pst.setString(1, stu.getClassNum());
pst.setString(2, stu.getName());
pst.setString(3, stu.getSex());
pst.setInt(4, stu.getAge());
pst.setString(5, stu.getBirthday());
pst.setString(6, stu.getEmail());
if(isEdit){
pst.setInt(7, stu.getStuId());
}
result=pst.executeUpdate();
if(result>0&&!isEdit){
//获取插入数据的id
rs=pst.getGeneratedKeys();
if(rs.next()){
result=rs.getInt(1);
}
}
}finally{
DBC.closeDBC(rs, pst, con);
return result;
}
}
int result=0;
con=DBC.getCon();
try{
pst=con.prepareStatement(sql);
pst.setString(1, stu.getClassNum());
pst.setString(2, stu.getName());
pst.setString(3, stu.getSex());
pst.setInt(4, stu.getAge());
pst.setString(5, stu.getBirthday());
pst.setString(6, stu.getEmail());
if(isEdit){
pst.setInt(7, stu.getStuId());
}
result=pst.executeUpdate();
if(result>0&&!isEdit){
//获取插入数据的id
rs=pst.getGeneratedKeys();
if(rs.next()){
result=rs.getInt(1);
}
}
}finally{
DBC.closeDBC(rs, pst, con);
return result;
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货