dree控件和JSP实例

package com.demo.struts.beans; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import com.demo.struts.form.MenuForm; public class DataBase { private Connection con; private Statement st; private ResultSet rs; //获得连结 public Connection getCon() { String classStr="com.microsoft.jdbc.sqlserver.SQLServerDriver"; String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; try { Class.forName(classStr); } catch (ClassNotFoundException e) { e.printStackTrace(); } try { con=DriverManager.getConnection(url,"sa","ddxkj"); } catch (SQLException e) { e.printStackTrace(); } return con; } public StringBuffer getMdTree() throws Exception{ if(con==null) con=this.getCon();//获得连结 String sql="select id,pid,name from menu order by recid"; st=con.createStatement(); rs=st.executeQuery(sql); StringBuffer str = new StringBuffer(100); str.append("new dTree('d');"); //if(rs.next()) while(rs.next()){ str.append("\n"); str.append("d.add('"); str.append(rs.getString("id")); str.append("','"); str.append(rs.getString("pid")); str.append("','"); str.append(rs.getString("name")); str.append("');"); } return str; } /*public StringBuffer getMdTree() throws Exception{ StringBuffer str = new StringBuffer(100); str.append("new dTree('d');"); ResultSet rs=this.getRS(); if(rs.next()) while(this.getRS().next()){ str.append("\n"); str.append("d.add('"); str.append(this.getRS().getString(1)); str.append("','"); str.append(this.getRS().getString(2)); str.append("','"); str.append(this.getRS().getString(3)); str.append("');"); } return str; }*/ }