dtree树形菜单简例
时间:2011-10-13 BlogJava Jakin
从http://www.destroydrop.com/javascripts/tree/下载dtree.zip压缩包，解压后我们会用到 dtree.js、dtree.css和img文件夹。
1.TreeInfo.java
package com.yxx;
public class TreeInfo {
private int nodeId = -1;
private int parentId = -1;
private String nodeName = null;
private String url = null;
private String target = null;
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;
}
public String getTarget() {
return target;
}
public void setTarget(String target) {
this.target = target;
}
}
dtree峯侘暇汽酒箭(2)
扮寂:2011-10-13 BlogJava Jakin
2.TreeUtil.java
package com.yxx;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
public class TreeUtil {
/** *//**
* @貫方象垂嶄響函tree議佚連
* @return
*/
public static List<TreeInfo> retrieveNodeInfos() {
List<TreeInfo> treeInfoList = new ArrayList<TreeInfo>();
String driverName = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test";
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet rs = null;
try {
Class.forName(driverName).newInstance();
connection = DriverManager.getConnection(url, "root", "1234");
String sql = "select * from tree_info";
preparedStatement = connection.prepareStatement(sql);
rs = preparedStatement.executeQuery();
TreeInfo treeInfo = null;
while (rs != null && rs.next()) {
treeInfo = new TreeInfo();
treeInfo.setNodeId(rs.getInt(1));
treeInfo.setParentId(rs.getInt(2));
treeInfo.setNodeName(rs.getString(3));
treeInfo.setUrl(rs.getString(4));
treeInfoList.add(treeInfo);
}
|
