treeload.java

目录树,在脚本中可以直接调用后台java代码,动态加载数据至页面显示.

package it.luzhrong;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class TreeLoad {
	Connection conn;
/*	public TreeLoad()
	{
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (Exception e) {
			// TODO: handle exception
		}			
	}
	public void getConnection()
	{
		try {
			conn = DriverManager.getConnection("jdbc:mysql://localhost/tree",
					"root", "1234");
		} catch (Exception e) {
			System.out.println(e.getMessage());
		}	
	}*/
	public String getChild(String parent)
	{
//		List list=new ArrayList();
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost/tree",
					"root", "1234");
		} catch (Exception e) {
			// TODO: handle exception
		}	
		String strResult="";
		try {
/*			if(conn==null)
			{
				
				getConnection();
			}*/
			PreparedStatement ps = conn
					.prepareStatement("select * from address where parent="
							+ parent);
			ResultSet rs = ps.executeQuery();
			while(rs.next())
			{
				Address address=new Address();
				strResult=strResult+rs.getString(1)+":"+rs.getString(2)+":"+rs.getInt(3)+":"+rs.getString(4)+",";
//				address.setId(rs.getString(1));
//				address.setName(rs.getString(2));
//				address.setLevel(new Integer(rs.getInt(3)));
//				address.setParent(rs.getString(4));
//				list.add(address);
				System.out.println(strResult);
			}
/*			for(int i=0;i<list.size();i++)
			{
				Address ad=(Address)list.get(i);
				System.out.println(ad.getName());
			}
			*/
		} catch (Exception e) {
			System.out.println(e.getMessage());
		}
		finally
		{
			try {
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
			}			
		}
		return strResult;
	}
/*	public static void main(String [] args)
	{
		TreeLoad tl=new TreeLoad();
		tl.getChild("1005");
	}*/
}