package?biz;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

import?entity.Car;

public?class?CarBiz?{
	private?Connection?connection?=null;
	private?Statement?statement?=null;?
	public?CarBiz（）?{
	}
	public?CarBiz（Connection?connection）{
		this.connection?=?connection;
	}
	public?int?insert（Car?car）{
		PreparedStatement?pstm?=?null;
		int?affect?=?0;//0表示正常狀態(tài)，-1表示失敗，1表示成功
		String?sql?=?“Insert?into?car（?“?+
????????????????“carnumbercartypecarcompanycarpurchasecarusetime“+
?????????“?）?values?（?“+
????????????????“????????）“;
		try?{
			pstm?=?connection.prepareStatement（sql）;
			pstm.setString（1?car.getCarNumber（））;
			pstm.setString（2?car.getCarType（））;
			pstm.setString（3?car.getCarCompany（））;
			pstm.setString（4?car.getCarPurchase（））;
			pstm.setInt（5?car.getCarUsetime（））;
			affect?=?pstm.executeUpdate（）;
		}?catch?（Exception?e）?{
			affect?=?-1;
			e.printStackTrace（）;
		}finally{
			try?{
				if?（pstm?!=?null）?{
					pstm.close（）;
				}
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		return?affect;
	}
	public?int?countWhere（String?carnumber）{
		ResultSet?rs?=?null;
		int?count?=?0;
		String?sql?=?“SELECT?COUNT（1）?CT??FROM?car?WHERE?carnumber?=‘“+carnumber+“‘“;
		try?{
			statement?=?（Statement）?connection.createStatement（）;
			rs?=?statement.executeQuery（sql）;
			if?（rs.next（））?{
				count?=?rs.getInt（“CT“）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			try?{
				if?（rs?!=?null）?{
					rs.close（）;
				}
				if?（statement?!=?null）?{
					statement.close（）;
				}
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		return?count;
	}
	public?Car?selectCar（String?carnumber）{
		ResultSet?rs?=?null;
		Car?car?=?null;
		String?sql?=?“SELECT?*?FROM?car?WHERE?carnumber?=‘“+carnumber+“‘“;
		try?{
			statement?=?connection.createStatement（）;
			rs?=?statement.executeQuery（sql）;
			car?=?new?Car（）;
			if?（rs.next（））?{
				car.setCarNumber（rs.getString（“carnumber“））;
				car.setCarType（rs.getString（“cartype“））;
				car.setCarCompany（rs.getString（“carcompany“））;;
				car.setCarPurchase（rs.getString（“carpurchase“））;;
				car.setCarUsetime（rs.getInt（“carusetime“））;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			try?{
				if?（rs?!=?null）?{
					rs.close（）;
				}
				if?（statement?!=?null）?{
					statement.close（）;
				}
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		return?car;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-03-11?11:14??Didi\
?????文件????????1186??2016-11-23?16:40??Didi\.classpath
?????目錄???????????0??2017-03-11?11:17??Didi\.git\
?????文件??????????13??2017-03-11?11:16??Didi\.git\COMMIT_EDITMSG
?????文件??????????23??2017-03-11?11:14??Didi\.git\HEAD
?????文件?????????298??2017-03-11?11:17??Didi\.git\config
?????文件??????????73??2017-03-11?11:14??Didi\.git\description
?????目錄???????????0??2017-03-11?11:14??Didi\.git\hooks\
?????文件?????????478??2017-03-11?11:14??Didi\.git\hooks\applypatch-msg.sample
?????文件?????????896??2017-03-11?11:14??Didi\.git\hooks\commit-msg.sample
?????文件?????????189??2017-03-11?11:14??Didi\.git\hooks\post-update.sample
?????文件?????????424??2017-03-11?11:14??Didi\.git\hooks\pre-applypatch.sample
?????文件????????1642??2017-03-11?11:14??Didi\.git\hooks\pre-commit.sample
?????文件????????1348??2017-03-11?11:14??Didi\.git\hooks\pre-push.sample
?????文件????????4951??2017-03-11?11:14??Didi\.git\hooks\pre-rebase.sample
?????文件?????????544??2017-03-11?11:14??Didi\.git\hooks\pre-receive.sample
?????文件????????1239??2017-03-11?11:14??Didi\.git\hooks\prepare-commit-msg.sample
?????文件????????3610??2017-03-11?11:14??Didi\.git\hooks\update.sample
?????文件????????7615??2017-03-11?11:16??Didi\.git\index
?????目錄???????????0??2017-03-11?11:14??Didi\.git\info\
?????文件?????????240??2017-03-11?11:14??Didi\.git\info\exclude
?????目錄???????????0??2017-03-11?11:16??Didi\.git\logs\
?????文件?????????159??2017-03-11?11:16??Didi\.git\logs\HEAD
?????目錄???????????0??2017-03-11?11:17??Didi\.git\logs\refs\
?????目錄???????????0??2017-03-11?11:16??Didi\.git\logs\refs\heads\
?????文件?????????159??2017-03-11?11:16??Didi\.git\logs\refs\heads\master
?????目錄???????????0??2017-03-11?11:17??Didi\.git\logs\refs\remotes\
?????目錄???????????0??2017-03-11?11:17??Didi\.git\logs\refs\remotes\origin\
?????文件?????????143??2017-03-11?11:17??Didi\.git\logs\refs\remotes\origin\master
?????目錄???????????0??2017-03-11?11:16??Didi\.git\objects\
?????目錄???????????0??2017-03-11?11:14??Didi\.git\objects\05\
............此處省略261個文件信息