commonmenuoperation.jsp
1.44 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="java.util.*"%>
<%@ page import="weaver.hrm.*,weaver.general.*"%>
<jsp:useBean id="rst" class="weaver.conn.RecordSetTrans" scope="page" />
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%
User user = HrmUserVarify.getUser(request,response);
if(user == null) return ;
String method = request.getParameter("method");
if("save".equals(method)){
String msg = "OK";
String[] menushowids = Util.TokenizerStringNew(Util.null2String(request.getParameter("menushowids")),",");
rst.setAutoCommit(false);
try{
rst.execute("delete from UserCommonMenu where userid="+user.getUID());
for(int i=0;i<menushowids.length;i++){
rst.executeSql("insert into UserCommonMenu (userid,menuid) values("+user.getUID()+",'"+menushowids[i]+"')");
}
rst.commit();
}catch(Exception e){
rst.rollback();
msg = e.toString();
}
out.println(msg);
}else if("del".equals(method)){
String menuid = request.getParameter("menuid");
rs.executeSql("delete from UserCommonMenu where userid="+user.getUID()+" and menuid='"+menuid+"'");
//rs.executeSql("SELECT parentid FROM LeftMenuInfo WHERE id = 12");
}else if("clear".equals(method)){
//String menuid = request.getParameter("menuid");
rs.executeSql("delete from UserCommonMenu where userid="+user.getUID());
//rs.executeSql("SELECT parentid FROM LeftMenuInfo WHERE id = 12");
}
%>