adminlookuserinfoframe.java~11~

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

package prjsystementer;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import prjUser.UserModel;
import prjUser.User;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.sql.SQLException;
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 java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JDialog;
import java.awt.Color;
import java.awt.SystemColor;

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

    public void fillUserInfoTable() {
        DBManager db = new DBManager();
        String sql = "select * from T_USERINFO";
        ResultSet rs = db.ExecuteQuery(sql);
        ArrayList al = new ArrayList();
        try {
            while (rs.next()) {

                String name = rs.getString("userName");
                String pwd = rs.getString("pwd");
                String grade = rs.getString("grade");

                User u = new User();
                u.setUserName(name);
                u.setGrade(grade);
                u.setPwd("********");

                al.add(u);

            }
            UserModel um = new UserModel();
            um.al = al;
            this.tblUserInfo.setModel(um);
        } catch (SQLException ex1) {
            ex1.printStackTrace();
        }

    }


    private void jbInit() throws Exception {
        fillUserInfoTable();
        getContentPane().setLayout(null);
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 16));
        jLabel1.setText("用户信息");
        jLabel1.setBounds(new Rectangle(165, 2, 91, 40));
        btnCancel.setBackground(Color.white);
        btnCancel.setBounds(new Rectangle(326, 341, 83, 25));
        btnCancel.setText("退出");
        btnCancel.addActionListener(new
                                    adminLookUserInfoFrame_btnCancel_actionAdapter(this));
        this.getContentPane().setBackground(Color.orange);
        jScrollPane1.getViewport().setBackground(SystemColor.activeCaptionText);
        tblUserInfo.setBackground(Color.orange);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(btnCancel);
        jScrollPane1.getViewport().add(tblUserInfo);
        jScrollPane1.setBounds(new Rectangle(5, 49, 404, 284));
    }

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


class adminLookUserInfoFrame_btnCancel_actionAdapter implements ActionListener {
    private adminLookUserInfoFrame adaptee;
    adminLookUserInfoFrame_btnCancel_actionAdapter(adminLookUserInfoFrame
            adaptee) {
        this.adaptee = adaptee;
    }

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