startconsumptionaccess.java

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

/*
 * StartConsumptionAccess.java
 *
 * Created on 2007年6月19日, 下午9:24
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package jimmie;
import java.sql.*;
import java.lang.*;
import java.util.ArrayList;
import plugin.*;
/**
 *
 * @author Jimmie
 */
public class StartConsumptionAccess {
    private IDBResource dbRes;
    /** Creates a new instance of BookAccess */
    public StartConsumptionAccess(IDBResource dbRes) 
    {
        this.dbRes=dbRes;
    }
    
     public int insert(StartConsumption start)
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "INSERT INTO StartConsumption(Account,RoomNum,HouseName,ListNum,StartTime) " +
		    " VALUES(?, ?,?,?,?)";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    ps.setString(1, start.getAccount());
	    ps.setString(2,start.getRoomNum());
            ps.setString(3,start.getHouseName());
            ps.setString(4,start.getListNum());
           
            ps.setObject(5,new Date(start.getStartTime().getTime()));
	    int rs = ps.executeUpdate();
	    return rs;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return -1;
	}
     }


    public ArrayList<StartConsumption> getAllStartConsumptions()
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "SELECT * FROM StartConsumption";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    ResultSet rs = ps.executeQuery();
	    ArrayList<StartConsumption> startc = new ArrayList<StartConsumption>();
	    while(rs.next())
	    {
		StartConsumption sc = new StartConsumption();
		sc.setAccount(rs.getString("Account"));
		sc.setRoomNum(rs.getString("RoomNum"));
		sc.setHouseName(rs.getString("HouseName"));
                sc.setListNum(rs.getString("ListNum"));
                sc.setStartTime(rs.getDate("StartTime"));
                startc.add(sc);
	    }
	    return startc;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return null;
	}		
    }
    
}