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?fz_adminlog“;
	private?String?sql2=“select?*?from?fz_adminlog?order?by?id?desc?“;
	//聲明時間變量
	String?date=new?SimpleDateFormat（“yyyy-MM-dd?HH:mm:ss“）.format（Calendar.getInstance（）.getTime（））;
	
	//分頁查詢登陸日志
	public?void?setEVERYPAGENUM（int?EVERYPAGENUM）{
????	this.EVERYPAGENUM=EVERYPAGENUM;
????}
????public?int?getMessageCount（）?{?//得到信息總數
???????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（）?{?//得到共多少頁（根據每頁要顯示幾條信息）
????????if?（count?%?EVERYPAGENUM?==?0）?{
????????????return?count?/?EVERYPAGENUM;
????????}?else?{
????????????return?count?/?EVERYPAGENUM?+?1;
????????}
????}
????public?List?getMessage（int?page）?{?//得到每頁要顯示的信息
????????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（“logintime“））;
????				list2.add（rs.getString（“loginip“））;
????				list2.add（rs.getString（“useros“））;
????				list2.add（rs.getString（“ok“））;
????				list.add（list2）;
????????????????}?else?{
????????????????????break;?//減少空循環的時間
????????????????}
????????????}
????????????return?list;
????????}?catch?（SQLException?ex）?{
????????????ex.printStackTrace（）;
????????????return?null;
????????}?finally?{
????????????dbo.close（）;
????????}
????}
	//管理員登錄?更新登錄次數?寫登錄日志
	public?int?adminLogin（String?usernameString?md5passwordString?passwordString?loginipString?useros）{
		String?sql?=?“select?*?from?fz_admin?where?username?=?‘“+username+“‘?and?isuse=‘1‘“;
		String?sql2?=?“insert?into?fz_adminlog（usernamepasswordlogintimeloginipuserosok）?values（‘“+username+“‘‘“+md5password+“‘‘“+date+“‘‘“+loginip+“‘‘“+useros+“‘‘true‘）“;
		String?sql3?=?“insert?into?fz_adminlog（usernamepasswordlogintimeloginipuse

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????42571??2012-06-30?13:43??010JSP校友錄\功能圖.JPG

?????文件????????709??2012-06-30?12:22??010JSP校友錄\校友錄\brxyl\.classpath

?????文件????????288??2012-07-01?06:55??010JSP校友錄\校友錄\brxyl\.mymetadata

?????文件???????1223??2012-06-30?20:48??010JSP校友錄\校友錄\brxyl\.project

?????文件???????7995??2012-07-01?02:10??010JSP校友錄\校友錄\brxyl\src\com\bean\AdminBean.java

?????文件??????18030??2012-06-30?17:00??010JSP校友錄\校友錄\brxyl\src\com\bean\MemberManageBean.java

?????文件????????318??2012-07-01?07:26??010JSP校友錄\校友錄\brxyl\src\com\util\CheckCode.java

?????文件???????1838??2012-06-30?11:04??010JSP校友錄\校友錄\brxyl\src\com\util\Common.java

?????文件????????533??2012-06-30?23:03??010JSP校友錄\校友錄\brxyl\src\com\util\Constant.java

?????文件???????2504??2012-06-30?16:32??010JSP校友錄\校友錄\brxyl\src\com\util\DBO.java

?????文件????????650??2012-06-30?08:01??010JSP校友錄\校友錄\brxyl\src\com\util\Filter.java

?????文件????????835??2012-06-30?15:54??010JSP校友錄\校友錄\brxyl\WebRoot\admin\affiche\default.jsp

?????文件???????4057??2012-07-01?04:54??010JSP校友錄\校友錄\brxyl\WebRoot\admin\affiche\edit.jsp

?????文件???????4380??2012-06-30?20:23??010JSP校友錄\校友錄\brxyl\WebRoot\admin\affiche\index.jsp

?????文件???????2738??2012-06-30?10:24??010JSP校友錄\校友錄\brxyl\WebRoot\admin\banji\banji.jsp

?????文件???????2464??2012-06-30?17:49??010JSP校友錄\校友錄\brxyl\WebRoot\admin\banji\gbook.jsp

?????文件???????2921??2012-06-30?23:05??010JSP校友錄\校友錄\brxyl\WebRoot\admin\banji\photo.jsp

?????文件???????2463??2012-07-01?06:31??010JSP校友錄\校友錄\brxyl\WebRoot\admin\banji\ppl.jsp

?????文件????????926??2012-06-30?21:56??010JSP校友錄\校友錄\brxyl\WebRoot\admin\default.jsp

?????文件????????835??2012-06-30?14:04??010JSP校友錄\校友錄\brxyl\WebRoot\admin\guestbook\default.jsp

?????文件???????9139??2012-06-30?10:04??010JSP校友錄\校友錄\brxyl\WebRoot\admin\guestbook\index.jsp

?????文件???????3416??2012-06-30?09:16??010JSP校友錄\校友錄\brxyl\WebRoot\admin\guestbook\replay.jsp

?????文件????????838??2012-06-30?11:30??010JSP校友錄\校友錄\brxyl\WebRoot\admin\iframe\default.jsp

?????文件???????2418??2012-06-30?08:54??010JSP校友錄\校友錄\brxyl\WebRoot\admin\iframe\foot.jsp

?????文件???????1227??2012-06-30?23:05??010JSP校友錄\校友錄\brxyl\WebRoot\admin\iframe\help.jsp

?????文件????????838??2012-06-30?17:35??010JSP校友錄\校友錄\brxyl\WebRoot\admin\iframe\index.jsp

?????文件??????11067??2012-06-30?08:58??010JSP校友錄\校友錄\brxyl\WebRoot\admin\iframe\left.jsp

?????文件???????4601??2012-06-30?16:26??010JSP校友錄\校友錄\brxyl\WebRoot\admin\iframe\main.jsp

?????文件???????5949??2012-06-30?23:50??010JSP校友錄\校友錄\brxyl\WebRoot\admin\iframe\top.jsp

?????文件??????10889??2012-06-30?21:42??010JSP校友錄\校友錄\brxyl\WebRoot\admin\images\admin_m.swf

............此處省略704個文件信息