departmenthandler.java

这是一个jsp联合javabean的电话查询系统。

/*
 * Created on 2006-7-14
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package org.jzgs.telnumber.ec.Util;

/**
 * @author zhangzhen
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
import java.util.ArrayList;

import org.jzgs.telnumber.ec.Util.DBAccess;
import org.jzgs.telnumber.ec.Util.TelNumValueMap;

public class DepartmentHandler {

	public static String FUN_GET_LIST_TAG( String selectParaName,String widthPara,String onchangeName) throws MyException  {
		
		ArrayList PRM_LIST_TAG = new ArrayList();
		String selectName="department";
		String width="20%";
		if(selectParaName!=null && !selectParaName.equals("")){
			selectName=selectParaName;
		}
		if(widthPara!=null && !widthPara.equals("")){
			width=widthPara;
		}		
		//儕僗僩 HTML 僞僌
		String PRM_LIST_HTML_TAG="<SELECT name=\""+selectName+"\" style=\"WIDTH: "+width+"\"onchange=\""+onchangeName+"()\">";
		DBAccess db = null;
		TelNumValueMap gcbMapBean = new TelNumValueMap();
		ArrayList list = new ArrayList();
		try {
			db =  DBAccess.getInstance();
			//愝掕偱懳徾偲側傞僨乕僞傪庢摼偡傞
			String strSql = "Select * FROM DEPTABLE ORDER BY MAINID ";
			list = db.executeQueryGetBeanList(strSql);
			for (int i = 0; i < list.size(); i++) { 
				gcbMapBean = (TelNumValueMap) list.get(i);
				PRM_LIST_TAG.add(gcbMapBean);
			}					
 		    for (int i = 0; i < PRM_LIST_TAG.size(); i++) { 
					gcbMapBean = (TelNumValueMap) PRM_LIST_TAG.get(i);
					if(i==0){
						PRM_LIST_HTML_TAG+="<OPTION value=\""+gcbMapBean.getValStr("SECONDID")+"\" selected>"+gcbMapBean.getValStr("DEPNAME")+"</OPTION>";
					}else{
						PRM_LIST_HTML_TAG+="<OPTION  value=\""+gcbMapBean.getValStr("SECONDID")+"\">"+gcbMapBean.getValStr("DEPNAME")+"</OPTION>";	
					}							
				}
			PRM_LIST_HTML_TAG+="</SELECT>";
		} catch (Exception e) { 
			e.printStackTrace();
			return "";
		} finally{
			if (db != null)
				try {
					db.rollback();
					db.closeDatabase();
				} catch (MyException e1) {
					e1.printStackTrace();
				}
		}
		return PRM_LIST_HTML_TAG;
	}	
	
public static String FUN_GET_PERSON_LIST_TAG( String selectParaName,String widthPara,String secondID,String table,String volumname) throws MyException  {
		
		ArrayList PRM_LIST_TAG = new ArrayList();
		String selectName="person";
		String width="20%";
		if(selectParaName!=null && !selectParaName.equals("")){
			selectName=selectParaName;
		}
		if(widthPara!=null && !widthPara.equals("")){
			width=widthPara;
		}		
		//儕僗僩 HTML 僞僌
		String PRM_LIST_HTML_TAG="<SELECT name=\""+selectName+"\" style=\"WIDTH: "+width+"\">";
		DBAccess db = null;
		TelNumValueMap gcbMapBean = new TelNumValueMap();
		ArrayList list = new ArrayList();
		try {
			db = DBAccess.getInstance();
			String strSql="";
			String temTitle="";
			String idTitle="";
			if(volumname.equals("")){
				  strSql = "Select * FROM "+table+"  WHERE DEPARTMENT='"+secondID+"'"+"ORDER BY PERSONID";
				  temTitle="PERSONNAME";
				  idTitle="PERSONID";
				}else{
					strSql = "Select * FROM "+table+"  WHERE ROUTENAME='"+secondID+"'"+"ORDER BY ROUTEID";
				  temTitle="DEPARTMENT";
				  idTitle="ROUTEID";
				}
			list = db.executeQueryGetBeanList(strSql);
			for (int i = 0; i < list.size(); i++) { 
				gcbMapBean = (TelNumValueMap) list.get(i);
				PRM_LIST_TAG.add(gcbMapBean);
			}					
 		    for (int i = 0; i < PRM_LIST_TAG.size(); i++) { 
					gcbMapBean = (TelNumValueMap) PRM_LIST_TAG.get(i);
					if(i==0){
						PRM_LIST_HTML_TAG+="<OPTION value=\""+gcbMapBean.getValStr(idTitle)+"\" selected>"+gcbMapBean.getValStr(temTitle)+"</OPTION>";
					}else{
						PRM_LIST_HTML_TAG+="<OPTION  value=\""+gcbMapBean.getValStr(idTitle)+"\">"+gcbMapBean.getValStr(temTitle)+"</OPTION>";	
					}							
				}
			PRM_LIST_HTML_TAG+="</SELECT>";
		} catch (Exception e) { 
			e.printStackTrace();
			return "";
		} finally{
			if (db != null)
				try {
					db.rollback();
					db.closeDatabase();
				} catch (MyException e1) {
					e1.printStackTrace();
				}

		}
		return PRM_LIST_HTML_TAG;
	}	

public static String FUN_GET_LIST_TAG( String department ,String selectParaName,String widthPara,String mainId,String onchangeName) throws MyException  {
	
	ArrayList PRM_LIST_TAG = new ArrayList();
	String selectName="department";
	String width="20%";
	if(selectParaName!=null && !selectParaName.equals("")){
		selectName=selectParaName;
	}
	if(widthPara!=null && !widthPara.equals("")){
		width=widthPara;
	}		
	//儕僗僩 HTML 僞僌
	String PRM_LIST_HTML_TAG="<SELECT name=\""+selectName+"\" style=\"WIDTH: "+width+"\"onchange=\""+onchangeName+"()\">";
	DBAccess db = null;
	TelNumValueMap gcbMapBean = new TelNumValueMap();
	ArrayList list = new ArrayList();
	try {
		db =  DBAccess.getInstance();
		//愝掕偱懳徾偲側傞僨乕僞傪庢摼偡傞
		String strSql = "Select * FROM DEPTABLE  Where MAINID='"+mainId+"'ORDER BY MAINID ";
		list = db.executeQueryGetBeanList(strSql);
		for (int i = 0; i < list.size(); i++) { 
			gcbMapBean = (TelNumValueMap) list.get(i);
			PRM_LIST_TAG.add(gcbMapBean);
		}					
		if(department!=null){
			for (int i = 0; i < PRM_LIST_TAG.size(); i++) { 
				gcbMapBean = (TelNumValueMap) PRM_LIST_TAG.get(i);
				if(i==0){
					PRM_LIST_HTML_TAG+="<OPTION value=\""+gcbMapBean.getValStr("SECONDID")+"\" selected>"+gcbMapBean.getValStr("DEPNAME")+"</OPTION>";
				}else{
					if(department.equals(gcbMapBean.getValStr("SECONDID"))){
						PRM_LIST_HTML_TAG+="<OPTION value=\""+gcbMapBean.getValStr("SECONDID")+"\" selected>"+gcbMapBean.getValStr("DEPNAME")+"</OPTION>";
					}else{
						PRM_LIST_HTML_TAG+="<OPTION value=\""+gcbMapBean.getValStr("SECONDID")+"\">"+gcbMapBean.getValStr("DEPNAME")+"</OPTION>";	
					}			
				}
			}
		}else{
			for (int i = 0; i < PRM_LIST_TAG.size(); i++) { 
				gcbMapBean = (TelNumValueMap) PRM_LIST_TAG.get(i);
				if(i==0){
					PRM_LIST_HTML_TAG+="<OPTION value=\""+gcbMapBean.getValStr("SECONDID")+"\" selected>"+gcbMapBean.getValStr("DEPNAME")+"</OPTION>";
				}else{
					PRM_LIST_HTML_TAG+="<OPTION  value=\""+gcbMapBean.getValStr("SECONDID")+"\">"+gcbMapBean.getValStr("DEPNAME")+"</OPTION>";	
				}							
			}						
			
		}
		PRM_LIST_HTML_TAG+="</SELECT>";
	} catch (Exception e) { 
		e.printStackTrace();
		return "";
	} finally{
		if (db != null)
			try {
				db.rollback();
				db.closeDatabase();
			} catch (MyException e1) {
				e1.printStackTrace();
			}
	}
	return PRM_LIST_HTML_TAG;
}	

public static String FUN_GET_PERSON_LIST_TAG( String person ,String selectParaName,String widthPara,String secondID,String table,String volumname) throws MyException  {
	
	ArrayList PRM_LIST_TAG = new ArrayList();
	String selectName="person";
	String width="20%";
	if(selectParaName!=null && !selectParaName.equals("")){
		selectName=selectParaName;
	}
	if(widthPara!=null && !widthPara.equals("")){
		width=widthPara;
	}		
	//儕僗僩 HTML 僞僌
	String PRM_LIST_HTML_TAG="<SELECT name=\""+selectName+"\" style=\"WIDTH: "+width+"\">";
	DBAccess db = null;
	TelNumValueMap gcbMapBean = new TelNumValueMap();
	ArrayList list = new ArrayList();
	try {
		db = DBAccess.getInstance();
		String strSql="";
		String temTitle="";
		String idTitle="";
		if(volumname.equals("")){
		  strSql = "Select * FROM "+table+"  WHERE DEPARTMENT='"+secondID+"'"+"ORDER BY PERSONID";
		  temTitle="PERSONNAME";
		  idTitle="PERSONID";
		}else{
			strSql = "Select * FROM "+table+"  WHERE ROUTENAME='"+secondID+"'"+"ORDER BY ROUTEID";
		  temTitle="DEPARTMENT";
		  idTitle="ROUTEID";
		}
			list = db.executeQueryGetBeanList(strSql);
		for (int i = 0; i < list.size(); i++) { 
			gcbMapBean = (TelNumValueMap) list.get(i);
			PRM_LIST_TAG.add(gcbMapBean);
		}		
		
		if(person!=null){
			for (int i = 0; i < PRM_LIST_TAG.size(); i++) { 
				gcbMapBean = (TelNumValueMap) PRM_LIST_TAG.get(i);
				if(i==0){
					PRM_LIST_HTML_TAG+="<OPTION value=\""+gcbMapBean.getValStr(idTitle)+"\" selected>"+gcbMapBean.getValStr(temTitle)+"</OPTION>";
				}else{
					if(person.equals(gcbMapBean.getValStr("PERSONID"))){
						PRM_LIST_HTML_TAG+="<OPTION value=\""+gcbMapBean.getValStr(idTitle)+"\" selected>"+gcbMapBean.getValStr(temTitle)+"</OPTION>";
					}else{
						PRM_LIST_HTML_TAG+="<OPTION value=\""+gcbMapBean.getValStr(idTitle)+"\">"+gcbMapBean.getValStr(temTitle)+"</OPTION>";	
					}			
				}
			}
		}else{
			for (int i = 0; i < PRM_LIST_TAG.size(); i++) { 
				gcbMapBean = (TelNumValueMap) PRM_LIST_TAG.get(i);
				if(i==0){
					PRM_LIST_HTML_TAG+="<OPTION value=\""+gcbMapBean.getValStr(idTitle)+"\" selected>"+gcbMapBean.getValStr(temTitle)+"</OPTION>";
				}else{
					PRM_LIST_HTML_TAG+="<OPTION  value=\""+gcbMapBean.getValStr(idTitle)+"\">"+gcbMapBean.getValStr(temTitle)+"</OPTION>";	
				}							
			}						
			
		}
		  
		PRM_LIST_HTML_TAG+="</SELECT>";
	} catch (Exception e) { 
		e.printStackTrace();
		return "";
	} finally{
		if (db != null)
			try {
				db.rollback();
				db.closeDatabase();
			} catch (MyException e1) {
				e1.printStackTrace();
			}

	}
	return PRM_LIST_HTML_TAG;
}	

}