package imis_hous.com.impl;

import imis_hous.com.bean.AreaInfoEH;
import imis_hous.com.db.DBClose;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;

import java.util.List;



import com.sun.org.apache.xalan.internal.xsltc.runtime.Hashtable;

import cmis.database.DBPoolManager;
public class GetBulingsn {
public  HashMap getDepartment(){
	
		DBPoolManager dbpool = new DBPoolManager();
		Connection conn = null;
		Statement stmt = null;
		
		ResultSet rs = null;
		
		HashMap hash= new HashMap(); 
		
		DBClose dbclose = new DBClose();
	
		String sql = "select BuildingName,BuildingNu from Buildings_info where BuildingNu in (select BuildingNu from Rent_info)";	
		int i = 0;
		dbpool.getConnection();
		try {
			stmt = dbpool.conn.createStatement();
			rs = stmt.executeQuery(sql);
			while (rs.next()) {
				hash.put(rs.getString("BuildingNu"),rs.getString("BuildingName"));							
			}			
			rs.close();
			stmt.close();
			
		} catch (SQLException e) {
			
		} finally {
			dbclose.CloseResultSet(rs);
			dbclose.CloseStmt(stmt);
			dbpool.freeConnection();
		}
		return hash;		
}
}