unuseroomaccess.java

Athena酒店小组_Athena酒店管理系统

/*
 * UnuseRoomAccess.java
 *
 * Created on 2007年6月18日, 上午11:57
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package jimmie;

import java.util.*;
import java.sql.*;

import plugin.*;
/**
 *
 * @author Administrator
 */
public class UnuseRoomAccess {
    private IDBResource dbRes;
    /** Creates a new instance of BookAccess */
    public UnuseRoomAccess(IDBResource dbRes) 
    {
        this.dbRes=dbRes;
    }
    
     public int insert(UnuseRoom uuRoom)
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "INSERT INTO UnuseRoom(RoomNum,HouseName,Reserve) " +
		    " VALUES(?, ?,?)";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    ps.setString(1, uuRoom.getRoomNum());
	    ps.setString(2,uuRoom.getHouseName());
            ps.setString(3,uuRoom.getReserve());
	    int rs = ps.executeUpdate();	    
	    return rs;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return -1;
	}
     }


    public ArrayList<UnuseRoom> getAllRooms()
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "SELECT * FROM UnuseRoom";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    ResultSet rs = ps.executeQuery();
	    ArrayList<UnuseRoom> rooms = new ArrayList<UnuseRoom>();
	    while(rs.next())
	    {
		UnuseRoom room = new UnuseRoom();
		room.setRoomNum(rs.getString("RoomNum"));
		room.setHouseName(rs.getString("HouseName"));
		room.setReserve(rs.getString("Reserve"));
                rooms.add(room);
	    }
	    return rooms;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return null;
	}		
    }
    
}