scanuser.java

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

package studentsystem;

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

/**
 * <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 scanuser
    extends JFrame {
  Statement ps;
  ResultSet rs;
  Connection con;
  String url;
  int i;
  JScrollPane jScrollPane1 = new JScrollPane();
  String[][] rowData = new String[10][3];
  String[] columnNames = {
      "用户名", "密码", "权限"};
  JTable jTable1 = new JTable(rowData, columnNames);
 // DefaultTableModel defaultModel = new DefaultTableModel(rowData, columnNames);
 // JTable jTable1 = new JTable(defaultModel);
  JButton ok = new JButton();

  public scanuser() {
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    try {
      url =
          "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Student;";
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection con = DriverManager.getConnection(
          "jdbc:odbc:student",
          "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) {
//      Log log = new Log();
     // log.addLog("\r\r", "数据库连接出错");
  //    log.closeStream();
      String err1 = err.getMessage();
      JOptionPane.showMessageDialog(null, err);
    }

  }

  public static void main(String[] args) {
    scanuser cxcj = new scanuser();
  }

  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 cxcj_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 cxcj_ok_actionAdapter
    implements java.awt.event.ActionListener {
  scanuser adaptee;

  cxcj_ok_actionAdapter(scanuser adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.ok_actionPerformed(e);
  }
  public static void  main(String args[]){
	  new scanuser();
  }
}