📄 user.java
字号:
sb.append("<td class=\"chinese\"> ");
sb.append(sAdminType);
sb.append("</td>\r\n");
sb.append("<td class=\"chinese\"><div align=\"right\">最后登录的时间：</div></td>\r\n");
sb.append("<td class=\"chinese\"><span class=\"chinese\"> ");
sb.append(LastLoginTime);
sb.append(" </span></td>\r\n");
sb.append("</tr>\r\n");
sb.append("<tr bgcolor=\"#d6dff7\">\r\n");
sb.append("<td class=\"chinese\"><div align=\"right\">性别： </div></td>\r\n");
sb.append("<td class=\"chinese\"> ");
sb.append(UserSex);
sb.append(" </td>\r\n");
sb.append("<td class=\"chinese\"><div align=\"right\">最后登录的IP：</div></td>\r\n");
sb.append("<td class=\"chinese\"> ");
sb.append(LastLoginIP);
sb.append(" </td>\r\n");
sb.append("</tr>\r\n");
sb.append("<tr bgcolor=\"#d6dff7\">\r\n");
sb.append("<td class=\"chinese\"><div align=\"right\">出生日期： </div></td>\r\n");
sb.append("<td class=\"chinese\"> ");
sb.append(UserBirthday);
sb.append(" </td>\r\n");
sb.append("<td class=\"chinese\"><div align=\"right\">发表的新闻数：</div></td>\r\n");
sb.append("<td class=\"chinese\"> ");
sb.append(NewsNum);
sb.append(" </td>\r\n");
sb.append("</tr>\r\n");
sb.append("<tr bgcolor=\"#d6dff7\">\r\n");
sb.append("<td class=\"chinese\"><div align=\"right\">电子邮件： </div></td>\r\n");
sb.append("<td><span class=\"chinese\"> ");
sb.append(UserEmail);
sb.append(" </span></td>\r\n");
sb.append("<td colspan=\"2\"><div align=\"center\" class=\"chinese\">管理员其它信息</div></td>\r\n");
sb.append("</tr>\r\n");
sb.append("<tr bgcolor=\"#d6dff7\">\r\n");
sb.append("<td class=\"chinese\"><div align=\"right\">联系电话： </div></td>\r\n");
sb.append("<td><span class=\"chinese\"> ");
sb.append(UserTel);
sb.append(" </span></td>\r\n");
sb.append("<td colspan=\"2\" rowspan=\"4\" valign=\"top\"><div align=\"right\"></div> \r\n");
sb.append("<div align=\"left\"><span class=\"chinese\">");
sb.append(UserInfo);
sb.append("</span></di></td>\r\n");
sb.append("</tr>\r\n");
sb.append("<tr bgcolor=\"#d6dff7\">\r\n");
sb.append("<td class=\"chinese\"><div align=\"right\">QQ： </div></td>\r\n");
sb.append("<td><span class=\"chinese\"> ");
sb.append(UserQQ);
sb.append(" </span></td>\r\n");
sb.append("</tr>\r\n");
sb.append("<tr bgcolor=\"#d6dff7\">\r\n");
sb.append("<td class=\"chinese\"><div align=\"right\">通讯地址： </div></td>\r\n");
sb.append("<td><span class=\"chinese\"> ");
sb.append(UserAddress);
sb.append(" </span></td>\r\n");
sb.append("</tr>\r\n");
sb.append("<tr bgcolor=\"#d6dff7\">\r\n");
sb.append("<td class=\"chinese\"><div align=\"right\">邮编： </div></td>\r\n");
sb.append("<td><span class=\"chinese\"> ");
sb.append(UserZip);
sb.append("</span></td>\r\n");
sb.append("</tr>\r\n");
sb.append("<tr bgcolor=\"#d6dff7\">\r\n");
sb.append("<td colspan=\"4\" class=\"chinese\"><div align=\"center\"><a href=\"#\"");
sb.append("onClick=\"javascript:history.go(-1)\"><strong>返回</strong></a></div></td>\r\n");
sb.append("</tr>\r\n");
sb.append("</table>\r\n");
sb.append("<br><br>\r\n");
return sb.toString();
}else return sError;
}catch(Exception e){return "No";}
}
/*********************************************************
* 函数名:SaveAdd()
* 作 用:添加用户
* 参 数:s,字符串数组，添加用户的各项参数
* s1:管理员;s2:IP地址
* 返回值:字符串型。返回操作结果的信息
***********************************************************/
public String SaveAdd(String [] s,String s1,String s2)
{
String NowTime = (new java.util.Date()).toLocaleString();
String [] sLog = new String[5];
sLog[0] = s1;
sLog[2] = NowTime;
sLog[3] = s2;
try{
boolean OK = true;
String sError = "";
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
ResultSet rs = null;
for(int i=0;i<s.length;i++)
{
s[i] = Fun.getStrCN(Fun.CheckReplace(s[i]));
}
String [] sa1 = new String [4];
String [] sa2 = new String [4];
sa1[0] = s[0];
sa1[1] = s[1];
sa1[2] = s[4];
sa1[3] = s[7];
sa2[0] = "管理员用户名";
sa2[1] = "管理员密码";
sa2[2] = "管理员真实姓名";
sa2[3] = "电子邮件";
int iAdminType = Fun.StrToInt(s[2]);
if (iAdminType == 0) iAdminType = 1;
String sOK = Fun.CheckDate(sa1,sa2);
if (!sOK.equals("Yes"))
{
OK = false;
sError = sOK;
}
String sql1 = "select * from Admin where AdminName='" + s[0] + "'";
ResultSet rs1 = stmt.executeQuery(sql1);
if (rs1.next())
{
OK = false;
sError = "该用户名已经存在，请重新输入!";
}
if(OK)
{
s[1] = md5.getMD5ofStr(md5.getMD5ofStr(s[1]));
String sql = "insert into Admin (AdminName,AdminPwd,AdminType,AddTime,UserName,UserSex,";
sql += "UserBirthday,UserEmail,UserQQ,UserTel,UserAddress,UserZip,UserInfo) values (";
sql += "'" + s[0] + "',";
sql += "'" + s[1] + "',";
sql += iAdminType + ",";
sql += "'" + s[3] + "',";
sql += "'" + s[4] + "',";
sql += "'" + s[5] + "',";
sql += "'" + s[6] + "',";
sql += "'" + s[7] + "',";
sql += "'" + s[8] + "',";
sql += "'" + s[9] + "',";
sql += "'" + s[10] + "',";
sql += "'" + s[11] + "',";
sql += "'" + s[12] + "')";
//out.println(sql);
stmt.executeUpdate(sql);
stmt.close();
Conn.close();
sLog[1] = "添加新的管理员用户["+s[0]+"]";
sLog[4] = "Yes";
Fun.AddLog(sLog);
return "Yes";
}
else return sError;
}catch(Exception e){
sLog[1] = "添加新的管理员用户["+s[0]+"]操作失败";
sLog[4] = "No";
Fun.AddLog(sLog);
////e.printStackTrace();
//System.out.print(e.getMessage());
//System.out.print(sql);
return "添加用户操作出错，请核对你的输入!";
}
}
/*********************************************************
* 函数名:SaveEdit()
* 作 用:修改用户资料，
* 参 数:s,字符串数组，修改用户的各项参数
* s1:管理员;s2:IP地址,
* b:布尔型，是否超级管理员
* 返回值:字符串型。返回操作结果的信息
***********************************************************/
public String SaveEdit(String [] s,String s1,String s2,boolean b)
{
String NowTime = (new java.util.Date()).toLocaleString();
String [] sLog = new String[5];
sLog[0] = s1;
sLog[2] = NowTime;
sLog[3] = s2;
sLog[1] = "修改ID为 [" + s[0] + " ] 的管理员用户资料";
try{
boolean OK = true;
String sError = "";
for(int i=0;i<s.length;i++)
{
s[i] = Fun.getStrCN(Fun.CheckReplace(s[i]));
}
String [] sa1 = new String [3];
String [] sa2 = new String [3];
sa1[0] = s[0];
sa1[1] = s[4];
sa1[2] = s[7];
sa2[0] = "管理员用户名";
sa2[1] = "管理员真实姓名";
sa2[2] = "电子邮件";
String sOK = Fun.CheckDate(sa1,sa2);
if (!sOK.equals("Yes"))
{
OK = false;
sError = sOK;
}
if(OK)
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
ResultSet rs = null;
int iAdminType = Fun.StrToInt(s[2]);
if (iAdminType == 0) iAdminType = 1;
String sql = "update Admin set ";
sql += "AddTime='" + s[3] + "',";
sql += "UserName='" + s[4] + "',";
sql += "UserSex='" + s[5] + "',";
sql += "UserBirthday='" + s[6] + "',";
sql += "UserEmail='" + s[7] + "',";
sql += "UserQQ='" + s[8] + "',";
sql += "UserTel='" + s[9] + "',";
sql += "UserAddress='" + s[10] + "',";
sql += "UserZip='" + s[11] + "',";
sql += "UserInfo='" + s[12] + "'";
String sql1 = " where AdminID=" + s[0];
if(b)
{
sql += ",AdminType=" + iAdminType;
if (s[1]!=null && !s[1].equals(""))
{
s[1] = md5.getMD5ofStr(md5.getMD5ofStr(s[1]));
sql += ",AdminPwd='" + s[1] + "'";
sLog[1] += "和密码!";
}
}
sql += sql1;
stmt.executeUpdate(sql);
stmt.close();
Conn.close();
sLog[4] = "Yes";
Fun.AddLog(sLog);
return "Yes";
} return sError;
}catch(Exception e){
sLog[4] = "No";
Fun.AddLog(sLog);
////e.printStackTrace();
//System.out.print(e.getMessage());
//System.out.print(sql);
return "修改用户操作出错，请核对你的输入!";
}
}
/*********************************************************
* 函数名:SaveEditPwd()
* 作 用:修改用户密码
* 参 数: s[0],旧密码⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -