?? 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 + -