adminlookstudentframe.java~6~

用java 写的学生信息管理系统

package prjsystementer;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.awt.Font;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JButton;
import prjStudent.studentModel;
import java.sql.ResultSet;
import prjStudent.Student;
import java.util.ArrayList;
import java.sql.SQLException;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JDialog;
import java.awt.Color;
import java.awt.SystemColor;

public class adminLookStudentFrame extends JDialog {
    public adminLookStudentFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    String sql = "select * from T_STUDENT ";
    private void fillTable() {
        DBManager db = new DBManager();

        ResultSet rs = db.ExecuteQuery(sql);
        ArrayList al = new ArrayList();
        try {
            while (rs.next()) {
                String stuId = rs.getString("stuID");
                String stuName = rs.getString("stuName");
                String sex = rs.getString("stuSex");
                String stuBirthday = rs.getString("stuBirthday");
                String classID = rs.getString("classID");
                String stuPhone = rs.getString("stuPhone");
                String stuInDate = rs.getString("stuInDate");
                String stuAddress = rs.getString("stuAddress");
                String memo = rs.getString("Memo");

                Student s = new Student();

                s.setID(stuId);
                s.setName(stuName);
                s.setSex(sex);
                s.setBirthday(stuBirthday);
                s.setClassId(classID);
                s.setPhone(stuPhone);
                s.setIndate(stuInDate);
                s.setAddress(stuAddress);
                s.setMemo(memo);

                al.add(s);
            }
            studentModel cm = new studentModel();
            cm.al = al;
            tblStudent.setModel(cm);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }

    }

    private void jbInit() throws Exception {
        fillTable();
        getContentPane().setLayout(null);
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 16));
        jLabel1.setText("学生信息列表");
        jLabel1.setBounds(new Rectangle(158, 5, 119, 50));
        btnCancel.setBackground(Color.white);
        btnCancel.setBounds(new Rectangle(339, 314, 83, 25));
        btnCancel.setText("关闭");
        btnCancel.addActionListener(new
                                    adminLookStudentFrame_btnCancel_actionAdapter(this));
        jScrollPane1.getViewport().setBackground(Color.white);
        this.getContentPane().setBackground(SystemColor.controlLtHighlight);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(btnCancel);
        jScrollPane1.getViewport().add(tblStudent);
        jScrollPane1.setBounds(new Rectangle(8, 48, 414, 252));
    }

    JLabel jLabel1 = new JLabel();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable tblStudent = new JTable();
    JButton btnCancel = new JButton();
    public void btnCancel_actionPerformed(ActionEvent e) {
        this.dispose();
    }
}


class adminLookStudentFrame_btnCancel_actionAdapter implements ActionListener {
    private adminLookStudentFrame adaptee;
    adminLookStudentFrame_btnCancel_actionAdapter(adminLookStudentFrame adaptee) {
        this.adaptee = adaptee;
    }

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