package imis_hous.com.impl;

import imis_hous.com.db.DBClose;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;

import cmis.database.DBPoolManager;

public class GetBuNu {
public  HashMap getDepartmentNU(){
		
		DBPoolManager dbpool = new DBPoolManager();
		Statement stmt = null;
		
		ResultSet rs = null;
		
		HashMap hash= new HashMap(); 
		
		DBClose dbclose = new DBClose();
		String sql = "select b.buildingnu,b.buildingname from buildings_info b";	
		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;		
}
}