adminlookuserinfoframe.java~2~

用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;

public class adminLookUserInfoFrame extends JFrame {
    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 {
        getContentPane().setLayout(null);
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 16));
        jLabel1.setText("用户信息");
        jLabel1.setBounds(new Rectangle(165, 2, 91, 40));
        btnCancel.setBounds(new Rectangle(333, 342, 83, 25));
        btnCancel.setText("退出");
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(btnCancel);
        jScrollPane1.getViewport().add(tblUserInfo);
        jScrollPane1.setBounds(new Rectangle(12, 43, 404, 284));
    }

    JLabel jLabel1 = new JLabel();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable tblUserInfo = new JTable();
    JButton btnCancel = new JButton();
}