tjkcxx.java

java+SQLServer2005编写的学生学籍管理系统

/*
 * tjkcxx.java
 *
 * Created on 2007年11月5日, 下午2:32
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package studentsystem;

/**
 *
 * @author asus
 */
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 {
                String name = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
                String url ="jdbc:sqlserver://localhost:1433; DatabaseName=student";               
                Class.forName(name);
                Connection con = DriverManager.getConnection(url, "ss", "123");
                ps = con.createStatement(ResultSet.
                                 TYPE_SCROLL_INSENSITIVE,
                                 ResultSet.CONCUR_READ_ONLY);
            }
            catch (Exception err) {
                JOptionPane.showMessageDialog(null, "连接数据库错误!");

            }
            try {
                ps.executeUpdate("Insert Into course Values('" +
                         kcbh.getText().trim() +
                         "','" + kcmc.getText().trim() + "','" +
                         kclx.getSelectedItem().toString() +
                         "','" + kcms.getText().trim() + "')");
                JOptionPane.showMessageDialog(null, "添加成功");
                this.dispose();
            }
            catch (SQLException sqle) {
                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);
    }
}