hoteldao.java

来自「java做的客房查询系统、 仅供初学者参考！」· Java 代码 · 共 136 行

package Dao;

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

import DBUtil.DBAccess;
import Bean.HotelBean;
/**
 * 查询的方法类
 * @author 李锡钧
 * @version 1.0
 */
public class HotelDao {
	/**
	 * 按照房间的类型和是否有人住查询
	 * @param roomtype
	 * @param checkin
	 * @return
	 */
	public ArrayList selectRoom(String roomtype,String checkin) {
		ArrayList li=new ArrayList();
		DBAccess db=new DBAccess();
		Connection con=db.getConnection();
		String sql="select * from Room where RoomType=? and CheckIn=?";
		try {
			java.sql.PreparedStatement ps=con.prepareStatement(sql);
			ps.setString(1, roomtype);
			ps.setString(2, checkin);
			java.sql.ResultSet rs=ps.executeQuery();
			HotelBean hb=new HotelBean();
			while(rs.next()) {
				
				hb.setMRoomId(rs.getInt(1));
				hb.setMRoomType(rs.getString(2));
				hb.setMRoomIn(rs.getString(3));
				li.add(hb.toString());
			}
			db.close(con, ps, rs);
		}
		catch(SQLException sqle) {
			sqle.printStackTrace();
		}
		return li;
		
	}
	/**
	 * 按照房间的类型查询
	 * @param roomtype
	 * @return
	 */
	public ArrayList selecttype(String roomtype) {
		ArrayList li=new ArrayList();
		DBAccess db=new DBAccess();
		Connection con=db.getConnection();
		String sql="select * from Room where RoomType=?";
		try {
			java.sql.PreparedStatement ps=con.prepareStatement(sql);
			ps.setString(1, roomtype);
			java.sql.ResultSet rs=ps.executeQuery();
			HotelBean hb=new HotelBean();
			while(rs.next()) {
				
				hb.setMRoomId(rs.getInt(1));
				hb.setMRoomType(rs.getString(2));
				hb.setMRoomIn(rs.getString(3));
				li.add(hb.toString());
			}
			db.close(con, ps, rs);
		}
		catch(SQLException sqle) {
			sqle.printStackTrace();
		}
		return li;
		
	}
	/**
	 * 按照房间是否有人住查询
	 * @param checkin
	 * @return
	 */
	public ArrayList selectcheckin(String checkin) {
		ArrayList li=new ArrayList();
		DBAccess db=new DBAccess();
		Connection con=db.getConnection();
		String sql="select * from Room where CheckIn=?";
		try {
			java.sql.PreparedStatement ps=con.prepareStatement(sql);
			ps.setString(1, checkin);
			java.sql.ResultSet rs=ps.executeQuery();
			HotelBean hb=new HotelBean();
			while(rs.next()) {
				
				hb.setMRoomId(rs.getInt(1));
				hb.setMRoomType(rs.getString(2));
				hb.setMRoomIn(rs.getString(3));
				li.add(hb.toString());	
			}
			db.close(con, ps, rs);
		}
		catch(SQLException sqle) {
			sqle.printStackTrace();
		}
		return li;
		
	}
	/**
	 * 当房间的类型和是否有人住为空时查询所有的数据
	 * @return
	 */
	public ArrayList select() {
		ArrayList li=new ArrayList();
		DBAccess db=new DBAccess();
		Connection con=db.getConnection();
		String sql="select * from Room";
		try {
			java.sql.PreparedStatement ps=con.prepareStatement(sql);
			java.sql.ResultSet rs=ps.executeQuery();
			HotelBean hb=new HotelBean();
			while(rs.next()) {
				hb.setMRoomId(rs.getInt(1));
				hb.setMRoomType(rs.getString(2));
				hb.setMRoomIn(rs.getString(3));
				li.add(hb.toString());
			}
			db.close(con, ps, rs);
			
		}
		catch(SQLException sqle) {
			sqle.printStackTrace();
		}
		return li;
		
	}

}