addcourseframe.java~21~

用java 写的学生信息管理系统

package prjStudent;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.awt.Font;
import javax.swing.JTextField;
import javax.swing.JTextArea;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import prjsystementer.DBManager;
import java.sql.ResultSet;
import java.sql.*;
import javax.swing.JOptionPane;
import javax.swing.JDialog;

public class AddCourseFrame extends JDialog {
    public AddCourseFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 16));
        jLabel1.setText("增加课程信息");
        jLabel1.setBounds(new Rectangle(132, 15, 115, 43));
        btnRWrite.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnRWrite.addActionListener(new AddCourseFrame_btnRWrite_actionAdapter(this));
        btnOk.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnOk.addActionListener(new AddCourseFrame_btnOk_actionAdapter(this));
        btnCancel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnCancel.addActionListener(new AddCourseFrame_btnCancel_actionAdapter(this));
        this.getContentPane().add(jLabel1);
        btnCancel.setBounds(new Rectangle(279, 323, 83, 25));
        btnCancel.setText("取消");
        btnOk.setBounds(new Rectangle(159, 323, 83, 25));
        btnOk.setText("确定");
        btnRWrite.setBounds(new Rectangle(39, 323, 83, 25));
        btnRWrite.setText("重置");
        txtMemo.setBounds(new Rectangle(142, 212, 142, 32));
        txtName.setBounds(new Rectangle(142, 141, 140, 36));
        txtId.setBounds(new Rectangle(142, 69, 139, 31));
        jLabel4.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel4.setText("课程名称：");
        jLabel4.setBounds(new Rectangle(31, 143, 66, 32));
        jLabel3.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel3.setToolTipText("");
        jLabel3.setText("课程备注：");
        jLabel3.setBounds(new Rectangle(31, 212, 72, 25));
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(txtId);
        this.getContentPane().add(txtName);
        this.getContentPane().add(txtMemo);
        this.getContentPane().add(btnRWrite);
        this.getContentPane().add(btnOk);
        this.getContentPane().add(btnCancel);
        jLabel2.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jLabel2.setText("课程编号：");
        jLabel2.setBounds(new Rectangle(31, 73, 74, 28));
    }

    public static void main(String[] args) {
        AddCourseFrame addcourseframe = new AddCourseFrame();
        addcourseframe.setTitle("课程信息列表");
        addcourseframe.setSize(400, 450);
        addcourseframe.setLocation(300, 200);
        addcourseframe.setDefaultCloseOperation(addcourseframe.DISPOSE_ON_CLOSE);
        addcourseframe.setVisible(true);

    }


    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField txtId = new JTextField();
    JTextField txtName = new JTextField();
    JTextArea txtMemo = new JTextArea();
    JButton btnRWrite = new JButton();
    JButton btnOk = new JButton();
    JButton btnCancel = new JButton();
    public void btnCancel_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void btnOk_actionPerformed(ActionEvent e) {
        String id = txtId.getText();

        if (id.equals("")) {
            JOptionPane.showMessageDialog(this, "课程编号不能为空。");
            return;
        }
        if (id.substring(0, 1).equals("C") == false) {
            JOptionPane.showMessageDialog(this, "课程编号个格式应该为：C001");
            return;
        }
        if (id.length() > 10) {
            JOptionPane.showMessageDialog(this, "课程编号过长。");
            return;
        }
        String Querysql = "select * from T_COURSE where courseID='" + id +
                          "'";
        DBManager db = new DBManager();
        ResultSet rs = db.ExecuteQuery(Querysql);

        try {
            while (rs.next()) {
                JOptionPane.showMessageDialog(this, "重复的课程编号。");
                return;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        String name = txtName.getText();
        if (name.equals("")) {
            JOptionPane.showMessageDialog(this, "课程名不能为空。");
            return;
        }
        String memo = txtMemo.getText();
        String sql =
                "insert T_COURSE(courseID, courseName, Memo)values ('" +
                id + "','" + name + "','" + memo + "')";
        db.ExecuteUpdate(sql);
        JOptionPane.showMessageDialog(this, "插入成功。");

    }

    public void btnRWrite_actionPerformed(ActionEvent e) {
        this.txtId.setText("");
        this.txtMemo.setText("");
        this.txtName.setText("");
    }
}


class AddCourseFrame_btnRWrite_actionAdapter implements ActionListener {
    private AddCourseFrame adaptee;
    AddCourseFrame_btnRWrite_actionAdapter(AddCourseFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class AddCourseFrame_btnOk_actionAdapter implements ActionListener {
    private AddCourseFrame adaptee;
    AddCourseFrame_btnOk_actionAdapter(AddCourseFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class AddCourseFrame_btnCancel_actionAdapter implements ActionListener {
    private AddCourseFrame adaptee;
    AddCourseFrame_btnCancel_actionAdapter(AddCourseFrame adaptee) {
        this.adaptee = adaptee;
    }

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