framexgcj2.java

班级管理系统

package myproject;

import java.awt.BorderLayout;

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

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jScrollPane1.setBorder(BorderFactory.createLoweredBevelBorder());
        jScrollPane1.setBounds(new Rectangle(11, 111, 371, 181));
        jButton1.setBounds(new Rectangle(221, 23, 83, 25));
        jButton1.setText("查询");
        jButton1.addActionListener(new Framexgcj2_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(222, 65, 83, 25));
        jButton2.setText("修改");
        jButton2.addActionListener(new Framexgcj2_jButton2_actionAdapter(this));
        jComboBox1.setBackground(Color.lightGray);
        jComboBox1.setBounds(new Rectangle(62, 27, 113, 23));
        jTextField1.setBackground(Color.lightGray);
        jTextField1.setBorder(BorderFactory.createLoweredBevelBorder());
        jTextField1.setBounds(new Rectangle(60, 64, 112, 25));
        jTable1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jComboBox1);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jButton2);
        jScrollPane1.getViewport().add(jTable1);
        jComboBox1.addItem("<默认>");
        jComboBox1.addItem("学号");
        jComboBox1.addItem("英语");
        jComboBox1.addItem("语文");
        jComboBox1.addItem("数据设计");
        jComboBox1.addItem("高等数学");

        df.addColumn("学号");
        df.addColumn("英语");
        df.addColumn("语文");
        df.addColumn("数据设计");
        df.addColumn("高等数学");

    }

    JScrollPane jScrollPane1 = new JScrollPane();
    DefaultTableModel df = new DefaultTableModel();
    JTable jTable1 = new JTable(df);
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JComboBox jComboBox1 = new JComboBox();
    JTextField jTextField1 = new JTextField();
    public void jButton1_actionPerformed(ActionEvent e) {
        df.setRowCount(0);
        String str = "select * from chengji where " + getstr() + "='" +
                     jTextField1.getText() + "'";
        if (jComboBox1.getItemAt(jComboBox1.getSelectedIndex()).equals("<默认>")) {
            str = "select * from chengji";
            jTextField1.setText("");
        }
        Vector ve = new Vector();
        DB db=new DB();
        ve = db.getuserve(str);
        for (int i = 0; i < ve.size(); i++) {
            jbuser j = new jbuser();
            j = (jbuser) ve.get(i);
            df.addRow(getv(j));
        }
    }
    public Vector getv(jbuser j) {
        Vector ve = new Vector();
        ve.add(j.getDnum());
        ve.add(j.getDyy());
        ve.add(j.getDyw());
        ve.add(j.getDsj());
        ve.add(j.getDgd());

        return ve;
    }


    public String getstr() {

        if (jComboBox1.getSelectedItem().equals("学号")) {
            return "number";
        } else if (jComboBox1.getSelectedItem().equals("英语")) {
            return "yingyu";
        } else if (jComboBox1.getSelectedItem().equals("语文")) {
            return "yuwen";
        } else if (jComboBox1.getSelectedItem().equals("数据设计")) {
            return "sujusheji";
        } else if (jComboBox1.getSelectedItem().equals("高等数学")) {
            return "gaodengshuxue";
        } else {
            return "";
        }
    }
    public void jButton2_actionPerformed(ActionEvent e) {
        Vector ve = new Vector();
       int i = jTable1.getSelectedRow();
       if (i != -1) {
           String st = String.valueOf(jTable1.getValueAt(i, 0));
           String str = "select * from chengji where number='" + st + "'";
           System.out.println(str);
           DB db=new DB();
           ve = db.getuserve(str);
       }
      Dadduser f=new Dadduser(ve);
      f.setSize(300, 300);
      f.setLocation(300, 200);
      f.show();

    }
    public Vector getvebao(jbuser j) {
        Vector ve = new Vector();
        ve.add(j.getDnum());
        ve.add(j.getDyy());
        ve.add(j.getDyw());
        ve.add(j.getDsj());
        ve.add(j.getDgd());
        return ve;
    }



    class Framexgcj2_jButton1_actionAdapter implements ActionListener {
        private Framexgcj2 adaptee;
        Framexgcj2_jButton1_actionAdapter(Framexgcj2 adaptee) {
            this.adaptee = adaptee;
        }

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

    }
}


class Framexgcj2_jButton2_actionAdapter implements ActionListener {
    private Framexgcj2 adaptee;
    Framexgcj2_jButton2_actionAdapter(Framexgcj2 adaptee) {
        this.adaptee = adaptee;
    }

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