package accessdbtest;

import java.awt.BorderLayout;
import java.awt.Dimension;

import javax.swing.JFrame;
import javax.swing.JPanel;
import   java.sql.*;
import   javax.swing.*;
import   javax.swing.tree.*;
import   java.awt.*;
import   java.awt.event.*;


/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Frame1 extends JFrame {

      public   static   Connection   getconnection()   throws   SQLException   {
          try{System.setProperty("jdbc.drivers",   "sun.jdbc.odbc.JdbcOdbcDriver");
              String url = "jdbc:odbc:SQLSERVER1;DatabaseName=WorkerTrack";
              return   DriverManager.getConnection(url,   "sa",   "111111");
                  }catch(SQLException ec)
                  {	 ec.printStackTrace();
                          System.exit(0);
                          return null;}
      }

      public   void   readtree()   {
          try   {
              conn   =   getconnection();
              stat   =   conn.createStatement();

              //setup   tree   model   root
              //root   =   new   DefaultMutableTreeNode("team");
              ResultSet   rs   =   stat.executeQuery("select   team   from   team");
              while   (rs.next())   {
                  DefaultMutableTreeNode   node   =   new   DefaultMutableTreeNode(rs.getString(1));
                  root.add(node);
              }
              rs.close();
              stat.close();
              conn.close();
          }
          catch   (Exception   ex)   {
              JOptionPane.showMessageDialog(this,   ex);
                          System.exit(0);
          }
      }

      private   Connection   conn;
      private   Statement   stat;
      private   DefaultMutableTreeNode   root   =   new   DefaultMutableTreeNode("team");
      private JTree   tree;
      private Container   contentpane  ;

    JPanel contentPane;
    BorderLayout borderLayout1 = new BorderLayout();
    public Frame1() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
        setTitle("viewdb");
         setSize(400,   300);

         readtree();
         tree   =   new   JTree(root);
         tree.setEditable(true);
         contentpane   =   getContentPane();
         contentpane.add(new   JScrollPane(tree),   BorderLayout.WEST);

         JButton   button   =   new   JButton();
         button.addActionListener(
                 new   ActionListener()   {
             public   void   actionPerformed(ActionEvent   event)   {
                 try   {
                     conn   =   getconnection();
                     stat   =   conn.createStatement();
                     //add   new
                    stat.executeUpdate("insert   into   team(team,leader)values('00219','china')");
                    stat.close();
                    conn.close();
                    root.removeAllChildren();
                    readtree();
                    DefaultTreeModel   model   =   (DefaultTreeModel)tree.getModel();
                    model.reload();
                 }
                 catch   (Exception   ex)   {
                     ex.printStackTrace();
                 }
             }
         }
         );
         JPanel   panel   =   new   JPanel();
         panel.add(button);
         contentpane.add(panel);

    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(borderLayout1);
        setSize(new Dimension(400, 300));
        setTitle("Frame Title");
    }


}