package?dao;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?vo.Customer;
public?class?CustomerDao?{//訪問數據庫
	private?Connection?conn?=?null;
	public?void?initConnection（）?throws?Exception?{
		Class.forName（“com.mysql.jdbc.Driver“）;
		conn?=?DriverManager.getConnection（
		“jdbc:mysql://localhost:3306/mysql““root““123456“）;
	}
	public?void?closeConnection（）?throws?Exception?{
		conn.close（）;
	}
	public?Customer?getNameByAccount（String?account）?throws?Exception?{
		String?sql?=?“SELECT?ACCOUNTPASSWORDCNAME?“
				+?“FROM?t_teacher?WHERE?ACCOUNT=?“;
		this.initConnection（）;
		PreparedStatement?ps?=?conn.prepareStatement（sql）;
		ps.setString（1?account）;
		ResultSet?rs?=?ps.executeQuery（）;
		if?（rs.next（））?{
			Customer?cus?=?new?Customer（）;
			cus.setAccount（rs.getString（“ACCOUNT“））;
			cus.setPassword（rs.getString（“PASSWORD“））;
			cus.setCname（rs.getString（“CNAME“））;
			return?cus;
		}
		closeConnection（）;
		return?null;
}}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-12-13?11:01??test2\
?????文件????????1389??2018-12-03?16:01??test2\.classpath
?????文件?????????905??2018-11-03?12:34??test2\.project
?????目錄???????????0??2018-12-13?11:01??test2\.settings\
?????文件?????????567??2018-11-03?12:34??test2\.settings\.jsdtscope
?????文件?????????364??2018-11-03?12:34??test2\.settings\org.eclipse.jdt.core.prefs
?????文件?????????117??2018-12-03?14:50??test2\.settings\org.eclipse.jst.j2ee.ejb.annotations.xdoclet.prefs
?????文件?????????467??2018-11-03?12:34??test2\.settings\org.eclipse.wst.common.component
?????文件?????????345??2018-11-03?12:34??test2\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-11-03?12:34??test2\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-11-03?12:34??test2\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件??????????87??2018-12-03?14:50??test2\.settings\org.eclipse.wst.ws.service.policy.prefs
?????目錄???????????0??2018-12-13?11:01??test2\build\
?????目錄???????????0??2018-12-13?11:01??test2\build\classes\
?????目錄???????????0??2018-12-13?11:01??test2\build\classes\dao\
?????文件????????1990??2018-12-11?20:28??test2\build\classes\dao\CustomerDao.class
?????文件????????2883??2018-12-12?09:40??test2\build\classes\dao\scoredao.class
?????文件????????4225??2018-12-07?15:34??test2\build\classes\dao\StudentDao.class
?????目錄???????????0??2018-12-13?11:01??test2\build\classes\servlet\
?????文件????????2154??2018-12-11?20:11??test2\build\classes\servlet\AutoQueryServlet.class
?????文件????????2151??2018-12-07?15:34??test2\build\classes\servlet\PageServlet1.class
?????文件????????2762??2018-12-11?20:35??test2\build\classes\servlet\UpdateServlet.class
?????文件????????3369??2018-12-12?22:18??test2\build\classes\servlet\Validate.class
?????文件????????3410??2018-12-11?22:08??test2\build\classes\servlet\ValidateServlet.class
?????目錄???????????0??2018-12-13?11:01??test2\build\classes\vo\
?????文件?????????893??2018-12-11?20:11??test2\build\classes\vo\Customer.class
?????文件????????1245??2018-12-12?09:23??test2\build\classes\vo\score.class
?????文件????????1666??2018-12-07?15:34??test2\build\classes\vo\Student.class
?????目錄???????????0??2018-12-13?11:01??test2\mysql\
?????文件???????11738??2018-12-11?22:59??test2\mysql\student1.sql
?????文件????????1022??2018-12-11?22:59??test2\mysql\t_course.sql
............此處省略60個文件信息