materialmaintaintree.java

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

package imis_mate.common;

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

import database.DBPoolManager;

public class MaterialMaintainTree {


	
	public ArrayList getMaterialMaintainNo() {
		ArrayList list = new ArrayList();
		DBPoolManager db = new DBPoolManager();

		   String sOrganID=null;
		   String sSupOrganID=null;
		   String sOrganName=null;
		db.getConnection();
		
		try {
			String s = null;
			String sql = "select distinct to_char(MaintainDate,'yyyy-mm-dd') t from Material_Maintain_Table  where rownum<=50 order by  t "; 
			
			//String sql = "select maintainID,materialName  from Material_Maintain_Table  order by  MaintainDate Desc"; //
			Statement stmt = db.conn.createStatement(); 
			ResultSet rs = stmt.executeQuery(sql);
			String date;
			Hashtable ht1 = new Hashtable();
			ht1.put("OrganID", "1");
			ht1.put("SupOrganID", "0");
			ht1.put("OrganName", "维修编号");
			list.add(ht1);
			int i = 11;
			while(rs.next()){
				Hashtable ht = new Hashtable();
				date = rs.getString("t");
				ht.put("OrganID", String.valueOf(i));
				ht.put("SupOrganID", "1");
				ht.put("OrganName", date);
				i++;
				list.add(ht);
			}
				rs.close();
				stmt.close();	
				ArrayList list1 = new ArrayList();
				Iterator itr = list.iterator();
				 while (itr.hasNext()) {
				   
				     
						Hashtable ht = (Hashtable) itr.next();   
						
				  				sOrganID      =  ht.get("OrganID").toString();
				            	sSupOrganID   =  ht.get("SupOrganID").toString(); 
				            	sOrganName    =  ht.get("OrganName").toString();
				if(sSupOrganID.equals("1")){
			     sql = "select maintainID,materialName  from Material_Maintain_Table  where MaintainDate=to_date('"+sOrganName+"','yyyy-mm-dd') order by maintainID"; //
			 	
			     stmt = db.conn.createStatement(); 
				 rs = stmt.executeQuery(sql);
				 
				 i = 11;
			while (rs.next()) {
				Hashtable hash = new Hashtable();
				s = rs.getString("materialName");
				String no = new Integer(rs.getInt("maintainID")).toString();
				
				s = s.trim();
				
				
			//	hash.put("OrganID", no);
				hash.put("OrganID", String.valueOf(i)+"*"+no);
				hash.put("SupOrganID", sOrganID);
				hash.put("OrganName", s);
				i=i+1;
				
				list1.add(hash);
				
				
			   }}
			
				 }
			list.addAll(list1);
			
			rs.close();
			stmt.close();
				 } catch (SQLException ex){
			System.err.print("Get MaterialTree SQLException: " + ex.toString());
			ex.printStackTrace();
		} finally {
			db.freeConnection();
		}
		return list;
	}
	

	

		
}