treedao.java.svn-base

tapestry json 实现从数据库读取数据生成树

package com.xino.dao;

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

import Metis.Common.Web.Ext2.Tree.TreeNode;

import com.datasource.DBControl;

/*
 * $Id$ 
 * 
 * Copyright (C)2002－2008 福建鑫诺.All rights reserved. 
 *
 * TreeDao.java
 * 
 * Original Author: 何则锐,2008-5-27
 *
 * 文件功能说明:  
 * <文件功能说明>
 * History
 * 版本号  |   作者   |  修改时间   |   修改内容
 */
public class TreeDao{

	DBControl db = DBControl.getInstance();
	
	@SuppressWarnings("unchecked")
	//取地区列表树
	public List<TreeNode> getAreaInfoListByCode(String code){
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		List list = null;
		
		try {
			conn = db.getConn();
			if(conn==null){
				return null;
			}
			stmt = conn.createStatement();
			String sql = "";
			if(code == null || code.equals("0")){
				sql = "select * from tbl_area where up_area = '440000'";
			}else{
				sql = "select * from tbl_area where up_area = "+"'"+code+"'";
			}
			
			rs=stmt.executeQuery(sql);
			list=new ArrayList();
			while(rs.next())
			{
				TreeNode node=new TreeNode();
				node.setId(rs.getString("AREA_CODE"));
				node.setName(rs.getString("AREA_NAME"));
				if(isHasChild(node.getId())){
					node.setHasChild(true);
				}else
					node.setHasChild(false);
				
				/*areaInfo.setAreaCode(rs.getString("AREA_CODE"));
				//System.out.println(areaInfo.getAreaCode()+","+rootCode);
				areaInfo.setAreaName(rs.getString("AREA_NAME"));
				areaInfo.setAreaPY(rs.getString("AREA_PY"));
				areaInfo.setParentAreaCode(rs.getString("UP_AREA"));
				areaInfo.setAreaValidity(rs.getString("AREA_VALIDITY"));*/
				list.add(node);
			}
			
			
		} catch (Exception e) {
			System.out.println("数据库连接超时");
			return null;
		}finally
		{
			try
			{
				if(stmt != null){
					stmt.close();
				}
				if(rs != null){
					rs.close();
				}
				db.putConn(conn);
			}catch(Exception e)
			{
				System.out.println("error");
			}
		}
		
		return list;
		
	} 
	
	//判断是否有下级地区
	@SuppressWarnings("unchecked")
	public boolean isHasChild(String code){
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		List list = null;
		boolean bool = false;
		try {
			conn = db.getConn();
			if(conn==null){
				return false;
			}
			stmt = conn.createStatement();
			String sql = "";
			
			sql = "select * from tbl_area where up_area = "+"'"+code+"'";
			
			rs=stmt.executeQuery(sql);
			list=new ArrayList();
			
			while(rs.next())
			{
				TreeNode node=new TreeNode();
				node.setId(rs.getString("AREA_CODE"));
				node.setName(rs.getString("AREA_NAME"));
				list.add(node);
			}
			
			
		} catch (Exception e) {
			System.out.println("数据库连接超时");
			return false;
		}finally
		{
			try
			{
				if(stmt != null){
					stmt.close();
				}
				if(rs != null){
					rs.close();
				}
				db.putConn(conn);
			}catch(Exception e)
			{
				System.out.println("error");
			}
		}
		if(list != null && list.size() > 0 ){
			bool = true;
		}else
			bool = false;
		
		return bool;
		
	} 
}