I have to populate my rich:tree from DB where I store them in the following structure->
id parentid name depth lineage
1 null root 0 /1/
2 1 A 1 /1/2/
3 1 B 1 /1/3
I have gotten the data into an ArrayList. Being a complete newbie to richfaces I have no idea how to use the information to build the rich tree and even after surfing about 100 sites I have no idea what to do. Any help would do..It's really really urgent.
Please Help!!
Moreover I need the tree to support functionalites for an Upload site. On automatically Uploading a File or Removing, it should display the new tree.
Following is the extent to which I have proceeded.
FolderTree.java
public class FolderTree{
int id;
int parentId;
String name;
int depth;
String lineage;
public int getid()
{
return(this.id);
}
public int getparentId()
{
return(this.parentId);
}
public String getname()
{
return(this.name);
}
public int getdepth()
{
return(this.depth);
}
public String getlineage()
{
return(this.lineage);
}
public void setid(int id)
{
this.id=id;
}
public void setparentId(int parentId)
{
this.parentId=parentId;
}
public void setname(String name)
{
this.name=name;
}
public void setdepth(int depth)
{
this.depth=depth;
}
public void setlineage(String lineage)
{
this.lineage=lineage;
}
}
StructureExtractor
import java.sql.*;
import java.util.ArrayList;
public class StructureExtractor {
ArrayList<FolderTree> tree = new ArrayList<FolderTree>();
public void extract() {
System.out.println("Getting All Rows from a table!");
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";
String db = "vcms";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "sanjukta";
try{
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+db, user, pass);
try{
Statement st = con.createStatement();
ResultSet res = st.executeQuery("SELECT * FROM foldertree");
System.out.println("id " + "\t" + "parentId "+ "\t" +"name"+ "\t" +"depth"+ "\t" +"lineage");
while (res.next()) {
FolderTree node = new FolderTree();
node.setid(res.getInt("id"));
node.setparentId(res.getInt("parentId"));
node.setname(res.getString("name"));
node.setdepth(res.getInt("depth"));
node.setlineage(res.getString("lineage"));
tree.add(node);
}
con.close();
}
catch (SQLException s){
System.out.println("SQL code does not execute.");
}
}
catch (Exception e){
e.printStackTrace();
}
}
}
