package?com.third.peccancy.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.third.peccancy.entity.Car;
import?com.third.peccancy.entity.CarAll;
import?com.third.peccancy.util.DBUtil;

public?class?CarDao?{
	public?List?getAll（）?{
		List?list?=?new?ArrayList（）;

		try?{
			Connection?conn?=?DBUtil.getConnection（）;
			Statement?sta?=?conn.createStatement（）;
			ResultSet?rs?=?sta.executeQuery（“select?*?from?car_ct_u“）;
			while?（rs.next（））?{
				CarAll?carA?=?new?CarAll（）;

				carA.setCid（rs.getInt（“Cid“））;
				carA.setCTid（rs.getInt（“CTid“））;
				carA.setCcol（rs.getString（“Ccol“））;
				carA.setCsix（rs.getInt（“Csix“））;
				carA.setCnum（rs.getString（“Cnum“））;
				carA.setCbrand（rs.getString（“Cbrand“））;
				carA.setCTname（rs.getString（“CTname“））;
				carA.setUname（rs.getString（“Uname“））;

				list.add（carA）;
			}
			rs.close（）;
			sta.close（）;
			conn.close（）;

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

	public?List?getAll_2（）?{
		List?list?=?new?ArrayList（）;

		try?{
			Connection?conn?=?DBUtil.getConnection（）;
			Statement?sta?=?conn.createStatement（）;
			ResultSet?rs?=?sta.executeQuery（“select?*?from?Car“）;
			while?（rs.next（））?{
				Car?c?=?new?Car（）;
				c.setCid（rs.getInt（“Cid“））;
				c.setUid（rs.getInt（“Uid“））;
				c.setCnum（rs.getString（“Cnum“））;
				c.setCcol（rs.getString（“Ccol“））;
				c.setCsix（rs.getInt（“Csix“））;
				c.setCnum（rs.getString（“Cnum“））;
				c.setCbrand（rs.getString（“Cbrand“））;
				list.add（c）;
			}
			rs.close（）;
			sta.close（）;
			conn.close（）;

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

		return?list;
	}

	//?添加車輛信息
	public?void?addCar（Car?c）?{

		try?{
			Connection?conn?=?DBUtil.getConnection（）;
			//?預處理語句

			PreparedStatement?ps?=?conn
					.prepareStatement（“insert?into?Car（Uid?CTid?Cnum?Csix?Cbrand?Ccol）?values（??????）“）;
			//?為預處理語句中的“字段”賦值。
			ps.setInt（1?c.getUid（））;
			ps.setInt（2?c.getCTid（））;
			ps.setString（3?c.getCnum（））;
			ps.setInt（4?c.getCsix（））;
			ps.setString（5?c.getCbrand（））;
			ps.setString（6?c.getCcol（））;

			ps.executeUpdate（）;//?執行“更新”操作
			ps.close（）;
			conn.close（）;

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

	//?刪除車輛信息
	public?void?delCar（Car?c）?{
		try?{
			Connection?conn?=?DBUtil.getConnection（）;
			//?預處理語句

			PreparedStatement?ps?=?conn
					.prepareStatement（“delete?from?car?where?cnum=‘“
							+?c.getCnum（）?+?“‘“）;

			ps.executeUpdate（）;//?執行“刪除”操作
			ps.close（）;
			conn.close（）;

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

	//?更新【車輛】信息
	public?void?updateCar（Car?c）?{
		try?{
			Connection?conn?=?DBUtil.getConnection（）;
			//?預處理語句
			PreparedStatement?ps?=?conn

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

?????文件???????1093??2015-12-28?21:14??車輛違章管理\CarPeccancy\.classpath

?????文件???????1336??2015-12-29?14:51??車輛違章管理\CarPeccancy\.project

?????文件????????522??2015-12-28?21:14??車輛違章管理\CarPeccancy\.settings\.jsdtscope

?????文件????????103??2017-04-10?12:56??車輛違章管理\CarPeccancy\.settings\com.genuitec.eclipse.core.prefs

?????文件????????482??2015-12-29?11:52??車輛違章管理\CarPeccancy\.settings\com.genuitec.runtime.libraries.xml

?????文件????????462??2017-04-10?12:56??車輛違章管理\CarPeccancy\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2015-12-28?21:14??車輛違章管理\CarPeccancy\.settings\org.eclipse.jdt.core.prefs

?????文件????????492??2015-12-28?21:14??車輛違章管理\CarPeccancy\.settings\org.eclipse.wst.common.component

?????文件????????414??2015-12-28?21:14??車輛違章管理\CarPeccancy\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-12-28?21:14??車輛違章管理\CarPeccancy\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-12-28?21:14??車輛違章管理\CarPeccancy\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3597??2015-12-31?14:00??車輛違章管理\CarPeccancy\src\com\third\peccancy\dao\CarDao.java

?????文件????????862??2015-12-30?18:40??車輛違章管理\CarPeccancy\src\com\third\peccancy\dao\CarTypeDao.java

?????文件???????1785??2015-12-31?14:03??車輛違章管理\CarPeccancy\src\com\third\peccancy\dao\PMsgDao.java

?????文件???????2852??2016-07-09?12:10??車輛違章管理\CarPeccancy\src\com\third\peccancy\dao\PoliceDao.java

?????文件????????946??2015-12-31?01:22??車輛違章管理\CarPeccancy\src\com\third\peccancy\dao\PtypeDao.java

?????文件???????4497??2016-07-09?16:52??車輛違章管理\CarPeccancy\src\com\third\peccancy\dao\UserDao.java

?????文件???????1033??2015-12-28?21:44??車輛違章管理\CarPeccancy\src\com\third\peccancy\entity\Car.java

?????文件???????1481??2015-12-31?10:33??車輛違章管理\CarPeccancy\src\com\third\peccancy\entity\CarAll.java

?????文件????????377??2015-12-28?21:47??車輛違章管理\CarPeccancy\src\com\third\peccancy\entity\CarType.java

?????文件????????978??2015-12-28?22:56??車輛違章管理\CarPeccancy\src\com\third\peccancy\entity\PMsg.java

?????文件????????863??2015-12-30?18:16??車輛違章管理\CarPeccancy\src\com\third\peccancy\entity\PMsgAll.java

?????文件????????493??2015-12-28?21:46??車輛違章管理\CarPeccancy\src\com\third\peccancy\entity\Police.java

?????文件????????697??2015-12-30?17:04??車輛違章管理\CarPeccancy\src\com\third\peccancy\entity\Ptype.java

?????文件???????1392??2016-07-09?16:44??車輛違章管理\CarPeccancy\src\com\third\peccancy\entity\User.java

?????文件???????1714??2016-01-03?19:38??車輛違章管理\CarPeccancy\src\com\third\peccancy\filter\AdminLoginFilter.java

?????文件???????1106??2015-12-30?10:42??車輛違章管理\CarPeccancy\src\com\third\peccancy\filter\EncodingFilter.java

?????文件???????1325??2016-01-03?20:25??車輛違章管理\CarPeccancy\src\com\third\peccancy\filter\NoCacheFilter.java

?????文件????????982??2016-07-09?12:45??車輛違章管理\CarPeccancy\src\com\third\peccancy\service\UserService.java

?????文件???????1403??2016-01-02?12:21??車輛違章管理\CarPeccancy\src\com\third\peccancy\servlet\AddCarServlet.java

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