package?bean;
import?java.sql.*;
public?class?book?{
	??private?String?userid;???//用戶號
	??private?int?countnum;????//訂票數目
	??private?double?dingjin;??//訂金
	??private?double?afford;???//應付金額
	??private?String?startplace;
	??private?String?destination;?

	??public?String?getuserId（）?{
		????return?userid;
		??}
		??public?void?setuserId（String?uid）?{
		????this.userid?=?uid;
		??}?????????????????????????????????????????????????????????????
		??public?String?getStartplace（）?{
			????return?startplace;
			??}
			??public?void?setStartplace（String?sp）?{
			????this.startplace?=?sp;
			??}
			??public?String?getDestination（）?{
			????return?destination;
			??}
			??public?void?setDestination（String?md）?{
			????this.destination?=?md;
			??}
??????public?int?getCountnum（）?{
			????return?countnum;
			??}
	??public?void?setCountnum（int?num）?{
			????this.countnum=num;
			??}
	??public?double?getSub（）?{
		????return?dingjin;
		??}
	??public?void?setSub（double?dj）?{
		????this.dingjin=?dj;
		??}
	??public?double?getAfford（）?{
		????return?afford;
		??}
	??public?void?setAfford（double?afford）?{
		????this.afford?=?afford;
		??}

	??
	??
	??public?boolean?hasLogin（String?tidString?uid）{???//檢查該訂票信息是否已經存在?
	??	boolean?f=true;
	???String?sql=“select?user_idticket_id?from?ticket“?+
	???		“?where?ticket_id?=‘“+tid+“‘?and?user_id=‘“+uid+“‘?“;
	??	sqlBean?db?=new?sqlBean（）;
	??	try{
	??	ResultSet?rs=db.executeQuery（sql）;
	??	if（rs.next（））{?f=false;}
	??	else{?f=true;}
	??	}catch（Exception?e）{?e.getMessage（）;}
	??	return?f;
	??	???????????????????????}
	??	???????????????????????
	??public?ResultSet??getBook（）{
			String?sql=“select?user_idbook.start_stationbook.dest_stationsubscriptioncountnumberafford“?+
					“train_idtypeprice?from?bookticket“?+
					“?where?book.start_station=ticket.start_station?and?book.dest_station=ticket.dest_station“;
			sqlBean?db=?new?sqlBean（）;
			ResultSet?rs?=?db.executeQuery（sql）;
			?return?rs;
			?????????????????????????}?
	??
			?????????????????????????
???/*?public?void?updateBook（）{
	????	String?sql=“update?book?SET?“?+
	????			???“startplace=‘“+startplace+“‘destination=‘“+destination+“‘“?+
	????			???“starttime=‘“+starttime+“‘remain=‘“+shengyu+“‘“?+
	????			???“price=‘“+price+“‘seat=‘“+seat+“‘train_id=‘“+trainid+“‘“+
	???????????????????“?where?ticket_id=‘“+ticketid+“‘?“;
	?????????????????sqlBean?db=?new?sqlBean（）;
	?????????????????db.executeInsert（sql）;
	?????????????????
	????	}	*/????
	??			?????????????????????????		?????????????????????????????????????????????????	???????????????????????	???????????????????????
	??public?void?deleteBook（）{
	????
	????	String?sql=“delete?from?book?where?start_station=‘“+startplace+“‘?and?“?+
	????			“?user_id=‘“+userid+“‘?and?dest_station=‘“+destination+“‘“;
	????	sqlBean?db=?new?sqlBean（）;
	????	db.executeDelete（sql）;
	????	}???????????????????????
	??	???????
	??public?int?dele

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-04-21?19:27??航空\
?????目錄???????????0??2018-04-21?19:27??航空\TrainOrdering\
?????文件?????????508??2017-12-12?19:10??航空\TrainOrdering\.classpath
?????目錄???????????0??2017-12-12?19:01??航空\TrainOrdering\.myeclipse\
?????文件?????????312??2017-12-12?19:01??航空\TrainOrdering\.mymetadata
?????文件????????1419??2009-07-09?15:16??航空\TrainOrdering\.project
?????目錄???????????0??2017-12-12?20:48??航空\TrainOrdering\.settings\
?????文件?????????406??2009-07-09?15:16??航空\TrainOrdering\.settings\.jsdtscope
?????文件?????????157??2009-07-09?15:16??航空\TrainOrdering\.settings\org.eclipse.core.resources.prefs
?????文件??????????49??2009-07-09?15:16??航空\TrainOrdering\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2009-07-09?15:16??航空\TrainOrdering\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-12-12?20:48??航空\TrainOrdering\src\
?????目錄???????????0??2018-04-21?19:27??航空\TrainOrdering\src\bean\
?????文件????????3380??2009-07-09?18:58??航空\TrainOrdering\src\bean\book.java
?????文件????????4749??2009-07-09?19:33??航空\TrainOrdering\src\bean\query.java
?????文件????????2257??2009-07-09?15:16??航空\TrainOrdering\src\bean\register.java
?????文件????????3523??2009-07-09?15:16??航空\TrainOrdering\src\bean\sta_sta.java
?????文件????????4835??2009-07-10?07:49??航空\TrainOrdering\src\bean\ticket.java
?????文件????????3990??2009-07-09?16:00??航空\TrainOrdering\src\bean\train.java
?????文件????????6131??2009-07-10?08:30??航空\TrainOrdering\src\bean\tra_sta_sta.java
?????文件????????2282??2009-07-09?15:16??航空\TrainOrdering\src\bean\type.java
?????文件????????4520??2009-07-09?15:16??航空\TrainOrdering\src\bean\user.java
?????目錄???????????0??2017-12-12?20:48??航空\TrainOrdering\src\servlet\
?????文件????????2937??2009-07-09?15:16??航空\TrainOrdering\src\servlet\logincheck.java
?????文件????????4605??2009-07-09?15:16??航空\TrainOrdering\src\servlet\passwordsvlt.java
?????文件????????7554??2009-07-09?15:16??航空\TrainOrdering\src\servlet\querysvlt.java
?????文件????????4452??2009-07-09?15:16??航空\TrainOrdering\src\servlet\registersvlt.java
?????文件????????5367??2009-07-09?15:16??航空\TrainOrdering\src\servlet\sta_stasvlt.java
?????文件????????8339??2009-07-10?07:54??航空\TrainOrdering\src\servlet\ticketsvlt.java
?????文件????????6553??2009-07-09?19:05??航空\TrainOrdering\src\servlet\trainsvlt.java
?????文件????????7097??2009-07-10?08:31??航空\TrainOrdering\src\servlet\tra_sta_stasvlt.java
............此處省略102個文件信息