package?com.example.dao;

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

import?com.example.entity.Address;
import?com.example.util.JdbcUtil;

public?class?AddressDao?{

	//?增加
	public?void?add（Address?address）?{
		try?{
			Connection?conn?=?JdbcUtil.getConnection（）;
			PreparedStatement?pstmt?=?conn.prepareStatement（“insert?into?address（namestreetcitystatezip）?values（?????）“）;
			pstmt.setString（1?address.getName（））;
			pstmt.setString（2?address.getStreet（））;
			pstmt.setString（3?address.getCity（））;
			pstmt.setString（4?address.getState（））;
			pstmt.setString（5?address.getZip（））;
			pstmt.executeUpdate（）;
			JdbcUtil.close（pstmt?conn）;

		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}

	//?刪除
	public?void?delete（int?id）?{
		try?{
			Connection?conn?=?JdbcUtil.getConnection（）;
			PreparedStatement?pstmt?=?conn.prepareStatement（“delete?from?address?where?id?=??“）;
			pstmt.setInt（1?id）;
			pstmt.executeUpdate（）;
			JdbcUtil.close（pstmt?conn）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			throw?new?RuntimeException（）;
		}
	}

	//?修改
	public?void?update（Address?address）?{
		try?{
			Connection?conn?=?JdbcUtil.getConnection（）;
			PreparedStatement?pstmt?=?conn.prepareStatement（“update?address?set?name?=??street?=??city?=??state?=?zip=???where?id?=??“）;
			
			pstmt.setString（1?address.getName（））;
			pstmt.setString（2?address.getStreet（））;
			pstmt.setString（3?address.getCity（））;
			pstmt.setString（4?address.getState（））;
			pstmt.setString（5?address.getZip（））;
			pstmt.setInt（6?address.getId（））;
			
			pstmt.executeUpdate（）;
			JdbcUtil.close（pstmt?conn）;

		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			throw?new?RuntimeException（）;
		}
	}

	//?查詢
	public?List
?findAll（）?{
		List
?list?=?new?ArrayList
（）;
		try?{
			Connection?conn?=?JdbcUtil.getConnection（）;
			PreparedStatement?pstmt?=?conn.prepareStatement（“select?*?from?address“）;
			ResultSet?rs?=?pstmt.executeQuery（）;
			while?（rs.next（））?{
				Address?address?=?new?Address（）;
				address.setId（rs.getInt（1））;
				address.setName（rs.getString（2））;
				address.setStreet（rs.getString（3））;
				address.setCity（rs.getString（4））;
				address.setState（rs.getString（5））;
				address.setZip（rs.getString（6））;
				list.add（address）;
			}
			JdbcUtil.close（pstmt?conn）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			throw?new?RuntimeException（）;
		}
		return?list;
	}

	//?根據id查詢
	public?Address?findById（int?id）?{
		Address?address?=?new?Address（）;
		try?{
			Connection?conn?=?JdbcUtil.getConnection（）;
			PreparedStatement?pstmt?=?conn.prepareStatement（“select?*?from?address?where?id=“?+?id）;
			ResultSet?rs?=?pstmt.executeQuery（）;
			if?（rs.next（））?{
				address.setId（rs.getInt（1））;
				address.setN

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-04-23?13:21??addr\
?????文件?????????606??2018-03-20?14:39??addr\.classpath
?????文件?????????904??2018-03-20?13:58??addr\.project
?????目錄???????????0??2018-04-23?13:21??addr\.settings\
?????文件?????????567??2018-03-20?13:58??addr\.settings\.jsdtscope
?????文件??????????68??2018-03-20?14:32??addr\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2018-03-20?13:57??addr\.settings\org.eclipse.jdt.core.prefs
?????文件?????????464??2018-03-20?13:57??addr\.settings\org.eclipse.wst.common.component
?????文件?????????305??2018-03-20?13:58??addr\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-03-20?13:58??addr\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-03-20?13:58??addr\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-04-23?13:21??addr\WebContent\
?????目錄???????????0??2018-04-23?13:21??addr\WebContent\meta-INF\
?????文件??????????39??2018-03-20?13:57??addr\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2018-04-23?13:21??addr\WebContent\WEB-INF\
?????目錄???????????0??2018-04-23?13:21??addr\WebContent\WEB-INF\lib\
?????文件??????775688??2018-03-20?14:39??addr\WebContent\WEB-INF\lib\mysql-connector-java-5.5.19.jar
?????文件?????????647??2018-03-20?13:59??addr\WebContent\WEB-INF\web.xml
?????文件?????????718??2018-03-20?14:19??addr\WebContent\add.jsp
?????文件????????1247??2018-03-20?16:12??addr\WebContent\edit.jsp
?????文件?????????304??2018-03-20?14:30??addr\WebContent\index.jsp
?????文件????????1089??2018-03-20?14:26??addr\WebContent\list.jsp
?????目錄???????????0??2018-04-23?13:21??addr\build\
?????目錄???????????0??2018-04-23?13:21??addr\build\classes\
?????目錄???????????0??2018-04-23?13:21??addr\build\classes\com\
?????目錄???????????0??2018-04-23?13:21??addr\build\classes\com\example\
?????目錄???????????0??2018-04-23?13:21??addr\build\classes\com\example\dao\
?????文件????????3760??2018-03-27?16:49??addr\build\classes\com\example\dao\AddressDao.class
?????目錄???????????0??2018-04-23?13:21??addr\build\classes\com\example\entity\
?????文件????????1461??2018-03-27?16:49??addr\build\classes\com\example\entity\Address.class
?????目錄???????????0??2018-04-23?13:21??addr\build\classes\com\example\servlet\
............此處省略14個文件信息