scanusers.java

用Java开发的学生信息管理系统

package studentsystem;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @download by http://www.codefans.net
 * @author not attributable
 * @version 1.0
 */

public class scanusers extends JFrame {
  Statement ps;
  ResultSet rs;
  Connection con;
  String url;
int i;
  JScrollPane jScrollPane1 = new JScrollPane();
  Object[][] rowData = new Object[10][3];
  String[] columnNames = {
      "用户名", "密码", "权限"};
  JTable jTable1 = new JTable(rowData, columnNames);
  JButton ok = new JButton();


  public scanusers() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
    try { //连接数据库

             // String name = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
             String url =
                 "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Student;";
             // Class.forName(name);
             // Connection con = DriverManager.getConnection(url, "sa", "123");
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             Connection con = DriverManager.getConnection(
                 "jdbc:odbc:lee",
                 "sa", "123");

             ps = con.createStatement(ResultSet.
                                      TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_READ_ONLY);


                 rs = ps.executeQuery("select * from users");
                 while (rs.next()) {

               rowData[i][0] = rs.getString("username");
               rowData[i][1] = rs.getString("pwd");
               rowData[i][2] = rs.getString("power");
               i = i + 1;
             }

             }

             catch (Exception err) {
               String err1 = err.getMessage();
               JOptionPane.showMessageDialog(null, err);
             }



  }
  public static void main(String[] args) {
    scanusers scanusers = new scanusers();
  }
  private void jbInit() throws Exception {
    this.setResizable(false);
    this.setTitle("浏览用户");
    this.getContentPane().setLayout(null);
    jScrollPane1.setBounds(new Rectangle(2, 10, 433, 185));
    ok.setBounds(new Rectangle(177, 209, 92, 34));
    ok.setFont(new java.awt.Font("Dialog", 0, 15));
    ok.setText("确  定");
    ok.addActionListener(new scanusers_ok_actionAdapter(this));

    this.getContentPane().add(jScrollPane1, null);
    jScrollPane1.getViewport().add(jTable1, null);
    this.getContentPane().add(ok, null);
    this.setBounds(250,250,450,350);
    this.setVisible(true);
  }

  void ok_actionPerformed(ActionEvent e) {
    this.dispose();
  }
}

class scanusers_ok_actionAdapter implements java.awt.event.ActionListener {
  scanusers adaptee;

  scanusers_ok_actionAdapter(scanusers adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.ok_actionPerformed(e);
  }
}