testservlet.java

一个用ajax写的动态树.实现无限级的树.

package com.servlet;

import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletException;

import sun.jdbc.rowset.CachedRowSet;

import java.io.IOException;
import com.database.*;
import java.sql.*;
import com.test.TestMan;

public class TestServlet extends HttpServlet {
	
	private TestMan tm = new TestMan();
	public TestServlet() {
		super();
	}
	
	public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,
		IOException{
		doGet(request,response);
	}
	
	public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,
		IOException{
		tm.getCheckBoxValue(request, response);
		String todo = request.getParameter("action");
		if("tree".equals(todo)) {
			DBSession s = null;
			Connection conn = null;
			CachedRowSet crs = null;
			String sql = null;
			String pid = request.getParameter("pid");
			String str = "[";
			try {
				s = new DBSession();
				conn = s.getConnection();
				sql = "select * from tree where pid="+pid;
				crs = s.executeQuery(sql, conn);
				if(crs.size()>0) {
					crs.beforeFirst();
					while(crs.next()) {
						str += getFormatString(crs.getString("id"),crs.getString("name"),crs.getString("isfolder"),crs.getString("link"))+",";
					}
					str = str.substring(0,str.length()-1);
					str += "]";
				}else {
					str = "["+getFormatString("-1","没有节点","false","#")+"]";
				}
				response.setContentType("text/xml;charset=UTF-8");
				response.setHeader("Cache-Control","no-cache");
				response.getWriter().write(str);
			}catch(Exception ex) {
				ex.printStackTrace();
			}finally {
				try {
					s.close(conn);
				}catch(Exception ex) {}
			}
			
		}
	}

	/*
	 * 将相应格式化成json
	 */
	private String getFormatString(String id,String name,String isfolder,String link) {
		String str = null;
		str = "{id:'"+id+"',name:'"+name+"',isfolder:'"+isfolder+"',link:'"+link+"'}";
		return str;
	}

}