package?com.four.addresslist.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;
import?com.four.addresslist.enitity.Group;
import?com.four.addresslist.enitity.Contact;
import?com.four.addresslist.enitity.ContactALL;
import?com.four.addresslist.utils.DBUtil;

public?class?ContactALLDao?{
	public?List?getAll（）{
		List?list?=?new?ArrayList（）;
		try{
			
			Connection?conn?=?DBUtil.getConnection（）;
			Statement?sta?=?conn.createStatement（）;
			ResultSet?rs?=?sta.executeQuery（“select?*?from?[cga]“）;
			while（rs.next（））{
				ContactALL?t?=?new?ContactALL（）;
				t.setCid（?rs.getString（“Gname“）?）;
				t.setCname（?rs.getString（“Cname“）?）;
				t.setCaddress（rs.getString（“Caddress“））;
				t.setCmail（?rs.getString（“Cmail“）?）;
				t.setCphone（?rs.getString（“Cphone“）?）;
				
				list.add（t）;
			}
			rs.close（）;
			sta.close（）;
			conn.close（）;
			
		}catch（SQLException?e）{
			e.printStackTrace（）;
		}
		return?list;
	}

	
	public?void?delete（String?cid）?{
		try?{
			Connection?conn?=?DBUtil.getConnection（）;
			Statement?sta?=?conn.createStatement（）;
			sta.executeUpdate（“delete?from?contact?where?CID=“?+?cid）;
			sta.close（）;
			conn.close（）;

		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
?????
	public?void?add（Contact?a）?{
		try?{
			Connection?conn?=?DBUtil.getConnection（）;
			PreparedStatement?ps?=?conn.prepareStatement（“insert?into?contact（CnameCaddressCmailCphone）?values（????）“）;
			ps.setString（1?a.getCname（））;
			ps.setString（2?a.getCaddress（））;
			ps.setString（3?a.getCmail（））;
			ps.setString（4?a.getCphone（））;
			
			ps.executeUpdate（）;
			ps.close（）;
			conn.close（）;

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

	public?void?update（Contact?a）?{
		try?{
			Connection?conn?=?DBUtil.getConnection（）;
			PreparedStatement?ps?=?conn
					.prepareStatement（“update?contact?set?Cname=?Caddress=?Cmail=?Cphone=??where?CID=?“）;
			ps.setString（1?a.getCname（））;
			ps.setString（2?a.getCaddress（））;
			ps.setString（3?a.getCmail（））;
			ps.setString（4?a.getCphone（））;
			ps.setString（5?a.getCID（））;

			ps.executeUpdate（）;
			ps.close（）;
			conn.close（）;

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

	public?Contact?get（String?Cid）?{
		Contact?a?=?null;

		try?{
			Connection?conn?=?DBUtil.getConnection（）;
			Statement?sta?=?conn.createStatement（）;
			ResultSet?rs?=?sta.executeQuery（“select?*?from?contact?where?CID=“
					+?Cid）;
			if?（rs.next（））?{
				a?=?new?Contact（）;
				
				a.setCname（?rs.getString（“Cname“）?）;
				a.setCaddress（rs.getString（“Caddress“））;
				a.setCmail（?rs.getString（“Cmail“）?）;
				a.setCphone（?rs.getString（“Cphone“）?）;
				a.setCid（?rs.getString（“CID“）?）;
				
			}
			rs.close（）;
			sta.c

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????1383??2015-12-30?14:12??stongxunlu\WebRoot\admin\Acontacts_update.jsp
?????目錄???????????0??2016-01-03?19:11??stongxunlu\src\com\four\addresslist\utils\
?????文件????????1530??2015-12-30?13:56??stongxunlu\src\com\four\addresslist\servlet\RecordUpdate.java
?????文件????????1321??2015-12-30?13:55??stongxunlu\src\com\four\addresslist\servlet\RecordDelete.java
?????文件????????1468??2015-12-30?11:35??stongxunlu\src\com\four\addresslist\servlet\RecordAdd.java
?????目錄???????????0??2016-01-03?19:11??stongxunlu\
?????文件?????????529??2015-12-29?19:17??stongxunlu\.classpath
?????目錄???????????0??2016-01-03?22:59??stongxunlu\.myeclipse\
?????文件?????????303??2015-12-29?19:17??stongxunlu\.mymetadata
?????文件????????1753??2015-12-29?22:51??stongxunlu\.project
?????目錄???????????0??2016-01-03?19:11??stongxunlu\.settings\
?????文件?????????500??2015-12-29?19:17??stongxunlu\.settings\.jsdtscope
?????文件??????????74??2015-12-31?18:00??stongxunlu\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2015-12-29?19:17??stongxunlu\.settings\org.eclipse.jdt.core.prefs
?????文件?????????468??2015-12-29?19:17??stongxunlu\.settings\org.eclipse.wst.common.component
?????文件?????????252??2015-12-29?19:17??stongxunlu\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2015-12-29?19:17??stongxunlu\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-12-29?19:17??stongxunlu\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2016-01-03?19:11??stongxunlu\WebRoot\
?????目錄???????????0??2016-01-03?19:11??stongxunlu\WebRoot\meta-INF\
?????文件??????????36??2015-12-29?19:17??stongxunlu\WebRoot\meta-INF\MANIFEST.MF
?????文件????????3081??2015-12-29?19:11??stongxunlu\WebRoot\Text.jsp
?????目錄???????????0??2016-01-03?19:11??stongxunlu\WebRoot\WEB-INF\
?????目錄???????????0??2016-01-03?19:11??stongxunlu\WebRoot\WEB-INF\classes\
?????目錄???????????0??2016-01-03?19:11??stongxunlu\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2016-01-03?19:11??stongxunlu\WebRoot\WEB-INF\classes\com\four\
?????目錄???????????0??2016-01-03?19:11??stongxunlu\WebRoot\WEB-INF\classes\com\four\addresslist\
?????目錄???????????0??2016-01-03?19:11??stongxunlu\WebRoot\WEB-INF\classes\com\four\addresslist\dao\
?????文件????????3941??2015-12-31?13:49??stongxunlu\WebRoot\WEB-INF\classes\com\four\addresslist\dao\ContactALLDao.class
?????文件????????3798??2015-12-30?09:50??stongxunlu\WebRoot\WEB-INF\classes\com\four\addresslist\dao\ContactDao.class
?????文件????????4227??2015-12-31?09:35??stongxunlu\WebRoot\WEB-INF\classes\com\four\addresslist\dao\GroupDao.class
............此處省略85個文件信息