tree

賓仔 2009-03-09

展開全文

Struts2中可以通過s:tree標(biāo)簽輕松的實(shí)現(xiàn)一個樹狀結(jié)構(gòu)。

下面是一個s:tree的具體實(shí)現(xiàn)的例子,。數(shù)的結(jié)構(gòu)用mysql數(shù)據(jù)庫類維護(hù),。

1.創(chuàng)建數(shù)據(jù)庫表

DROP TABLE IF EXISTS CATEGORY_MASTER ;
CREATE TABLE CATEGORY_MASTER(
CATEGORY_ID int auto_increment NOT NULL,
CATEGORY_NAME varchar(50) NOT NULL,
PARENT_CATEGORY_ID int DEFAULT -1 NOT NULL,
PRIMARY KEY (CATEGORY_ID)
)

2.創(chuàng)建數(shù)據(jù)庫連接類

參看Struts2中DB操作的一個例子(1)

3.創(chuàng)建Category.java,，用來保存DB數(shù)據(jù)和頁面提交的數(shù)據(jù)

package s2.ex.data;

public class Category {

private int id;

private String name;

private Category[] children;

private int parentNodeId;

public Category[] getChildren() {

return children;

}

public void setChildren(Category[] children) {

this.children = children;

}

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public int getParentNodeId() {

return parentNodeId;

}

public void setParentNodeId(int parentNodeId) {

this.parentNodeId = parentNodeId;

}

4.創(chuàng)建對數(shù)據(jù)庫表category_master操作的類

package s2.ex.svc;

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

import s2.ex.data.Category;
import s2.ex.db.DBConn;

public class CategoryService {
private static CategoryService instance;
private CategoryService() {

}
public static CategoryService getInstance() {
   if (instance == null){
    instance = new CategoryService();
   }
   return instance;
}
public Category[] getCategoryList() {
   Connection conn = DBConn.getConnection();
   final String SQL = "SELECT * FROM category_master";
   ResultSet rs = null;
   try {
    rs = conn.createStatement().executeQuery(SQL);
    ArrayList<Category> aryResult = new ArrayList<Category>();
    while (rs.next()) {
     Category category = new Category();
     category.setId(rs.getInt("CATEGORY_ID"));
     category.setName(rs.getString("CATEGORY_NAME"));
     aryResult.add(category);
    }
    Category[] result = new Category[aryResult.size()];
    result = aryResult.toArray(result);
    return result;

   } catch (SQLException e) {
    e.printStackTrace();
   } finally {
    try {
     if (rs != null){
      rs.close();
     }
     if (conn != null) {
      if (!conn.isClosed()) {
       conn.close();
      }

     }
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   return null;
}
public boolean addNewTreeNode(Category category) {
   Connection conn = DBConn.getConnection();
   final String SQL = "INSERT INTO category_master(CATEGORY_NAME,PARENT_CATEGORY_ID) VALUES(?,?)";
   PreparedStatement pre = null;
   try {
    pre = conn.prepareStatement(SQL);
    pre.setString(1, category.getName());
    pre.setInt(2, category.getParentNodeId());
    int result = pre.executeUpdate();
    if (result >= 0) {
     return true;
    }

   } catch (SQLException e) {
    e.printStackTrace();
   } finally {
    try {

     if (pre != null){
      pre.close();
     }
     if (conn != null) {
      if (!conn.isClosed()) {
       conn.close();
      }

     }
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   return false;
}
public Category[] getAllCategory() {
   Connection conn = DBConn.getConnection();
   final String SQL = "SELECT * FROM category_master where PARENT_CATEGORY_ID=-1";
   ResultSet rs = null;
   try {
    rs = conn.createStatement().executeQuery(SQL);
    ArrayList<Category> aryResult = new ArrayList<Category>();
    while (rs.next()) {
     Category category = new Category();
     category.setId(rs.getInt("CATEGORY_ID"));
     category.setName(rs.getString("CATEGORY_NAME"));
     category.setChildren(this.getChildren(category.getId()));
     aryResult.add(category);
    }
    Category[] result = new Category[aryResult.size()];
    result = aryResult.toArray(result);
    return result;

     }
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   return null;
}
public Category[] getChildren(int categoryId) {
   Connection conn = DBConn.getConnection();
   final String SQL = "SELECT * FROM category_master where PARENT_CATEGORY_ID=?";
   PreparedStatement pre = null;
   ResultSet rs = null;
   try {
    pre = conn.prepareStatement(SQL);
    pre.setInt(1, categoryId);
    rs = pre.executeQuery();
    ArrayList<Category> aryResult = new ArrayList<Category>();
    while (rs.next()) {
     Category category = new Category();
     category.setId(rs.getInt("CATEGORY_ID"));
     category.setName(rs.getString("CATEGORY_NAME"));
     category.setChildren(this.getChildren(category.getId()));
     aryResult.add(category);
    }
    Category[] result = new Category[aryResult.size()];
    result = aryResult.toArray(result);
    return result;
   } catch (SQLException e) {
    e.printStackTrace();
   } finally {
    try {
     if (rs != null){
      rs.close();
     }
     if (pre != null){
      pre.close();
     }
     if (conn != null) {
      if (!conn.isClosed()) {
       conn.close();
      }

     }
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   return null;
}
}

上面getChildren方法里面用到了遞歸,。

5.創(chuàng)建action類

package s2.ex.action;

import s2.ex.data.Category;
import s2.ex.svc.CategoryService;

import com.opensymphony.xwork2.ActionSupport;

public class SimpleTreeAction extends ActionSupport {

private static final long serialVersionUID = 1L;
private Category root;
private Category[] parentNodeIds;
private Category editCategory;
public String displayTree() {
   root = new Category();
   root.setId(-1);
   root.setName("root");
   root.setChildren(CategoryService.getInstance().getAllCategory());
   return SUCCESS;
}
public Category getRoot() {
   return root;
}
public void setRoot(Category root) {
   this.root = root;
}
public String goTreeEdit(){
   this.parentNodeIds = CategoryService.getInstance().getCategoryList();
   return SUCCESS;
}
public Category[] getParentNodeIds() {
   return parentNodeIds;
}
public void setParentNodeIds(Category[] parentNodeIds) {
   this.parentNodeIds = parentNodeIds;
}

public Category getEditCategory() {
   return editCategory;
}
public void setEditCategory(Category editCategory) {
   this.editCategory = editCategory;
}
public String saveTreeNode() {
   if (CategoryService.getInstance().addNewTreeNode(this.editCategory)){
    return SUCCESS;
   }else {
    return INPUT;
   }
}
}

6.創(chuàng)建TreeIndex.jsp,，用來顯示樹

<%@ page contentType="text/html; charset=UTF-8" %>
<%@page pageEncoding="utf-8" %>
<%@taglib prefix="s" uri="/struts-tags" %>
<html>
<head>
<title>Tree</title>
<s:head theme="ajax" debug="true" />
</head>

<body>
<script language="JavaScript">
function treeNodeSelected(arg) {
    alert("id["+arg.source.widgetId+"], name["+ arg.source.title+ "] selected");
}
dojo.addOnLoad(function() {
    var s = dojo.widget.byId('treeTestId').selector;
    dojo.event.connect(s, 'select', 'treeNodeSelected');
});</script>
<div style="float:left; margin-right: 50px;">
<s:tree id="treeTestId"
theme="ajax"
rootNode="root"
childCollectionProperty="children"
nodeIdProperty="id"
nodeTitleProperty="name"
treeSelectedTopic="treeSelected">
</s:tree>
<s:form action="GoTreeEdit">
<s:submit value="Add New"/>
</s:form>
</div>

</body>
</html>

7.創(chuàng)建用來增加節(jié)點(diǎn)的TreeEdit.jsp

<%@ page contentType="text/html; charset=UTF-8" %>
<%@page pageEncoding="utf-8" %>
<%@taglib prefix="s" uri="/struts-tags" %>
<html>
<head>
<title>Session Test</title>
<s:head theme="xhtml"/>
</head>

</body>
</html>

8.配置struts.xml

<package name="Test" extends="struts-default" namespace="/test">
   <action name="DisplayTree" class="s2.ex.action.SimpleTreeAction" method="displayTree">
    <result>TreeIndex.jsp</result>
   </action>
   <action name="GoTreeEdit" class="s2.ex.action.SimpleTreeAction" method="goTreeEdit">
    <result>TreeEdit.jsp</result>
   </action>
   <action name="SaveTreeNode" class="s2.ex.action.SimpleTreeAction" method="saveTreeNode">
    <result name="input">TreeEdit.jsp</result>
    <result type="redirect">DisplayTree.action</result>
   </action>
</package>

本站是提供個人知識管理的網(wǎng)絡(luò)存儲空間,，所有內(nèi)容均由用戶發(fā)布,，不代表本站觀點(diǎn),。請注意甄別內(nèi)容中的聯(lián)系方式、誘導(dǎo)購買等信息,，謹(jǐn)防詐騙,。如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請點(diǎn)擊一鍵舉報,。

轉(zhuǎn)藏 分享

QQ空間 QQ好友新浪微博微信

獻(xiàn)花（0） +1

來自：賓仔 > 《struts2.》

舉報/認(rèn)領(lǐng)