remarkadd.java~15~

java语言做的教务管理系统

package java_教务管理系统;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;


/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class remarkadd extends JPanel {
    public remarkadd() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel1.setText("学号：");
        jLabel1.setBounds(new Rectangle(102, 17, 82, 34));
        txtresultstuno.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtresultstuno.setBounds(new Rectangle(191, 20, 184, 32));
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel2.setText("课程名称：");
        jLabel2.setBounds(new Rectangle(470, 24, 140, 24));
        txtresultclassno.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtresultclassno.setBounds(new Rectangle(592, 23, 200, 32));
        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel3.setText("任课老师：");
        jLabel3.setBounds(new Rectangle(294, 59, 108, 39));
        txtlessonteacher.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtlessonteacher.setBounds(new Rectangle(408, 65, 203, 32));
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel4.setText("考试时间：");
        jLabel4.setBounds(new Rectangle(117, 103, 127, 44));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel5.setText("年");
        jLabel5.setBounds(new Rectangle(340, 110, 23, 28));
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel6.setText("月");
        jLabel6.setBounds(new Rectangle(463, 108, 32, 33));
        jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel7.setText("日");
        jLabel7.setBounds(new Rectangle(579, 109, 25, 31));
        jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel8.setText("考试次数：");
        jLabel8.setBounds(new Rectangle(70, 152, 120, 40));
        txtexaminationnumber.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtexaminationnumber.setBounds(new Rectangle(191, 154, 184, 29));
        jLabel9.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel9.setText("成绩：");
        jLabel9.setBounds(new Rectangle(508, 147, 81, 35));
        txtresult.setBounds(new Rectangle(584, 154, 209, 29));
        jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel10.setText("备注：");
        jLabel10.setBounds(new Rectangle(115, 195, 60, 51));
        cboexaminationdatedate.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cboexaminationdatedate.setBounds(new Rectangle(496, 109, 71, 31));
        cboexaminationdatemonth.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cboexaminationdatemonth.setBounds(new Rectangle(367, 109, 82, 31));
        cboexaminationdateyear.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cboexaminationdateyear.setBounds(new Rectangle(237, 108, 88, 32));
        txaresultremarks.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        txaresultremarks.setBounds(new Rectangle(189, 194, 604, 105));
        btnremarkadd.setBounds(new Rectangle(266, 322, 164, 48));
        btnremarkadd.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        btnremarkadd.setText("添加成绩");
        btnremarkadd.addActionListener(new remarkadd_btnremarkadd_actionAdapter(this));
        btnexit.setBounds(new Rectangle(495, 322, 163, 48));
        btnexit.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        btnexit.setText("退出添加");
        this.add(cboexaminationdatemonth);
        this.add(jLabel1);
        this.add(txtresultstuno);
        this.add(txtresultclassno);
        this.add(jLabel2);
        this.add(jLabel4);
        this.add(cboexaminationdateyear);
        this.add(jLabel5);
        this.add(jLabel6);
        this.add(jLabel7);
        this.add(cboexaminationdatedate);
        this.add(txtexaminationnumber);
        this.add(jLabel8);
        this.add(txtresult);
        this.add(jLabel9);
        this.add(jLabel10);
        this.add(txaresultremarks);
        this.add(btnexit);
        this.add(btnremarkadd);
        this.add(txtlessonteacher);
        this.add(jLabel3);
    }
    String year[] = {"2006", "2007", "2008", "2009"};
    String month[] = { "01", "02", "03", "04", "05", "06", "07",
                     "08",
                     "09",
                     "10", "11", "12"};
    String date[] = { "01", "02", "03", "04", "05", "06", "07",
                    "08",
                    "09",
                    "10", "11", "12", "13", "14", "15", "16", "17",
                    "18", "19", "20", "21", "22", "23", "24", "25",
                    "26", "27", "28", "29", "30", "31"};
    JLabel jLabel1 = new JLabel();
    JTextField txtresultstuno = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField txtresultclassno = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField txtlessonteacher = new JTextField();
    JLabel jLabel4 = new JLabel();
    JComboBox cboexaminationdateyear = new JComboBox(year);
    JLabel jLabel5 = new JLabel();
    JComboBox cboexaminationdatemonth = new JComboBox(month);
    JLabel jLabel6 = new JLabel();
    JComboBox cboexaminationdatedate = new JComboBox(date);
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JTextField txtexaminationnumber = new JTextField();
    JLabel jLabel9 = new JLabel();
    JTextField txtresult = new JTextField();
    JLabel jLabel10 = new JLabel();
    JTextArea txaresultremarks = new JTextArea();
    JButton btnremarkadd = new JButton();
    JButton btnexit = new JButton();
    public void btnremarkadd_actionPerformed(ActionEvent e) {
        try {
            String examinationdatename =
                    this.cboexaminationdateyear.getSelectedItem().toString() + "-" +
                    this.cboexaminationdatemonth.getSelectedItem().toString() + "-" +
                    this.cboexaminationdatedate.getSelectedItem().toString() + " ";
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection("jdbc:odbc:studer");
            PreparedStatement sql = conn.prepareStatement(
                    "insert into result (resultstuno,resultclassno,lessonteacher,examinationdate,examinationnumber,result,resultremarks) values(?,?,?,?,?,?,?)");
            sql.setString(1, this.txtresultstuno.getText());
            sql.setString(2, this.txtresultclassno.getText());
            sql.setString(3, this.txtlessonteacher.getText());
            sql.setString(4, examinationdatename);
            sql.setString(5, this.txtexaminationnumber.getText());
            sql.setString(6, this.txtresult.getText());
            sql.setString(7, this.txaresultremarks.getText());
            int row = sql.executeUpdate();
            if (row > 0) {
                JOptionPane.showMessageDialog(this, "添加成功！");
            } else {
                JOptionPane.showMessageDialog(this, "添加失败！");
            }
            sql.close();
            conn.close();
        } catch (Exception ex) {
            JOptionPane.showMessageDialog(this, "添加失败！");
        }

    }
}


class remarkadd_btnremarkadd_actionAdapter implements ActionListener {
    private remarkadd adaptee;
    remarkadd_btnremarkadd_actionAdapter(remarkadd adaptee) {
        this.adaptee = adaptee;
    }

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