clearflow.jsp
1.59 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
<%@ page import="weaver.conn.RecordSet" %>
<%@ page import="weaver.general.Util" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%
try{
String requestid = Util.null2String(request.getParameter("requestid"));
String type = Util.null2String(request.getParameter("type"));
if(requestid.length() == 0){
out.println("param requestid is null:<br/>");
return ;
}
if(type.length() == 0){
out.println("param type is null:<br/>");
return ;
}
RecordSet rs1 = new RecordSet();
String sql = "";
switch (type){
case "0":
sql = "delete from kq_flow_split_leave where requestid in("+requestid+")";
break;
case "1":
sql = "delete from kq_flow_split_evection where requestid in("+requestid+")";
break;
case "2":
sql = "delete from kq_flow_split_out where requestid in("+requestid+")";
break;
case "3":
sql = "delete from kq_flow_split_overtime where requestid in("+requestid+")";
break;
case "4":
sql = "delete from kq_flow_split_other where requestid in("+requestid+")";
break;
case "6":
sql = "delete from kq_flow_split_leaveback where requestid in("+requestid+")";
break;
default:
break;
}
if(sql.length() > 0){
rs1.executeUpdate(sql);
}
}catch (Exception e){
e.printStackTrace();
}
%>