remarkdel.java

java语言做的教务管理系统

package java_教务管理系统;

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

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class remarkdel extends JPanel {
    public remarkdel() {
        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(79, 272, 112, 42));
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel2.setText("考试时间：");
        jLabel2.setBounds(new Rectangle(171, 232, 119, 40));
        txtresultstuno.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtresultstuno.setBounds(new Rectangle(189, 161, 166, 28));
        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel3.setText("学号：");
        jLabel3.setBounds(new Rectangle(81, 153, 91, 43));
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel4.setText("任课老师：");
        jLabel4.setBounds(new Rectangle(169, 192, 123, 44));
        txtlessonteacher.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtlessonteacher.setBounds(new Rectangle(292, 198, 277, 28));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel5.setText("课程名称：");
        jLabel5.setBounds(new Rectangle(440, 164, 123, 24));
        txtresult.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtresult.setBounds(new Rectangle(568, 277, 180, 28));
        txaresultremarks.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        txaresultremarks.setBounds(new Rectangle(188, 312, 560, 95));
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel6.setText("成绩：");
        jLabel6.setBounds(new Rectangle(467, 268, 108, 40));
        cboexaminationdatedate.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cboexaminationdatedate.setBounds(new Rectangle(520, 238, 63, 28));
        txtexaminationnumber.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtexaminationnumber.setBounds(new Rectangle(189, 276, 166, 28));
        jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel7.setText("日");
        jLabel7.setBounds(new Rectangle(596, 241, 28, 23));
        cboexaminationdateyear.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cboexaminationdateyear.setBounds(new Rectangle(291, 238, 84, 28));
        cboexaminationdatemonth.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cboexaminationdatemonth.setBounds(new Rectangle(412, 238, 72, 28));
        jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel8.setText("月");
        jLabel8.setBounds(new Rectangle(493, 237, 25, 31));
        jLabel9.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel9.setText("备注：");
        jLabel9.setBounds(new Rectangle(85, 318, 88, 33));
        txtresultclassno.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtresultclassno.setBounds(new Rectangle(568, 162, 180, 28));
        jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel10.setText("年");
        jLabel10.setBounds(new Rectangle(379, 235, 21, 38));
        tbremark.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        tbremark.setBounds(new Rectangle(6, 39, 846, 114));
        tbremark.addMouseListener(new remarkdel_tbremark_mouseAdapter(this));
        jTableHeader1.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jTableHeader1.setBounds(new Rectangle(7, 15, 844, 23));
        brnselect.setBounds(new Rectangle(171, 438, 160, 52));
        brnselect.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        brnselect.setText("搜索成绩");
        brnselect.addActionListener(new remarkdel_brnselect_actionAdapter(this));
        btndel.setBounds(new Rectangle(351, 438, 160, 52));
        btndel.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        btndel.setText("删除成绩");
        btndel.addActionListener(new remarkdel_btndel_actionAdapter(this));
        btnexit.setBounds(new Rectangle(534, 438, 160, 52));
        btnexit.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        btnexit.setText("退出删除");
        this.add(tbremark);
        this.add(jTableHeader1);
        this.add(txtresultclassno);
        this.add(jLabel5);
        this.add(txtresultstuno);
        this.add(jLabel3);
        this.add(jLabel4);
        this.add(txtlessonteacher);
        this.add(jLabel1);
        this.add(txtexaminationnumber);
        this.add(jLabel10);
        this.add(cboexaminationdatemonth);
        this.add(jLabel8);
        this.add(cboexaminationdatedate);
        this.add(jLabel7);
        this.add(cboexaminationdateyear);
        this.add(jLabel2);
        this.add(txtresult);
        this.add(jLabel6);
        this.add(jLabel9);
        this.add(txaresultremarks);
        this.add(btndel);
        this.add(btnexit);
        this.add(brnselect);
    }

    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();
    JLabel jLabel2 = new JLabel();
    JTextField txtresultstuno = new JTextField();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField txtlessonteacher = new JTextField();
    JLabel jLabel5 = new JLabel();
    JTextField txtresult = new JTextField();
    JTextArea txaresultremarks = new JTextArea();
    JLabel jLabel6 = new JLabel();
    JComboBox cboexaminationdatedate = new JComboBox(date);
    JTextField txtexaminationnumber = new JTextField();
    JLabel jLabel7 = new JLabel();
    JComboBox cboexaminationdateyear = new JComboBox(year);
    JComboBox cboexaminationdatemonth = new JComboBox(month);
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JTextField txtresultclassno = new JTextField();
    JLabel jLabel10 = new JLabel();
    String head[] = {"学号", "考试名称", "任课老师", "考试时间", "考试次数", "成绩", "备注"};
    DefaultTableModel mod = new DefaultTableModel(head, 0);
    JTable tbremark = new JTable(mod);
    JTableHeader jTableHeader1 = tbremark.getTableHeader();
    JButton brnselect = new JButton();
    JButton btndel = new JButton();
    JButton btnexit = new JButton();
    String timename =
            this.cboexaminationdateyear.getSelectedItem().toString() + "-" +
            this.cboexaminationdatemonth.getSelectedItem().toString() + "-" +
            this.cboexaminationdatedate.getSelectedItem().toString() + " ";

    public void brnselect_actionPerformed(ActionEvent e) {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection nod = DriverManager.getConnection("jdbc:odbc:studer");
            String daima = "select resultstuno,resultclassno,lessonteacher,examinationdate,examinationnumber,result,resultremarks from result where 1=1";
            if (!this.txtresultstuno.getText().equals("")) {
                daima += " and classno = '" + this.txtresultstuno.getText() +
                        "'";
            }
            if (!this.txtresultclassno.getText().equals("")) {
                daima += " and classmastername ='" +
                        this.txtresultclassno.getText() + "'";
            }
            if (!this.txtlessonteacher.getText().equals("")) {
                daima += " and classcategory ='" +
                        this.txtlessonteacher.getText() + "'";
            }
            if (!this.txtexaminationnumber.getText().equals("")) {
                daima += " and beginstime = '" +
                        this.txtexaminationnumber.getText() + "'";
            }
            if (!this.txtresult.getText().equals("")) {
                daima += " and beginstime = '" + this.txtresult.getText() + "'";
            }if(!this.cboexaminationdateyear.getSelectedItem().toString().equals("")){
                daima+=" and examinationdate like '%"+this.cboexaminationdateyear.getSelectedItem().toString()+"%' ";
            }if(!this.cboexaminationdatemonth.getSelectedItem().toString().equals("")){
                daima+=" and examinationdate like '%"+this.cboexaminationdatemonth.getSelectedItem().toString()+"%'";
            }if(!this.cboexaminationdatedate.getSelectedItem().toString().equals("")){
                daima+=" and examinationdate like '%"+this.cboexaminationdatedate.getSelectedItem().toString()+"%'";
            }

            PreparedStatement sql = nod.prepareStatement(daima);
            ResultSet i = sql.executeQuery();
            mod.setNumRows(0);
            while (i.next()) {
                Object j[] = {i.getString(1), i.getString(2), i.getString(3),
                             i.getString(4), i.getString(5), i.getString(6),
                             i.getString(7)};
                mod.addRow(j);
            }
            tbremark.updateUI();
            i.close();
            sql.close();
            nod.close();
        } catch (Exception ex) {
        }
    }

    public void tbremark_mouseClicked(MouseEvent e) {
        int row = this.tbremark.getSelectedRow();
        if (row > -1) {
            this.txtresultstuno.setText(this.tbremark.getValueAt(row, 0).
                                        toString());
            this.txtresultclassno.setText(this.tbremark.getValueAt(row, 1).
                                          toString());
            this.txtlessonteacher.setText(this.tbremark.getValueAt(row, 2).
                                          toString());
            String examinationdate = this.tbremark.getValueAt(row, 3).toString();
            this.cboexaminationdateyear.setSelectedItem(examinationdate.
                    substring(0, 4));
            this.cboexaminationdatemonth.setSelectedItem(examinationdate.
                    substring(5, 7));
            this.cboexaminationdatedate.setSelectedItem(examinationdate.
                    substring(8, 10));
            this.txtexaminationnumber.setText(this.tbremark.getValueAt(row, 4).
                                              toString());
            this.txtresult.setText(this.tbremark.getValueAt(row, 5).toString());
            this.txaresultremarks.setText(this.tbremark.getValueAt(row, 6).
                                          toString());
        }
    }

    public void btndel_actionPerformed(ActionEvent e) {
        try {
            int row = this.tbremark.getSelectedRow();
            if (JOptionPane.showConfirmDialog(this, "你确定删除吗?", "删除提示",
                                              JOptionPane.OK_CANCEL_OPTION) ==
                JOptionPane.OK_OPTION) {
                if (row < 0) {
                    JOptionPane.showMessageDialog(this, "请选择数据");
                    return;
                }
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection nod = DriverManager.getConnection(
                        "jdbc:odbc:studer");
                PreparedStatement sql = nod.prepareStatement(
                        "delete from result where resultstuno = ?");
                sql.setString(1, this.tbremark.getValueAt(row, 0).toString());
                int i = sql.executeUpdate();
                if (i > 0) {
                    mod.removeRow(row);
                    JOptionPane.showMessageDialog(this, "删除成功");
                } else {
                    JOptionPane.showMessageDialog(this, "删除失败");
                }
                sql.close();
                nod.close();
            }
        } catch (Exception ex) {
        }
    }
}


class remarkdel_tbremark_mouseAdapter extends MouseAdapter {
    private remarkdel adaptee;
    remarkdel_tbremark_mouseAdapter(remarkdel adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.tbremark_mouseClicked(e);
    }
}


class remarkdel_btndel_actionAdapter implements ActionListener {
    private remarkdel adaptee;
    remarkdel_btndel_actionAdapter(remarkdel adaptee) {
        this.adaptee = adaptee;
    }

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


class remarkdel_brnselect_actionAdapter implements ActionListener {
    private remarkdel adaptee;
    remarkdel_brnselect_actionAdapter(remarkdel adaptee) {
        this.adaptee = adaptee;
    }

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