d0a6e24d40f7001d17c382fc5cbc284e

java做的客房查询系统、 仅供初学者参考！

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

public class DBAccess {
	public List selectRoom(String roomtype,String checkin) {
		List li=new List();
		String sql="select * from Room where RoomType=? and CheckIn=?";
		Connection con=getConnection();
		try {
			java.sql.PreparedStatement ps=con.prepareStatement(sql);
			ps.setString(1, roomtype);
			ps.setString(2, checkin);
			java.sql.ResultSet rs=ps.executeQuery();
			while(rs.next()) {
				li.add(rs.getInt("RoomId"));
				li.add(rs.getString("RoomType"));
				li.add(rs.getString("RoomIn"));
			}
		}
		catch(SQLException sqle) {
			sqle.printStackTrace();
		}
		return li;
		
	}
	public Connection getConnection() {
		Connection con=null;
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			con=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databaseName=Hotel","sa","");
		}
		catch(SQLException sqle) {
			sqle.printStackTrace();
		}
		catch(java.lang.ClassNotFoundException cnfe) {
			cnfe.printStackTrace();
		}
		return con;
	}
	public void close(Connection con,java.sql.PreparedStatement ps,java.sql.ResultSet rs) {
		try {
			if(rs != null) {
				rs.close();
			}
			if(ps != null) {
				ps.close();
			}
			if(con != null) {
				con.close();
		    }
		}
		catch(java.sql.SQLException sqle) {
			sqle.printStackTrace();
		}
		
		
	}

}