tree.java

useing java to show a tree,like windows tr

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.tree.*;
import java.sql.*;
public class tree 
{
 void createtree()
 {   String url="jdbc:mysql://192.168.4.26:3306/school?user=root&password=123&useUnicode=true&characterEncoding=GB2312";
//jdbc:mysql://127.0.0.1:3306/test?user=root&password=123&useUnicode=true&characterEncoding=GB2312";
  //
  //conn=DriverManager.getConnection(url);
 // String userName="root";
 // String password="123";
  String sql=null;
  Connection conn=null;
  Statement stmt=null;

  JFrame f=new JFrame("tree");
  Container content=f.getContentPane();
        DefaultMutableTreeNode root=null;
        DefaultMutableTreeNode node1=null;
  DefaultMutableTreeNode node2=null;
  DefaultMutableTreeNode leafnode1=null;
        DefaultMutableTreeNode leafnode2=null;
       

  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }
  catch(ClassNotFoundException e){
   System.out.println(""+e);
  }
  try{
   conn=DriverManager.getConnection(url);
   stmt=conn.createStatement();
   sql="select * from class                         ";
   ResultSet rs=stmt.executeQuery(sql);
    /*ResultSetMetaData rsmd=rs.getMetaData();
   String name1=rsmd.getColumnName(1);//取得表中第一列字段的名称
   String name2=rsmd.getColumnName(2);//取得表中第二列字段的名称


   root=new DefaultMutableTreeNode("class");
   node1=new DefaultMutableTreeNode(name1);
   node2=new DefaultMutableTreeNode(name2);

            root.add(node1);
   root.add(node2);
  while(rs.next())
   {
   String a=rs.getString(1);
   String b=rs.getString(2);
   
   leafnode1=new DefaultMutableTreeNode(a);
   leafnode2=new DefaultMutableTreeNode(b);
   node1.add(leafnode1);
   node2.add(leafnode2);

   
}
*/
      rs.close();
   stmt.close();
}
catch(SQLException e){ System.out.println("出现SQLEXCEPTION异常"+e);}

   
JTree tree=new JTree(root);
         JScrollPane scrollpane=new JScrollPane();
         scrollpane.setViewportView(tree);
         content.add(scrollpane);
         f.pack();
         f.setVisible(true);
         f.addWindowListener(new WindowAdapter(){
      public void windowClosing(WindowEvent e)
      {System.exit(0);}
         });

 }

 public static void main(String args[])
 { new createtree();
 }
}