/***********************************************
?/*
?/*用戶操作
?/*
?/*******************************************?*/
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í)間???名稱
-----------?---------??----------?-----??----

?????文件????????626??2007-05-11?10:11??教學(xué)資源管理與師生交互平臺(tái)\.classpath

?????文件????????309??2007-05-11?15:16??教學(xué)資源管理與師生交互平臺(tái)\.mymetadata

?????文件???????1230??2007-02-14?14:11??教學(xué)資源管理與師生交互平臺(tái)\.project

?????文件????1507328??2007-05-11?16:08??教學(xué)資源管理與師生交互平臺(tái)\database\sll103111040_Data.MDF

?????文件????1048576??2007-05-11?16:08??教學(xué)資源管理與師生交互平臺(tái)\database\sll103111040_Log.LDF

?????文件???????8777??2007-04-24?17:28??教學(xué)資源管理與師生交互平臺(tái)\src\com\admin\Admin.java

?????文件??????12569??2007-04-26?10:00??教學(xué)資源管理與師生交互平臺(tái)\src\com\index\Article.java

?????文件??????22252??2007-04-12?12:39??教學(xué)資源管理與師生交互平臺(tái)\src\com\index\Know.java

?????文件??????16063??2007-05-06?11:08??教學(xué)資源管理與師生交互平臺(tái)\src\com\index\User.java

?????文件???????7224??2007-04-13?09:20??教學(xué)資源管理與師生交互平臺(tái)\src\com\know\Module.java

?????文件??????10312??2007-05-11?13:45??教學(xué)資源管理與師生交互平臺(tái)\src\com\room\Course.java

?????文件???????5384??2007-04-24?16:27??教學(xué)資源管理與師生交互平臺(tái)\src\com\room\Log.java

?????文件???????5627??2007-04-25?13:27??教學(xué)資源管理與師生交互平臺(tái)\src\com\room\News.java

?????文件??????12150??2007-05-10?20:55??教學(xué)資源管理與師生交互平臺(tái)\src\com\room\Work.java

?????文件????????906??2007-03-26?17:09??教學(xué)資源管理與師生交互平臺(tái)\src\com\util\DBConn.java

?????文件???????1836??2007-03-26?19:36??教學(xué)資源管理與師生交互平臺(tái)\src\com\util\SetCharacterEncodingFilter.java

?????文件????????815??2007-04-26?09:21??教學(xué)資源管理與師生交互平臺(tái)\WebRoot\admin\article\add.jsp

?????文件???????4964??2007-04-13?15:15??教學(xué)資源管理與師生交互平臺(tái)\WebRoot\admin\article\addArticle.jsp

?????文件???????5702??2007-04-11?08:34??教學(xué)資源管理與師生交互平臺(tái)\WebRoot\admin\article\audit.jsp

?????文件????????657??2007-04-11?16:34??教學(xué)資源管理與師生交互平臺(tái)\WebRoot\admin\article\del.jsp

?????文件???????1162??2007-04-11?14:14??教學(xué)資源管理與師生交互平臺(tái)\WebRoot\admin\article\edit.jsp

?????文件???????5849??2007-04-11?14:03??教學(xué)資源管理與師生交互平臺(tái)\WebRoot\admin\article\editArticle.jsp

?????文件???????5617??2007-04-12?12:54??教學(xué)資源管理與師生交互平臺(tái)\WebRoot\admin\article\list.jsp

?????文件????????722??2007-04-11?11:14??教學(xué)資源管理與師生交互平臺(tái)\WebRoot\admin\article\showfilename.jsp

?????文件???????1293??2007-05-10?13:14??教學(xué)資源管理與師生交互平臺(tái)\WebRoot\admin\article\upload.jsp

?????文件???????1256??2007-04-11?09:46??教學(xué)資源管理與師生交互平臺(tái)\WebRoot\admin\article\upload_ok.jsp

?????文件????????279??2007-04-12?09:28??教學(xué)資源管理與師生交互平臺(tái)\WebRoot\admin\checklogin.jsp

?????文件???????1290??2007-04-26?16:36??教學(xué)資源管理與師生交互平臺(tái)\WebRoot\admin\css\left.css

?????文件??????24277??2007-04-09?09:14??教學(xué)資源管理與師生交互平臺(tái)\WebRoot\admin\images\11_01.gif

?????文件???????7417??2007-04-09?09:14??教學(xué)資源管理與師生交互平臺(tái)\WebRoot\admin\images\11_02.gif

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