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