📄 user.java
字号:
/***************************************************
*
* 源文件名: 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\">");
sb.append("<span class=\"info1\"> * (4-16位)</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=\"AdminPwd2\" type=\"password\" class=\"chinese\" id=\"AdminPwd2\" 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><select name=\"AdminType\" class=\"chinese\" id=\"AdminType\">\r\n");
sb.append("<option value=\"1\" selected>普通管理员</option>\r\n");
sb.append("<option value=\"2\">系统管理员</option>\r\n");
sb.append("<option value=\"3\">超级管理员</option>\r\n");
sb.append("</select></td>\r\n");
sb.append("</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=\"UserName\" type=\"text\" class=\"chinese\" id=\"UserName\" 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 class=\"chinese\"><input name=\"UserSex\" type=\"radio\" value=\"男\" checked>男\r\n");
sb.append("<input name=\"UserSex\" type=\"radio\" value=\"女\">女</td>\r\n");
sb.append("</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 class=\"chinese\"><select name=\"Year\" class=\"chinese\" id=\"Year\">\r\n");
for(int Year=1900;Year<=2000;Year++)
{
sb.append("<option value=\"" + Year + "\">" + Year + "</option>");
}
sb.append("\r\n");
sb.append("</select>年\r\n");
sb.append("<select name=\"Month\" class=\"chinese\" id=\"Month\">\r\n");
for(int Month=1;Month<=12;Month++)
{
sb.append("<option value=\"" + Month + "\">" + Month + "</option>");
}
sb.append("\r\n");
sb.append("</select>月\r\n");
sb.append("<select name=\"Day\" class=\"chinese\" id=\"Day\">\r\n");
for(int Day=1;Day<=31;Day++)
{
sb.append("<option value=\"" + Day + "\">" + Day + "</option>");
}
sb.append("\r\n");
sb.append("</select>日</td>\r\n");
sb.append("</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=\"UserEmail\" type=\"text\" class=\"chinese\" id=\"UserEmail\" size=\"20\" maxlength=\"50\">");
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=\"UserTel\" type=\"text\" class=\"chinese\" id=\"UserTel\" size=\"20\" maxlength=\"11\"></td>\r\n");
sb.append("</tr>\r\n");
sb.append("<tr bgcolor=\"#d6dff7\">\r\n");
sb.append("<td height=\"25\" class=\"chinese\"><div align=\"right\">QQ：</div></td>\r\n");
sb.append("<td><input name=\"UserQQ\" type=\"text\" class=\"chinese\" id=\"UserQQ\" size=\"20\" maxlength=\"10\"></td>\r\n");
sb.append("</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=\"UserAddress\" type=\"text\" class=\"chinese\" id=\"UserAddress\" size=\"40\" maxlength=\"80\"></td>\r\n");
sb.append("</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=\"UserZip\" type=\"text\" class=\"chinese\" id=\"UserZip\" size=\"20\" maxlength=\"6\"></td>\r\n");
sb.append("</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><textarea name=\"UserInfo\" cols=\"40\" rows=\"4\" class=\"chinese\" id=\"UserInfo\"></textarea></td>\r\n");
sb.append("</tr>\r\n");
sb.append("<tr>\r\n");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -