package?cn.edu.qust.news.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?cn.edu.qust.news.dao.AdminDao;
import?cn.edu.qust.news.domain.Admin;
import?cn.edu.qust.news.utils.JdbcUtil;

public?class?AdminDao?{

	public?AdminDao（）?{
		//?TODO?Auto-generated?constructor?stub
	}

	public?Admin?findAdminByName（String?adminName）?{
		Connection?conn?=?null;
		PreparedStatement?stmt?=?null;
		ResultSet?rs?=?null;
		try?{
			conn?=?JdbcUtil.getConnection（）;
			stmt?=?conn
					.prepareStatement（“select?f_adminname?from?t_admin?where?f_adminname=?“）;
			stmt.setString（1?adminName）;
			rs?=?stmt.executeQuery（）;
			if?（rs.next（））?{
				Admin?admin?=?new?Admin（）;
				admin.setAdminName（rs.getString（“f_adminname“））;
				return?admin;
			}?else
				return?null;
		}?catch?（Exception?e）?{
			throw?new?RuntimeException（e）;
		}?finally?{
			JdbcUtil.release（rs?stmt?conn）;
		}
	}

	public?Admin?findAdmin（String?adminName?String?passWord）?{
		Connection?conn?=?null;
		PreparedStatement?stmt?=?null;
		ResultSet?rs?=?null;
		try?{
			conn?=?JdbcUtil.getConnection（）;
			stmt?=?conn
					.prepareStatement（“select?f_adminnamef_adminpassword?from?t_admin?where?f_adminname=??and?f_adminpassword=?“）;
			stmt.setString（1?adminName）;
			stmt.setString（2?passWord）;
			rs?=?stmt.executeQuery（）;
			if?（rs.next（））?{
				Admin?admin?=?new?Admin（）;
				admin.setAdminName（rs.getString（“f_adminname“））;
				admin.setAdminPassWord（rs.getString（“f_adminpassword“））;
				return?admin;
			}?else
				return?null;
		}?catch?（Exception?e）?{
			throw?new?RuntimeException（e）;
		}?finally?{
			JdbcUtil.release（rs?stmt?conn）;
		}
	}

	public?void?updateAdmin（String?passWord）?{
		Connection?conn?=?null;
		PreparedStatement?stmt?=?null;
		ResultSet?rs?=?null;
		try?{
			conn?=?JdbcUtil.getConnection（）;
			stmt?=?conn
					.prepareStatement（“update?t_admin?set?f_adminpassword=?“）;
			stmt.setString（1?passWord）;
			stmt.executeUpdate（）;

		}?catch?（Exception?e）?{
			throw?new?RuntimeException（e）;
		}?finally?{
			JdbcUtil.release（rs?stmt?conn）;
		}
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-07-06?16:44??News\
?????文件?????????921??2016-07-06?13:52??News\.classpath
?????文件????????1037??2014-12-04?21:45??News\.project
?????目錄???????????0??2016-07-06?16:44??News\.settings\
?????文件?????????503??2014-12-04?21:45??News\.settings\.jsdtscope
?????文件?????????100??2016-07-06?14:22??News\.settings\org.eclipse.core.resources.prefs
?????文件?????????598??2014-12-12?15:11??News\.settings\org.eclipse.jdt.core.prefs
?????文件?????????464??2014-12-04?21:45??News\.settings\org.eclipse.wst.common.component
?????文件?????????345??2016-07-06?13:52??News\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2014-12-04?21:45??News\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2014-12-04?21:45??News\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2016-07-06?16:44??News\WebContent\
?????目錄???????????0??2016-07-06?16:44??News\WebContent\meta-INF\
?????文件??????????39??2014-12-04?21:45??News\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2016-07-06?16:44??News\WebContent\WEB-INF\
?????目錄???????????0??2016-07-06?16:44??News\WebContent\WEB-INF\lib\
?????文件??????232019??2014-12-05?20:27??News\WebContent\WEB-INF\lib\commons-beanutils-1.8.3.jar
?????文件???????60841??2014-12-05?20:27??News\WebContent\WEB-INF\lib\commons-logging-1.1.1.jar
?????文件???????49990??2014-12-07?14:23??News\WebContent\WEB-INF\lib\fckeditor-java-core-2.4.1.jar
?????文件???????20682??2014-12-04?21:46??News\WebContent\WEB-INF\lib\jstl.jar
?????文件??????540852??2014-12-05?20:27??News\WebContent\WEB-INF\lib\mysql-connector-java-5.0.8-bin.jar
?????文件??????393259??2014-12-04?21:46??News\WebContent\WEB-INF\lib\standard.jar
?????文件?????????425??2014-12-09?20:51??News\WebContent\WEB-INF\web.xml
?????目錄???????????0??2016-07-06?16:44??News\WebContent\admin\
?????文件????????2202??2016-07-06?16:31??News\WebContent\admin\addNews.jsp
?????目錄???????????0??2016-07-06?16:44??News\WebContent\admin\images\
?????文件??????112351??2014-12-06?21:29??News\WebContent\admin\images\banner.png
?????文件???????17956??2014-12-06?22:13??News\WebContent\admin\images\body_03.jpg
?????文件???????21096??2014-12-06?22:13??News\WebContent\admin\images\body_05.jpg
?????文件????????3651??2014-12-06?22:13??News\WebContent\admin\images\body_06.jpg
?????文件????????2354??2014-12-06?22:13??News\WebContent\admin\images\btn1.jpg
............此處省略80個文件信息