package?com.wmct.lmr.admin.dao;

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

import?com.wmct.lmr.admin.domain.Admin;
import?com.wmct.lmr.tools.conn.utils.JdbcUtils;

public?class?AdminDao?{

	public?Admin?findByAdminNameAndAdminPwd（Admin?admin）?throws?SQLException?{
		Admin?returnAdmin=null;
		String?sql=“select?*?from?w_admin?where?aname=??and?apwd=?“;
		Connection?connection=null;
		PreparedStatement?pStatement=null;
		ResultSet?resultSet=null;

		try?{
			connection=JdbcUtils.getConnection（）;
			pStatement=connection.prepareStatement（sql）;
			pStatement.setString（1?admin.getAname（））;
			pStatement.setString（2?admin.getApwd（））;
			resultSet=pStatement.executeQuery（）;

			while?（resultSet.next（））?{
				returnAdmin=new?Admin（resultSet.getInt（“aid“）resultSet.getString（“aname“）
						resultSet.getString（“apwd“）resultSet.getString（“email“））;
			}
		}?catch?（Exception?e）?{
			throw?new?RuntimeException（e）;
		}finally?{
			try?{
				if（resultSet!=null）
					resultSet.close（）;
				if（pStatement!=null）
					pStatement.close（）;
				if（connection!=null）
					connection.close（）;
			}?catch?（SQLException?e2）?{
				throw?new?RuntimeException（e2）;
			}
		}
		JdbcUtils.releaseConnection（connection）;
		return?returnAdmin;
	}
}

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

?????文件????????841??2017-09-29?15:08??Printer\.classpath

?????文件????????907??2017-09-29?15:08??Printer\.project

?????文件????????567??2017-09-29?15:08??Printer\.settings\.jsdtscope

?????文件????????364??2017-09-29?15:08??Printer\.settings\org.eclipse.jdt.core.prefs

?????文件????????473??2017-09-29?15:08??Printer\.settings\org.eclipse.wst.common.component

?????文件????????345??2017-09-29?15:08??Printer\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-09-29?15:08??Printer\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-09-29?15:08??Printer\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????730??2017-09-30?08:41??Printer\build\classes\c3p0-config.xml

?????文件???????2384??2017-10-10?14:38??Printer\build\classes\com\wmct\lmr\admin\dao\AdminDao.class

?????文件???????1665??2017-10-10?14:38??Printer\build\classes\com\wmct\lmr\admin\domain\Admin.class

?????文件????????868??2017-10-10?14:38??Printer\build\classes\com\wmct\lmr\admin\service\AdminService.class

?????文件???????4444??2017-10-10?14:38??Printer\build\classes\com\wmct\lmr\admin\servlet\AdminServlet.class

?????文件??????11215??2017-10-11?15:50??Printer\build\classes\com\wmct\lmr\print\dao\PrintDao.class

?????文件???????1180??2017-10-10?14:38??Printer\build\classes\com\wmct\lmr\print\domain\Company.class

?????文件???????3876??2017-10-10?14:38??Printer\build\classes\com\wmct\lmr\print\domain\Print.class

?????文件???????1176??2017-10-10?14:38??Printer\build\classes\com\wmct\lmr\print\domain\Room.class

?????文件???????1413??2017-10-10?14:38??Printer\build\classes\com\wmct\lmr\print\pager\expression.class

?????文件???????2965??2017-10-10?14:38??Printer\build\classes\com\wmct\lmr\print\pager\PageBean.class

?????文件????????370??2017-10-10?14:38??Printer\build\classes\com\wmct\lmr\print\pager\PageConstans.class

?????文件???????2321??2017-10-11?15:50??Printer\build\classes\com\wmct\lmr\print\service\PrintService.class

?????文件???????6118??2017-10-11?15:51??Printer\build\classes\com\wmct\lmr\print\servlet\PrintServlet.class

?????文件???????1999??2017-10-11?16:51??Printer\build\classes\com\wmct\lmr\servlet\AdminFilter.class

?????文件???????2339??2017-10-10?17:11??Printer\build\classes\com\wmct\lmr\servlet\baseServlet.class

?????文件???????2114??2017-10-10?14:38??Printer\build\classes\com\wmct\lmr\tools\conn\utils\JdbcUtils.class

?????文件???????1634??2017-10-10?14:38??Printer\build\classes\com\wmct\lmr\tools\verifycode\servlet\VerifyCodeServlet.class

?????文件???????3746??2017-10-10?14:38??Printer\build\classes\com\wmct\lmr\tools\verifycode\utils\VerifyCode.class

?????文件????????730??2017-09-30?08:41??Printer\src\c3p0-config.xml

?????文件???????1394??2017-09-30?16:14??Printer\src\com\wmct\lmr\admin\dao\AdminDao.java

?????文件????????946??2017-09-30?15:53??Printer\src\com\wmct\lmr\admin\domain\Admin.java

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