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

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

?????文件????????433??2009-07-09?15:16??TrainOrdering\.classpath

?????文件????????312??2009-07-09?15:16??TrainOrdering\.mymetadata

?????文件???????1419??2009-07-09?15:16??TrainOrdering\.project

?????文件????????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

?????文件???????8824??2009-07-09?23:41??TrainOrdering\ordering.sql

?????文件???????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

?????文件???????2977??2009-07-09?15:16??TrainOrdering\src\bean\sqlBean.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

?????文件???????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

?????文件???????3764??2009-07-09?15:16??TrainOrdering\src\servlet\typesvlt.java

?????文件???????5520??2009-07-09?15:16??TrainOrdering\src\servlet\usersvlt.java

?????文件???????7398??2009-07-09?15:16??TrainOrdering\WebRoot\addressquery.jsp

?????文件???????6657??2009-07-09?15:16??TrainOrdering\WebRoot\addressquery1.jsp

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