/***********************************************
?/*
?/*用戶操作
?/*
?/*******************************************?*/
package?com.admin;

import?java.sql.*;
import?java.util.ArrayList;

import?com.util.*;

public?class?Admin?{
	
	??public?String?adminid?=?““;
	??
	??public?String?pwd=““;
	??
	??public?String?prelogin=““;
	??
	??public?String?logintime=““;
	??
	??public?int?totle=0;
	??
	??public?int?id;

	??
?????public?Admin（）?{
????????????	?
	?}
??
??//管理員登陸
?	public?int?login（）?throws?Exception{
	????Connection?conn=null;
	????PreparedStatement?stmt?=null;
	????ResultSet?rs?=null;
	????int?flag=0;
	??????String?sql?=?“select?*?from?admin?where?adminid=?“;
	????try{
	??????conn?=DBConn.getConn（）;
	??????stmt?=conn.prepareStatement（sql）;?
	??????stmt.setString（1?adminid）;
	??????rs?=?stmt.executeQuery（）;
	??????if（rs.next（））{
	????	??sql=“select?*?from?admin?where?adminid=??and?pwd=?“;
	????	??stmt?=conn.prepareStatement（sql）;
		??????stmt.setString（1?adminid）;
		??????stmt.setString（2?pwd）;
		??????rs?=?stmt.executeQuery（）;
		???????if（rs.next（））{
		????	???
		?????	??java.util.Date?date=new?java.util.Date（）;
				???Timestamp?tt=new?Timestamp（date.getTime（））;??
				???
		????	??????if（rs.getInt（“totle“）==0）{
		????	????????sql=“update?admin?set?totle=1logintime=??where?adminid=?“;
			????	????stmt?=conn.prepareStatement（sql）;
				????????stmt.setTimestamp（1?tt）;
				????????stmt.setString（2adminid）;
				????????stmt.executeUpdate（）;
		????	??????}else{
			????	????sql=“update?admin?set?totle=totle+1logintime=?prelogin=??where?adminid=?“;
				????	stmt?=conn.prepareStatement（sql）;
					????stmt.setTimestamp（1?tt）;
					????stmt.setString（2rs.getString（“l(fā)ogintime“））;
					????stmt.setString（3adminid）;
					????stmt.executeUpdate（）;	??
		????	??????}

		????	???flag=3;//登陸成功
		???????}
		???????else{
		????	???flag=2;//密碼錯(cuò)誤
		???????}
	??????}else{
	????????flag=1;//不存在此管理員
	??????}
	????}catch（Exception?e）{
	????	e.printStackTrace（）;???
	????}finally{
	??????try{
	????????if（rs!=null）
	??????????rs.close（）;
	????????if（stmt!=null）
	??????????stmt.close（）;
	????????if（conn!=null）
	??????????conn.close（）;
	??????}catch（Exception?ee）{
	????	??ee.printStackTrace（）;???
	??????}
	????}
	???return?flag;
	??}

?	
????//判斷是否存在該管理員名稱
?	public?int?isAdminExist（）?throws?Exception{
	????Connection?conn=null;
	????PreparedStatement?stmt?=null;
	????ResultSet?rs?=null;
	????int?flag=0;
	??????String?sql?=?“select?*?from?admin?where?adminid=?“;
	????try{
	??????conn?=DBConn.getConn（）;
	??????stmt?=conn.prepareStatement（sql）;?
	??????stmt.setString（1?adminid）;
	??????rs?=?stmt.executeQuery（）;
	??????if（rs.next（））{
	????	???flag=1;//存在
		???????}
		???else{
		????	???flag=2;//不存在
		???????}
	??????
	????}catch（Exception?e）{
	????	e.printStackTrace（）;???
	????}finally{
	??????try{
	????????if（rs!=null）
	??????????rs.close（）;
	????????if（s

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

?????文件??????62464??2007-05-11?15:19??畢業(yè)設(shè)計(jì)\WebRoot\work\11-軟件工程第一章作業(yè)-103111001.doc

?????文件??????62464??2007-05-11?15:20??畢業(yè)設(shè)計(jì)\WebRoot\work\11-軟件工程第一章作業(yè)-103111002.doc

?????文件??????62464??2007-05-11?15:21??畢業(yè)設(shè)計(jì)\WebRoot\work\11-軟件工程第一章作業(yè)-103111005.doc

?????文件??????62464??2007-05-11?15:23??畢業(yè)設(shè)計(jì)\WebRoot\work\11-軟件工程第一章作業(yè)-103111008.doc

?????文件??????62464??2007-05-11?15:23??畢業(yè)設(shè)計(jì)\WebRoot\work\11-軟件工程第一章作業(yè)-103111009.doc

?????文件??????62464??2007-05-11?15:22??畢業(yè)設(shè)計(jì)\WebRoot\work\11-軟件工程第一章作業(yè)-103111010.doc

?????文件??????62464??2007-05-11?15:23??畢業(yè)設(shè)計(jì)\WebRoot\work\11-軟件工程第一章作業(yè)-103111011.doc

?????文件???????6820??2007-05-11?15:16??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\classes\com\admin\Admin.class

?????文件??????10427??2007-05-11?15:16??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\classes\com\index\Article.class

?????文件???????7804??2007-05-11?15:16??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\classes\com\room\Course.class

?????文件???????1403??2007-05-11?15:16??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\classes\com\util\DBConn.class

?????文件??????16755??2007-05-11?15:16??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\classes\com\index\Know.class

?????文件???????4521??2007-05-11?15:16??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\classes\com\room\Log.class

?????文件???????5804??2007-05-11?15:16??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\classes\com\know\Module.class

?????文件???????5008??2007-05-11?15:16??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\classes\com\room\News.class

?????文件???????1949??2007-05-11?15:16??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\classes\com\util\SetCharacterEncodingFilter.class

?????文件??????11279??2007-05-11?15:16??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\classes\com\index\User.class

?????文件???????8849??2007-05-11?15:16??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\classes\com\room\Work.class

?????文件????????626??2007-05-11?10:11??畢業(yè)設(shè)計(jì)\.classpath

?????文件???????4408??2007-04-25?12:40??畢業(yè)設(shè)計(jì)\WebRoot\css\css.css

?????文件???????2053??2007-04-04?08:27??畢業(yè)設(shè)計(jì)\WebRoot\css\k_css.css

?????文件???????1290??2007-04-26?16:36??畢業(yè)設(shè)計(jì)\WebRoot\admin\css\left.css

????..A.SH.?????76288??2007-04-26?10:40??畢業(yè)設(shè)計(jì)\WebRoot\admin\images\Thumbs.db

????..A.SH.????371290??2007-05-11?10:56??畢業(yè)設(shè)計(jì)\WebRoot\images\Thumbs.db

?????文件?????287022??2007-04-03?09:17??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\lib\msbase.jar

?????文件??????67115??2007-04-03?09:17??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\lib\mssqlserver.jar

?????文件??????59074??2007-04-03?09:17??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\lib\msutil.jar

?????文件??????12201??2007-04-10?12:45??畢業(yè)設(shè)計(jì)\WebRoot\WEB-INF\lib\smartupload.jar

?????文件???????8777??2007-04-24?17:28??畢業(yè)設(shè)計(jì)\src\com\admin\Admin.java

?????文件??????12569??2007-04-26?10:00??畢業(yè)設(shè)計(jì)\src\com\index\Article.java

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