cxxj.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 cxxj
    extends JFrame {

  Statement ps;
  ResultSet rs;
  Connection con;
  String url;

  JScrollPane jScrollPane1 = new JScrollPane();
  Object[][] rowData = new Object[10][9];
  String[] columnNames = {
      "学号", "姓名", "性别", "出生日期", "班号", "联系电话", "入校日期", "家庭住址", "备注"};
  JTable jTable1 = new JTable(rowData, columnNames);
  JButton cancel = new JButton();
  JButton ok = new JButton();
  JTextField input = new JTextField();
  ButtonGroup buttonGroup2 = new ButtonGroup();
  JRadioButton xh = new JRadioButton();
  JRadioButton xm = new JRadioButton();
  JRadioButton bh = new JRadioButton();
  public cxxj() {
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

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

  private void jbInit() throws Exception {
    this.setLocale(java.util.Locale.getDefault());
    this.getContentPane().setLayout(null);
    jScrollPane1.setBounds(new Rectangle(6, 0, 780, 400));
    ok.setToolTipText("直接点击确定，可查询全部学生信息");
    cancel.setBounds(new Rectangle(578, 412, 85, 30));
    cancel.setFont(new java.awt.Font("Dialog", 0, 15));
    cancel.setText("取   消");
    cancel.addActionListener(new cxxj_cancel_actionAdapter(this));
    ok.setBounds(new Rectangle(465, 412, 85, 34));
    ok.setFont(new java.awt.Font("Dialog", 0, 15));
    ok.setText("确   定");
    ok.addActionListener(new cxxj_ok_actionAdapter(this));
    input.setFont(new java.awt.Font("Dialog", 0, 15));
    input.setText("");
    input.setBounds(new Rectangle(291, 410, 124, 31));
    xh.setFont(new java.awt.Font("Dialog", 0, 15));
    xh.setRolloverEnabled(false);
    xh.setText("按学号");
    xh.setBounds(new Rectangle(20, 417, 74, 34));
    xm.setBounds(new Rectangle(95, 417, 74, 34));
    xm.setText("按姓名");
    xm.setRolloverEnabled(false);
    xm.setFont(new java.awt.Font("Dialog", 0, 15));
    bh.setBounds(new Rectangle(174, 418, 74, 34));
    bh.setText("按班号");
    bh.setRolloverEnabled(false);
    bh.setFont(new java.awt.Font("Dialog", 0, 15));
    this.getContentPane().add(jScrollPane1, null);
    this.getContentPane().add(input, null);
    this.getContentPane().add(ok, null);
    this.getContentPane().add(cancel, null);
    this.getContentPane().add(bh, null);
    this.getContentPane().add(xm, null);
    this.getContentPane().add(xh, null);
    jScrollPane1.getViewport().add(jTable1, null);
    this.setBounds(100, 100, 800, 500);
    this.setVisible(true);
    buttonGroup2.add(xh);
    buttonGroup2.add(bh);
    buttonGroup2.add(xm);
  }

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

  void ok_actionPerformed(ActionEvent e) {
    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);

      int i = 0;
      try {
        if (xh.isSelected()) {
          rs = ps.executeQuery("select * from student where student_ID='" +
                               input.getText().trim() + "'");
        }
        else if (xm.isSelected()) {
          rs = ps.executeQuery("select * from student where student_Name='" +
                               input.getText().trim() + "'");
        }
        else if (bh.isSelected()) {
          rs = ps.executeQuery("select * from student where class_NO='" +
                               input.getText().trim() + "'");
        }
        else
          rs = ps.executeQuery("select * from student");
      }

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

      while (rs.next()) {

        rowData[i][0] = rs.getString("student_ID");
        rowData[i][1] = rs.getString("student_Name");
        rowData[i][2] = rs.getString("student_Sex");
        rowData[i][3] = rs.getString("born_Date").substring(0, 10);
        rowData[i][4] = rs.getString("class_NO");
        rowData[i][5] = rs.getString("tele_Number");
        rowData[i][6] = rs.getString("ru_Date").substring(0, 10);
        rowData[i][7] = rs.getString("address");
        rowData[i][8] = rs.getString("comment");
        i = i + 1;

      }
    }

    catch (Exception err) {
      Log log=new Log();
      log.addLog("\r\r","数据库连接出错");
     log.closeStream();

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

class cxxj_cancel_actionAdapter
    implements java.awt.event.ActionListener {
  cxxj adaptee;

  cxxj_cancel_actionAdapter(cxxj adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.cancel_actionPerformed(e);
  }
}

class cxxj_ok_actionAdapter
    implements java.awt.event.ActionListener {
  cxxj adaptee;

  cxxj_ok_actionAdapter(cxxj adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.ok_actionPerformed(e);
  }
}