getbuildnu.java

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

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 GetBuildNU {
	public  HashMap getDepartmentNU(){
		
		DBPoolManager dbpool = new DBPoolManager();
		
		Statement stmt = null;
		
		
		ResultSet rs = null;
		
		HashMap hash= new HashMap(); 
		
		DBClose dbclose = new DBClose();
		String sql = "select distinct bf.BuildingName,bf.BuildingNu from Buildings_info bf JOIN Room_Info rf on (bf.BuildingNu=rf.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;		
}	
	public  HashMap getDepartmentRoom(String str){
		
		DBPoolManager dbpool = new DBPoolManager();
		
		Statement stmt = null;
		
		
		ResultSet rs = null;
		
		HashMap hash= new HashMap(); 
		
		DBClose dbclose = new DBClose();
		String sql = "select RoomNu from room_info 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) {
			e.printStackTrace();
		} finally {
			dbclose.CloseResultSet(rs);
			dbclose.CloseStmt(stmt);
			dbpool.freeConnection();
		}
		return hash;		
}
	
public  String getDepartmentBuName(String str,String room){
		
		DBPoolManager dbpool = new DBPoolManager();
		
		Statement stmt = null;
		
		
		ResultSet rs = null;
		
		HashMap hash= new HashMap(); 
		
		DBClose dbclose = new DBClose();
		String sql = "select b.buildingname from buildings_info b where b.buildingnu=( select r.buildingnu from room_info r where r.roomnu='"+room+"' and r.buildingnu='"+str+"')" ;	
		String bstr=null;
		int i = 0;
		dbpool.getConnection();
		try {
			stmt = dbpool.conn.createStatement();
			rs = stmt.executeQuery(sql);	
			 while (rs.next()) { 
				bstr=rs.getString("buildingname");							
			}			
				
			rs.close();
			stmt.close();
			
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			dbclose.CloseResultSet(rs);
			dbclose.CloseStmt(stmt);
			dbpool.freeConnection();
		}
		return bstr;		
}
public  String getnewDepartmentBuName(String str){
	
	DBPoolManager dbpool = new DBPoolManager();
	
	Statement stmt = null;
	
	
	ResultSet rs = null;
	
	HashMap hash= new HashMap(); 
	
	DBClose dbclose = new DBClose();
	String sql = "select b.buildingnu from buildings_info b where b.buildingname='"+str+"'";
	String bstr=null;
	int i = 0;
	dbpool.getConnection();
	try {
		stmt = dbpool.conn.createStatement();
		rs = stmt.executeQuery(sql);	
		 while (rs.next()) { 
			bstr=rs.getString("buildingnu");							
		}			
			
		rs.close();
		stmt.close();
		
	} catch (SQLException e) {
		e.printStackTrace();
	} finally {
		dbclose.CloseResultSet(rs);
		dbclose.CloseStmt(stmt);
		dbpool.freeConnection();
	}
	return bstr;		
}
}