walk_in.java

这个一个餐厅预定系统,可实现查询目前餐厅预订情况,实现餐桌预订以及就餐时为顾客调节餐桌的情况.

package bookingsystem;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.*;

public class WALK_IN
{
    private int covers;
    private String arrivalDate;
    private String talno;
    Connection cn = ConnectionDB.getCon();

    WALK_IN(int covers,String arrivalDate,String talno)
    {
        this.covers=covers;
        this.arrivalDate = arrivalDate;
        this.talno = talno;

    }

    public void addWalk()
    {
        String sql = "INSERT INTO WALK_IN (COVERS,ARRIVALDATE,TALNO,ISPAYBILL) VALUES ("+this.covers
                     +",'"+this.arrivalDate+"','"+this.talno+"',"+0+")";
        PreparedStatement ps = null;
        try {
            ps = cn.prepareStatement(sql);
            ps.executeUpdate();
            String Talsql = "UPDATE T_TABLE SET STATE = 'dining' WHERE TALNO = '"+this.talno+"'";
            ps = cn.prepareStatement(Talsql);
            ps.executeUpdate();
        } catch (SQLException ex) {
        }

    }
}