CreateDB.jsp
4.39 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
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*" %>
<%@ page import="weaver.hrm.*" %>
<%@ page import="weaver.systeminfo.*" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%
response.setHeader("cache-control", "no-cache");
response.setHeader("pragma", "no-cache");
response.setHeader("expires", "Mon 1 Jan 1990 00:00:00 GMT");
%>
<HTML><HEAD>
<LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
<META http-equiv=Content-Type content="text/html; charset=UTF-8">
<SCRIPT language="javascript" src="/js/weaver_wev8.js"></script>
</head>
<%
String message = Util.null2String(request.getParameter("message")) ;
String imagefilename = "/images/hdSystem_wev8.gif";
String titlename = "数据库设置" ;
String needfav ="1";
String needhelp ="";
%>
<BODY>
<DIV class=HdrProps>
<TABLE class=Form>
<COLGROUP> <COL width="20%"> <COL width="80%"><TBODY>
<TR class=Section>
<TH colSpan=2>数据库</TH>
</TR>
</TBODY>
</TABLE>
</DIV>
<FORM style="MARGIN-TOP: 0px" name=frmMain method=post action="CreateDBOperation.jsp">
<div>
<BUTTON class=btn id=btnSave accessKey=S name=btnSave type=button onClick="OnSubmit()"><U>S</U>-创建</BUTTON>
<BUTTON class=btn id=btnClear accessKey=R name=btnClear type=reset><U>R</U>-重置</BUTTON>
</div> <br>
<TABLE class=Form>
<COLGROUP> <COL width="20%"> <COL width="80%"><TBODY>
<TR class=Separator>
<TD class=sep1 colSpan=2></TD>
</TR>
<tr>
<td nowrap>验证码:</td>
<td class=Field><input type=password name=code maxlength=16 size=16> <a href="\system\ModifyCode.jsp">更改验证码</a></td>
</tr>
<tr>
<td>数据库类型</td>
<td class=Field>
<select name=dbtype onchange="changeDBType()">
<option value="1">SqlServer</option>
<option value="2">Oracle</option>
<!--option value="3">DB2</option-->
<option value="4">Mysql</option>
</select>
<span id="orclSpan" style="visibility:hidden;color:red">(如果为12C容器模式数据库，需要在$ORACLE_HOME/network/admin/sqlnet.ora文件末尾处增加SQLNET.ALLOWED_LOGON_VERSION=8)</span>
</td>
</tr>
<tr>
<td>数据库服务器IP</td>
<td class=Field>
<input accesskey=Z name=dbserver maxlength="20" value="127.0.0.1">
</td>
</tr>
<tr>
<tr>
<td>数据库端口号</td>
<td class=Field>
<input accesskey=Z name=dbport maxlength="20" value="">
</td>
</tr>
<tr>
<td>数据库名称</td>
<td class=Field>
<input accesskey=Z name=dbname maxlength="20" value="ecology">
</td>
</tr>
<tr style="display:none;" id="characterSet">
<td>字符集</td>
<td class=Field>
<select name=characterSet>
<option value="utf8">utf8</option>
<option value="gbk">gbk</option>
</select>
</td>
</tr>
<tr>
<td>用户名</td>
<td class=Field>
<input accesskey=Z name=username maxlength="20" value="sa">
</td>
</tr>
<tr>
<td>密码</td>
<td class=Field>
<input accesskey=Z type=password name=password maxlength="20" value="">
</td>
</tr>
<tr>
<td>使用现有数据库</td>
<td class=Field>
<input accesskey=Z type=checkbox name=isexist value="1">
</td>
</tr>
</TBODY>
</TABLE>
</FORM>
<%
if(!message.equals("")){
%>
<DIV>
<font color=red size=2>
<%=message%>
</font>
</DIV>
<%}%>
<script language="javascript">
if(document.all('dbtype').value==2){
document.getElementById("orclSpan").style.visibility="visible";
}
</script>
<SCRIPT language="javascript">
function OnSubmit(){
document.frmMain.btnSave.disabled = true;
document.frmMain.submit();
}
function changeDBType() {
if(document.all('dbtype').value==1) {
document.all('dbport').value='1433';
document.getElementById("characterSet").style.display = "none";
}
else if(document.all('dbtype').value==2) {
document.all('dbport').value='1521';
document.getElementById("characterSet").style.display = "none";
document.getElementById("orclSpan").style.visibility="visible";
}
else if(document.all('dbtype').value==4) {
document.all('dbport').value='3306';
document.getElementById("characterSet").style.display = "";
}
}
changeDBType();
</script>
</BODY>
</HTML>