jsp 基于dtree 从数据库中进行动态生成树(radio)

来源:互联网 发布:万方数据库客户端 编辑:程序博客网 时间:2024/06/03 20:04

大家可以从网上下载  dtree.js和dtree.css,网上很好找的

jsp页面

 

<%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8" import="java.sql.*"%>    <%@page import="DB.DbDao" %><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html xmlns="http://www.w3.org/1999/xhtml"> <head>  <title> new document </title>    <link rel="StyleSheet" href="css/dtree.css" type="text/css" />    <script type="text/javascript" src="js/jquery-1.9.1.min.js"></script> <script type="text/javascript" src="js/dtree.js"></script> <script type="text/javascript"> <!--     $(function(){            d = new dTree('d');            d.add(0,-1,"学科分类");           //d.config.inOrder = true;            $.ajax({    url:'treeServlet',    type:'post', //数据发送方式    dataType:'xml', //接受数据格式    error:function(json){             alert( "not lived!");       },    async: false ,//同步方式    success: function(xml){         $(xml).find("node").each(function(){        var nodeId=$(this).attr("nodeId");          var parentId=$(this).attr("parentId");         var nodeName=$(this).text();        d.add(nodeId,parentId,"<input type='radio' name='where' value='2' id='t100001'>"+nodeName);                        });           }     });                  window.d=d;       $("#tree").html(d.toString());      $("input[type='checkbox']").click(function(){              var pId=this.id;             $("input[id*='"+pId+"']").attr("checked",this.checked);       });  });    //--> </script> </head> <body>  <div id="tree"></div> </body></html>


TreeServlet

 */protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {// TODO Auto-generated method stub        request.setCharacterEncoding("utf-8");                  response.setContentType("text/xml;charset=utf-8");                  PrintWriter out = response.getWriter();                  DbDao aDao=new DbDao();               System.out.print("dsdsds");               ResultSet resultSet=aDao.executeQuery("select * from T_XKFL");              if(resultSet != null){                      out.println("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");                      out.println("<nodes>");                  try    {while(resultSet.next()){               out.println("<node nodeId='"+resultSet.getString(1)+"' parentId='"+resultSet.getString(3)+"'>"+resultSet.getString(2)+"</node>");          }    } catch (SQLException e)    {// TODO Auto-generated catch blocke.printStackTrace();    }                  try    {resultSet.close();    } catch (SQLException e)    {// TODO Auto-generated catch blocke.printStackTrace();    }               aDao.CloseDB();                  out.println("</nodes>");                 }               }


 

 

0 0