Java新增多表修改
开发工具与关键技术:java
作者:彭浩达
撰写时间:2019年 8月 14日
Servlet代码:
public void shenhecruk(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
String purchaseid = request.getParameter(“purchaseid”);
String msg = “”;
if(Tools.isNotNull(purchaseid)){
UserService service = new UserSerimpl();
int a = service.insertykdetail(Integer.parseInt(purchaseid));
if(a > 2){
msg = “{“msg”:“审核成功”}”;
}else{
msg = “{“msg”:“审核失败”}”;
}
}
response.setCharacterEncoding(“utf-8”);
JSONObject jsonObject = JSONObject.fromObject(msg);
response.setContentType(“text/json”);
PrintWriter out = response.getWriter();
out.write(jsonObject.toString());
out.flush();
out.close();
}
@Override
public int insertykdetail(int purchaseid) {
// TODO Auto-generated method stub
int flog = 0;
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
con = DBUtil.getConnection();
ps = con.prepareStatement(“insert into ykdetail(purchaseid) values(?)”,Statement.RETURN_GENERATED_KEYS);
ps.setInt(1, purchaseid);
//rs = ps.getGeneratedKeys();
//while(rs.next()){
if(ps.executeUpdate() > 0){
flog = 1;
}
//替换ps 再继续执行修改,形成多表修改
ps = con.prepareStatement(“update purchase set rkfalse=? where purchaseid = ?”);
ps.setInt(1, 1);
ps.setInt(2, purchaseid);
if(ps.executeUpdate() > 0){
flog = 2;
}
ps = con.prepareStatement(“update rwarehouse set shenhefo = ? where purchaseid = ?”);
ps.setInt(1, 1);
ps.setInt(2, purchaseid);
if(ps.executeUpdate() > 0){
flog = 3;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
DBUtil.close(con, ps, rs);
}
return flog;