tjkcxx.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 tjkcxx
    extends JFrame {
  Statement ps;
  ResultSet rs;
  Connection con;
  String url;

  JLabel jLabel1 = new JLabel();
  JTextField kcbh = new JTextField();
  JLabel jLabel2 = new JLabel();
  JTextField kcmc = new JTextField();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JScrollPane jScrollPane1 = new JScrollPane();
  JTextPane kcms = new JTextPane();
  JComboBox kclx = new JComboBox();
  JButton ok = new JButton();
  JButton cancel = new JButton();

  public tjkcxx() {
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

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

  private void jbInit() throws Exception {
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel1.setText("课程编号");
    jLabel1.setBounds(new Rectangle(11, 31, 67, 35));
    this.setResizable(false);
    this.setTitle("添加课程信息");
    this.getContentPane().setLayout(null);
    kcbh.setFont(new java.awt.Font("Dialog", 0, 15));
    kcbh.setText("");
    kcbh.setBounds(new Rectangle(85, 32, 116, 31));
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel2.setText("课程名称");
    jLabel2.setBounds(new Rectangle(220, 30, 72, 38));
    kcmc.setFont(new java.awt.Font("Dialog", 0, 15));
    kcmc.setText("");
    kcmc.setBounds(new Rectangle(297, 29, 138, 34));
    jLabel3.setBounds(new Rectangle(12, 80, 67, 35));
    jLabel3.setText("课程类型");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 15));
    kclx.setFont(new java.awt.Font("Dialog", 0, 15));
    kclx.setBounds(new Rectangle(81, 85, 116, 26));
    jLabel4.setBounds(new Rectangle(218, 79, 67, 35));
    jLabel4.setText("课程描述");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 15));
    jScrollPane1.setBounds(new Rectangle(265, 111, 188, 150));
    kclx.addItem("必修");
    kclx.addItem("限选");
    kclx.addItem("任选");
    kclx.setFont(new java.awt.Font("Dialog", 0, 15));
    kclx.setBounds(new Rectangle(83, 89, 121, 28));
    ok.setBounds(new Rectangle(85, 292, 88, 34));
    ok.setFont(new java.awt.Font("Dialog", 0, 15));
    ok.setText("确   定");
    ok.addActionListener(new tjkcxx_ok_actionAdapter(this));
    cancel.setText("取    消 ");
    cancel.addActionListener(new tjkcxx_cancel_actionAdapter(this));
    cancel.setFont(new java.awt.Font("Dialog", 0, 15));
    cancel.setBounds(new Rectangle(216, 292, 88, 34));
    this.getContentPane().add(jLabel1, null);
    this.getContentPane().add(kcbh, null);
    this.getContentPane().add(jLabel2, null);
    this.getContentPane().add(kcmc, null);
    this.getContentPane().add(jLabel3, null);
    this.getContentPane().add(kclx, null);
    this.getContentPane().add(jLabel4, null);
    this.getContentPane().add(jScrollPane1, null);
    this.getContentPane().add(ok, null);
    this.getContentPane().add(kclx, null);
    jScrollPane1.getViewport().add(kcms, null);
    this.getContentPane().add(cancel, null);
    this.setBounds(200, 200, 500, 400);
    this.setVisible(true);
  }

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

  void ok_actionPerformed(ActionEvent e) {
    JOptionPane.showConfirmDialog(null,
                                      "确定添加？", "添加课程", JOptionPane.YES_NO_OPTION);
    try {

      try {
        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);

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

        // String error = err.getMessage();
        JOptionPane.showMessageDialog(null, "连接数据库错误!");

      }
      try {

        ps.executeUpdate("Insert Into course Values('" +
                         kcbh.getText().trim() +
                         "','" + kcmc.getText().trim() + "','" +
                         kclx.getSelectedItem().toString() +
                         "','" + kcms.getText().trim() + "')");

        //ps.executeUpdate("Insert Into yonghu  Values('"  +user2+
        //                    "','" +psw +"'");

        JOptionPane.showMessageDialog(null, "添加成功");
        Log log=new Log();
     log.addLog("\r\r","添加"+kcbh.getText().trim()+"课程成功");
    log.closeStream();

        this.dispose();
      }

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

        String error = sqle.getMessage();
        JOptionPane.showMessageDialog(null, error);
        sqle.printStackTrace();

      }

    }
    catch (Exception ex) {
      ex.getMessage();
      String error = ex.getMessage();
      JOptionPane.showMessageDialog(null, error);
      ex.printStackTrace();

    }
  }

}

class tjkcxx_cancel_actionAdapter
    implements java.awt.event.ActionListener {
  tjkcxx adaptee;

  tjkcxx_cancel_actionAdapter(tjkcxx adaptee) {
    this.adaptee = adaptee;
  }

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

class tjkcxx_ok_actionAdapter
    implements java.awt.event.ActionListener {
  tjkcxx adaptee;

  tjkcxx_ok_actionAdapter(tjkcxx adaptee) {
    this.adaptee = adaptee;
  }

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