package?com.bean;

/**
?*?
?*?管理員登陸?修改密碼?登陸記錄查詢?通用類文件
?*?
?*/

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.text.SimpleDateFormat;
import?java.util.ArrayList;
import?java.util.Calendar;
import?java.util.List;

import?com.util.Constant;
import?com.util.DBO;

public?class?AdminBean?{

	private?List?list;
	private?ResultSet?rs?=?null;
	private?int?EVERYPAGENUM?=?2;
	private?int?count?=?-1;
	private?int?qq?=?0;
	private?String?sql=“select?count（*）?from?adminlog“;
	private?String?sql2=“select?*?from?adminlog?order?by?id?desc?“;
	//聲明時(shí)間變量
	String?date=new?SimpleDateFormat（“yyyy-MM-dd?HH:mm:ss“）.format（Calendar.getInstance（）.getTime（））;
	
	//分頁(yè)查詢登陸日志
	public?void?setEVERYPAGENUM（int?EVERYPAGENUM）{
????	this.EVERYPAGENUM=EVERYPAGENUM;
????}
????public?int?getMessageCount（）?{?//得到信息總數(shù)
???????DBO?dbo=new?DBO（）;
???????dbo.open（）;
????????try?{?
????????????rs?=?dbo.executeQuery（sql）;
????????????rs.next（）;
????????????count?=?rs.getInt（1）;
????????????return?count;
????????}?catch?（SQLException?ex）?{
????????????ex.printStackTrace（）;
????????????return?-1;
????????}?finally?{
????????????dbo.close（）;
????????}
????}
????public?int?getPageCount（）?{?//得到共多少頁(yè)（根據(jù)每頁(yè)要顯示幾條信息）
????????if?（count?%?EVERYPAGENUM?==?0）?{
????????????return?count?/?EVERYPAGENUM;
????????}?else?{
????????????return?count?/?EVERYPAGENUM?+?1;
????????}
????}
????public?List?getMessage（int?page）?{?//得到每頁(yè)要顯示的信息
????????DBO?dbo=new?DBO（）;
????????dbo.open（）;
????????List?list?=?new?ArrayList（）;
????????try?{
????????????rs?=?dbo.executeQuery（sql2）;
????????????for?（int?i?=?0;?i?????????????????rs.next（）;
????????????}
????????????for?（int?t?=?0;?t?????????????????if?（rs.next（））?{
????????????????????qq++;
????????????????????List?list2=new?ArrayList（）;
????????????????????list2.add（rs.getInt（“id“））;
????				list2.add（rs.getString（“username“））;
????				list2.add（rs.getString（“password“））;
????				list2.add（rs.getString（“l(fā)ogintime“））;
????				list2.add（rs.getString（“l(fā)oginip“））;
????				list2.add（rs.getString（“useros“））;
????				list2.add（rs.getString（“ok“））;
????				list.add（list2）;
????????????????}?else?{
????????????????????break;?//減少空循環(huán)的時(shí)間
????????????????}
????????????}
????????????return?list;
????????}?catch?（SQLException?ex）?{
????????????ex.printStackTrace（）;
????????????return?null;
????????}?finally?{
????????????dbo.close（）;
????????}
????}
	//管理員登錄?更新登錄次數(shù)?寫(xiě)登錄日志
	public?int?adminLogin（String?usernameString?md5passwordString?passwordString?loginipString?useros）{
		String?sql?=?“select?*?from?admin?where?username?=?‘“+username+“‘?and?isuse=‘1‘“;
		String?sql2?=?“insert?into?adminlog（usernamepasswordlogintimeloginipuserosok）?values（‘“+username+“‘‘“+md5password+“‘‘“+date+“‘‘“+loginip+“‘‘“+useros+“‘‘true‘）“;
		String?sql3?=?“insert?into?adminlog（usernamepasswordlogintimeloginipuserosok）?values（

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????2120643??2013-04-30?00:37??241JSP新生報(bào)到系統(tǒng)\JSP新生報(bào)到系統(tǒng)錄像.exe

?????文件????????622??2013-04-30?00:21??241JSP新生報(bào)到系統(tǒng)\xsbd\.classpath

?????文件????????285??2013-05-13?16:54??241JSP新生報(bào)到系統(tǒng)\xsbd\.mymetadata

?????文件???????1222??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\.project

?????文件???????7947??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\src\com\bean\AdminBean.java

?????文件????????318??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\src\com\util\CheckCode.java

?????文件???????1838??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\src\com\util\Common.java

?????文件????????533??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\src\com\util\Constant.java

?????文件???????2605??2013-05-13?16:58??241JSP新生報(bào)到系統(tǒng)\xsbd\src\com\util\DBO.java

?????文件????????650??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\src\com\util\Filter.java

?????文件???????2301??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\iframe\foot.jsp

?????文件???????1227??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\iframe\help.jsp

?????文件???????8908??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\iframe\left.jsp

?????文件???????2647??2013-04-30?00:28??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\iframe\main.jsp

?????文件???????5858??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\iframe\top.jsp

?????文件??????10889??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\admin_m.swf

?????文件???????6221??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\Admin_style.css

?????文件????????876??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\bg.jpg

?????文件????????315??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\bt_login.gif

?????文件????????179??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\bullet.gif

?????文件??????20734??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\calendar.js

?????文件??????26508??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\Common.js

?????文件???????3143??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\date.js

?????文件????????835??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\default.jsp

?????文件????????168??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\HardWare.gif

?????文件?????????85??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\img_u.gif

?????文件????????835??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\index.jsp

?????文件?????????57??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\linkbg1.gif

?????文件?????????63??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\linkbg2.gif

?????文件??????25985??2013-04-30?00:16??241JSP新生報(bào)到系統(tǒng)\xsbd\WebRoot\admin\images\MainBg.gif

............此處省略161個(gè)文件信息