简单的自定义标签实现树结构的小功能

最新推荐文章于 2023-08-16 09:50:26 发布

youyou0204

最新推荐文章于 2023-08-16 09:50:26 发布

阅读量650

点赞数

文章标签： string list oracle url tree exception

本文链接：https://blog.csdn.net/youyou0204/article/details/4277086

版权

最近做了个小功能，用dtree.js做了个树结构，用自定义标签做的，也是参照网上的例子。

具体实现如下：

TreeUtil.java (树结构目录数据处理类)

package cl.mytree; import java.util.Collection; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Connection; import java.sql.DriverManager; /** * 为树结构目录提供数据来源 * @author Diegoyun * @version 1.0 */ public class TreeUtil { /** * 读取数据库内容，填充LIST(MYSQL) * * @return */ public static List retrieveNodeInfos() { List coll = new ArrayList(); String driverName = "com.mysql.jdbc.Driver"; String host = "localhost"; String port = ":3306"; String serverID = "test"; String userName = "root"; String userPwd = "root"; String url = "jdbc:mysql://" + host + port + "/" + serverID; Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; try { Class.forName(driverName).newInstance(); conn = DriverManager.getConnection(url, userName, userPwd); String sql = "select * from tree_info"; ps = conn.prepareStatement(sql); rs = ps.executeQuery(); TreeInfo info = null; while (rs != null && rs.next()) { info = new TreeInfo(); info.setNodeId(rs.getInt(1)); info.setParentId(rs.getInt(2)); info.setNodeName(rs.getString(3)); info.setUrl(rs.getString(4)); coll.add(info); } // if(rs!=null){ // rs.close(); // rs=null; // } // if(ps!=null){ // ps.close(); // ps=null; // } } catch (Exception e) { System.out.println(e); } return coll; } /** * 读取数据库内容，填充LIST(ORACLE) * * @return */ public static List retrieveNodeInfos4Oracle() { List coll = new ArrayList(); String driverName = "oracle.jdbc.driver.OracleDriver"; String host = "localhost"; String port = ":1521"; String serverID = "MYDB"; String userName = "YFFW_TEST"; String userPwd = "YFFW_TEST"; String url = "jdbc:oracle:thin:@" + host + port + ":" + serverID; Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; try { Class.forName(driverName).newInstance(); conn = DriverManager.getConnection(url, userName, userPwd); String sql = "select * from tree_info"; ps = conn.prepareStatement(sql); rs = ps.executeQuery(); TreeInfo info = null; while (rs != null && rs.next()) { info = new TreeInfo(); info.setNodeId(rs.getInt(1)); info.setParentId(rs.getInt(2)); info.setNodeName(rs.getString(3)); info.setUrl(rs.getString(4)); coll.add(info); } } catch (Exception e) { System.out.println(e); } return coll; } /** * 为查询的信息创建树结构信息(基于dTree) * @param list * @return */ public static String createTreeInfo4Dtree(List list){ StringBuffer contents = new StringBuffer(); contents.append("/n"); return contents.toString(); } public static void main(String[] args) { List alist = TreeUtil.retrieveNodeInfos4Oracle(); System.out.println(TreeUtil.createTreeInfo4Dtree(alist)); } }

在数据库中创建TREE_INFO的表，字段为：NODE_ID INTEGER,PARENT_ID INTEGER,NODE_NAME VARCHAR(20),URL VARCHAR(50)，并插入数据

TreeInfo.java(实体类)

package cl.mytree; /** * @author Diegoyun * @version 1.0 */ public class TreeInfo { private int nodeId = -1;// node id private int parentId = -1;// parentId private String nodeName = null;// node name private String url = null;// url references public int getNodeId() { return nodeId; } public void setNodeId(int nodeId) { this.nodeId = nodeId; } public int getParentId() { return parentId; } public void setParentId(int parentId) { this.parentId = parentId; } public String getNodeName() { return nodeName; } public void setNodeName(String nodeName) { this.nodeName = nodeName; } public String getUrl() { return url; } public void setUrl(String url) { this.url = url; } }

InitTreeTag(自定义标签类):

package cl.mytree; import javax.servlet.jsp.tagext.TagSupport; import javax.servlet.jsp.JspException; import java.io.IOException; /** * @author Diegoyun * @version 1.0 */ public class InitTreeTag extends TagSupport{ public int doEndTag() throws JspException { StringBuffer tree = new StringBuffer(); tree.append("<mce:script type=/"text/javascript/"></mce:script>/n"); try{ pageContext.getOut().println(tree.toString()); }catch(IOException ioe){ ioe.printStackTrace(); } return super.doEndTag(); } }

ShowTreeTag(自定义标签类):

package cl.mytree; import java.io.IOException; import javax.servlet.jsp.tagext.TagSupport; import javax.servlet.jsp.JspException; import java.io.IOException; public class ShowTreeTag extends TagSupport { public int doEndTag() throws JspException { StringBuffer buffer = showTree(); try { pageContext.getOut().println(buffer.toString()); } catch (IOException ioe) { ioe.printStackTrace(); } return super.doEndTag(); } private StringBuffer showTree() { StringBuffer sb = new StringBuffer(); sb.append("<div class=/"tree/">/n"); sb.append("<mce:script type=/"text/javascript/">/n"); sb.append(" // --></mce:script>/n"); sb.append("</div>/n"); return sb; } }

在WEB-INF/taglib/创建my-taglib.xml文件:

<?xml version="1.0" encoding="ISO-8859-1" ?> <!DOCTYPE taglib PUBLIC "-//Sun Microsystems, Inc.//DTD JSP Tag Library 1.2//EN" "http://java.sun.com/dtd/web-jsptaglibrary_1_2.dtd"> <taglib> <tlib-version>1.0</tlib-version> <jsp-version>1.2</jsp-version> <short-name>tree</short-name>  <tag> <name>init</name> <tag-class>cl.mytree.InitTreeTag</tag-class> <body-content>empty</body-content> </tag>  <tag> <name>show</name> <tag-class>cl.mytree.ShowTreeTag</tag-class> <body-content>empty</body-content> </tag> </taglib>

在web.xml中添加:

<taglib> <taglib-uri>/WEB-INF/lib/my-taglib.tld</taglib-uri> <taglib-location>/WEB-INF/taglib/my-taglib.tld</taglib-location> </taglib>

新建mytree.jsp页面:

<%@ page language="java" contentType="text/html; charset=gbk"%> <%@ taglib uri="/WEB-INF/lib/my-taglib.tld" prefix="tree"%> <html> <head> <title>Tree example</title> <meta http-equiv="Content-Type" content="text/html; charset=GBK"> <link rel="StyleSheet" href="dtree.css" type="text/css"> <script type="text/javascript" src="dtree.js"></script> <tree:init /> </head> <body> <b>Tree example :</b> <br /> <br /> <tree:show /> <br /> <br /> </body> </html>

运行页面即可看到效果，不过只是很简单的效果。