checkbillaccess.java

来自「Athena酒店小组_Athena酒店管理系统」· Java 代码 · 共 79 行

/*
 * CheckBillAccess.java
 *
 * Created on 2007年6月18日, 下午12:30
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package dennis;
import java.util.*;
import java.sql.*;

import plugin.*;
/**
 *
 * @author Administrator
 */
public class CheckBillAccess {
    private IDBResource dbRes;
    /** Creates a new instance of CheckBillAccess */
    public CheckBillAccess(IDBResource dbRes)
    {
        this.dbRes=dbRes;
    }
     public int insert(CheckBill checkBill)
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "INSERT INTO CheckBill(MenuId, GuestAccouts, SumConsume,CheckoutType,CheckoutDate,Remark) " +
		    " VALUES(?, ?, ?,?,?,?)";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    ps.setString(1, checkBill.getMenuId());
	    ps.setString(2, checkBill.getGuestAccouts());
	    ps.setString(3, checkBill.getSumConsume());
            ps.setString(4, checkBill.getCheckoutType());
            ps.setObject(5, checkBill.getCheckoutDate());
            ps.setString(6, checkBill.getRemark());
	    int rs = ps.executeUpdate();	    
	    return rs;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return -1;
	}		
    }
     
    public ArrayList<CheckBill> getAllCheckBills()
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "SELECT * FROM CheckBill";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    ResultSet rs = ps.executeQuery();
	    ArrayList<CheckBill> checkBills = new ArrayList<CheckBill>();
	    while(rs.next())
	    {
		CheckBill checkBill = new CheckBill();
		checkBill.setMenuId(rs.getString("MenuId"));
		checkBill.setGuestAccouts(rs.getString("GuestAccouts"));
		checkBill.setSumConsume(rs.getString("SumConsume"));
                checkBill.setCheckoutType(rs.getString("CheckoutType"));
                checkBill.setCheckoutDate(rs.getDate("CheckoutDate"));
                checkBill.setRemark(rs.getString("Remark"));
		checkBills.add(checkBill);
	    }
	    return checkBills;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return null;
	}		
    }
}