walk_in.java~5~

来自「这个一个餐厅预定系统,可实现查询目前餐厅预订情况,实现餐桌预订以及就餐时为顾客调」· JAVA~5~ 代码 · 共 35 行

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();
        } catch (SQLException ex) {
        }

    }
}