package?dao;

import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.Date;
import?java.util.List;

import?org.apache.commons.dbutils.QueryRunner;
import?org.apache.commons.dbutils.handlers.BeanHandler;
import?org.apache.commons.dbutils.handlers.BeanListHandler;

import?util.C3P0Util;
import?domain.Bus;

public?class?busDao?{
	
	/**
	?*?汽車信息列表查詢
	?*?@return
	?*?@throws?SQLException
	?*/
	public?List?findAllBus?（）?throws?SQLException{
		QueryRunner?qr?=?new?QueryRunner（C3P0Util.getDataSource（））;
		String?sql?=?“select?*?from?bus“;
		return?qr.query（sql?new?BeanListHandler（Bus.class））;
	}
	
	/**
	?*?根據(jù)查詢條件查詢
	?*?@param?busNO
	?*?@param?bustype
	?*?@param?buydate
	?*?@param?usedate
	?*?@param?seatnum
	?*?@param?TV
	?*?@param?aircondition
	?*?@return
	?*?@throws?SQLException
	?*/
	
	public?List?selectBus（String?busNOString?bustypeString?buydateString?usedateString?seatnumString?TVString?aircondition）?throws?SQLException?{
		QueryRunner?qr?=?new?QueryRunner（C3P0Util.getDataSource（））;
		Listject>?list?=?new?ArrayListject>（）;
		String?sql?=?“select?*?from?bus?where?1=1“;
		if?（!““.equals（busNO.trim（）））?{
			sql+=“?and?busNO?like??“;
			list.add（“%“+busNO+“%“）;
		}
		if?（!““.equals（bustype.trim（）））?{
			sql+=“?and?bustype?like??“;
			list.add（“%“+bustype+“%“）;
		}
		if?（!““.equals（buydate.trim（）））?{
			sql+=“?and?buydate?like??“;
			list.add（“%“+buydate.trim（）+“%“）;
		}
		if?（!““.equals（usedate.trim（）））?{
			sql+=“?and?usedate?like??“;
			list.add（“%“+usedate.trim（）+“%“）;
		}
		if?（!““.equals（seatnum.trim（）））?{
			sql+=“?and?seatnum=?“;
			list.add（seatnum）;
		}
		if?（!““.equals（TV.trim（）））?{
			sql+=“?and?TV=?“;
			list.add（TV）;
		}
		if?（!““.equals（aircondition.trim（）））?{
			sql+=“?and?aircondition=?“;
			list.add（aircondition）;
		}
		for?（object?object?:?list.toArray（））?{
			System.out.println（）;
		}
		return?qr.query（sql?new?BeanListHandler（Bus.class）list.toArray（））;
	}
	
	/**
	?*?根據(jù)list頁(yè)面?zhèn)鱽淼腷usNO?查詢信息?填在編輯頁(yè)面
	?*?@param?busNO
	?*?@return
	?*?@throws?SQLException
	?*/
	
	public?Bus?findbus（String?busNO）?throws?SQLException?{
		QueryRunner?qr?=?new?QueryRunner（C3P0Util.getDataSource（））;
		String?sql?=?“select?*?from?bus?where?busNO=?“;
		return?qr.query（sql?new?BeanHandler（Bus.class）busNO）;
	}
	
	/**
	?*?修改汽車信息
	?*?@param?busNO
	?*?@param?bustype
	?*?@param?buydate
	?*?@param?usedate
	?*?@param?seatnum
	?*?@param?TV
	?*?@param?aircondition
	?*?@param?busmemo
	?*?@throws?SQLException
	?*/
	public?void?updateBus（String?busNO?String?bustype?Date?buydateDate?usedate?String?seatnum?String?TV?String?airconditionString?busmemo）?throws?SQLException?{
		QueryRunner?qr?=?new?QueryRunner（C3P0Util.getDataSource（））;
		String?sql?=?“update?bus?set?bustype=?buydate=?usedate=?seatnum=?TV=?aircondition=?busmemo=??where?busNO=?“;
		qr.update（sqlbustypebuydateusedateseatnumTVaircondition

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????1093??2017-03-08?14:36??BusSystem\.classpath

?????文件???????1334??2017-03-08?14:37??BusSystem\.project

?????文件????????522??2017-03-08?14:36??BusSystem\.settings\.jsdtscope

?????文件????????364??2017-03-08?14:36??BusSystem\.settings\org.eclipse.jdt.core.prefs

?????文件????????486??2017-03-08?14:36??BusSystem\.settings\org.eclipse.wst.common.component

?????文件????????414??2017-03-08?14:36??BusSystem\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-03-08?14:36??BusSystem\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-03-08?14:36??BusSystem\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????553??2017-03-09?20:47??BusSystem\src\c3p0-config.xml

?????文件???????4136??2017-03-10?20:27??BusSystem\src\dao\busDao.java

?????文件???????4769??2017-03-09?22:12??BusSystem\src\dao\buslineDao.java

?????文件???????5088??2017-03-09?22:16??BusSystem\src\dao\busticketDao.java

?????文件???????3670??2017-03-09?17:00??BusSystem\src\dao\userDao.java

?????文件???????1310??2017-03-08?14:36??BusSystem\src\domain\Bus.java

?????文件???????1335??2017-03-08?14:36??BusSystem\src\domain\BusLine.java

?????文件???????1887??2017-03-09?18:28??BusSystem\src\domain\BusTicket.java

?????文件???????1046??2017-03-08?14:36??BusSystem\src\domain\User.java

?????文件???????2969??2017-03-08?14:36??BusSystem\src\filter\EncodingFilter.java

?????文件???????2432??2017-03-09?21:49??BusSystem\src\form\busForm.java

?????文件???????2672??2017-03-09?22:13??BusSystem\src\form\buslineForm.java

?????文件???????3134??2017-03-09?22:31??BusSystem\src\form\busticketForm.java

?????文件???????2238??2017-03-08?14:36??BusSystem\src\form\UserForm.java

?????文件???????3466??2017-03-08?14:36??BusSystem\src\servlet\addUserServlet.java

?????文件????????949??2017-03-09?16:52??BusSystem\src\servlet\allUserServlet.java

?????文件???????4378??2017-03-08?14:36??BusSystem\src\servlet\CheckImgServlet.java

?????文件????????933??2017-03-09?16:49??BusSystem\src\servlet\deleteUserServlet.java

?????文件???????1011??2017-03-08?14:36??BusSystem\src\servlet\editUserServlet.java

?????文件???????2611??2017-03-09?16:51??BusSystem\src\servlet\loginServlet.java

?????文件???????1430??2017-03-08?14:36??BusSystem\src\servlet\selectUserServlet.java

?????文件???????1301??2017-03-08?14:36??BusSystem\src\servlet\updateUserServlet.java

............此處省略266個(gè)文件信息