java dtree_dtree实现动态加载树形菜单，动态插入树形菜单

packagecom.dtree.test;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.ArrayList;importjava.util.List;public classOrganizationService {privateConnection conn;privatePreparedStatement titleQuery;privateResultSet results;publicList getOrganization(){

List list= newArrayList();try{

conn=ConnectionManager.getConnection();

String sql="select * from treetest";

titleQuery=conn.prepareStatement(sql);

results=titleQuery.executeQuery();while(results.next()){

Organization org1= newOrganization();

org1.setId(results.getInt("id"));

org1.setParentId(results.getInt("parentId"));

org1.setName(results.getString("name"));

list.add(org1);

}

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}finally{

ConnectionManager.closeResultSet(results);

ConnectionManager.closeStatement(titleQuery);

ConnectionManager.closeConnection(conn);

}returnlist;

}public intinsertUser1(String name) {int num=0;try{

conn=ConnectionManager.getConnection();

String sql="insert into treetest (parentId,name,pid)values(0,?,1)";

titleQuery=conn.prepareStatement(sql);

titleQuery.setString(1,name);

num=titleQuery.executeUpdate();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}finally{

ConnectionManager.closeResultSet(results);

ConnectionManager.closeStatement(titleQuery);

ConnectionManager.closeConnection(conn);

}returnnum;

}public int insertUser2(intparentId,String name) {int num=0;try{

conn=ConnectionManager.getConnection();

String sql="insert into treetest (parentId,name,pid)values(?,?,2)";

titleQuery=conn.prepareStatement(sql);

titleQuery.setInt(1,parentId);

titleQuery.setString(2,name);

num=titleQuery.executeUpdate();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}finally{

ConnectionManager.closeResultSet(results);

ConnectionManager.closeStatement(titleQuery);

ConnectionManager.closeConnection(conn);

}returnnum;

}publicList getOrganization1(){

List list= newArrayList();try{

conn=ConnectionManager.getConnection();

String sql="select * from treetest where pid=1";

titleQuery=conn.prepareStatement(sql);

results=titleQuery.executeQuery();while(results.next()){

Organization org1= newOrganization();

org1.setId(results.getInt("id"));

org1.setParentId(results.getInt("parentId"));

org1.setName(results.getString("name"));

list.add(org1);

}

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}finally{ ConnectionManager.closeResultSet(results);

ConnectionManager.closeStatement(titleQuery);

ConnectionManager.closeConnection(conn);

}returnlist;

}

}