housbuildingandroom.java

JSP移动商品管理平台源代码.........

package imis_mate.DAO;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Hashtable;

import database.DBPoolManager;

public class HousBuildingAndRoom {
	
	public ArrayList getBuildingList() {
		// 返回建筑物的list
		ArrayList list = new ArrayList();
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();
		try {
			String sql = 	"select BuildingNu, BuildingName " +
							"from Buildings_info  " +
							"order by BuildingNu";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			while (rs.next()) {
				Hashtable ht = new Hashtable();
				ht.put("BuildingNu", rs.getString("BuildingNu"));
				ht.put("BuildingName", rs.getString("BuildingName"));
				list.add(ht);
			}
			rs.close();
			stmt.close();
		} catch (SQLException ex) {
			System.err.println("Get Departments SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}
		return list;
	}
	public ArrayList getRoomListForBuildingNu(String BuildingNu){
		//根据建筑物编号 返回房屋信息
		ArrayList list = new ArrayList();
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();
		try {
			String sql = 	"select RoomNu " +
							"from Room_Info " +
							"WHERE BuildingNu ='"+BuildingNu+"'"+
							"order by RoomNu";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			while (rs.next()) {
				Hashtable ht = new Hashtable();
				ht.put("RoomNu", rs.getString("RoomNu"));
				ht.put("RoomName", rs.getString("RoomNu"));
				list.add(ht);
			}
			rs.close();
			stmt.close();
		} catch (SQLException ex) {
			System.err.println("Get Departments SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}
		return list;
	}
	public String getBuildingName(String BuildingNu) {
		String buildingName = "";
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();
		try {
			String sql = 	"select BuildingNu, BuildingName " +
							"from Buildings_info  " +
							"WHERE BuildingNu = '"+BuildingNu+"'";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			while (rs.next()) {
				buildingName = rs.getString("BuildingName");
			}
			rs.close();
			stmt.close();
		} catch (SQLException ex) {
			System.err.println("Get Departments SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}
		
		return buildingName;
	}
}