easyui02 03（tree前后端）

实体类

public class Module {
    
    private Integer id;
    
    private Integer pid;
    
    private String text;
    
    private String icon;
    
    private String url;
    
    private int sort;
    
    private List<Module> children = new ArrayList<>();
 
    public Integer getId() {
        return id;
    }
 
    public void setId(Integer id) {
        this.id = id;
    }

  servlet:

@WebServlet("/moduleServlet")
public class ModuleServlet extends HttpServlet {
    
    private IModuleService service = new ModuleService();
    
    public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException {
        doPost(req, resp);
    }
    
    
    public void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
        
        req.setCharacterEncoding("utf-8");
        resp.setContentType("application/json; charset=utf-8");
        
        
        List<Module> list = service.listModel(-1);
        
        PrintWriter out = resp.getWriter();
        String str = JSON.toJSONString(list);
        
        out.write(str);
        out.flush();
        out.close();
    }
 
} 

数据访问层：

public class ModuleDao implements IModuleDao {
 
    @Override
    public List<Module> listModel(int pid) {
        List<Module> list = new ArrayList<>();
        Connection con = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            String sql = "select id,pid,text,icon,url,sort from t_module where pid=?";
            con = DBHelper.getsCon();
            ps = con.prepareStatement(sql);
            ps.setInt(1, pid);
            rs = ps.executeQuery();
            
            while(rs.next()) {
                Module m = new Module();
                m.setId(rs.getInt("id"));
                m.setPid(rs.getInt("pid"));
                m.setText(rs.getString("text"));
                m.setUrl(rs.getString("url"));
                m.setSort(rs.getInt("sort"));
                list.add(m);
            }
            
        } catch (Exception e) {
            
        } finally {
            DBHelper.Close(con, ps, rs);
        }
        
        return list;
    }
    
    public static void main(String[] args) {
        ModuleDao dao = new ModuleDao();
        List<Module> list = dao.listModel(21);
        list.forEach(t->System.out.println(t));
    }
 
} 

建包