SAPConnectionOperation.jsp
2.57 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
<%@page import="com.sap.mw.jco.JCO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<%@ page import="weaver.general.Util"%>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<%
String operation = Util.null2String(request.getParameter("operation"));
String code = Util.null2String(request.getParameter("code"));
String hostname = Util.null2String(request.getParameter("hostname"));
String sapclient = Util.null2String(request.getParameter("sapclient"));
String userid = Util.null2String(request.getParameter("userid"));
String password = Util.null2String(request.getParameter("password"));
String language = Util.null2String(request.getParameter("language"));
String systemnumber = Util.null2String(request.getParameter("systemnumber"));
if ("add".equals(operation)) {
RecordSet.execute("select * from SAPCONN where code = '" + code + "'");
if (RecordSet.next()) {
request.getRequestDispatcher("/sap/data/SAPConnectionNew.jsp?errorcode=101").forward(request, response);
return;
}
RecordSet.execute("insert into SAPCONN(code,hostname,sapclient,userid,password,language,systemnumber) values('"
+ code + "','" + hostname + "','" + sapclient + "','" + userid + "','" + password + "','"
+ language + "','" + systemnumber + "')");
} else if ("edit".equals(operation)) {
String _code = Util.null2String(request.getParameter("_code"));
if (!_code.equals(code)) {
RecordSet.execute("select * from SAPCONN where code = '"+ code + "'");
if (RecordSet.next()) {
request.getRequestDispatcher("/sap/data/SAPConnectionNew.jsp?errorcode=101").forward(request, response);
return;
}
}
RecordSet.execute("update SAPCONN set code='" + code
+ "',hostname='" + hostname + "',sapclient='"
+ sapclient + "',userid='" + userid + "',password='"
+ password + "',language='" + language
+ "',systemnumber='" + systemnumber
+ "' where code = '" + _code + "'");
//清除连接池中的该项连接配置，以便启用新的连接池的配置，这样可以防止重启服务的麻烦
//对应这个文件/src/weaver/interfaces/sap/SAPConn.java
JCO.removeClientPool("Pool");
if(!"".equals(code)&&null!=code){
JCO.removeClientPool(code);
}
} else if ("delete".equals(operation)) {
RecordSet.execute("delete from SAPCONN where code='" + code
+ "'");
} else if ("default".equals(operation)) {
RecordSet.execute("update SAPCONN set isdefault = 2");
RecordSet
.execute("update sapconn set isdefault = 1 where code='"
+ code + "'");
}
response.sendRedirect("/sap/data/SAPConnection.jsp");
%>