TransDatabaseStruct.jsp
9.97 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
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
<!DOCTYPE HTML>
<%@ page import="weaver.general.Util" %>
<%@ 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");
String type = Util.null2String(request.getParameter("type"));
response.sendRedirect("/notice/noright.jsp?isovertime=0");
%>
<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>
<script type="text/javascript" src="/wui/common/jquery/jquery.min_wev8.js"></script>
<script language=javascript src="/wui/theme/ecology8/jquery/js/zDialog_wev8.js"></script>
<script language=javascript src="/wui/theme/ecology8/jquery/js/zDrag_wev8.js"></script>
<link rel="stylesheet" href="/wui/theme/ecology8/jquery/js/e8_zDialog_btn_wev8.css" type="text/css" />
<link rel="stylesheet" href="/css/ecology8/request/seachBody_wev8.css" type="text/css" />
<script type="text/javascript" src="/js/ecology8/jNice/jNice/jquery.jNice_wev8.js"></script>
<link rel="stylesheet" href="/js/ecology8/jNice/jNice/jNice_wev8.css" type="text/css" />
<script type="text/javascript">
jQuery(document).ready(function(){
jQuery(".e8_btn_top_first").hover(function(){
jQuery(this).addClass("e8_btn_top_first_hover");
},function(){
jQuery(this).removeClass("e8_btn_top_first_hover");
});
});
</script>
<style type="text/css">
.e8_btn_top:hover{
background-color: #03a996 !important;
color: white!important;
border: 1px solid #03a996;
}
</style>
</head>
<%
String message = Util.null2String(request.getParameter("message")) ;
%>
<BODY>
<FORM style="MARGIN-TOP: 0px" name=frmMain method=post action="E7ToE9Operator.jsp?operate=transDatabaseStruct">
<TABLE width="800px" style="text-align:center;margin-left:auto;margin-right:auto;margin-top:30px;" height=100% border="0" cellspacing="0" cellpadding="0">
<COLGROUP> <COL width="20%"> <COL width="80%"><TBODY>
<tr class=Title >
<TD colSpan=2 style="background-color:#f8f8f8;font-weight: bold;text-align:center;height:50px;color:#545454;border:1px solid #eaeaea;padding-bottom:5px;">
<span style="display:inline-block;line-height:32px;height:32px;background-image:url(/images/ecology8/dbinit_wev8.png);background-repeat:no-repeat;background-position:0 50%;">
<span style="padding-left:42px;display:inline-block;height:32px;line-height:45px;font-size:18px;">同步e7表结构</span>
</span>
</TD>
</tr>
<tr>
<td style="font-size:14px;color:#5c5c5c;height:33px;border-left:1px solid #eaeaea;text-align:right;padding-right:30px;padding-top:6px;">验证码:</td>
<td style="font-size:14px;color:#5c5c5c;border-right:1px solid #eaeaea;text-align:left;"><input style="margin-top:10px;border:1px solid #c5c5c5;width:300px;height:30px;" class="InputStyle" type=password name=code maxlength=16 size=16><a style="margin-left:10px;color:#006dff;" href="/system/ModifyCode.jsp?from=db">更改验证码</a></td>
</tr>
<tr>
<td style="font-size:14px;color:#5c5c5c;height:33px;border-left:1px solid #eaeaea;text-align:right;padding-right:30px;padding-top:6px;">数据库类型:</td>
<td style="font-size:14px;color:#5c5c5c;border-right:1px solid #eaeaea;text-align:left;">
<span style="padding-top:10px;display:inline-block;">
<select name=dbtype style="width:300px;height:30px;" onchange="if(this.value==1) {dbport.value='1433';/*document.getElementById('orclSpan').style.display='none'*/}else if(this.value==2){ dbport.value='1521'; /*document.getElementById('orclSpan').style.display='block'*/} ">
<option value="1">SqlServer</option>
<option value="2">Oracle</option>
<!--option value="3">DB2</option-->
</select>
<%--<span id="orclSpan" style="display:none;color:red">(如果为12C容器模式数据库，需要在$ORACLE_HOME/network/admin/sqlnet.ora文件末尾处增加SQLNET.ALLOWED_LOGON_VERSION=8)</span>--%>
</span>
</td>
</tr>
<tr>
<td style="font-size:14px;color:#5c5c5c;height:33px;border-left:1px solid #eaeaea;text-align:right;padding-right:30px;padding-top:6px;">e7数据库服务器IP:</td>
<td style="font-size:14px;color:#5c5c5c;border-right:1px solid #eaeaea;text-align:left;">
<input style="margin-top:10px;border:1px solid #c5c5c5;width:300px;height:30px;" class="InputStyle" accesskey=Z name=dbserver maxlength="20" value="127.0.0.1">
</td>
</tr>
<tr>
<td style="font-size:14px;color:#5c5c5c;height:33px;border-left:1px solid #eaeaea;text-align:right;padding-right:30px;padding-top:6px;">e7数据库端口号:</td>
<td style="font-size:14px;color:#5c5c5c;border-right:1px solid #eaeaea;text-align:left;">
<input style="margin-top:10px;border:1px solid #c5c5c5;width:300px;height:30px;" class="InputStyle" accesskey=Z name=dbport maxlength="20" value="1433">
</td>
</tr>
<tr>
<td style="font-size:14px;color:#5c5c5c;height:33px;border-left:1px solid #eaeaea;text-align:right;padding-right:30px;padding-top:6px;">e7数据库名称:</td>
<td style="font-size:14px;color:#5c5c5c;border-right:1px solid #eaeaea;text-align:left;">
<input style="margin-top:10px;border:1px solid #c5c5c5;width:300px;height:30px;" class="InputStyle" accesskey=Z name=dbname maxlength="20" value="ecology">
</td>
</tr>
<tr>
<td style="font-size:14px;color:#5c5c5c;height:33px;border-left:1px solid #eaeaea;text-align:right;padding-right:30px;padding-top:6px;">e7用户名:</td>
<td style="font-size:14px;color:#5c5c5c;border-right:1px solid #eaeaea;text-align:left;">
<input style="margin-top:10px;border:1px solid #c5c5c5;width:300px;height:30px;" class="InputStyle" accesskey=Z name=username maxlength="20" value="sa">
</td>
</tr>
<tr>
<td style="font-size:14px;color:#5c5c5c;height:33px;border-left:1px solid #eaeaea;text-align:right;padding-right:30px;padding-top:6px;">e7密码:</td>
<td style="font-size:14px;color:#5c5c5c;border-right:1px solid #eaeaea;text-align:left;">
<input style="margin-top:10px;border:1px solid #c5c5c5;width:300px;height:30px;" class="InputStyle" accesskey=Z type=password name=password maxlength="20" value="">
</td>
</tr>
<tr>
<td style="font-size:14px;color:#5c5c5c;height:33px;border-left:1px solid #eaeaea;text-align:right;padding-right:30px;padding-top:6px;">e7需要同步的表名:</td>
<td style="font-size:14px;color:#5c5c5c;border-right:1px solid #eaeaea;text-align:left;">
<textarea style="margin-top:10px;border:1px solid #c5c5c5;width:296px;height:100px;" name="tablenames"></textarea>
</td>
</tr>
<tr>
<td colspan="2" style="text-align:right;height:60px;border-left:1px solid #eaeaea;border-bottom:1px solid #eaeaea;border-right:1px solid #eaeaea;">
<input style="margin-right:18px;font-size:14px;height:35px;width:100px;text-align:center;" class="e8_btn_top_first" id=btnSave accessKey=S name=btnSave type=button onClick="OnSubmit()"value="开始同步"></input>
<input style="margin-right:18px;font-size:14px;height:35px;width:100px;text-align:center;color:#000;border:1px solid #d8d8d8;" class="e8_btn_top" id=btnClear accessKey=R name=btnClear type=reset value="重 置"></input>
</td>
</tr>
</TBODY>
</TABLE>
</FORM>
<%
if(!message.equals("")){
%>
<DIV>
<font color=red size=2>
<%=message%>
</font>
</DIV>
<%}%>
<SCRIPT language="javascript">
function OnSubmit(){
document.frmMain.btnSave.disabled = true;
jQuery("#btnSave").css("background-color", "rgb(224,224,224)");
jQuery("#btnSave").css("border", "1px solid #d8d8d8");
jQuery("#btnSave").css("color", "#000");
document.frmMain.submit();
}
</script>
<script>
function changeselect(){
if(document.getElementById('dbtype').value==2)
document.getElementById('sidtr').style.display="none";
if(document.getElementById('dbtype').value==1)
document.getElementById('sidtr').style.display="";
}
</script>
<script type="text/javascript">
jQuery(document).ready(function(){
var type= "<%=type%>";
if(type == "transDatabaseStruct"){
jQuery(window.parent.document).find("#transDatabaseStruct").attr("class","current");
jQuery(window.parent.document).find("#dropTable").removeAttr("class");
jQuery(window.parent.document).find("#getTableName").removeAttr("class");
jQuery(window.parent.document).find("#deleteTable").removeAttr("class");
jQuery(window.parent.document).find("#createFormTableMain").removeAttr("class");
jQuery(window.parent.document).find("#synchroSequence").removeAttr("class");
jQuery(window.parent.document).find("#clearRepeatTable").removeAttr("class");
jQuery(window.parent.document).find("#initFormTableTrigger").removeAttr("class");
jQuery(window.parent.document).find("#initHtmlMode").removeAttr("class");
jQuery(window.parent.document).find("#getTableName1").removeAttr("class");
}
/*jQuery("body").on("propertychange input", "#field19642", function(){
if(jQuery("#field17281").val()==0){
jQuery("#field17421").val(jQuery("#field19642").val()-1);
jQuery("#field17420").val(11);
}else{
jQuery("#field17421").val(jQuery("#field19642").val());
jQuery("#field17420").val(jQuery("#field17281").val()-1);
}
});
jQuery("body").on("propertychange input", "#field17281", function(){
if(jQuery("#field17281").val()==0){
jQuery("#field17421").val(jQuery("#field19642").val()-1);
jQuery("#field17420").val(11);
}else{
jQuery("#field17421").val(jQuery("#field19642").val());
jQuery("#field17420").val(jQuery("#field17281").val()-1);
}
});*/
});
</script>
</BODY>
</HTML>