framexgxs.java

班级管理系统

package myproject;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JButton;
import java.awt.Rectangle;
import javax.swing.JComboBox;
import java.awt.Color;
import javax.swing.JTextField;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import java.awt.Font;
import javax.swing.table.DefaultTableModel;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;
import javax.swing.BorderFactory;

public class Framexgxs extends JFrame {
    public Framexgxs() {
        try {
            jbInit();
            this.setResizable(false);
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jButton1.setBounds(new Rectangle(220, 29, 83, 25));
        jButton1.setText("查询");
        jButton1.addActionListener(new Framexgxs_jButton1_actionAdapter(this));
        jTextField1.setBackground(Color.lightGray);
        jTextField1.setBorder(BorderFactory.createLoweredBevelBorder());
        jTextField1.setToolTipText("");
        jTextField1.setBounds(new Rectangle(60, 64, 112, 25));
        jButton2.setBounds(new Rectangle(222, 65, 83, 25));
        jButton2.setText("修改");
        jButton2.addActionListener(new Framexgxs_jButton2_actionAdapter(this));
        jScrollPane1.setBorder(BorderFactory.createLoweredBevelBorder());
        jScrollPane1.setBounds(new Rectangle(15, 109, 371, 181));
        jTable1 = new JTable(df);
        jTable1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jComboBox1);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(jTable1);
        jComboBox1.addItem("<默认>");
        jComboBox1.addItem("名字");
        jComboBox1.addItem("学号");
        jComboBox1.addItem("QQ");
        jComboBox1.addItem("性别");
        df.addColumn("名字");
        df.addColumn("学号");
        df.addColumn("QQ");
        df.addColumn("性别");

        jComboBox1.setBackground(Color.lightGray);

        jComboBox1.setBounds(new Rectangle(62, 27, 113, 23));
        }
        JTable jTable1=null;
    DefaultTableModel df = new DefaultTableModel();
    JButton jButton1 = new JButton();
    JComboBox jComboBox1 = new JComboBox();
    JTextField jTextField1 = new JTextField();
    JButton jButton2 = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    public void jButton1_actionPerformed(ActionEvent e) {
        df.setRowCount(0);
        String str = "select * from student where " + getstr() + "='" +
                     jTextField1.getText() + "'";
        if (jComboBox1.getItemAt(jComboBox1.getSelectedIndex()).equals("<默认>")) {
            str = "select * from student";
            jTextField1.setText("");
        }
        Vector ve = new Vector();
        DB db=new DB();
        ve = db.getuserve1(str);
       for (int i = 0; i < ve.size(); i++) {
           jbuser1 j = new jbuser1();
           j = (jbuser1) ve.get(i);
           df.addRow(getv(j));
        }
    }
    public Vector getv(jbuser1 j) {
        Vector ve = new Vector();
        ve.add(j.getDname());
        ve.add(j.getDxh());
        ve.add(j.getDQQ());
        ve.add(j.getDxb());
        return ve;
}
    public String getstr() {

           if (jComboBox1.getSelectedItem().equals("名字")) {
               return "name";
           } else if (jComboBox1.getSelectedItem().equals("学号")) {
               return "number";
           } else if (jComboBox1.getSelectedItem().equals("QQ")) {
               return "QQ";
           } else if (jComboBox1.getSelectedItem().equals("性别")) {
               return "sex";
           } else {
               return "";
           }
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        Vector ve = new Vector();
        int i = jTable1.getSelectedRow();
                System.out.println(i);
        if (i != -1) {
            String st = String.valueOf(jTable1.getValueAt(i, 1));
            String str = "select * from student where number='" + st + "'";
            System.out.println(str);
            DB db = new DB();
            ve = db.getuserve1(str);
        }
        Dadduser1 f = new Dadduser1(ve);
        f.setSize(300, 320);
        f.setLocation(300, 200);
        f.show();
    }
    public Vector getvebao(jbuser1 j) {
            Vector ve = new Vector();
            ve.add(j.getDname());
            ve.add(j.getDxh());
            ve.add(j.getDQQ());
            ve.add(j.getDxb());
            return ve;
    }
    class Framexgxs_jButton1_actionAdapter implements ActionListener {
    private Framexgxs adaptee;
    Framexgxs_jButton1_actionAdapter(Framexgxs adaptee) {
        this.adaptee = adaptee;
    }

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


class Framexgxs_jButton2_actionAdapter implements ActionListener {
    private Framexgxs adaptee;
    Framexgxs_jButton2_actionAdapter(Framexgxs adaptee) {
        this.adaptee = adaptee;
    }

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