?? reservation.java~28~
字號:
package bookingsystem;
import java.util.ArrayList;
import java.util.Date;
import java.sql.Time;
import java.util.Vector;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.sql.*;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2007</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class Reservation extends Booking{
private Table table;
private String arrivalDate;
private String arrivaltime;
private boolean isarrival;
private Customer customer;
private String bookingNo;
Connection cn = ConnectionDB.getCon();
public Reservation()
{
super();
}
public Reservation(int covers,String predate,Table t,Customer c,String arrivaldate,String arrivaltime)
{
super(covers,predate,t);
if(c==null)
{
return;
}
customer = c;
this.arrivalDate = arrivaldate;
this.arrivaltime = arrivaltime;
this.isarrival = false;
}
public void addBooking()
{
int tempCno = customer.getCno();
String addSql = "INSERT INTO RESERVATION"
+"(COVERS,PREDATE,ARRIVALDATE,ARRIVALTIME,TALNO,CNO,ISARRIVAL,ISPAYBILL) VALUES("
+this.covers+","+"'"+super.getpreDate()+"','"+this.arrivalDate+"','"+this.arrivaltime+"','"
+super.getTalNo()+"'," + tempCno + ","+0+","+0;
try {
PreparedStatement ps = cn.prepareStatement(addSql);
ps.executeUpdate();
} catch (SQLException ex) {
}
}
public String getarrivaldate()
{
return arrivalDate;
}
public String getarrivaltime()
{
return arrivaltime;
}
public boolean getisarrival()
{
return isarrival;
}
public Customer getCustomer()
{
return customer;
}
public String getbookingno()
{
return bookingNo;
}
public Vector getfreetables()
{
Vector freeTables = new Vector();
Connection cn = ConnectionDB.getCon();
Statement st = null;
ResultSet rs = null;
try
{
String sql = "SELECT * FROM T_TABLE WHERE TALNO NOT IN"
+ " (SELECT TALNO FROM RESERVATION WHERE ARRIVALDATE ='"
+ "2008-1-1" +"' AND ARRIVALTIME = '"+this.arrivaltime+"')";
st = cn.createStatement();
rs = st.executeQuery(sql);
while (rs.next()) {
String tempFreeTalno = rs.getString("TALNO");
Table tempFreeTable = new Table(tempFreeTalno);
freeTables.add(tempFreeTable);
}
}catch(Exception ex)
{
ex.printStackTrace();
}
return freeTables;
}
public void setarrivaldate(String arrivaldate)
{
this.arrivalDate = arrivaldate;
}
public void setarrivaltime(String arrivaltime)
{
this.arrivaltime = arrivaltime;
}
public void setisarrival(boolean isarrival)
{
this.isarrival = isarrival;
}
public void setcustomer(Customer customer)
{
this.customer = customer;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -