framecxcj.java~3~

班级管理系统

package myproject;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

public class Framecxcj extends JFrame {
    public Framecxcj() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jLabel1.setToolTipText("");
        jLabel1.setText("请输入学号");
        jLabel1.setBounds(new Rectangle(51, 30, 69, 21));
        jTextField1.setBounds(new Rectangle(139, 30, 72, 23));
        jButton1.setBounds(new Rectangle(236, 29, 58, 25));
        jButton1.setToolTipText("");
        jButton1.setText("查询");
        jButton1.addActionListener(new Framecxcj_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(305, 28, 59, 25));
        jButton2.setToolTipText("");
        jButton2.setText("重置");
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jLabel2.setToolTipText("");
        jLabel2.setText("英语");
        jLabel2.setBounds(new Rectangle(53, 94, 52, 20));
        jTextField2.setBounds(new Rectangle(137, 96, 72, 21));
        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jLabel3.setToolTipText("");
        jLabel3.setText("高等数学");
        jLabel3.setBounds(new Rectangle(226, 92, 76, 24));
        jTextField3.setToolTipText("");
        jTextField3.setBounds(new Rectangle(298, 94, 74, 21));
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jLabel4.setToolTipText("");
        jLabel4.setText("语文");
        jLabel4.setBounds(new Rectangle(50, 175, 50, 15));
        jTextField4.setBounds(new Rectangle(136, 177, 72, 21));
        jTextField5.setBounds(new Rectangle(299, 180, 72, 21));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jLabel5.setToolTipText("");
        jLabel5.setText("数据设计");
        jLabel5.setBounds(new Rectangle(226, 179, 71, 24));
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jTextField2);
        this.getContentPane().add(jTextField4);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jTextField3);
        this.getContentPane().add(jTextField5);
    }

    JLabel jLabel1 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField2 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField jTextField3 = new JTextField();
    JLabel jLabel4 = new JLabel();
    JTextField jTextField4 = new JTextField();
    JTextField jTextField5 = new JTextField();
    JLabel jLabel5 = new JLabel();
    public void jButton1_actionPerformed(ActionEvent e) {
        DB db = new DB();
       String strobj1 = jTextField1.getText();
       String strobj2 = jTextField2.getText();
       String strobj3 = jTextField3.getText();
       String strobj4 = jTextField4.getText();
       String strobj5 = jTextField5.getText();
       Vector vc=new Vector(100);
       String str = "select * from chengji where number='" + strobj1 + "'";
       ResultSet rs = db.Select(str);
       ResultSetMetaData rsmd = null;
       try {
           rsmd = rs.getMetaData();
           int count=rsmd.getColumnCount();
           while(rs.next())
               for(int i=1;i<=count;i++)
               {
                   vc.add(rs.getObject(i));
               }
           if(strobj1.length()==0)
           {
               JOptionPane.showMessageDialog(this,"请输入学号","消息",JOptionPane.INFORMATION_MESSAGE);
           }
           else if(vc.contains(strobj1))
           {
               this.jTextField2.setText(vc.elementAt(0).toString());
               this.jTextField3.setText(vc.elementAt(1).toString());
               this.jTextField4.setText(vc.elementAt(2).toString());
               this.jTextField5.setText(vc.elementAt(3).toString());
           }
           else
           {
               JOptionPane.showMessageDialog(this,"查无此人","消息",JOptionPane.INFORMATION_MESSAGE);
           }
       } catch (SQLException ex) {
       }

    }
}


class Framecxcj_jButton1_actionAdapter implements ActionListener {
    private Framecxcj adaptee;
    Framecxcj_jButton1_actionAdapter(Framecxcj adaptee) {
        this.adaptee = adaptee;
    }

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