梦想年华新闻发布系统

/*************************************************** * * 源文件名: User.java * 功 能： 梦想年华新闻系统 - 用户管理类 * 作者：梦想年华 [DreamTime] * Email:fanwsp@126.com * QQ:122142023 * CopyRight(c)2005-2006 by DreamTime * **************************************************** */ package dreamtime.dreamnews; //指定类所在的包 import java.sql.*; import dreamtime.dreamnews.Function; import dreamtime.dreamnews.DBConnection; import dreamtime.dreamnews.MD5; public class User { DBConnection DBConn = new DBConnection(); Function Fun = new Function(); MD5 md5 = new MD5(); public String AdminName,AdminPwd,UserName,UserSex,UserTel; public String UserQQ,UserEmail,UserAddress,UserZip,UserInfo; public String AddTime,LastLoginTime,LastLoginIP; public String sAdminType,UserBirthday; public int AdminType,BirthYear,BirthMonth,BirthDay; public int NewsNum,LoginNum; public String [] sType = new String[4]; public User() { sType[1] = "普通管理员"; sType[2] = "系统管理员"; sType[3] = "超级管理员"; } public boolean ReadUser(int AdminID) { try{ Connection Conn = DBConn.getConn(); Statement stmt = Conn.createStatement(1004,1007); ResultSet rs = null; String Sql = "select * from Admin where AdminID=" + AdminID; rs = stmt.executeQuery(Sql); rs.next(); AdminName = rs.getString("AdminName"); AdminType = rs.getInt("AdminType"); UserName = rs.getString("UserName"); UserSex = rs.getString("UserSex"); UserBirthday = rs.getString("UserBirthday"); UserTel = rs.getString("UserTel"); UserQQ = rs.getString("UserQQ"); UserEmail = rs.getString("UserEmail"); UserAddress = rs.getString("UserAddress"); UserZip = rs.getString("UserZip"); UserInfo = rs.getString("UserInfo"); AddTime = rs.getString("AddTime"); LastLoginTime = rs.getString("LastLoginTime"); LastLoginIP = rs.getString("LastLoginIP"); NewsNum = rs.getInt("NewsNum"); LoginNum = rs.getInt("LoginNum"); String [] s = UserBirthday.split("-"); BirthYear = Fun.StrToInt(s[0]); BirthMonth = Fun.StrToInt(s[1]); BirthDay = Fun.StrToInt(s[2]); rs.close(); stmt.close(); Conn.close(); return true; }catch(Exception e){ return false;} } /*********************************************************** * 函数名：UserList * 作 用：管理员用户列表 * 参 数：sPage,页面地址; strPage,第几页 * 返回值：字符串 ***********************************************************/ public String UserList(String sPage,String strPage) { try { Connection Conn = DBConn.getConn(); Statement stmt = Conn.createStatement(1004,1007); ResultSet rs = null; String sSql = null; StringBuffer sb = new StringBuffer(); int i; int intPage = 1; int intPageSize = 10; if (Fun.ReadConfig() && Fun.AdminUserListNum>0) intPageSize = Fun.AdminUserListNum; sSql = "select * from Admin order by AdminID desc"; rs = stmt.executeQuery(sSql); sb.append("<br><br><table width=\"90%\" border=\"1\" align=\"center\" cellpadding=\"2\" cellspacing=\"\">\r\n"); sb.append("<tr background=\"images/bg.gif\">\r\n"); sb.append("<td height=\"27\" colspan=\"7\" background=\"images/bg.gif\"><div align=\"center\" class=\"title\">"); sb.append("<strong>所有管理员用户列表</strong></div></td>\r\n"); sb.append("</tr>\r\n"); sb.append("<tr height=\"25\" class=\"chinese\">\r\n"); sb.append("<td width=\"5%\"><div align=\"center\"><b>ID</b></div></td>\r\n"); sb.append("<td width=\"12%\"><div align=\"center\"><b>用户名</b></div></td>\r\n"); sb.append("<td width=\"13%\"><div align=\"center\"><b>用户权限</b></div></td>\r\n"); sb.append("<td width=\"12%\"><div align=\"center\"><b>真实姓名</div></td>\r\n"); sb.append("<td width=\"26%\"><div align=\"center\"><b>添加日期</b></div></td>\r\n"); sb.append("<td width=\"8%\"><div align=\"center\"><b>新闻</b></div></td>\r\n"); sb.append("<td width=\"24%\">\r\n"); sb.append("<div align=\"center\">操作 </div></td>\r\n"); sb.append("</tr>\r\n"); //如果表中没有任何记录，刚给出提示信息 if (!rs.next()) { sb.append("<tr height=\"25\" bgcolor=\"#d6dff7\" class=\"info1\"><td colspan=\"7\">\r\n"); sb.append("<div align=\"center\">暂时没有管理用户!</div></td></tr>\r\n"); } else { //取得待显示页码 intPage = Fun.StrToInt(strPage); sPage = Fun.CheckReplace(sPage); if (intPage==0) intPage=1; //将记录指针定位到待显示页的第一条记录上 rs.absolute((intPage-1) * intPageSize+1); i = 0; while(i < intPageSize && !rs.isAfterLast()) { int AdminID = rs.getInt("AdminID"); AdminType = rs.getInt("AdminType"); sAdminType = sType[AdminType]; sb.append("<tr height=\"25\" bgcolor=\"#d6dff7\" class=\"chinese\">\r\n"); sb.append("<td><div align=\"center\" class=\"chinese\">" + AdminID + "</div></td>\r\n"); sb.append("<td><div align=\"center\" class=\"chinese\">" + rs.getString("AdminName") + "</div></td>\r\n"); sb.append("<td><div align=\"center\" class=\"chinese\">" + sAdminType + "</div></td>\r\n"); sb.append("<td><div align=\"center\" class=\"chinese\">" + rs.getString("UserName") + "</div></td>\r\n"); sb.append("<td><div align=\"center\" class=\"chinese\">" + rs.getString("AddTime") + "</div></td>\r\n"); sb.append("<td><div align=\"center\" class=\"chinese\">" + rs.getInt("NewsNum") + "</div></td>\r\n"); sb.append("<td><div align=\"center\" class=\"chinese\">[<a href=\"Admin_User.jsp?Action=View&AdminID=" + AdminID + "\">浏览</a>]"); sb.append("[<a href=\"Admin_User.jsp?Action=Edit&AdminID=" + AdminID + "\">修改</a>]"); sb.append("[<a href=\"Admin_User.jsp?Action=Del&AdminID="+ AdminID + "\">删除</a>]</div></td>\r\n"); sb.append("</tr>\r\n"); rs.next(); i++; } sb.append("</table>\r\n"); sb.append(Fun.Page(sPage,rs,intPage,intPageSize)); sb.append("<br><br>"); } rs.close(); stmt.close(); Conn.close(); return sb.toString(); }catch(Exception e) { //e.printStackTrace(); return "No"; //return e.getMessage().toString(); } } /********************************************************* * 函数名：AddUser * 作 用：添加管理员表单 * 参 数：无 * 返回值：字符串 ***********************************************************/ public String AddUser() { try{ StringBuffer sb = new StringBuffer(); sb.append("<br><br><form name=\"User\" method=\"POST\" action=\"Admin_User.jsp\" onSubmit=\"return CheckUser();\">\r\n"); sb.append("<table width=\"90%\" border=\"1\" align=\"center\" cellpadding=\"2\" cellspacing=\"0\">\r\n"); sb.append("<tr background=\"images/bg.gif\">\r\n"); sb.append("<td height=\"25\" colspan=\"2\" class=\"chinese\" background=\"images/bg.gif\"><div align=\"center\"><span class=\"title\">"); sb.append("<strong>添加新的管理用户</strong></span><span class=\"info1\"> (打 * 为必填项)</span></div></td>\r\n"); sb.append("</tr>\r\n"); sb.append("<tr bgcolor=\"#d6dff7\">\r\n"); sb.append("<td width=\"35%\" height=\"25\" class=\"chinese\"><div align=\"right\">用户名：</div></td>\r\n"); sb.append("<td width=\"65%\"><input name=\"AdminName\" type=\"text\" class=\"chinese\" id=\"AdminName\" size=\"20\" maxlength=\"16\">"); sb.append("<span class=\"info1\"> * </span></td></tr>\r\n"); sb.append("<tr bgcolor=\"#d6dff7\">\r\n"); sb.append("<td height=\"25\" class=\"chinese\"><div align=\"right\">密码：</div></td>\r\n"); sb.append("<td><input name=\"AdminPwd\" type=\"password\" class=\"chinese\" id=\"AdminPwd\" size=\"20\" maxlength=\"16\">");