cxbj.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>
 * @author not attributable
 * @version 1.0
 */

public class cxbj extends JFrame {
  Statement ps;
  ResultSet rs;
  Connection con;
  String url;
int i=0;
  JScrollPane jScrollPane1 = new JScrollPane();
  Object[][] rowData = new Object[10][4];
  String[] columnNames = {
      "班号", "年级", "班主任","教室"};
  JTable jTable1 = new JTable(rowData, columnNames);
  JButton ok = new JButton();


  public cxbj() {
    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 class");
                 while (rs.next()) {
                             rowData[i][0] = rs.getString("class_No");
               rowData[i][1] = rs.getString("grade");
               rowData[i][2] = rs.getString("director");
               rowData[i][3] = rs.getString("classroom_No");
               i = i + 1;
             }

             }

             catch (Exception err) {
               String err1 = err.getMessage();
               Log log=new Log();
              log.addLog("\r\r","查询班级出错");
              log.closeStream();
               JOptionPane.showMessageDialog(null, err);
             }



  }
  public static void main(String[] args) {
    cxbj cxbj = new cxbj();
  }
  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 cxbj_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 cxbj_ok_actionAdapter implements java.awt.event.ActionListener {
  cxbj adaptee;

  cxbj_ok_actionAdapter(cxbj adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.ok_actionPerformed(e);
  }
}