cha3frame1.java

Java学生管理系统学生及成绩记录的查询删除修改

package student;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JPanel;
import java.awt.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.JTableHeader;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.table.DefaultTableModel;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class cha3Frame1 extends JFrame {
    public cha3Frame1() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        ButtonGroup s=new ButtonGroup();
        jPanel1.setBackground(Color.pink);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(27, 17, 528, 34));
        jPanel1.setLayout(null);
        jsj.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jsj.setText("计算机专业");
        jsj.addActionListener(new cha3Frame1_jsj_actionAdapter(this));
        jTable1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        yy.addActionListener(new cha3Frame1_yy_actionAdapter(this));
        ty.addActionListener(new cha3Frame1_ty_actionAdapter(this));
        jButton1.setBounds(new Rectangle(40, 252, 82, 32));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jButton1.setText("统计");
        jButton1.addActionListener(new cha3Frame1_jButton1_actionAdapter(this));
        ren.setEnabled(false);
        ren.setBounds(new Rectangle(136, 252, 89, 32));
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel1.setText("人");
        jLabel1.setBounds(new Rectangle(227, 254, 45, 27));
        this.getContentPane().setBackground(Color.pink);
        jLabel2.setBounds(new Rectangle(1, 0, 604, 331));
        jLabel3.setBounds(new Rectangle( -1, 0, 524, 33));
        s.add(jsj);
        s.add(yy);
        s.add(ty);
        jsj.setBounds(new Rectangle(5, 5, 91, 25));
        ty.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        yy.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jTable1.setBounds(new Rectangle(26, 73, 529, 165));
        jTableHeader2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jTableHeader2.setBounds(new Rectangle(28, 49, 533, 21));
        this.getContentPane().add(jPanel1);
        this.getContentPane().add(jTableHeader2);
        this.getContentPane().add(jTable1);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(ren);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jLabel2);
        yy.setText("英语专业");
        yy.setBounds(new Rectangle(202, 2, 91, 25));
        jPanel1.add(jsj);
        jPanel1.add(ty);
        jPanel1.add(yy);
        jPanel1.add(jLabel3);
        ty.setBounds(new Rectangle(368, 1, 91, 25));
        ty.setText("体育专业");
        jLabel2.setIcon(new ImageIcon("11.jpg"));
        jLabel3.setIcon(new ImageIcon("11.jpg"));
    }

    JPanel jPanel1 = new JPanel();
    JRadioButton ty = new JRadioButton();
    JRadioButton yy = new JRadioButton();
    JRadioButton jsj = new JRadioButton();
    Object hang[][]={
                    {" "," "," "," ","  "," "},
    };
    String [] head={"姓 名","性 别","家庭住址","联系电话","入学时间","籍 贯"};
    JTable jTable1 = new JTable(hang,head);
    JTableHeader jTableHeader1=jTable1.getTableHeader();
    JTableHeader jTableHeader2 = jTable1.getTableHeader();
    JButton jButton1 = new JButton();
    JTextField ren = new JTextField();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    public void jsj_actionPerformed(ActionEvent e) {
        try{
           Connectionsql c=new Connectionsql();
           Connection con=c.getConnection();
           Statement pstmt=con.createStatement();
           String sql="select * from student where zhuanye='"+"计算机"+"'";
           ResultSet rs=pstmt.executeQuery(sql);
           DefaultTableModel model1 = new DefaultTableModel();
           model1.setColumnIdentifiers(head);
           while(rs.next()){
               model1.addRow(new Object[]
                             {rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(8),rs.getString(9)}
                       );

           }
           jTable1.setModel(model1);
        }catch(Exception cc){
            cc.getMessage();
        }
    }

    public void yy_actionPerformed(ActionEvent e) {
        try{
              Connectionsql c=new Connectionsql();
              Connection con=c.getConnection();
              Statement pstmt=con.createStatement();
              String sql="select * from student where zhuanye='"+"英语"+"'";
              ResultSet rs=pstmt.executeQuery(sql);
              DefaultTableModel model1 = new DefaultTableModel();
              model1.setColumnIdentifiers(head);
              while(rs.next()){
                  model1.addRow(new Object[]
                                {rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(8),rs.getString(9)}
                          );

              }
              jTable1.setModel(model1);
           }catch(Exception cc){
               cc.getMessage();
           }

    }

    public void ty_actionPerformed(ActionEvent e) {
        try{
                   Connectionsql c=new Connectionsql();
                   Connection con=c.getConnection();
                   Statement pstmt=con.createStatement();
                   String sql="select * from student where zhuanye='"+"体育"+"'";
                   ResultSet rs=pstmt.executeQuery(sql);
                   DefaultTableModel model1 = new DefaultTableModel();
                   model1.setColumnIdentifiers(head);
                   while(rs.next()){
                       model1.addRow(new Object[]
                                     {rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(8),rs.getString(9)}
                               );

                   }
                   jTable1.setModel(model1);
                }catch(Exception cc){
                    cc.getMessage();
                }

    }

    public void jButton1_actionPerformed(ActionEvent e) {
       try{
                   Connectionsql c=new Connectionsql();
                   Connection con=c.getConnection();
                   Statement pstmt=con.createStatement();
                   String sql="select count(*) from student where zhuanye='"+"体育"+"'";
                   ResultSet rs=pstmt.executeQuery(sql);
                   while(rs.next()){
                       Integer x=new Integer(rs.getInt(1));
                       ren.setText( x.toString());
                   }
                  }catch(Exception cc){
                    cc.getMessage();
                }

}


class cha3Frame1_jButton1_actionAdapter implements ActionListener {
    private cha3Frame1 adaptee;
    cha3Frame1_jButton1_actionAdapter(cha3Frame1 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}


class cha3Frame1_ty_actionAdapter implements ActionListener {
    private cha3Frame1 adaptee;
    cha3Frame1_ty_actionAdapter(cha3Frame1 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.ty_actionPerformed(e);
    }
}


class cha3Frame1_yy_actionAdapter implements ActionListener {
    private cha3Frame1 adaptee;
    cha3Frame1_yy_actionAdapter(cha3Frame1 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.yy_actionPerformed(e);
    }
}


class cha3Frame1_jsj_actionAdapter implements ActionListener {
    private cha3Frame1 adaptee;
    cha3Frame1_jsj_actionAdapter(cha3Frame1 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jsj_actionPerformed(e);
    }
}
}