cha1frame1.java

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

package student;

import java.awt.BorderLayout;

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

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class cha1Frame1 extends JFrame {
    JPanel jPanel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JComboBox xh = new JComboBox();
    JButton jButton1 = new JButton();
    Connectionsql s=new Connectionsql();
    String XH;
    Object [][] cells={
                       {" "," "," "," "," "," "},
    };
    String tableheader[] = {"姓名", "性别", "家庭住址","联系电话","专业名称","出生日期"};
    JTable xx = new JTable(cells,tableheader);
    JTableHeader jTableHeader1 = xx.getTableHeader();
    javax.swing.JButton jButton2 = new JButton();
    javax.swing.JButton jButton3 = new JButton();
    javax.swing.JLabel tp = new JLabel();
    javax.swing.JTextArea bz = new JTextArea();
    javax.swing.JButton QK = new JButton();
    javax.swing.JLabel jLabel2 = new JLabel();
    javax.swing.JLabel jLabel3 = new JLabel();
    javax.swing.JLabel jLabel4 = new JLabel();
    public cha1Frame1() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jPanel1.setBackground(Color.pink);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(22, 16, 503, 309));
        jPanel1.setLayout(null);
        xh.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        xh.setBounds(new Rectangle(112, 11, 80, 23));
        jButton1.setBounds(new Rectangle(226, 10, 79, 28));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton1.setText("查询");
        jButton1.addActionListener(new cha1Frame1_jButton1_actionAdapter(this));
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        xx.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        xx.setBounds(new Rectangle( -2, 75, 504, 46));
        jTableHeader1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jTableHeader1.setBounds(new Rectangle(0, 48, 503, 27));
        jButton2.setBounds(new Rectangle(317, 10, 79, 28));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton2.setText("显示");
        jButton2.addActionListener(new cha1Frame1_jButton2_actionAdapter(this));
        jButton3.setBounds(new Rectangle(403, 9, 79, 28));
        jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton3.setText("离开");
        jButton3.addActionListener(new cha1Frame1_jButton3_actionAdapter(this));
        tp.setBackground(Color.white);
        tp.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        tp.setBorder(BorderFactory.createEtchedBorder());
        tp.setBounds(new Rectangle(15, 163, 179, 133));
        bz.setBorder(BorderFactory.createEtchedBorder());
        bz.setEditable(false);
        bz.setLineWrap(true);
        bz.setBounds(new Rectangle(233, 162, 257, 133));
        QK.setBounds(new Rectangle(19, 128, 87, 28));
        QK.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        QK.setText("刷新");
        QK.addActionListener(new cha1Frame1_jQK_actionAdapter(this));
        this.setForeground(Color.pink);
        jLabel2.setBounds(new Rectangle(4, 2, 558, 363));
        jLabel3.setBounds(new Rectangle(2, 120, 502, 188));
        jLabel4.setBounds(new Rectangle(0, 0, 502, 51));
        jPanel1.add(jLabel1);
        jPanel1.add(xh);
        jPanel1.add(jButton1);
        jPanel1.add(xx);
        jPanel1.add(jButton2);
        jPanel1.add(jButton3);
        jPanel1.add(tp);
        jPanel1.add(bz);
        jPanel1.add(jTableHeader1);
        jPanel1.add(QK);
        jPanel1.add(jLabel3);
        jPanel1.add(jLabel4);
        this.getContentPane().add(jPanel1, null);
        this.getContentPane().add(jLabel2);
        jLabel1.setText("按学号查询");
        jLabel1.setBounds(new Rectangle(5, 14, 98, 27));
        jLabel2.setIcon(new ImageIcon("11.jpg"));
        jLabel3.setIcon(new ImageIcon("11.jpg"));
        jLabel4.setIcon(new ImageIcon("11.jpg"));
        try{
            Connectionsql c=new Connectionsql();
            Connection con=c.getConnection();
            Statement pstmt=con.createStatement();
            String sql="select num from student ";
            ResultSet rs=pstmt.executeQuery(sql);
            while (rs.next()){
             xh.addItem(rs.getString(1));
            }

        }catch(Exception xx){
            xx.printStackTrace();
        }
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        try{
                  String XH;
                  XH=xh.getSelectedItem().toString();
                   Connectionsql s=new Connectionsql();
                   Connection con=s.getConnection();
                   Statement pstmt=con.createStatement();
                   String sql="select * from student where num='"+XH+"'";
                   ResultSet rs=pstmt.executeQuery(sql);
                   String tableheader[] = {"姓名", "性别", "家庭住址","联系电话","出生日期","祖籍"};
                   DefaultTableModel model1 = new DefaultTableModel();
                   model1.setColumnIdentifiers(tableheader);
                   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)});
                   }
                   xx.setModel(model1);
                   rs.close();
                   pstmt.close();

               }catch(Exception ce){
                   ce.printStackTrace();
        }
    }

    public void jButton2_actionPerformed(ActionEvent e) {
       String XH=(String)xh.getSelectedItem();
        try{
              Connectionsql c=new Connectionsql();
              Connection con=c.getConnection();
              Statement pstmt=con.createStatement();
              String sql="select * from student where num='"+XH+"'";
              ResultSet rs=pstmt.executeQuery(sql);
            if(!rs.next()){
                JOptionPane.showMessageDialog(null, "无此用户！");
            }else{
                bz.setText(rs.getString(11));
                if(rs.getString(12)!=null){
                    tp.setText("");
                    tp.setIcon(new ImageIcon(rs.getString(12)));
                }
                else{
                    tp.setText("暂时无此学生照片");
                    tp.setIcon(new ImageIcon(""));
                }
            }
             }catch(Exception xm){
              xm.printStackTrace();
          }
           }

    public void jButton3_actionPerformed(ActionEvent e) {
   this.dispose();
    }

    public void jQK_actionPerformed(ActionEvent e) {
    tp.setText("");
    bz.setText("");
    xx.removeAll();
    }
}


class cha1Frame1_jQK_actionAdapter implements ActionListener {
    private cha1Frame1 adaptee;
    cha1Frame1_jQK_actionAdapter(cha1Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class cha1Frame1_jButton3_actionAdapter implements ActionListener {
    private cha1Frame1 adaptee;
    cha1Frame1_jButton3_actionAdapter(cha1Frame1 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton3_actionPerformed(e);
    }
}


class cha1Frame1_jButton2_actionAdapter implements ActionListener {
    private cha1Frame1 adaptee;
    cha1Frame1_jButton2_actionAdapter(cha1Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class cha1Frame1_jButton1_actionAdapter implements ActionListener {
    private cha1Frame1 adaptee;
    cha1Frame1_jButton1_actionAdapter(cha1Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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