treebean.java

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

			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.out.println(sql);
			System.err.println("Get MenuTree SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return this.treenodes;
	}
	public ArrayList getPurviewMenuTree(String Menu_ID,String Purview) {
		treenodes.clear();	
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			char      temp ;
			String    s    = null;
			String    sql  = null;			
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = null;
			Purview	       = Purview.trim();			
			Purview	       = Purview.replace('a',',');
			
			temp	       = Purview.charAt(0);
			if(temp==',')	 Purview = Purview.substring(1);
			temp	       = Purview.charAt(Purview.length()-1);
			if(temp==',')	 Purview = Purview.substring(0,Purview.length()-1);			
			if(Purview.length()==0){
				sql  = "select menu_id, menu_name, sup_menu_id, menu_herf, open_ico, close_ico from sysmenu where 1=2 ";
			}
			else{
				Purview =	"("+Purview+")";
				sql	=	" select  menu_id, menu_name, sup_menu_id, menu_herf, open_ico, close_ico from (";
				sql	=	" (select  menu_id, menu_name, sup_menu_id, menu_herf, open_ico, close_ico from ";
				sql	= 	sql +	"( select menu_id, menu_name, sup_menu_id, menu_herf, open_ico, close_ico from sysmenu  start with menu_id = "+ Menu_ID + " connect by prior menu_id=sup_menu_id ) where menu_id in ";				
				sql	= 	sql +	"( select  sup_menu_id from sysmenu  start with menu_id = " + Menu_ID + " connect by prior menu_id=sup_menu_id ) ) ";
				sql	= 	sql +	"  union ";
				sql	= 	sql +	"(select menu_id, menu_name, sup_menu_id, menu_herf, open_ico, close_ico from ";
				sql	= 	sql +	"( select menu_id, menu_name, sup_menu_id, menu_herf, open_ico, close_ico from sysmenu  start with menu_id = "+Menu_ID+" connect by prior menu_id=sup_menu_id ) where menu_id not in ";
				sql	= 	sql +   "(select sup_menu_id from sysmenu start with menu_id = "+ Menu_ID +" connect by prior menu_id=sup_menu_id ) and menu_id in "+Purview+")) order by sup_menu_id, menu_id desc";
			}
			rest	=	stmt.executeQuery(sql);
			while (rest.next()) {
				Hashtable ht = new Hashtable();
				if (rest.getString("menu_id") == null){
					ht.put("menu_id", "");
				}
				else{
				        s = rest.getString("menu_id");
				        s = s.trim();
					ht.put("menu_id", s);
				}
				if (rest.getString("menu_name") == null){
					ht.put("menu_name", "");
				}
				else{
				        s = rest.getString("menu_name");
				        s = s.trim();				
					ht.put("menu_name", s);
				}
				if (rest.getString("sup_menu_id") == null){
					ht.put("sup_menu_id", "");
				}
				else{
				        s = rest.getString("sup_menu_id");
				        s = s.trim();							
					ht.put("sup_menu_id", s);
				}
				if (rest.getString("menu_herf") == null){
					ht.put("menu_herf", "");
				}
				else{
				        s = rest.getString("menu_herf");
				        s = s.trim();								
					ht.put("menu_herf", s);
				}	
				if (rest.getString("open_ico") == null){
					ht.put("open_ico", "");
				}
				else{
				        s = rest.getString("open_ico");
				        s = s.trim();				
					ht.put("open_ico", s);
				}
				if (rest.getString("close_ico") == null){
					ht.put("close_ico", "");
				}
				else{
				        s = rest.getString("close_ico");
				        s = s.trim();					
					ht.put("close_ico", s);
				}															
				treenodes.add(ht);
			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.err.println("Get MenuTree SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return this.treenodes;
	}
	
	public ArrayList getOrganTree() {
		treenodes.clear();
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;
			String    sql  = "select OrganID, SupOrganID, OrganName, OrganAddr, Telephone, Fax, Postal, Remark  from organ where ORGANFLAG='1' order by SupOrganID, OrganID Desc";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);
			while (rest.next()) {
				Hashtable ht = new Hashtable();
				if (rest.getString("OrganID") == null){
					ht.put("OrganID", "");
				}
				else{
				 	s = rest.getString("OrganID");
				 	s = s.trim();
					ht.put("OrganID", s);
				}
				if (rest.getString("SupOrganID") == null){
					ht.put("SupOrganID", "");
				}
				else{
				 	s = rest.getString("SupOrganID");
				 	s = s.trim();				
					ht.put("SupOrganID", s);
				}
				if (rest.getString("OrganName") == null){
					ht.put("OrganName", "");
				}
				else{
				 	s = rest.getString("OrganName");
				 	s = s.trim();				
					ht.put("OrganName", s);
				}
				if (rest.getString("OrganAddr") == null){
					ht.put("OrganAddr", "");
				}
				else{
				 	s = rest.getString("OrganAddr");
				 	s = s.trim();				
					ht.put("OrganAddr", s);
				}
				if (rest.getString("Telephone") == null){
					ht.put("Telephone", "");
				}
				else{
				 	s = rest.getString("Telephone");
				 	s = s.trim();				
					ht.put("Telephone", s);
				}
				if (rest.getString("Fax") == null){
					ht.put("Fax", "");
				}
				else{
				 	s = rest.getString("Fax");
				 	s = s.trim();				
					ht.put("Fax", s);
				}
				if (rest.getString("Postal") == null){
					ht.put("Postal", "");
				}
				else{
				 	s = rest.getString("Postal");
				 	s = s.trim();				
					ht.put("Postal", s);
				}
				if (rest.getString("Remark") == null){
					ht.put("Remark", "");
				}
				else{
				 	s = rest.getString("Remark");
				 	s = s.trim();				
					ht.put("Remark", s);
				}																
				treenodes.add(ht);
			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.err.println("Get OrganTree SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return this.treenodes;
	}
	public ArrayList getOrganTreeNode(String OrganID) {
		treenodes.clear();
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;
			String    sql  = "select OrganID, SupOrganID, OrganName, OrganAddr, Telephone, Fax, Postal, Remark  from organ where OrganID="+OrganID;
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);
			while (rest.next()) {
				Hashtable ht = new Hashtable();
				if (rest.getString("OrganID") == null){
					ht.put("OrganID", "");
				}
				else{
				 	s = rest.getString("OrganID");
				 	s = s.trim();
					ht.put("OrganID", s);
				}
				if (rest.getString("SupOrganID") == null){
					ht.put("SupOrganID", "");
				}
				else{
				 	s = rest.getString("SupOrganID");
				 	s = s.trim();				
					ht.put("SupOrganID", s);
				}
				if (rest.getString("OrganName") == null){
					ht.put("OrganName", "");
				}
				else{
				 	s = rest.getString("OrganName");
				 	s = s.trim();				
					ht.put("OrganName", s);
				}
				if (rest.getString("OrganAddr") == null){
					ht.put("OrganAddr", "");
				}
				else{
				 	s = rest.getString("OrganAddr");
				 	s = s.trim();				
					ht.put("OrganAddr", s);
				}
				if (rest.getString("Telephone") == null){
					ht.put("Telephone", "");
				}
				else{
				 	s = rest.getString("Telephone");
				 	s = s.trim();				
					ht.put("Telephone", s);
				}
				if (rest.getString("Fax") == null){
					ht.put("Fax", "");
				}
				else{
				 	s = rest.getString("Fax");
				 	s = s.trim();				
					ht.put("Fax", s);
				}
				if (rest.getString("Postal") == null){
					ht.put("Postal", "");
				}
				else{
				 	s = rest.getString("Postal");
				 	s = s.trim();				
					ht.put("Postal", s);
				}
				if (rest.getString("Remark") == null){
					ht.put("Remark", "");
				}
				else{
				 	s = rest.getString("Remark");
				 	s = s.trim();				
					ht.put("Remark", s);
				}																
				treenodes.add(ht);
			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.err.println("Get OrganTree SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return this.treenodes;
	}
	
}