pluginSettingOperation.jsp
2.83 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
<%@ 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 delSql="delete from hppluginsetting";
rs.execute(delSql);
if(!"".equals(sendData)){
String inSql = "insert into hppluginsetting(pid,plugindesc,filepath,isuse,ordernum) values(?,?,?,?,?) ";
ConnStatementNew batchInRs = new ConnStatementNew();
batchInRs.setStatementSqlBatch(inSql);
String keySplit = ":mh:";
String itemSplit=",dh,";
String lineSplit=";fh;";
String[] lines = sendData.split(lineSplit);
for(String line: lines){
String key= "",plugindesc="",filepath="",isuse="",ordernum="";
String[] items = line.split(itemSplit);
for(String item : items){
String[] datas = item.split(keySplit,-1);
if("key".equals(datas[0])){
key = Util.null2String(datas[1]);
}else if("plugindesc".equals(datas[0])){
plugindesc = datas[1];
}else if("filepath".equals(datas[0])){
filepath = datas[1];
}else if("isuse".equals(datas[0])){
isuse = datas[1];
}else if("ordernum".equals(datas[0])){
ordernum = datas[1];
}
}
batchInRs.setString(1, key);
batchInRs.setObject(2, plugindesc);
batchInRs.setString(3, filepath);
batchInRs.setString(4, isuse);
batchInRs.setString(5, ordernum);
batchInRs.addBatch();
}
batchInRs.executeBatch();
}
} else if("init".equals(method)){
String strSql="select * from hppluginsetting order by ordernum";
rs.execute(strSql);
StringBuffer retJson = new StringBuffer("[");
while(rs.next()){
if(retJson.length()>1){
retJson.append(",");
}
retJson.append("[");
retJson.append("{\"name\":\"key\",\"value\":\"").append(rs.getString("pid")).append("\",\"iseditable\":\"true\",\"type\":\"input\"},");
retJson.append("{\"name\":\"plugindesc\",\"value\":\"").append(rs.getString("plugindesc")).append("\",\"iseditable\":\"true\",\"type\":\"input\"},");
retJson.append("{\"name\":\"filepath\",\"value\":\"").append(rs.getString("filepath")).append("\",\"iseditable\":\"true\",\"type\":\"input\"},");
retJson.append("{\"name\":\"ordernum\",\"value\":\"").append(rs.getString("ordernum")).append("\",\"iseditable\":\"true\",\"type\":\"input\"},");
retJson.append("{\"name\":\"isuse\",\"checked\":\"").append("1".equals(rs.getString("isuse"))).append("\",\"iseditable\":\"true\",\"type\":\"checkbox\"}");
retJson.append("]");
}
retJson.append("]");
returnStr = retJson.toString();
}
out.println(returnStr);
%>