telnumchaxun2bean.java

来自「这是一个jsp联合javabean的电话查询系统。」· Java 代码 · 共 62 行

/*
 * 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.bean;

import java.util.ArrayList;


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



/**
 * @author zhangzhen
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class TelNumChaXun2Bean {

	private DBAccess db = null;

    public TelNumChaXun2Bean() throws MyException {
        db = DBAccess.getInstance();
    }
    
    /**
	 * @throws GcbException
	 */
	public void closeDBConnection() throws Exception{
		if(db!=null){
			db.closeDatabase();
		}
	}
	
	public TelNumValueMap getResultBean(String person) throws MyException {
		
		TelNumValueMap resultBean = new TelNumValueMap();
		
	    String strSql = new StringBuffer(" SELECT *	 \n")
		.append(" from DEPTABLE T1,                  \n")
		.append(" (select * FROM   			 table2  \n")
		.append(" WHERE  				             \n")
		.append(" ROUTEID = ").append(person)	
		.append(") T                                 \n")
		.append(" WHERE T.ROUTENAME = T1.SECONDID \n")
		.toString();
		//System.out.println(strSql);
	    try	{
	    	resultBean=db.executeQueryGetBean(strSql);
		} catch (MyException e) {
		    throw e;		
		} 
		return resultBean;
	}
}