toolbarMoreOperation.jsp
3.41 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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="weaver.general.*" %>
<%@ page import="java.util.*" %>
<%@ page import="org.json.JSONArray" %>
<%@ page import="weaver.conn.ConnStatementNew" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%
String method = Util.null2String(request.getParameter("method"));
String pageEdit="";
List paraList=new ArrayList();
String returnStr = "ok";
if("save".equals(method)){
String sendData = Util.null2String(request.getParameter("senddata"));
String inSql = "insert into toolbarmoremenuinfo(customname,icon,isshow,url,linkmode,sortnum,shoposition,id,type) values(?,?,?,?,?,?,?,?,'cus') ";
String upSql = "update toolbarmoremenuinfo set customname=?,icon=?,isshow=?,url=?,linkmode=?,sortnum=?,shoposition=? where id=? ";
rs.execute("select MAX(id) id from toolbarmoremenuinfo");
int newRowNum =0;
int reSortId = 0; //取当前页的某一行数据id，然后将该id对应行排序后排序递增
int maxId = 1;
if(rs.next()){
maxId = rs.getInt("id")+1;
}
ConnStatementNew batchInRs = new ConnStatementNew();
batchInRs.setStatementSqlBatch(inSql);
ConnStatementNew batchUpRs = new ConnStatementNew();
batchUpRs.setStatementSqlBatch(upSql);
String keySplit = ":mh:";
String itemSplit=",dh,";
String lineSplit=";fh;";
String[] lines = sendData.split(lineSplit);
for(String line: lines){
String id= "",customname="",icon="",isshow="",url="",linkmode="",sortnum="",shoposition="";
String[] items = line.split(itemSplit);
for(String item : items){
String[] datas = item.split(keySplit,-1);
if("id".equals(datas[0])){
id = Util.null2String(datas[1]);
}else if("sortnum".equals(datas[0])){
sortnum = datas[1];
}else if("name".equals(datas[0])){
customname = datas[1];
}else if("icon".equals(datas[0])){
icon = datas[1];
}else if("isshow".equals(datas[0])){
isshow = datas[1];
}else if("url".equals(datas[0])){
url = datas[1];
}else if("linkmode".equals(datas[0])){
linkmode = datas[1];
}else if("shoposition".equals(datas[0])){
shoposition = datas[1];
}
}
if("".equals(id)){
batchInRs.setObject(1, customname);
batchInRs.setString(2, icon);
batchInRs.setString(3, isshow);
batchInRs.setString(4, url);
batchInRs.setString(5, linkmode);
batchInRs.setInt(6, Util.getIntValue(sortnum));
batchInRs.setString(7, shoposition);
batchInRs.setInt(8, maxId++);
batchInRs.addBatch();
newRowNum++;
}else{
batchUpRs.setObject(1, customname);
batchUpRs.setString(2, icon);
batchUpRs.setString(3, isshow);
batchUpRs.setString(4, url);
batchUpRs.setString(5, linkmode);
batchUpRs.setInt(6, Util.getIntValue(sortnum));
batchUpRs.setString(7, shoposition);
batchUpRs.setInt(8,Util.getIntValue( id));
batchUpRs.addBatch();
if(reSortId == 0){
reSortId = Util.getIntValue( id);
}
}
}
if(newRowNum >0){
rs.execute("update toolbarmoremenuinfo set sortnum= sortnum+"+newRowNum+" where sortnum>( select sortnum from toolbarmoremenuinfo where id = "+reSortId+")");
}
batchInRs.executeBatch();
batchUpRs.executeBatch();
} else if("del".equals(method)){
String ids=Util.null2String(request.getParameter("delids"));
String strSql="delete from toolbarmoremenuinfo where id in("+ids+")";
rs.execute(strSql);
strSql="delete from commonshareinfo where infoid in("+ids+") and module ='toolbarm' ";
rs.execute(strSql);
}
out.println(returnStr);
%>
<%!
%>