frame2.java

java开发的一个基于mysql的小数据库系统

package 桀骜学管理系统;

import java.awt.Dimension;
import java.sql.*;
import javax.swing.JFrame;
import javax.swing.JPanel;
import java.awt.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.table.*;
import javax.swing.JRadioButton;
import javax.swing.JButton;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.*;
import javax.swing.JScrollPane;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import javax.swing.JTable;

public class Frame2 extends JFrame
{
    private Connection connect;
    String url;
    private DefaultTableModel defaultTableModel1=new DefaultTableModel();
    JPanel contentPane;
    XYLayout xYLayout1 = new XYLayout();
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    JPanel jPanel3 = new JPanel();
    JPanel jPanel4 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField4 = new JTextField();
    JTextField jTextField5 = new JTextField();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JTextField jTextField6 = new JTextField();
    JRadioButton jRadioButton1 = new JRadioButton();
    JRadioButton jRadioButton2 = new JRadioButton();
    JLabel jLabel9 = new JLabel();
    XYLayout xYLayout4 = new XYLayout();
    JTextField jTextField7 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    Database database1 = new Database();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    QueryDataSet queryDataSet2 = new QueryDataSet();
    XYLayout xYLayout2 = new XYLayout();
    JScrollPane jScrollPane1 = new JScrollPane();
    QueryDataSet queryDataSet3 = new QueryDataSet();
    QueryDataSet queryDataSet4 = new QueryDataSet();
    QueryDataSet queryDataSet5 = new QueryDataSet();
    JButton jButton5 = new JButton();
    JTable jTable1 = new JTable();
    XYLayout xYLayout3 = new XYLayout();
    public Frame2() {
        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, 400));
        setTitle("学生查询");
        jLabel1.setText("姓   名:");
        jPanel1.setLayout(xYLayout3);
        jLabel2.setText("学   号:");
        jLabel3.setText("年   级:");
        jLabel4.setText("班   级:");
        jLabel5.setText("班主任:");
        jLabel6.setText("生   日:");
        jPanel2.setLayout(xYLayout2);
        jLabel8.setText("课程信息:");
        jLabel7.setText("性   别:");
        jRadioButton1.setSelected(true);
        jRadioButton1.setText("男");
        jRadioButton1.addActionListener(new Frame2_jRadioButton1_actionAdapter(this));
        jRadioButton2.setText("女");
        jRadioButton2.addActionListener(new Frame2_jRadioButton2_actionAdapter(this));
        jLabel9.setText("地   址:");
        jPanel3.setLayout(xYLayout4);
        jButton1.setText("插入");
        jButton1.addActionListener(new Frame2_jButton1_actionAdapter(this));
        jButton2.setText("查找");
        jButton2.addActionListener(new Frame2_jButton2_actionAdapter(this));
        jButton3.setText("删除");
        jButton3.addActionListener(new Frame2_jButton3_actionAdapter(this));
        jButton4.setText("修改");
        jButton4.addActionListener(new Frame2_jButton4_actionAdapter(this));
        database1.setConnection(new ConnectionDescriptor("jdbc:odbc:task",
                "root", "abc", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
        try
      {
          url="jdbc:odbc:task";
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          connect=DriverManager.getConnection(url,"root","abc");
      }

      catch   (SQLException   sqlex)
      {
                  System.err.println("unable   to   connect");
                 sqlex.printStackTrace();
       }

        queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1, "select * from sclass", null, true, Load.ALL));
        queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1, "select * from gclass", null, true, Load.ALL));
        queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1, "select * from steacher", null, true, Load.ALL));
        queryDataSet5.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1, "select * from sgc", null, true, Load.ALL));
        jButton5.setText("清空");
        jButton5.addActionListener(new Frame2_jButton5_actionAdapter(this));
        contentPane.add(jPanel2, new XYConstraints(274, 1, 321, 232));
        contentPane.add(jPanel1, new XYConstraints(7, 2, 266, 233));
        contentPane.add(jPanel3, new XYConstraints(5, 243, 587, 61));
        jPanel3.add(jLabel9, new XYConstraints(14, 20, -1, -1));
        contentPane.add(jPanel4, new XYConstraints(4, 308, 589, 90));
        jPanel4.add(jButton1);
        jPanel4.add(jButton2);
        jPanel4.add(jButton5);
        jPanel4.add(jButton4);
        jPanel4.add(jButton3);
        jPanel3.add(jTextField7, new XYConstraints(56, 16, 503, 28));
        jPanel2.add(jTextField6, new XYConstraints(83, 36, 168, 28));
        jPanel2.add(jScrollPane1, new XYConstraints(84, 110, 170, 103));
        jScrollPane1.getViewport().add(jTable1);
        jPanel2.add(jRadioButton2, new XYConstraints(170, 75, 98, 28));
        jPanel2.add(jRadioButton1, new XYConstraints(89, 75, 70, 28));
        jPanel1.add(jTextField5, new XYConstraints(48, 169, 160, 27));
        jPanel1.add(jTextField2, new XYConstraints(48, 65, 160, 27));
        jPanel1.add(jTextField1, new XYConstraints(48, 27, 160, 27));
        jPanel1.add(jLabel1, new XYConstraints(8, 27, 38, 26));
        jPanel1.add(jLabel2, new XYConstraints(8, 60, 38, 26));
        jPanel1.add(jLabel3, new XYConstraints(8, 92, 38, 26));
        jPanel1.add(jLabel4, new XYConstraints(8, 131, 40, 26));
        jPanel1.add(jLabel5, new XYConstraints(8, 170, 39, 26));
        jPanel1.add(jTextField3, new XYConstraints(48, 100, 160, 27));
        jPanel1.add(jTextField4, new XYConstraints(48, 134, 160, 27));
        jPanel2.add(jLabel6, new XYConstraints(32, 38, 52, 23));
        jPanel2.add(jLabel8, new XYConstraints(32, 104, 48, 23));
        jPanel2.add(jLabel7, new XYConstraints(32, 74, 42, 23));
    }

    public void jButton2_actionPerformed(ActionEvent e)
    {
         try
          {
             Statement statement =connect.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,
                             ResultSet.CONCUR_UPDATABLE);
             String query1="select * from student where SN="+"'"+jTextField2.getText()+"'";
             String query2="select * from gclass where SN ='"+
                    jTextField2.getText()+"'";
             String query3="select ClassTeacher from sgc where Grade in( select Grade from student where SN='"
                    +jTextField2.getText()+"' ) "+" and "+"banji in (select banji from student where SN='"+
                    jTextField2.getText()+"')";
             ResultSet rs1 = statement.executeQuery( query1 );
             if(rs1.next())
              {
              jTextField1.setText( rs1.getString( "Sname" ) );
              jTextField3.setText( rs1.getString( "Grade" ) );
              jTextField4.setText( rs1.getString( "banji" ) );
              jTextField6.setText( rs1.getString( "sbirthday" ) );
              jTextField7.setText( rs1.getString( "Saddress" ) );
              String a=rs1.getString("Ssex");
              if( a.equalsIgnoreCase("女"))
              {
                 jRadioButton1.setSelected(false);
                 jRadioButton2.setSelected(true);
              }
              else
              {
                  jRadioButton1.setSelected(true);
                 jRadioButton2.setSelected(false);}
             }
            else
           {
              String find="查无此人";
              message(find);
           }
             rs1 = statement.executeQuery( query3 );
            if(rs1.next())
              jTextField5.setText(rs1.getString("ClassTeacher"));
            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())
           {
              defaultTableModel1.setNumRows(i+1);
              for (int j=0;j<rsmd1.getColumnCount();j++)
                  {
                      defaultTableModel1.setValueAt(rs1.getString(j+1),i,j);
                  }
              i++;
          }
             rs1.close();
             jTable1.setModel((TableModel)defaultTableModel1);
             statement.close();
         }
        catch(Exception sqlex)
           {
           System.out.println("unable run ***");
            sqlex.printStackTrace();
          }

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

    public void jButton5_actionPerformed(ActionEvent e) {
        jTextField1.setText("");
        jTextField2.setText("");
        jTextField3.setText("");
        jTextField4.setText("");
        jTextField5.setText("");
        jTextField6.setText("");
        jTextField7.setText("");
        jRadioButton1.setSelected(true);
        jRadioButton2.setSelected(false);
        defaultTableModel1.setRowCount(0);

    }

    public void jButton1_actionPerformed(ActionEvent e) {
        try{
            boolean test=true;
            String kong1="";
        Statement statement = connect.createStatement(ResultSet.
                TYPE_SCROLL_INSENSITIVE,
                ResultSet.CONCUR_UPDATABLE);
        ////////////////////