Struts-jquery-tree例子.docVIP

tree.jsp !DOCTYPE HTML PUBLIC -//W3C//DTD XHTML 4.01 Transitional//EN /TR/xhtmll/DTD/xhtmll-transitional.dtd %@ page language=java pageEncoding=UTF-8% %@taglib prefix=s uri=/struts-tags% %@ taglib prefix=sj uri=/struts-jquery-tags% %@ taglib prefix=sjt uri=/struts-jquery-tree-tags% sj:head jqueryui=true / s:url var=treeDataUrl action=json-tree-data / sjt:tree id=jsonTree href=%{treeDataUrl} onClickTopics=treeClicked / JsonTreeData.java package com.jq.web.action; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.jgeppert.struts2.jquery.tree.result.TreeNode; import com.opensymphony.xwork2.ActionSupport; public class JsonTreeData extends ActionSupport { private static final long serialVersionUID = -2886756982077980790L; private ListTreeNode nodes = new ArrayListTreeNode(); private String id = ; // @Actions( { @Action(value = /json-tree-data, results = { @Result(name = // success, type = json, params = { // root, nodes }) }) }) public String execute() { Connection conn = null; Statement stmt = null; try { Class.forName(com.mysql.jdbc.Driver); conn = DriverManager.getConnection( jdbc:mysql://localhost:3306/mysql, root, 123); stmt = conn.createStatement(); // System.out.print(连接成功！); String sql = select t.NODEID as NODEID ,t.NODENAME as NODENAME,t.DESCRIPTION as DESCRIPTION from mysql.t_tree t where t.PARENTID = + Integer.valueOf(id) + order by t.NODEID; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { TreeNode nodeA = new TreeNode(); nodeA.setId(rs.getString(NODEID)); nodeA.setTitle(rs.getString(NODENAME)); nodeA.setState(TreeNode.NODE_STATE_CLOSED); // nodeA.setState(TreeNode.NODE_STATE_LEAF); nodes.add(nodeA); } } catch (Exception e) { e.getStackTrace(); } return SUCCESS; } public String getJSON() { return execute(); } public ListTreeNode getNodes(