frame1.java~21~

数据库管理系统平台

package 教学系统;

import java.awt.*;
import java.awt.event.*;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JMenuBar;
import javax.swing.JMenu;
import javax.swing.JMenuItem;
import javax.swing.JTabbedPane;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.JButton;
import javax.swing.BorderFactory;
import javax.swing.border.EtchedBorder;
import javax.swing.border.Border;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JLabel;
import javax.swing.JTextField;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Connection;
import javax.swing.table.TableModel;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.ResultSetMetaData;
import javax.swing.table.DefaultTableModel;
import javax.swing.JOptionPane;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Frame1 extends JFrame {
    Connection connect;
    JPanel contentPane;
    DefaultTableModel defaultTableModel1=new DefaultTableModel();
    DefaultTableModel defaultTableModel2=new DefaultTableModel();
    JMenuBar jMenuBar1 = new JMenuBar();
    JMenu jMenuFile = new JMenu();
    JMenuItem jMenuFileExit = new JMenuItem();
    JMenu jMenuHelp = new JMenu();
    JMenuItem jMenuHelpAbout = new JMenuItem();
    JTabbedPane jTabbedPane1 = new JTabbedPane();
    XYLayout xYLayout1 = new XYLayout();
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    XYLayout xYLayout2 = new XYLayout();
    JPanel jPanel3 = new JPanel();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    GridLayout gridLayout1 = new GridLayout();
    JPanel jPanel4 = new JPanel();
    XYLayout xYLayout3 = new XYLayout();
    Border border1 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.cyan, new Color(165, 163, 151));
    Border border2 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.white, new Color(165, 163, 151));
    Border border3 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.cyan, new Color(165, 163, 151));
    JScrollPane jScrollPane1 = new JScrollPane();
    Border border4 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.white, new Color(165, 163, 151));
    JTable jTable1 = new JTable();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField4 = new JTextField();
    JPanel jPanel5 = new JPanel();
    XYLayout xYLayout4 = new XYLayout();
    GridLayout gridLayout2 = new GridLayout();
    JButton jButton5 = new JButton();
    JButton jButton6 = new JButton();
    JButton jButton7 = new JButton();
    JButton jButton8 = new JButton();
    JPanel jPanel6 = new JPanel();
    Border border5 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.cyan, new Color(165, 163, 151));
    JScrollPane jScrollPane2 = new JScrollPane();
    JTable jTable2 = new JTable();
    Border border7 = BorderFactory.createLineBorder(Color.cyan, 2);
    Border border6 = BorderFactory.createLineBorder(Color.cyan, 2);
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    XYLayout xYLayout5 = new XYLayout();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JTextField jTextField5 = new JTextField();
    JTextField jTextField6 = new JTextField();
    JTextField jTextField7 = new JTextField();
    JTextField jTextField8 = new JTextField();
    Border border8 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.cyan, new Color(165, 163, 151));
    JPanel jPanel7 = new JPanel();
    XYLayout xYLayout6 = new XYLayout();
    JPanel jPanel8 = new JPanel();
    Border border9 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.green, new Color(165, 163, 151));
    JPanel jPanel9 = new JPanel();
    Border border10 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.green, new Color(165, 163, 151));
    JPanel jPanel10 = new JPanel();
    XYLayout xYLayout7 = new XYLayout();
    XYLayout xYLayout8 = new XYLayout();
    JButton jButton9 = new JButton();
    JButton jButton10 = new JButton();
    GridLayout gridLayout3 = new GridLayout();
    JPanel jPanel11 = new JPanel();
    JButton jButton11 = new JButton();
    JButton jButton12 = new JButton();
    GridLayout gridLayout4 = new GridLayout();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    JLabel jLabel11 = new JLabel();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    JTextField jTextField9 = new JTextField();
    JTextField jTextField10 = new JTextField();
    JTextField jTextField11 = new JTextField();
    JTextField jTextField12 = new JTextField();
    JTextField jTextField13 = new JTextField();
    public Frame1() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(xYLayout1);
        setSize(new Dimension(600, 450));
        setTitle("教学系统");
        jMenuFile.setText("File");
        jMenuFileExit.setText("Exit");
        jMenuFileExit.addActionListener(new Frame1_jMenuFileExit_ActionAdapter(this));
        jMenuHelp.setText("Help");
        jMenuHelpAbout.setText("About");
        jMenuHelpAbout.addActionListener(new
                                         Frame1_jMenuHelpAbout_ActionAdapter(this));
        jPanel1.setLayout(xYLayout2);
        jPanel3.setBackground(new Color(203, 255, 255));
        jPanel3.setLayout(gridLayout1);
        jButton1.setBackground(new Color(215, 249, 241));
        jButton1.setText("查询");
        jButton1.addActionListener(new Frame1_jButton1_actionAdapter(this));
        jButton2.setText("插入");
        jButton2.addActionListener(new Frame1_jButton2_actionAdapter(this));
        jButton3.setText("删除");
        jButton3.addActionListener(new Frame1_jButton3_actionAdapter(this));
        jButton4.setText("清空");
        jButton4.addActionListener(new Frame1_jButton4_actionAdapter(this));
        jPanel4.setLayout(xYLayout3);
        jScrollPane1.setBorder(border6);
        jLabel1.setText("教   号");
        jLabel2.setText("姓   名");
        jLabel3.setText("性   别");
        jLabel4.setText("地   止");
        jTextField1.setText("");
        jTextField2.setText("");
        jTextField3.setText("");
        jTextField4.setText("");
        jPanel2.setLayout(xYLayout4);
        jPanel5.setLayout(gridLayout2);
        jButton5.setText("查询");
        jButton5.addActionListener(new Frame1_jButton5_actionAdapter(this));
        jButton6.setText("插入");
        jButton6.addActionListener(new Frame1_jButton6_actionAdapter(this));
        jButton7.setText("删除");
        jButton7.addActionListener(new Frame1_jButton7_actionAdapter(this));
        jButton8.setText("清空");
        jPanel6.setBorder(border5);
        jPanel6.setLayout(xYLayout5);
        jScrollPane2.setBorder(border7);
        jLabel5.setText("学   号");
        jLabel6.setText("姓   名");
        jLabel7.setText("性   别");
        jLabel8.setText("寝室号");
        jPanel4.setBorder(border8);
        jPanel7.setLayout(xYLayout6);
        jPanel8.setBorder(border9);
        jPanel8.setLayout(xYLayout7);
        jPanel9.setBorder(border10);
        jPanel9.setLayout(xYLayout8);
        jButton9.setText("插入");
        jButton10.setText("清空");
        jPanel10.setLayout(gridLayout3);
        jButton11.setText("插入");
        jButton12.setText("清空");
        jPanel11.setLayout(gridLayout4);
        jLabel9.setText("jLabel9");
        jLabel10.setText("jLabel10");
        jLabel11.setText("jLabel11");
        jLabel12.setText("jLabel12");
        jLabel13.setText("jLabel13");
        jTextField9.setText("jTextField9");
        jTextField10.setText("jTextField10");
        jTextField11.setText("jTextField11");
        jTextField12.setText("jTextField12");
        jTextField13.setText("jTextField13");
        jMenuBar1.add(jMenuFile);
        jMenuFile.add(jMenuFileExit);
        jMenuBar1.add(jMenuHelp);
        jMenuHelp.add(jMenuHelpAbout);
        contentPane.add(jTabbedPane1, new XYConstraints(0, 0, 600, 448));
        jPanel2.add(jPanel5, new XYConstraints(50, 18, 491, 41));
        jPanel3.add(jButton1, null);
        jPanel3.add(jButton2, null);
        jPanel3.add(jButton3, null);
        jPanel3.add(jButton4, null);
        jPanel1.add(jPanel3, new XYConstraints(44, 13, 471, 40));
        jPanel1.add(jPanel4, new XYConstraints(9, 61, 281, 354));
        jPanel4.add(jLabel1, new XYConstraints(7, 20, 52, 25));
        jPanel1.add(jScrollPane1, new XYConstraints(302, 60, 270, 356));
        jPanel4.add(jLabel2, new XYConstraints(7, 89, 52, 25));
        jPanel4.add(jLabel3, new XYConstraints(7, 174, 52, 25));
        jPanel4.add(jLabel4, new XYConstraints(7, 249, 52, 25));
        jPanel4.add(jTextField1, new XYConstraints(61, 16, 144, 29));
        jPanel4.add(jTextField2, new XYConstraints(61, 85, 144, 29));
        jPanel4.add(jTextField3, new XYConstraints(61, 170, 144, 29));
        jPanel4.add(jTextField4, new XYConstraints(61, 245, 144, 29));
        jPanel5.add(jButton5);
        jPanel5.add(jButton6);
        jPanel5.add(jButton7);
        jPanel5.add(jButton8);
        jPanel2.add(jPanel6, new XYConstraints(19, 86, 245, 321));
        jPanel2.add(jScrollPane2, new XYConstraints(307, 87, 236, 318));
        jScrollPane2.getViewport().add(jTable2);
        jScrollPane1.getViewport().add(jTable1);
        jPanel6.add(jLabel5, new XYConstraints(17, 20, 51, 26));
        jPanel6.add(jLabel6, new XYConstraints(17, 101, 51, 26));
        jPanel6.add(jLabel7, new XYConstraints(17, 178, 51, 26));
        jPanel6.add(jLabel8, new XYConstraints(17, 248, 51, 26));
        jPanel6.add(jTextField5, new XYConstraints(75, 14, 125, 32));
        jPanel6.add(jTextField6, new XYConstraints(75, 95, 125, 32));
        jPanel6.add(jTextField7, new XYConstraints(75, 172, 125, 32));
        jPanel6.add(jTextField8, new XYConstraints(75, 242, 125, 32));
        jTabbedPane1.add(jPanel1, "教师系统");
        jTabbedPane1.add(jPanel2, "学生系统");
        jTabbedPane1.add(jPanel7, "课程更新");
        jPanel7.add(jPanel8, new XYConstraints(15, 16, 282, 404));
        jPanel8.add(jPanel10, new XYConstraints(33, 10, 190, 35));
        jPanel10.add(jButton9);
        jPanel10.add(jButton10);
        jPanel7.add(jPanel9, new XYConstraints(299, 16, 282, 404));
        jPanel9.add(jPanel11, new XYConstraints(42, 12, 179, 35));
        jPanel11.add(jButton11, null);
        jPanel11.add(jButton12, null);
        jPanel9.add(jLabel12, new XYConstraints(32, 77, 65, 32));
        jPanel8.add(jLabel9, new XYConstraints(24, 84, 66, 27));
        jPanel8.add(jLabel11, new XYConstraints(24, 197, 66, 27));
        jPanel8.add(jTextField9, new XYConstraints(96, 87, 130, 29));
        jPanel8.add(jTextField10, new XYConstraints(96, 139, 130, 29));
        jPanel8.add(jTextField11, new XYConstraints(96, 195, 130, 29));
        jPanel8.add(jLabel10, new XYConstraints(24, 141, 66, 27));
        jPanel9.add(jLabel13, new XYConstraints(32, 127, 65, 32));
        jPanel9.add(jTextField12, new XYConstraints(98, 80, 135, 34));
        jPanel9.add(jTextField13, new XYConstraints(98, 126, 135, 34));
        setJMenuBar(jMenuBar1);
        try
        {
          String url="jdbc:odbc:wang";
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          connect=DriverManager.getConnection(url,"root","abc");
        }
        catch   (SQLException   sqlex)
         {
            System.err.println("unable   to   connect");
            sqlex.printStackTrace();
        }


    }

    /**
     * File | Exit action performed.
     *
     * @param actionEvent ActionEvent
     */
    void jMenuFileExit_actionPerformed(ActionEvent actionEvent) {
        System.exit(0);
    }

    /**
     * Help | About action performed.
     *
     * @param actionEvent ActionEvent
     */
    void jMenuHelpAbout_actionPerformed(ActionEvent actionEvent) {
        Frame1_AboutBox dlg = new Frame1_AboutBox(this);
        Dimension dlgSize = dlg.getPreferredSize();
        Dimension frmSize = getSize();
        Point loc = getLocation();
        dlg.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x,
                        (frmSize.height - dlgSize.height) / 2 + loc.y);
        dlg.setModal(true);
        dlg.pack();
        dlg.show();
    }

    void message(String t)
      {
          JOptionPane.showMessageDialog(null,t);
      }


    public void jButton1_actionPerformed(ActionEvent e) {
        try
        {
            Statement statement =connect.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,
                                    ResultSet.CONCUR_UPDATABLE);
             String query1="select * from teacher where tssn="+"'"+jTextField1.getText()+"'";
             String query2="select * from  tsubject where   tssn='"
                           +jTextField1.getText()+"'";
             ResultSet rs1 = statement.executeQuery( query1 );
             if(rs1.next())
             {
                     jTextField2.setText( rs1.getString( "tname" ) );
                     jTextField3.setText( rs1.getString( "sex" ) );
                     jTextField4.setText( rs1.getString( "adress" ) );

             }
             else
             {

                String find="查无此人";
                message(find);
             }
             statement=connect.createStatement();
             rs1=statement.executeQuery(query2);
             ResultSetMetaData rsmd1=rs1.getMetaData();
             defaultTableModel1.setColumnCount(0);
             defaultTableModel1.setRowCount(0);
             for(int i=1;i<=rsmd1.getColumnCount();i++)
              {
                    defaultTableModel1.addColumn(rsmd1.getColumnName(i));
              }
             int i=0;
             while(rs1.next())
               {