cha2frame1.java~46~

Student management system

package student;

import java.awt.BorderLayout;

import javax.swing.*;
import javax.swing.JTextField;
import java.awt.*;
import javax.swing.JLabel;
import javax.swing.JButton;
import javax.swing.JTable;
import javax.swing.JTextArea;
import javax.swing.table.JTableHeader;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Statement;
import java.sql.*;
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 cha2Frame1 extends JFrame {
    public cha2Frame1() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        Connectionsql s=new Connectionsql();
        getContentPane().setLayout(null);
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jLabel1.setText("请输入姓名");
        jLabel1.setBounds(new Rectangle(16, 23, 91, 27));
        jButton2.setBounds(new Rectangle(316, 20, 70, 30));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton2.setText("查询");
        jButton2.addActionListener(new cha2Frame1_jButton2_actionAdapter(this));
        jTableHeader1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jTableHeader1.setBounds(new Rectangle( -5, 59, 399, 20));
        xm.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jTable1.setEnabled(false);
        jTable1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton1.setBounds(new Rectangle(238, 21, 71, 31));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton1.setText("奖惩");
        jButton1.addActionListener(new cha2Frame1_jButton1_actionAdapter(this));
        jPanel1.setBackground(Color.pink);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle( -2, 231, 402, 66));
        jPanel1.setLayout(null);
        jc.setBackground(Color.white);
        jc.setEnabled(true);
        jc.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jc.setForeground(Color.black);
        jc.setCaretColor(Color.pink);
        jc.setDisabledTextColor(Color.white);
        jc.setBounds(new Rectangle(165, 13, 210, 40));
        cf.setBackground(Color.white);
        cf.setEnabled(true);
        cf.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        cf.setForeground(Color.black);
        cf.setCaretColor(Color.pink);
        cf.setDisabledTextColor(Color.white);
        cf.setSelectionColor(Color.black);
        cf.setText("");
        cf.setBounds(new Rectangle(15, 13, 138, 41));
        this.getContentPane().setBackground(Color.pink);
        this.getContentPane().add(jLabel1);
        jTable1.setBounds(new Rectangle( -4, 79, 401, 148));
        this.getContentPane().add(xm);
        this.getContentPane().add(jButton2);
        jPanel1.add(cf);
        jPanel1.add(jc);
        this.getContentPane().add(jTable1);
        this.getContentPane().add(jTableHeader1);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jPanel1);
        xm.setBounds(new Rectangle(101, 27, 114, 23));
    }

    JLabel jLabel1 = new JLabel();
    JTextField xm = new JTextField();
    Object [][] cells={
                       {" "," "," "," "," ",},
    };
    String tableheader[] = {"专业", "学院", "入学时间","籍贯","出生日期"};
    JTable jTable1 = new JTable(cells,tableheader);
    JButton jButton2 = new JButton();
    JTableHeader jTableHeader1 = jTable1.getTableHeader();
    JButton jButton1 = new JButton();
    JPanel jPanel1 = new JPanel();
    JTextField jc = new JTextField();
    JTextField cf = new JTextField();
    public void jButton2_actionPerformed(ActionEvent e) {
           String XM=xm.getText();
           if(XM.length()==0){
               JOptionPane.showMessageDialog(this,"请输入你要查询的名字");
               return;
           }else{
                try{
               Connectionsql s=new Connectionsql();
               Connection con=s.getConnection();
               Statement pstmt=con.createStatement();
               String sql="select * from student where name='"+XM+"'";
               ResultSet rs=pstmt.executeQuery(sql);
               if(!rs.next()){
                   JOptionPane.showMessageDialog(this,"本学校没有这个学生","警告",JOptionPane.WARNING_MESSAGE);
               }
                }catch(Exception qs){
                    qs.getMessage();
                }

           }
           try{
               Connectionsql s=new Connectionsql();
               Connection con=s.getConnection();
               Statement pstmt=con.createStatement();
               String sqls="select * from student where name='"+XM+"'";
               ResultSet rs=pstmt.executeQuery(sqls);
               DefaultTableModel model1 = new DefaultTableModel();
               model1.setColumnIdentifiers(tableheader);
               while(rs.next()){
                   model1.addRow(new Object[]{rs.getString(6),rs.getString(7),rs.getString(10),rs.getString(9),rs.getString(8)});
               }
               jTable1.setModel(model1);
           }catch(Exception x){
               System.out.println(x.getMessage());
           }
    }

    public void jButton1_actionPerformed(ActionEvent e) {
     String XM=xm.getText();

     try{
               Connectionsql s=new Connectionsql();
               Connection con=s.getConnection();
               Statement pstmt=con.createStatement();
               String sqls="select * from jiangcheng where ming='"+XM+"'";
               ResultSet rs=pstmt.executeQuery(sqls);
               while(rs.next()){
                   jc.setText(rs.getString(3));
                   cf.setText(rs.getString(4));

               }
               rs.close();
               pstmt.close();
         }catch(Exception x){
               System.out.println(x.getMessage());
           }


    }
}


class cha2Frame1_jButton1_actionAdapter implements ActionListener {
    private cha2Frame1 adaptee;
    cha2Frame1_jButton1_actionAdapter(cha2Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class cha2Frame1_jButton2_actionAdapter implements ActionListener {
    private cha2Frame1 adaptee;
    cha2Frame1_jButton2_actionAdapter(cha2Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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