package?com.hhtc.yully.dao.impl;

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

import?com.hhtc.yully.util.Jdbc;
import?com.hhtc.yully.vo.Admin;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?java.util.List;

public?class?AdminDaoImpl?{
	public?static?Jdbc?jdbc?=?new?Jdbc（）;
	public?static?Connection?conn;
	public?static?PreparedStatement?pstmt;
	public?static?ResultSet?rs;
		
	public?List?Login（Admin?admin）?{
		List?all?=?new?ArrayList（）;
		try?{
			//???????l???????conn
			conn?=?jdbc.getConnection（）;
			//??conn???????PreparedStatement????????stmt
			String?sql?=?“select?*?from?admin?where?name=?“;
			pstmt?=?conn.prepareStatement（sql）;
			pstmt.setString（1?admin.getName（））;
			rs=pstmt.executeQuery（）;
			if（!（rs.next（）））?{
				String?err1?=?“用戶名不存在“;
				all.add（err1）;
			}?else?{
				String?sql1?=?“select?password?from?admin?where?name=?“;
				pstmt?=?conn.prepareStatement（sql1）;
				pstmt.setString（1?admin.getName（））;
				rs=pstmt.executeQuery（）;?
				while（rs.next（））?{
					String?password?=?admin.getPassword（）;
					if（!（password.equals（rs.getString（“password“））））?{
						String?err2?=?“密碼不正確“;
						all.add（err2）;
					}
				}
			}	
		}?catch?（SQLException?e）?{
			//???????l????????????????
			System.err.println（“SQLException:?“+?e.getMessage（））;
		}?catch?（ClassNotFoundException?e）?{
			//????JDBC??????????????????
			System.err.print（“ClassNotFoundException.“）;
			//???????
			System.err.print（e.getMessage（））;
		}?finally?{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				//?????????
				System.err.println（“Database?Close?error.“）;
			}
		}
		return?all;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-12-30?15:41??基于SSH的網上招聘求職系統的源代碼+sql文件\
?????文件????????4457??2009-04-26?10:41??基于SSH的網上招聘求職系統的源代碼+sql文件\job.sql
?????目錄???????????0??2009-04-12?10:49??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\
?????文件?????????433??2008-12-27?13:15??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\.classpath
?????目錄???????????0??2019-12-30?15:42??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\.myeclipse\
?????文件?????????288??2009-04-12?10:49??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\.mymetadata
?????文件??????????66??2009-01-12?13:03??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\.myumldata
?????文件????????1223??2008-11-26?16:27??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\.project
?????目錄???????????0??2009-04-12?10:49??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\.settings\
?????文件??????????88??2009-04-01?14:59??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\.settings\org.eclipse.core.resources.prefs
?????文件??????????83??2009-01-12?13:00??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\.settings\org.eclipse.core.runtime.prefs
?????文件?????????334??2008-11-26?16:07??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2009-04-22?10:17??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\
?????目錄???????????0??2009-04-12?10:49??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\meta-INF\
?????文件??????????39??2008-11-26?16:07??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2009-04-17?21:44??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\
?????目錄???????????0??2009-04-27?21:51??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\
?????目錄???????????0??2009-04-27?21:51??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2009-04-27?21:51??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\com\hhtc\
?????目錄???????????0??2009-04-27?21:51??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\com\hhtc\yully\
?????目錄???????????0??2009-04-27?21:51??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\com\hhtc\yully\dao\
?????目錄???????????0??2009-04-27?21:51??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\com\hhtc\yully\dao\impl\
?????文件????????2800??2009-04-27?21:51??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\com\hhtc\yully\dao\impl\AdminDaoImpl.class
?????文件????????7507??2009-04-27?22:12??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\com\hhtc\yully\dao\impl\ArticlesDaoImpl.class
?????文件????????6792??2009-04-27?21:51??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\com\hhtc\yully\dao\impl\CominforDaoImpl.class
?????文件????????8727??2009-04-27?21:51??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\com\hhtc\yully\dao\impl\CompanyDaoImpl.class
?????文件???????24077??2009-04-28?17:28??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\com\hhtc\yully\dao\impl\CvsDaoImpl.class
?????文件????????2325??2009-04-27?21:51??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\com\hhtc\yully\dao\impl\HrmsgDaoImpl.class
?????文件????????8200??2009-04-27?21:51??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\com\hhtc\yully\dao\impl\IndexDaoImpl.class
?????文件???????14224??2009-04-27?21:51??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\com\hhtc\yully\dao\impl\JobDaoImpl.class
?????文件????????7193??2009-04-27?21:51??基于SSH的網上招聘求職系統的源代碼+sql文件\myweb\WebRoot\WEB-INF\classes\com\hhtc\yully\dao\impl\UserDaoImpl.class
............此處省略242個文件信息