userlist.java

来自「采用java+sql实现图书管理系统」· Java 代码 · 共 46 行

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
import java.util.Vector;

public class UserList
    extends JFrame {
  DataBaseManager db = new DataBaseManager();
  ResultSet rs;
  Container c;
  JTable table = null;
  DefaultTableModel defaultModel = null;
  public UserList() {
    super("用户列表一览！");
    c = getContentPane();
    c.setLayout(new BorderLayout());
    String[] name = {
        "用户名", "权限"};
    String[][] data = new String[0][0];
    defaultModel = new DefaultTableModel(data, name);
    table = new JTable(defaultModel);//表格的model
    table.setPreferredScrollableViewportSize(new Dimension(400, 80));
    JScrollPane s = new JScrollPane(table);//新建表格
    c.add(s);//表格增加到面板
    try {
      String strSql = "select UserName,power from userTable";
      rs = db.getResult(strSql);
      while (rs.next()) {//将查询结果放进向量表
        Vector insertRow = new Vector();
        insertRow.addElement(rs.getString(1));
        insertRow.addElement(rs.getString(2));
        defaultModel.addRow(insertRow);
      }
      table.revalidate();//更新界面
    }
    catch (SQLException sqle) {
      System.out.println(sqle.toString());
    }
    catch (Exception ex) {
      System.out.println(ex.toString());
    }
  }
}