adminlookteacherframe.java

用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 java.sql.ResultSet;
import java.sql.*;
import java.util.ArrayList;
import prjTeacher.Teacher;
import prjTeacher.TeacherModal;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JDialog;
import java.awt.Color;
import java.awt.SystemColor;

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

    private void fillTable() {
        DBManager db = new DBManager();
        String sql = "select * from T_TEACHER ";
        ResultSet rs = db.ExecuteQuery(sql);
        ArrayList al = new ArrayList();
        try {
            while (rs.next()) {
                String ID = rs.getString("teacherId");
                String Name = rs.getString("teacherName");
                String Phone = rs.getString("teacherTel");
                String Memo = rs.getString("Memo");

                Teacher t = new Teacher();

                t.setTeacherID(ID);
                t.setTeacherName(Name);
                t.setTeacherPhone(Phone);
                t.setTeacherMemo(Memo);

                al.add(t);
            }
            TeacherModal tm = new TeacherModal();
            tm.al = al;
            this.tblTeacher.setModel(tm);
        } 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(136, 3, 115, 32));
        btnCancel.setBackground(Color.white);
        btnCancel.setBounds(new Rectangle(293, 296, 99, 25));
        btnCancel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnCancel.setText("关闭");
        btnCancel.addActionListener(new
                                    AdminLookTeacherFrame_btnCancel_actionAdapter(this));
        jScrollPane1.getViewport().setBackground(Color.orange);
        this.getContentPane().setBackground(Color.orange);
        tblTeacher.setBackground(Color.orange);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(btnCancel);
        jScrollPane1.getViewport().add(tblTeacher);
        jScrollPane1.setBounds(new Rectangle(8, 38, 385, 251));
    }

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


class AdminLookTeacherFrame_btnCancel_actionAdapter implements ActionListener {
    private AdminLookTeacherFrame adaptee;
    AdminLookTeacherFrame_btnCancel_actionAdapter(AdminLookTeacherFrame adaptee) {
        this.adaptee = adaptee;
    }

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