supplytree.java

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

package imis_mate.common;


import database.DBPoolManager;

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

//踱湔攷
import java.sql.SQLException;
public class SupplyTree {
	

		
		public ArrayList getSupplyNo() {
			ArrayList list = new ArrayList();
			DBPoolManager db = new DBPoolManager();
			db.getConnection();
			
			try {
				String s = null;
				String sql = "select supplyno, supplyname  from supply  order by  supplyno Desc"; //
				Statement stmt = db.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("supplyname");
					String no = new Integer(rs.getInt("supplyno")).toString();
					s = s.trim();
					
				//	hash.put("OrganID", no);
					hash.put("OrganID", String.valueOf(i)+"*"+no);
					hash.put("SupOrganID", "1");
					hash.put("OrganName", s);
					i=i+1;
					list.add(hash);
					
				}
				rs.close();
				stmt.close();
			} catch (SQLException ex){
				System.err.print("Get MaterialTree SQLException: " + ex.toString());
				ex.printStackTrace();
			} finally {
				db.freeConnection();
			}
			return list;
		}
		
		public ArrayList getSupplyTreeNode(String supplyno) {
			ArrayList list = new ArrayList();
			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.getInt("supplyno") == 0){
						ht.put("supplyno", "");
					}
					else{
					 	s =String.valueOf(rest.getInt("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);
					}	
					
					list.add(ht);
				}
				
				rest.close();
				stmt.close();									
			} catch (SQLException ex) {
				System.err.println("Get OrganTree SQLException: " + ex.toString());
			} finally {
				dbpool.freeConnection();
			}	
			return list;
		}
		
		
	}