package?com.scien.common;

import?java.sql.ResultSet;
import?java.util.ArrayList;
import?java.util.List;

import?com.scien.entity.User;
import?com.scien.entity.Menu;
import?com.scien.Dao.DBAccess;
import?javax.servlet.http.HttpSession;?
import?javax.servlet.http.HttpServletRequest;

public?class?Logon?{
	
	private?User?user?=?new?User（）;
	private?DBAccess?dao?=?new?DBAccess（）;
	

	/*
	?*?@method?login.
	?*?@param:?request?HttpServletRequest.
	?*?@param:?userName?String.?
	?*?@param:?password?String.
	?*?@function:?login?DB?and?save?loginer?information?into?session.
	?*/
	public?void?login（HttpServletRequest?requestString?userNameString?password）{
		String?sql?=?“select?*?from?sci_user?where?userName=‘“+userName+“‘?and?password=‘“+password+“‘“;
		ResultSet?rs?=?null;
		
		HttpSession?session?=?request.getSession（）;
		try{
			rs?=?dao.query（sql）;
			while（rs.next（））{
				user.setUid（rs.getInt（“uid“））;
				user.setRid（rs.getInt（“rid“））;
				user.setUserName（rs.getString（“userName“））;
				user.setTrueName（rs.getString（“trueName“））;
				user.setAge（rs.getInt（“age“））;
				user.setPassword（rs.getString（“password“））;
				user.setPosition（rs.getString（“position“））;
				user.setCorporation（rs.getString（“corporation“））;
				user.setTel（rs.getString（“tel“））;
				user.setEmail（rs.getString（“email“））;
				user.setAddress（rs.getString（“address“））;
				user.setAuthority（rs.getString（“authority“））;
				user.setTotal（rs.getInt（“total“））;
				user.setPassed（rs.getInt（“passed“））;
			}	
			session.setAttribute（“user“?user）;
			rs.close（）;
			dao.closeConnection（）;
		}catch（Exception?ex）{
			System.out.println（“method:dao.login（）/error?is?happend?!“）;
			ex.printStackTrace（）;
			System.exit（0）;
		}
	}
	
	/*
	?*?logout
	?*/
	public?void?logout（HttpServletRequest?request）{
		HttpSession?session?=?request.getSession（false）;
		session.invalidate（）;		
	}
	
	/*
	?*?@method?isValidUser.
	?*?@param:?sql?String.
	?*?@function:check?the?user?is?valide?or?not.
	?*?@return:?true?boolean:the?user?is?valide?and?save?the?user‘s?information?into?session;
	?*??false?boolean:the?user?is?not?valide.
	?*/
	public?boolean?isValiadUser（String?userNameString?password）?{	
		String?sql?=?“select?*?from?sci_user?where?userName=‘“+userName+“‘?and?password=‘“+password+“‘“;
		ResultSet?rs?=?dao.query（sql）;
		boolean?flag?=?false;
		try{
			flag?=?rs.next（）;
			rs.close（）;
			dao.closeConnection（）;
		}catch（Exception?ex）{
			System.out.println（“error->?method:Logon.isValidUser（）/error?is?happend!“）;
			ex.printStackTrace（）;
		}
		return?flag;
	}	
	
	/*
	?*?@method:?getMenus.
	?*?@param:?request?HttpServletRequest.
	?*?@param:?role?String?/user‘s?role.
	?*?@function:?get?the?role‘s?menus?and?save?them?into?session.
	?*?@return:?List/role‘s?menus‘?list.?
	?*/
	public?List?getMenus（HttpServletRequest?requestString?rid）{
		String[]?role_rids?=?rid.split（““）;
		ArrayList?menusList?=?new?ArrayList（）;

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

?????文件???????1422??2009-05-19?10:12??scien\.classpath

?????文件????????288??2009-05-19?10:12??scien\.mymetadata

?????文件????????256??2009-03-26?09:20??scien\.mystrutsdata

?????文件???????1306??2009-03-26?09:20??scien\.project

?????文件?????????88??2009-05-05?09:23??scien\.settings\org.eclipse.core.resources.prefs

?????文件???????4938??2009-05-19?10:16??scien\src\com\scien\common\Logon.java

?????文件???????3775??2009-05-10?13:29??scien\src\com\scien\common\PageBean.java

?????文件???????4753??2009-05-16?12:15??scien\src\com\scien\Dao\DBAccess.java

?????文件????????627??2009-05-09?17:04??scien\src\com\scien\entity\Menu.java

?????文件??????10548??2009-05-19?10:21??scien\src\com\scien\entity\Nature.java

?????文件????????668??2009-05-10?12:02??scien\src\com\scien\entity\Role.java

?????文件????????418??2009-05-19?11:34??scien\src\com\scien\entity\Subject.java

?????文件???????4043??2009-05-19?10:17??scien\src\com\scien\entity\User.java

?????文件???????1143??2009-05-08?21:08??scien\src\com\scien\filter\CharacterEncodFilter.java

?????文件???????4707??2009-05-15?22:27??scien\src\com\scien\struts\action\AchieveAction.java

?????文件??????15083??2009-05-16?14:07??scien\src\com\scien\struts\action\CheckAction.java

?????文件???????2898??2009-05-15?23:16??scien\src\com\scien\struts\action\CheckerAction.java

?????文件???????5785??2009-05-19?15:42??scien\src\com\scien\struts\action\ForwardAction.java

?????文件???????3362??2009-05-10?14:02??scien\src\com\scien\struts\action\LoginAction.java

?????文件???????8770??2009-05-19?15:36??scien\src\com\scien\struts\action\NatureAction.java

?????文件???????4501??2009-05-15?23:17??scien\src\com\scien\struts\action\RegisterAction.java

?????文件???????2956??2009-05-19?10:18??scien\src\com\scien\struts\action\RightAction.java

?????文件???????4944??2009-05-19?10:19??scien\src\com\scien\struts\action\RoleAuthAction.java

?????文件??????12707??2009-05-19?14:08??scien\src\com\scien\struts\action\SearchAction.java

?????文件??????10984??2009-05-19?15:41??scien\src\com\scien\struts\action\SocietyAction.java

?????文件???????3321??2009-05-19?12:01??scien\src\com\scien\struts\action\TestAction.java

?????文件???????6265??2009-05-15?23:09??scien\src\com\scien\struts\action\UserAction.java

?????文件???????1982??2009-05-16?08:48??scien\src\com\scien\struts\ApplicationResources.properties

?????文件???????2034??2009-05-08?21:08??scien\src\com\scien\struts\form\CheckForm.java

?????文件???????4116??2009-05-08?21:08??scien\src\com\scien\struts\form\CkerForm.java

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