tree.java

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

package imis_hous.com.tree;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Hashtable;
import java.util.List;

import cmis.database.DBPoolManager;

public class Tree {
	public Tree() {

	}

	public List getRoomInfoUser() {
		List list = new ArrayList();
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();
		try {
			String s = null;
			String sql = "select roomNu from room_info order by roomNu Desc";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);

			Hashtable ht = new Hashtable();
			ht.put("OrganID", "1");
			ht.put("SupOrganID", "0");
			ht.put("OrganName", "");
			list.add(ht);
			int i = 11;
			while (rs.next()) {
				Hashtable hash = new Hashtable();
				s = rs.getString("roomNu");
				s = s.trim();

				hash.put("OrganID", String.valueOf(i));
				hash.put("SupOrganID", "1");
				hash.put("OrganName", s);

				list.add(hash);
				i++;
			}
			rs.close();
			stmt.close();
		} catch (SQLException ex) {
			
		} finally {
			dbpool.freeConnection();
		}
		return list;

	}

	public ArrayList getRoomInfoUserAllRoomNu() {
		ArrayList list = new ArrayList();
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();
		try {
			String s = "";
			String n = "";
//			String sql = "select RoomNu from Room_Info order by roomNu Desc";
			String sql="select BuildingName,buildingnu from Buildings_info where BuildingNu in (select BuildingNu from Room_Info)";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);

			Hashtable ht = new Hashtable();
			ht.put("OrganID", "1");
			ht.put("SupOrganID", "0");
			ht.put("OrganName", "房屋编号");
			ht.put("OrganNu", "房屋号");
			list.add(ht);
			int i = 11;
			while (rs.next()) {
				Hashtable hash = new Hashtable();
				s = rs.getString("BuildingName");
				s = s.trim();
				n = rs.getString("buildingnu");
				n = n.trim();
				
				hash.put("OrganID", String.valueOf(i));
				hash.put("SupOrganID", "1");
				hash.put("OrganName", s);
				hash.put("OrganNu", n);
				
				String    sNo    = null;
				String sqlNo = "select RoomNu from Room_Info where BuildingNu in (select buildingnu from Buildings_info where BuildingName='"+s+"')";
//				String sqlNo = "select RoomNu from Room_Info where RoomNu = '"+s+"' order by RoomNu Desc";
//				String sqlNo="select BuildingName from Buildings_info where BuildingNu in (select BuildingNu from Room_Info)";
				Statement stmtNo = dbpool.conn.createStatement();
				ResultSet rsNo = stmtNo.executeQuery(sqlNo);
				int iRoom=1;
				
				while (rsNo.next()) {
					
					sNo=rsNo.getString("RoomNu");
					sNo=sNo.trim();
					Hashtable hashRoom = new Hashtable();
					hashRoom.put("OrganID", String.valueOf(i * 10 + iRoom)+"*"+n);
					hashRoom.put("SupOrganID", i);
					hashRoom.put("OrganName", sNo);
					
					list.add(hashRoom);
					iRoom++;
				}
				
				rsNo.close();
				stmtNo.close();
				list.add(hash);
				i++;
			}
			rs.close();
			stmt.close();
		} catch (SQLException ex) {
			
		}finally{
			dbpool.freeConnection();
		}
		return list;
	}
}