materialtypetree.java

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

package imis_mate.common;

import database.DBPoolManager;

import java.util.ArrayList;
import java.util.Hashtable;
import java.util.Iterator;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

//库存树
import java.sql.SQLException;

public class MaterialTypeTree {
	public MaterialTypeTree() {
		
	}
	public ArrayList getMaterialTypeNo() {
		ArrayList list1 = new ArrayList();
		ArrayList list2 = new ArrayList();
		DBPoolManager db = new DBPoolManager();

		   String sSupOrganID=null;  //父类的编号
		   String sSupOrganNO=null;  //父类的表单编号
		   String sOrganName=null;  //子类名称
		   String sOrganID=null;	//子类的编号
		   String sOrganNO=null;	//子类对应表单编号
	
		   db.getConnection();
		
		try {
			String s = null;
			String name = null;
			String sp = null;
			String sql = "SELECT MaterialTypeNo ,MATERIALTYPENAME ,MATERIALPATYPENO FROM Material_Type  order by MaterialTypeNo DESC  "; //查询物品类型编号的SQL语句
			Statement stmt = db.conn.createStatement(); 
			ResultSet rs = stmt.executeQuery(sql);
			
			Hashtable ht = new Hashtable();
			ht.put("OrganID", "11");
			ht.put("OrganNO", "0");
			ht.put("SupOrganID", "0");
			ht.put("OrganName", "物品类型名称");
			ht.put("SupOrganNO", "物品类型编号");
			list2.add(ht);
			int i = 1;
			
			while (rs.next()) {
				Hashtable hash = new Hashtable();
				s = rs.getString("MaterialTypeNo");
				name = rs.getString("MATERIALTYPENAME");
				sp = rs.getString("MATERIALPATYPENO");
				s = s.trim();
				
				hash.put("OrganID", i);
				hash.put("OrganNO", s);
				hash.put("SupOrganNO", sp);
				hash.put("OrganName", name);
				hash.put("SupOrganID",0);
				i++;
				list1.add(hash);
				
			}
			rs.close();
			stmt.close();
			Iterator itr = list1.iterator();
			
			 while (itr.hasNext()) {
			   
			     
					 ht = (Hashtable) itr.next();   
					
					 		
			  				sOrganID      =  ht.get("OrganID").toString();
			            	sSupOrganID   =  ht.get("SupOrganID").toString(); 
			            	sOrganName    =  ht.get("OrganName").toString();
			            	sOrganNO      =  ht.get("OrganNO").toString();
			            	sSupOrganNO   =  ht.get("SupOrganNO").toString(); 
			            	
			            	i=20;
		     sql = "SELECT MaterialTypeNo ,MATERIALTYPENAME FROM Material_Type where MATERIALPATYPENO = '"+sOrganNO+"' order by MaterialTypeNo DESC"; //
		 	
		    
		 	
		     stmt = db.conn.createStatement(); 
			 rs = stmt.executeQuery(sql);
			 
			
		
			 
			 while (rs.next()) {
				
			Hashtable hash = new Hashtable();
			s = rs.getString("MaterialTypeNo");
			name = rs.getString("MATERIALTYPENAME");
			s = s.trim();
			
			
			hash.put("OrganID", String.valueOf(i));
			hash.put("SupOrganID", sOrganID);
			hash.put("SupOrganNO", sOrganNO);
			hash.put("OrganName", name);
			hash.put("OrganNO", s);
			
		
			i++;
			
			list2.add(hash);
			
			
		   }
		
			 }
		
		
		rs.close();
		stmt.close();
			
			
		} catch (SQLException ex){
			System.err.print("Get MaterialTypeTree SQLException: " + ex.toString());
			ex.printStackTrace();
		} finally {
			db.freeConnection();
		}
		return list2;
	}
	
	
	public ArrayList getMaterialTypeTree() {
		ArrayList treenodes = new ArrayList();
		DBPoolManager dbpool = new DBPoolManager();
		dbpool.getConnection();	
		try {
			String    s    = null;
			String    sql  = "SELECT MATERIALSQ, MATERIALTYPENAME, MATERIALPATYPENO,MATERIALTYPENO FROM Material_Type order by MATERIALPATYPENO,MATERIALSQ DESC";
			Statement stmt = dbpool.conn.createStatement();
			ResultSet rest = stmt.executeQuery(sql);
			while (rest.next()) {
				Hashtable ht = new Hashtable();
					s = Integer.valueOf(rest.getInt("MATERIALSQ")).toString();
				 	s = s.trim();
					ht.put("OrganID", s);
					
				if (rest.getString("MATERIALPATYPENO") == null){
					ht.put("SupOrganID", "");
				}
				else{
				 	s = rest.getString("MATERIALPATYPENO");
				 	s = s.trim();				
					ht.put("SupOrganID", s);
				}
				if (rest.getString("MATERIALTYPENAME") == null){
					ht.put("OrganName", "");
				}
				else{
				 	s = rest.getString("MATERIALTYPENAME");
				 	s = s.trim();				
					ht.put("OrganName", s);
				}
				if (rest.getString("MATERIALTYPENO") == null){
					ht.put("MaterialtypeNO", "");
				}
				else{
				 	s = rest.getString("MATERIALTYPENO");
				 	s = s.trim();				
					ht.put("MaterialtypeNO", s);
				}														
				treenodes.add(ht);
			}
			rest.close();
			stmt.close();									
		} catch (SQLException ex) {
			System.err.println("Get OrganTree SQLException: " + ex.toString());
		} finally {
			dbpool.freeConnection();
		}	
		return treenodes;
	}
}