package?xgp.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?xgp.model.Car;
import?xgp.model.User;
import?xgp.util.JDBCUtil;

public?class?CarDao?{
	private	Connection?conn;
	private?PreparedStatement?psmt;
	private?ResultSet?rs;
	

	
public?List?getAllUsers（）?{
		
		//?TODO?Auto-generated?method?stub
			//定義sql
		????Listlist=new?ArrayList（）;
			String?sql?=?“select?*?from?car_system“;
			//獲取數據庫連接
			conn?=?JDBCUtil.getConnection（）;
			try?{
			//編譯sql
			psmt?=?conn.prepareStatement（sql）;
			//設置參數
			//執行sql
			rs?=?psmt.executeQuery（）;
			//獲取結果集
			while（rs.next（））{
				Car?u?=new?Car（）;
				u.setId（rs.getInt（“id“））;
				u.setUsername（rs.getString（“username“））;
				u.setCarname（rs.getString（“carname“））;
				u.setPrice（rs.getInt（“price“））;
				list.add（u）;
			};//結果有數據?f?ture
			}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			}?finally?{
			//最后要關閉連接
			JDBCUtil.close（conn?null?psmt?rs）;
			}

		return?list;
	}
public?boolean?saveUser（String?un?String?carint?price）?{
	//?TODO?Auto-generated?method?stub
	boolean?f?=?false;
	//定義sql
	String?sql?=?“insert?into?car_system（usernamecarnameprice）?values（???）“;
	//獲取數據庫連接
	conn?=?JDBCUtil.getConnection（）;
	try?{
	//編譯sql
	psmt?=?conn.prepareStatement（sql）;
	//設置參數
	psmt.setString（1?un）;
	psmt.setString（2?car）;
	psmt.setInt（3?price）;
	//執行sql
	int?i=psmt.executeUpdate（）;
	//獲取結果集
	?	f=i>0;//結果有數據?f?ture
	}?catch?（SQLException?e）?{
	e.printStackTrace（）;
	}?finally?{
	//最后要關閉連接
	JDBCUtil.close（conn?null?psmt?rs）;
	}
	return?f;
}
public?boolean?CarUpdata（int?priceString?usernameString?carnameint?id）{
	boolean?f=false;
	String?sql?=?“update?Car_system?set?username=?carname=?price=??where?id=?“;
	conn?=?JDBCUtil.getConnection（）;
	try?{
		//編譯sql
		psmt?=?conn.prepareStatement（sql）;
		
		//設置參數
		psmt.setString（1?username）;
		psmt.setString（2?carname）;
		psmt.setInt（3?price）;
		psmt.setInt（4?id）;
		//執行sql
		int?i=psmt.executeUpdate（）;
		//獲取結果集
		?	f=i>0;//結果有數據?f?ture
		}?catch?（SQLException?e）?{
		e.printStackTrace（）;
		}?finally?{
		//最后要關閉連接
		JDBCUtil.close（conn?null?psmt?rs）;
		}
		return?f;
}
public?List?Queryuser（String?username）{
	?Listlist=new?ArrayList（）;
	?String?sql?=?“select?*?from?Car_system?where?username?like???order?by?id“;
	?conn?=?JDBCUtil.getConnection（）;
	try{
	psmt?=?conn.prepareStatement（sql）;
	psmt.setString（1“%“+username+“%“）;
	rs?=?psmt.executeQuery（）;
	while（rs.next（））{
		Car?u?=new?Car（）;
		u=new?Car（）;
		u.setId（rs.getInt（“id“））;
		u.setUsername（rs.getString（“username“））;
		u.setCarname（rs.getString（“carname“））;
		u.setPrice（rs.getInt（“price“））;
		list.add（u）;
	};
	
	}
	catch?（SQLException?e）?{
		e.printStackTrace（）;
		}
	return?list;
}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????1039??2019-06-27?19:29??carsystem.sql
?????文件??????????29??2019-06-27?19:29??carsystem.txt
?????文件?????????886??2019-06-27?19:28??car_system.sql
?????文件??????????16??2019-06-27?19:29??car_system.txt
?????目錄???????????0??2019-06-27?15:57??Fcc.project1\
?????文件?????????484??2019-06-27?15:57??Fcc.project1\.classpath
?????文件?????????387??2019-06-27?15:57??Fcc.project1\.project
?????目錄???????????0??2019-06-27?15:57??Fcc.project1\.settings\
?????文件?????????598??2019-06-27?15:57??Fcc.project1\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2019-06-27?15:57??Fcc.project1\bin\
?????目錄???????????0??2019-06-27?15:57??Fcc.project1\bin\picture\
?????文件???????20929??2019-06-27?15:57??Fcc.project1\bin\picture\lanbo.jpg
?????文件???????23890??2019-06-27?15:57??Fcc.project1\bin\picture\u=18458870311309476495&fm=26&gp=0.jpg
?????文件???????11374??2019-06-27?15:57??Fcc.project1\bin\picture\u=278015242439165137&fm=26&gp=0.jpg
?????文件???????25099??2019-06-27?15:57??Fcc.project1\bin\picture\u=35868860353062230814&fm=26&gp=0.jpg
?????文件???????25752??2019-06-27?15:57??Fcc.project1\bin\picture\u=38086772691443370403&fm=26&gp=0.jpg
?????文件???????14341??2019-06-27?15:57??Fcc.project1\bin\picture\下載.jpg
?????目錄???????????0??2019-06-27?15:57??Fcc.project1\bin\xgp\
?????目錄???????????0??2019-06-27?15:57??Fcc.project1\bin\xgp\Dao\
?????文件????????3827??2019-06-27?15:57??Fcc.project1\bin\xgp\Dao\CarDao.class
?????文件????????5011??2019-06-27?15:57??Fcc.project1\bin\xgp\Dao\UserDao.class
?????目錄???????????0??2019-06-27?15:57??Fcc.project1\bin\xgp\model\
?????文件????????1275??2019-06-27?15:57??Fcc.project1\bin\xgp\model\Car.class
?????文件????????1281??2019-06-27?15:57??Fcc.project1\bin\xgp\model\User.class
?????目錄???????????0??2019-06-27?15:57??Fcc.project1\bin\xgp\util\
?????文件????????1762??2019-06-27?15:57??Fcc.project1\bin\xgp\util\JDBCUtil.class
?????目錄???????????0??2019-06-27?15:57??Fcc.project1\bin\xgp\view\
?????文件?????????719??2019-06-27?15:57??Fcc.project1\bin\xgp\view\Adminpassword$1.class
?????文件????????1246??2019-06-27?15:57??Fcc.project1\bin\xgp\view\Adminpassword$2.class
?????文件?????????755??2019-06-27?15:57??Fcc.project1\bin\xgp\view\Adminpassword$3.class
?????文件????????2644??2019-06-27?15:57??Fcc.project1\bin\xgp\view\Adminpassword.class
............此處省略72個文件信息