getroomnu.java

来自「JSP移动商品管理平台源代码.........」· Java 代码 · 共 78 行

package imis_hous.com.impl;

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.HashMap;

import cmis.database.DBPoolManager;

public class GetRoomnu {
	public  HashMap getDepartment(String str){
		
		DBPoolManager dbpool = new DBPoolManager();
		Statement stmt = null;
		
		ResultSet rs = null;
		
		HashMap hash= new HashMap(); 
		
		DBClose dbclose = new DBClose();
		String sql = "select r.roomnu from room_info r where BuildingNu ='"+str+"'";	
		int i = 0;
		dbpool.getConnection();
		try {
			stmt = dbpool.conn.createStatement();
			rs = stmt.executeQuery(sql);
			while (rs.next()) {
				hash.put(rs.getString("roomnu"),rs.getString("RoomNu"));							
			}			
			rs.close();
			stmt.close();
			
		} catch (SQLException e) {
			
		} finally {
			dbclose.CloseResultSet(rs);
			dbclose.CloseStmt(stmt);
			dbpool.freeConnection();
		}
		return hash;		
}
	
	public  HashMap getDepartmentNU(){
		
		DBPoolManager dbpool = new DBPoolManager();
		Statement stmt = null;
		
		ResultSet rs = null;
		
		HashMap hash= new HashMap(); 
		
		DBClose dbclose = new DBClose();
		String sql = "select r.buildingnu,b.buildingname from room_info r JOIN buildings_info b on (r.buildingnu=b.buildingnu)";	
		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;		
}
}