Struts2+jQury+Ajax+ztree

package com.lee.crud2.DAO; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.*; import com.lee.crud2.vo.ZtreePO; import net.sf.json.JSONArray; import net.sf.json.JSONObject; public class TreeNodeDAO { public List<ZtreePO> getMakeNodes(){ List<Map<String,Object>> list = new ArrayList<Map<String,Object>>(); List<ZtreePO> listPO = new ArrayList<ZtreePO>(); Map<String,Object> subitem = new HashMap<String,Object>(); Connection conn = null; Statement stmt = null; ResultSet rs = null; String address = "jdbc:oracle:thin:@localhost:1521:orcl"; String user = "lee"; String password = "lee"; String sql = ""; ZtreePO poroot = new ZtreePO(); poroot.setId("999"); poroot.setPid("0"); poroot.setName("根"); listPO.add(poroot); ZtreePO po1 = new ZtreePO(); po1.setId("1"); po1.setPid("999"); po1.setName("采矿业"); listPO.add(po1); ZtreePO po2 = new ZtreePO(); po2.setId("2"); po2.setPid("999"); po2.setName("金融业"); listPO.add(po2); ZtreePO po3 = new ZtreePO(); po3.setId("11"); po3.setPid("1"); po3.setName("开采辅助活动"); listPO.add(po3); return listPO; } public List<ZtreePO> getTreeAllNodes(){ List<Map<String,Object>> list = new ArrayList<Map<String,Object>>(); List<ZtreePO> listPO = new ArrayList<ZtreePO>(); Map<String,Object> subitem = new HashMap<String,Object>(); Connection conn = null; Statement stmt = null; ResultSet rs = null; String address = "jdbc:oracle:thin:@localhost:1521:orcl"; String user = "lee"; String password = "lee"; String sql = ""; try { Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection(address, user, password); stmt = conn.createStatement(); sql = "select distinct hyml_dm , hyml_mc from HYMXK_MX_HY t"; rs = stmt.executeQuery(sql); ZtreePO poroot = new ZtreePO(); poroot.setId("999"); poroot.setPid("0"); poroot.setName("所有行业"); poroot.setOpen(true); listPO.add(poroot); while(rs.next()){ ZtreePO po = new ZtreePO(); po.setId(rs.getString("hyml_dm")); po.setPid("999"); po.setName(rs.getString("hyml_mc")); po.setOpen(false); listPO.add(po); } sql = "select distinct hydl_dm , hydl_mc, hyml_dm from HYMXK_MX_HY t"; rs = stmt.executeQuery(sql); while(rs.next()){ ZtreePO po = new ZtreePO(); po.setId(rs.getString("hydl_dm")); po.setPid(rs.getString("hyml_dm")); po.setName(rs.getString("hydl_mc")); listPO.add(po); } sql = "select distinct hyxl_dm , hyxl_mc, hydl_dm from HYMXK_MX_HY t"; rs = stmt.executeQuery(sql); while(rs.next()){ ZtreePO po = new ZtreePO(); po.setId(rs.getString("hyxl_dm")); po.setPid(rs.getString("hydl_dm")); po.setName(rs.getString("hyxl_mc")); listPO.add(po); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); }finally{ try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return listPO; } /* public List<ZtreePO> getTreeNodes(String hydm, String hymc){ List<Map<String,Object>> list = new ArrayList<Map<String,Object>>(); List<ZtreePO> listPO = new ArrayList<ZtreePO>(); Map<String,Object> subitem = new HashMap<String,Object>(); Connection conn = null; Statement stmt = null; ResultSet rs = null; String address = "jdbc:oracle:thin:@localhost:1521:orcl"; String user = "lee"; String password = "lee"; String sql = ""; try { Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection(address, user, password); //sql = "select distinct hyml_dm,hyml_mc from HYMXK_MX_HY t"; sql = "select distinct " + hydm + " hydm, " + hymc + " hymc from HYMXK_MX_HY t"; //System.out.println("sql:"+sql); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); while(rs.next()){ ZtreePO po = new ZtreePO(); po.setId(rs.getString("hydm")); po.setName(rs.getString("hymc")); po.setPid("0"); //po.setHasChild(false); listPO.add(po); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); }finally{ try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return listPO; }*/ /*public JSONArray getTreeNodesByJson(String hydm, String hymc){ Connection conn = null; Statement stmt = null; ResultSet rs = null; JSONArray jsonArray = new JSONArray(); String address = "jdbc:oracle:thin:@localhost:1521:orcl"; String user = "lee"; String password = "lee"; String sql = ""; try { Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection(address, user, password); //sql = "select distinct hyml_dm,hyml_mc from HYMXK_MX_HY t"; sql = "select distinct " + hydm + ", " + hymc + " from HYMXK_MX_HY t"; //System.out.println("sql:"+sql); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); while(rs.next()){ JSONObject j = new JSONObject(); j.put("id", rs.getString(hydm)); j.put("name", rs.getString(hymc)); jsonArray.add(j); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); }finally{ try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return jsonArray; }*/ public static void main(String[] args) { TreeNodeDAO t = new TreeNodeDAO(); String hydm = "hydl_dm"; String hymc = "hydl_mc"; //t.getTreeNodes(hydm,hymc); } }