AccountOperation.jsp
2.8 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="RecordSet1" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="RecordSet2" class="weaver.conn.RecordSet" scope="page" />
<%
String operate = Util.fromScreen(request.getParameter("operate"),user.getLanguage());
String currentid = Util.null2String(request.getParameter("currentid"));// 系统标识
RecordSet.executeSql("delete from outter_account where userid = "+user.getUID());//308742 [90]集成登录-Mysql集成模块问题列表
RecordSet.executeSql("delete from outter_params where userid = "+user.getUID());//308742 [90]集成登录-Mysql集成模块问题列表
RecordSet.executeSql("select * from outter_sys");
while(RecordSet.next()) {
String sysid= RecordSet.getString("sysid");
String account = Util.fromScreen(request.getParameter("account_999_"+sysid),user.getLanguage());
String password = Util.fromScreen(request.getParameter("password_999_"+sysid),user.getLanguage());
// 密码加密存储
if(!password.equals("")) {
password = SecurityHelper.encryptSimple(password);
}
String logintype = Util.fromScreen(request.getParameter("logintype_999_"+sysid),user.getLanguage());
String date = TimeUtil.getCurrentDateString();
String time = TimeUtil.getOnlyCurrentTimeString();
//qc308742 [90]集成登录-Mysql集成模块问题列表 数据源无法保存 ----START
String dbtype=RecordSet.getDBType();
String addacountsql="insert into outter_account(sysid,userid,account,password,logintype,createdate,createtime,modifydate,modifytime) values(?,?,?,?,?,?,?,?,?)" ;
if(logintype==null||"".equals(logintype)){
if(dbtype.toLowerCase().indexOf("mysql")>-1){
logintype=null;
}
}
RecordSet1.executeUpdate(addacountsql,sysid,user.getUID(),account,password,logintype,date,time,date,time) ;
//qc308742 [90]集成登录-Mysql集成模块问题列表 数据源无法保存 ----END
RecordSet1.executeSql("select * from outter_sysparam where paramtype=1 and sysid='"+sysid+"'");
while(RecordSet1.next()) {
String paramname = RecordSet1.getString("paramname");
String paramvalue = Util.fromScreen(request.getParameter(paramname+"_"+sysid),user.getLanguage());
RecordSet1.executeSql("insert into outter_params(sysid,userid,paramname,paramvalue) values('"+sysid+"',"+user.getUID()+",'"+paramname+"','"+paramvalue+"')") ;
}
}
if(operate.equals("insert")) {
%>
<script>
alert("<%=SystemEnv.getHtmlLabelName(16746,user.getLanguage())%>");
<% if(!"".equals(currentid)) { %>
window.location = "/interface/AccountSettingFrame.jsp?sysid=<%=currentid %>";
<% } else { %>
window.location = "/interface/AccountSettingFrame.jsp";
<% } %>
</script>
<%
} else {
response.sendRedirect("login.jsp");
}
%>