selectframe.java~13~

行业分类数据库管理系统

package blapp;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.tree.*;
import javax.swing.event.*;



public class selectframe extends JInternalFrame{
  public Statement stmt;
  JPanel contentPane;
  GridLayout gridLayout1 = new GridLayout();
  JSplitPane jSplitPane1 = new JSplitPane();
  DefaultMutableTreeNode root=new DefaultMutableTreeNode("行业分类");
 //DefaultTreeModel root =(DefaultTreeModel)jTree1.getModel();
 JTree jTree1 = new JTree(root);
 JScrollPane jScrollPane1 = new JScrollPane();
 JEditorPane jEditorPane1 = new JEditorPane();

  public selectframe(Statement st,Connection c,Frame1 fr,int w,int h) {
      enableEvents(AWTEvent.WINDOW_EVENT_MASK);
      stmt=st;
      try {
     jbInit();
   }
   catch(Exception e) {
     e.printStackTrace();
   }

  }

  void firstto(JTree jt)
  { String hyname,anliname;
    DefaultMutableTreeNode newnode,subnode;
    try
    {
        String query1="SELECT hyname,subname FROM neirong";
        ResultSet rst=stmt.executeQuery(query1);

       while(rst.next())
       { boolean finded=false;
         hyname=rst.getString("hyname").trim();
         anliname=rst.getString("subname").trim();
         if(root.getChildCount()==0)
         {
           newnode=new DefaultMutableTreeNode(hyname);
           root.add(newnode);
           newnode=new DefaultMutableTreeNode(anliname);
           root.getFirstLeaf().add(newnode);
         }
         else
         {  newnode=new DefaultMutableTreeNode(anliname);
           for(int i=1;i<=root.getChildCount();i++)
                  {
                    if(hyname.equals(String.valueOf(root.getChildAt(i-1))))
                      {
                        subnode=(DefaultMutableTreeNode)root.getChildAt(i-1);
                        subnode.add(newnode);
                        finded=true;
                      }
                  }
          if(finded==false)
            {
              newnode=new DefaultMutableTreeNode(hyname);
              root.add(newnode);
              newnode=new DefaultMutableTreeNode(anliname);
              root.getLastLeaf().add(newnode);
           }
         }
      }
    }
    catch(SQLException sqlex)
    {

    }
  }
  private void jbInit() throws Exception  {
    contentPane = (JPanel) this.getContentPane();
    contentPane.setLayout(gridLayout1);
    //contentPane.add(desktop);
    this.setSize(new Dimension(660, 404));
    this.setTitle("行业知识库管理系统");
    contentPane.setBackground(SystemColor.control);
    contentPane.setBorder(BorderFactory.createLoweredBevelBorder());

    gridLayout1.setRows(1);
    jSplitPane1.setOrientation(JSplitPane.HORIZONTAL_SPLIT);
    jSplitPane1.setBorder(BorderFactory.createEtchedBorder());
    jSplitPane1.setDebugGraphicsOptions(0);
    jSplitPane1.setPreferredSize(new Dimension(796, 30));
    jSplitPane1.setDividerSize(0);
    jSplitPane1.setOneTouchExpandable(false);
    jTree1.setBackground(Color.lightGray);
    jTree1.setFont(new java.awt.Font("Dialog", 0, 15));
    jTree1.setForeground(SystemColor.desktop);
    jTree1.setAutoscrolls(true);
    jTree1.addTreeSelectionListener(new selectframe_jTree1_treeSelectionAdapter(this));
    contentPane.add(jSplitPane1, null);
    //desktop.add(contentPane,null);
    jSplitPane1.add(jTree1, JSplitPane.LEFT);
    jSplitPane1.add(jScrollPane1, JSplitPane.RIGHT);
    jScrollPane1.getViewport().add(jEditorPane1, null);
    firstto(jTree1);
    jSplitPane1.setDividerLocation(200);
    //jTree1.setSelectionModel(root);
  }
  protected void processWindowEvent(WindowEvent e) {
     //super.processWindowEvent(e);
     if (e.getID() == WindowEvent.WINDOW_CLOSING) {

     }
   }
   void jTree1_valueChanged(TreeSelectionEvent e) {
     try
     {
       String query1= "SELECT subname,texts FROM neirong WHERE subname='"+jTree1.getSelectionPath().getLastPathComponent().toString()+"'";
       ResultSet rst=stmt.executeQuery(query1);
       while(rst.next())
       {//System.out.println(String.valueOf(rst.getString("texts")));
       jEditorPane1.setText(String.valueOf(rst.getString("texts")));

     }


     }
     catch(SQLException sqlex){
     }

   }

}

class selectframe_jTree1_treeSelectionAdapter implements javax.swing.event.TreeSelectionListener {
  selectframe adaptee;

  selectframe_jTree1_treeSelectionAdapter(selectframe adaptee) {
    this.adaptee = adaptee;
  }
  public void valueChanged(TreeSelectionEvent e) {
    adaptee.jTree1_valueChanged(e);
  }
}