treebean.java

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

package imis_mate.bean.TreeCom;


import java.io.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Hashtable;
import database.DBPoolManager;

public class TreeBean {

	private ArrayList treenodes;
	private byte   	  temp[];
	
	public TreeBean() {
		treenodes = new ArrayList();
	}

	public String ISOtoGB(String in){
		String out = "";
		if (in == null){
			return "";
		}
		else{
    			try {
	
    				out = new String(in.getBytes("iso-8859-1"),"gb2312");
				return out;    					
    			} 
    			catch (UnsupportedEncodingException e) {
    				e.printStackTrace();
    			}
    		}
    		return out; 		
        } 
	public String GBtoISO(String in){
		String out = "";
		if (in == null){
			return "";
		}
		else{
    			try {
	
    				out = new String(in.getBytes("gb2312"),"iso-8859-1");
				return out;    					
    			} 
    			catch (UnsupportedEncodingException e) {
    				e.printStackTrace();
    			}
    		}
    		return out;		
        } 
	
	
	public ArrayList getMenuTree() {
		treenodes.clear();
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;			
			String    sql  = "select menu_id, menu_name, sup_menu_id, menu_herf, open_ico, close_ico from sysmenu order by sup_menu_id, menu_id Desc ";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet 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 getMenuTree(String menu_id) {
		treenodes.clear();
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;			
			String    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 order by sup_menu_id, menu_id Desc";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet 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 getPurviewMenuTree(String Purview) {
		treenodes.clear();	
		DBPoolManager dbpool = new DBPoolManager();
		String    sql  = null;
		dbpool.getConnection();	
		try {
			char      temp ;
			String    s    = null;
			
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = null;
			if(Purview.length()==0){
				//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 order by sup_menu_id, menu_id Desc ";
				sql  = "select menu_id, menu_name, sup_menu_id, menu_herf, open_ico, close_ico from sysmenu where 1=2 ";
			}
			else{
	
			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);			
				Purview =	"("+Purview+")";
				sql	=	" select distinct 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 in "+Purview+" connect by prior sup_menu_id=menu_id ) 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.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();
		ArrayList list = new ArrayList();
		dbpool.getConnection();	
		
		try {
			String    s    = null;
			String    sql  = "select supplyno, supplyname, tele, addr, attperson, acccount, bank, Remark  from supply  order by  supplyno Desc";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);
				
				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("supplyName");
					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) {
				System.err.println("Get OrganTree SQLException: " + ex.toString());
			} finally {
				dbpool.freeConnection();
			}	
			return list;
	}
	public ArrayList getOrganTreeNode(String supplyno) {
		treenodes.clear();
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;
			int supplyno1 = new Integer(supplyno).intValue();
			String    sql  = "select supplyno, supplyname, tele, addr, attperson, acccount, bank, remark  from supply  where  supplyno ="+supplyno1;
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);
			while (rest.next()) {
				Hashtable ht = new Hashtable();
				if (rest.getString("supplyno") == null){
					ht.put("supplyno", "");
				}
				else{
				 	s = rest.getString("supplyno");
				 	s = s.trim();
					ht.put("supplyno", s);
				}
				if (rest.getString("supplyname") == null){
					ht.put("supplyname", "");
				}
				else{
				 	s = rest.getString("supplyname");
				 	s = s.trim();				
					ht.put("supplyname", s);
				}
				if (rest.getString("tele") == null){
					ht.put("tele", "");
				}
				else{
				 	s = rest.getString("tele");
				 	s = s.trim();				
					ht.put("tele", s);
				}
				if (rest.getString("addr") == null){
					ht.put("addr", "");
				}
				else{
				 	s = rest.getString("addr");
				 	s = s.trim();				
					ht.put("addr", s);
				}
				if (rest.getString("attperson") == null){
					ht.put("attperson", "");
				}
				else{
				 	s = rest.getString("attperson");
				 	s = s.trim();				
					ht.put("attperson", s);
				}
				if (rest.getString("acccount") == null){
					ht.put("acccount", "");
				}
				else{
				 	s = rest.getString("acccount");
				 	s = s.trim();				
					ht.put("acccount", s);
				}
				if (rest.getString("bank") == null){
					ht.put("bank", "");
				}
				else{
				 	s = rest.getString("bank");
				 	s = s.trim();				
					ht.put("bank", 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;
	}
	
}