dataDMLOperation.jsp
2.96 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page"/>
<%
String flag="0";//0保存失败,1保存成功
//save--保存,update--修改,delete-删除
String opera=Util.null2String(request.getParameter("opera"));
String id=Util.null2String(request.getParameter("ids"));
if(!"".equals(id)&&(id.length()==(id.lastIndexOf(",")+1)))
{
id=id.substring(0,(id.length()-1));
}
String hpid=Util.null2String(request.getParameter("hpid"));
String sourcename=Util.null2String(request.getParameter("sourcename"));
int DBtype=Util.getIntValue(request.getParameter("DBtype"),1);
String serverip=Util.null2String(request.getParameter("serverip"));
int port=Util.getIntValue(request.getParameter("port"),1433);
String dbname=Util.null2String(request.getParameter("dbname"));
String username=Util.null2String(request.getParameter("username"));
String password=Util.null2String(request.getParameter("password"));
int minConnNum=Util.getIntValue(request.getParameter("minConnNum"),10);
int maxConnNum=Util.getIntValue(request.getParameter("maxConnNum"),50);
String datasourceDes=Util.null2String(request.getParameter("datasourceDes"));
String sql="";
if("save".equals(opera))
{
sql=" insert into dml_datasource (hpid,sourcename,DBtype,serverip,port,dbname,username,password,minConnNum,maxConnNum,datasourceDes)";
sql+=" values ('"+hpid+"','"+sourcename+"','"+DBtype+"','"+serverip+"','"+port+"','"+dbname+"','"+username+"','"+password+"','"+minConnNum+"','"+maxConnNum+"','"+datasourceDes+"')";
if(rs.execute(sql))
{
flag="1";
}
response.sendRedirect("/integration/dateSource/dataDMLNew.jsp?closeDialog=close&isNew=1&id="+hpid);
return;
}else if("update".equals(opera))
{
sql=" update dml_datasource set hpid='"+hpid+"',sourcename='"+sourcename+"',DBtype='"+DBtype+"',serverip='"+serverip+"',port='"+port+"',dbname='"+dbname+"',username='"+username+"',password='"+password+"',minConnNum='"+minConnNum+"',maxConnNum='"+maxConnNum+"',datasourceDes='"+datasourceDes+"'";
sql+=" where id='"+id+"'";
if(rs.execute(sql))
{
flag="1";
}
response.sendRedirect("/integration/dateSource/dataDMLNew.jsp?closeDialog=close&isNew=1&id="+id);
return;
}else if("delete".equals(opera))
{
sql=" delete dml_datasource where id in("+id+")";
if(rs.execute(sql))
{
flag="1";
}
String isDialog=Util.null2String(request.getParameter("isDialog"));
if("1".equals(isDialog)){
response.sendRedirect("/integration/dateSource/dataDMLNew.jsp?closeDialog=close&isNew=1&id="+id);
return;
}
}
%>
<script type="text/javascript">
<!--
if(<%=flag%>==1)
{
alert("<%=SystemEnv.getHtmlLabelName(30648,user.getLanguage())%>!");
}else
{
alert("<%=SystemEnv.getHtmlLabelName(30651,user.getLanguage())%>!");
}
window.location.href="/integration/dateSource/dataDMLlist.jsp?hpid=<%=hpid%>";
//-->
</script>