package?edu.lzjtu.dao;

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

import?edu.lzjtu.db.DbConn;
import?edu.lzjtu.entity.Phone;

public?class?PhoneDAO?{

	public?List?getList（）{
		Connection?conn;
		PreparedStatement?st;
		String?sql;
		ResultSet?rs;

		List?list;
		list?=?new?ArrayList（）;
		Phone?o;
		Integer?id;
		String?phonenumber;
		
		try{
//			sql=“select?count（*）?from?t_user?where?username=??and?pwd=?“;
			sql=“select?*?from?t_phone“;
			
			conn?=?new?DbConn（）.getConn（）;
			st?=?conn.prepareStatement（sql）;

			
			rs?=?st.executeQuery（）;
			
			while（rs.next（））{
				o=new?Phone（）;
				id?=?rs.getInt（1）;
				phonenumber?=?rs.get

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

?????文件????????841??2019-04-24?17:13??J2EE??源碼\.classpath

?????文件???????1037??2019-04-24?17:13??J2EE??源碼\.project

?????文件????????503??2019-04-24?17:13??J2EE??源碼\.settings\.jsdtscope

?????文件????????364??2019-04-24?17:13??J2EE??源碼\.settings\org.eclipse.jdt.core.prefs

?????文件????????464??2019-04-24?17:13??J2EE??源碼\.settings\org.eclipse.wst.common.component

?????文件????????345??2019-04-24?17:13??J2EE??源碼\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2019-04-24?17:13??J2EE??源碼\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2019-04-24?17:13??J2EE??源碼\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????4099??2019-04-24?18:34??J2EE??源碼\build\classes\edu\lzjtu\dao\PhoneDAO.class

?????文件???????1317??2019-04-24?17:38??J2EE??源碼\build\classes\edu\lzjtu\dao\UserDAO.class

?????文件???????1041??2019-04-24?17:38??J2EE??源碼\build\classes\edu\lzjtu\db\DbConn.class

?????文件???????1113??2019-04-24?17:52??J2EE??源碼\build\classes\edu\lzjtu\entity\Phone.class

?????文件???????1108??2019-04-24?17:21??J2EE??源碼\build\classes\edu\lzjtu\entity\User.class

?????文件???????1654??2019-04-24?18:35??J2EE??源碼\build\classes\edu\lzjtu\Servlet\DeleteServlet.class

?????文件???????1748??2019-04-24?18:04??J2EE??源碼\build\classes\edu\lzjtu\Servlet\EditServlet.class

?????文件???????1721??2019-04-24?18:20??J2EE??源碼\build\classes\edu\lzjtu\Servlet\InsertServlet.class

?????文件???????1831??2019-04-24?17:55??J2EE??源碼\build\classes\edu\lzjtu\Servlet\ListServlet.class

?????文件???????1619??2019-04-24?17:51??J2EE??源碼\build\classes\edu\lzjtu\Servlet\LoginServlet.class

?????文件???????1859??2019-04-24?18:13??J2EE??源碼\build\classes\edu\lzjtu\Servlet\SaveServlet.class

?????文件???????1738??2019-04-24?18:38??J2EE??源碼\db_course1904.sql

?????文件???????3831??2019-04-24?18:34??J2EE??源碼\src\edu\lzjtu\dao\PhoneDAO.java

?????文件????????846??2019-04-24?17:38??J2EE??源碼\src\edu\lzjtu\dao\UserDAO.java

?????文件????????537??2019-04-24?17:38??J2EE??源碼\src\edu\lzjtu\db\DbConn.java

?????文件????????476??2019-04-24?17:52??J2EE??源碼\src\edu\lzjtu\entity\Phone.java

?????文件????????638??2019-04-24?17:18??J2EE??源碼\src\edu\lzjtu\entity\User.java

?????文件???????1493??2019-04-24?18:35??J2EE??源碼\src\edu\lzjtu\Servlet\DeleteServlet.java

?????文件???????1572??2019-04-24?18:04??J2EE??源碼\src\edu\lzjtu\Servlet\EditServlet.java

?????文件???????1660??2019-04-24?18:20??J2EE??源碼\src\edu\lzjtu\Servlet\InsertServlet.java

?????文件???????1593??2019-04-24?17:55??J2EE??源碼\src\edu\lzjtu\Servlet\ListServlet.java

?????文件???????1515??2019-04-24?17:51??J2EE??源碼\src\edu\lzjtu\Servlet\LoginServlet.java

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