getdepartment.java

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

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

import cmis.database.DBPoolManager;

public class GetDepartment {
public  HashMap getDepartment(String tableid,String tablename,String tablett){
		// TODO Auto-generated method stub
		DBPoolManager dbpool = new DBPoolManager();
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		HashMap hash= new HashMap(); 
		DBClose dbclose = new DBClose();
		List departList = new ArrayList();
		String sql = "select " + tableid + " , " + tablename + " from " + tablett;//'"+table+"'";//锟斤拷貌锟斤拷锟?
		
		// sql = "select * from area_info where AreaNu='" + name + "'";
		dbpool.getConnection();
		try {
			stmt = dbpool.conn.createStatement();
			rs = stmt.executeQuery(sql);
			while (rs.next()) {
				hash.put(rs.getInt(tableid), rs.getString(tablename));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			
		} finally {
			dbclose.CloseResultSet(rs);
			dbclose.CloseStmt(stmt);
			dbpool.freeConnection();
		}

		return hash;
		
}
}