Java 删除

                                     Java 删除 

开发工具与关键技术：java
作者：彭浩达
撰写时间：2019年 8月 17日

Servlet代码：
public void detelepurchase(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
String msg = “”;
String purchaseid = request.getParameter(“purchaseid”);

	if(purchaseid != "" && purchaseid != null){
	    int purchaseids = Integer.parseInt(purchaseid);
		int a = userService.deletepurchase(purchaseids);
		if(a > 0){
			msg = "{\"msg\":\"采购单删除成功,采购明细删除异常\",\"state\":\"true\"}";
		}
		if(a > 1){
			msg = "{\"msg\":\"删除成功\",\"state\":\"true\"}";
		}
	}else{
		msg = "{\"msg\":\"数据异常\"}";
	}
	JSONObject jsonObject = JSONObject.fromObject(msg);
	response.setCharacterEncoding("utf-8");
	response.setContentType("text/json");
	response.getWriter().write(jsonObject.toString());
	response.getWriter().flush();
	response.getWriter().close();
}

@Override
public int deletepurchase(int purchaseid) {
// TODO Auto-generated method stub
int flog = 0;
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
PurDrugMed drugMed = null;
try {
con = DBUtil.getConnection();
ps = con.prepareStatement(“select * from purchase where purchaseid = ?”);
ps.setInt(1, purchaseid);
rs = ps.executeQuery();
while(rs.next()){
drugMed = new PurDrugMed();
drugMed.setPurcharisid(rs.getInt(“purcharisid”));
}

ps = con.prepareStatement(deletepurchase);
ps.setInt(1, purchaseid);
if (ps.executeUpdate() >0) {
flog = 1;
}
if(drugMed.getPurcharisid() >0){
ps = con.prepareStatement(“delete from purcharis where purcharisid = ?”);
ps.setInt(1, drugMed.getPurcharisid());
if (ps.executeUpdate() >0) {
flog = 2;
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flog;
}