walk_in.java~1~

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

package bookingsystem;

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

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+"'";
        PreparedStatement ps = cn.prepareStatement(sql);
        ps.executeUpdate();
    }
}