Dtree修改版（Ajax异步载入）

package com.service; import java.sql.*; public class TreeService { private Connection con; private PreparedStatement pstmt; private ResultSet rs; public void getConnection(){ try{ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); String url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=ssh"; con=DriverManager.getConnection(url,"sa","sa"); }catch(Exception se){ se.printStackTrace(); } } public String getNodesInfo(Integer pid){ String condition=null; if(pid==null) condition=" and parent_id is null"; else{ condition=" and parent_id="+pid; } String sql="select permission_id,permission_name,count(permission_id) as c from permission"+ " where 1=1 "+condition+" group by permission_id,permission_name"; StringBuffer temp=new StringBuffer(); try { getConnection(); pstmt=con.prepareStatement(sql); rs=pstmt.executeQuery(); while(rs.next()){ temp.append(rs.getInt("permission_id")+","+rs.getString("permission_name")+","+rs.getInt("c")+"|"); } System.out.println("the string value is:"+temp); } catch (SQLException e) { e.printStackTrace(); }finally{ try { rs.close(); pstmt.close(); con.close(); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } } return temp.toString(); } }