classdel.java~26~

java语言做的教务管理系统

package java_教务管理系统;

import java.awt.BorderLayout;

import javax.swing.JPanel;
import java.awt.Rectangle;
import javax.swing.JTextArea;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.BorderFactory;
import javax.swing.JTable;
import javax.swing.table.JTableHeader;
import javax.swing.table.DefaultTableModel;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.JOptionPane;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import javax.swing.*;
import java.awt.Font;

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

    private void jbInit() throws Exception {
        this.setLayout(null);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(2, 1, 861, 634));
        jPanel1.setLayout(null);
        txaclassRemarks.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        txaclassRemarks.setBounds(new Rectangle(308, 399, 472, 75));
        cboendtimeyear.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cboendtimeyear.setBounds(new Rectangle(308, 362, 100, 28));
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel1.setText("班级类别：");
        jLabel1.setBounds(new Rectangle(64, 291, 106, 36));
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel2.setText("日");
        jLabel2.setBounds(new Rectangle(662, 328, 33, 31));
        cbobeginstimedate.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cbobeginstimedate.setBounds(new Rectangle(576, 328, 70, 29));
        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel3.setText("日");
        jLabel3.setBounds(new Rectangle(663, 361, 24, 23));
        cbobeginstimeyear.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cbobeginstimeyear.setBounds(new Rectangle(307, 329, 101, 28));
        cbobeginstimemonth.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cbobeginstimemonth.setBounds(new Rectangle(459, 329, 57, 28));
        txtclassno.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtclassno.setBounds(new Rectangle(180, 260, 169, 28));
        cboclassSemester.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cboclassSemester.setBounds(new Rectangle(569, 295, 89, 28));
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel4.setText("月");
        jLabel4.setBounds(new Rectangle(533, 359, 25, 29));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel5.setText("班级编号：");
        jLabel5.setBounds(new Rectangle(63, 260, 110, 28));
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel6.setText("备注：");
        jLabel6.setBounds(new Rectangle(228, 398, 94, 34));
        jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel7.setText("学期：");
        jLabel7.setBounds(new Rectangle(503, 293, 79, 34));
        cboclasscategory.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cboclasscategory.setBounds(new Rectangle(180, 295, 101, 28));
        jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel8.setText("月");
        jLabel8.setBounds(new Rectangle(533, 328, 25, 28));
        jLabel9.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel9.setText("班主任姓名：");
        jLabel9.setBounds(new Rectangle(442, 260, 126, 32));
        cboendtimemonth.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cboendtimemonth.setBounds(new Rectangle(459, 362, 57, 28));
        jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel10.setText("年");
        jLabel10.setBounds(new Rectangle(418, 329, 27, 28));
        cboendtimedate.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cboendtimedate.setBounds(new Rectangle(576, 362, 70, 28));
        txtclassmastername.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtclassmastername.setBounds(new Rectangle(569, 262, 211, 27));
        jLabel11.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel11.setText("毕业时间：");
        jLabel11.setBounds(new Rectangle(192, 362, 113, 37));
        jLabel12.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel12.setText("年");
        jLabel12.setBounds(new Rectangle(418, 359, 25, 30));
        jLabel13.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel13.setText("开学时间：");
        jLabel13.setBounds(new Rectangle(191, 331, 118, 30));
        tbclass.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        tbclass.setBounds(new Rectangle(4, 106, 852, 142));
        tbclass.addMouseListener(new classdel_tbclass_mouseAdapter(this));
        tbclass.addKeyListener(new classdel_tbclass_keyAdapter(this));
        jTableHeader1.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jTableHeader1.setBounds(new Rectangle(6, 82, 850, 24));
        btnclassselect.setBounds(new Rectangle(159, 495, 145, 39));
        btnclassselect.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        btnclassselect.setText("搜索班级");
        btnclassselect.addActionListener(new
                                         classdel_btnclassselect_actionAdapter(this));
        btnexit.setBounds(new Rectangle(547, 495, 145, 38));
        btnexit.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        btnexit.setText("退出删除");
        classdel.setBounds(new Rectangle(346, 495, 145, 39));
        classdel.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        classdel.setText("删除班级");
        classdel.addActionListener(new classdel_classupdate_actionAdapter(this));
        jLabel14.setFont(new java.awt.Font("华文彩云", Font.PLAIN, 50));
        jLabel14.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel14.setText("删除班级信息");
        jLabel14.setBounds(new Rectangle(3, 0, 850, 81));
        jPanel1.add(jLabel14);
        jPanel1.add(jTableHeader1);
        jPanel1.add(tbclass);
        jPanel1.add(classdel);
        jPanel1.add(btnclassselect);
        jPanel1.add(btnexit);
        jPanel1.add(cbobeginstimemonth);
        jPanel1.add(txaclassRemarks);
        jPanel1.add(jLabel3);
        jPanel1.add(jLabel2);
        jPanel1.add(cbobeginstimedate);
        jPanel1.add(cboendtimedate);
        jPanel1.add(jLabel4);
        jPanel1.add(cboendtimemonth);
        jPanel1.add(jLabel8);
        jPanel1.add(jLabel10);
        jPanel1.add(jLabel12);
        jPanel1.add(cboendtimeyear);
        jPanel1.add(cbobeginstimeyear);
        jPanel1.add(jLabel13);
        jPanel1.add(jLabel11);
        jPanel1.add(jLabel6);
        jPanel1.add(cboclasscategory);
        jPanel1.add(jLabel1);
        jPanel1.add(jLabel5);
        jPanel1.add(txtclassno);
        jPanel1.add(jLabel9);
        jPanel1.add(jLabel7);
        jPanel1.add(cboclassSemester);
        jPanel1.add(txtclassmastername);
        this.add(jPanel1);
    }

    String Head[] = {"班级编号", "班主任姓名", "班级类型", "学期", "开学时间", "毕业时间", "备注"};
    DefaultTableModel mod = new DefaultTableModel(Head, 0);
    JTable tbclass = new JTable(mod);
    JTableHeader jTableHeader1 = tbclass.getTableHeader();
    JPanel jPanel1 = new JPanel();
    JTextArea txaclassRemarks = new JTextArea();
    //班级年级
    String Semester[] = {"", "S1", "S2", "Y2"};
    //班级类别
    String category[] = {"", "脱产班", "周末班"};
    //开学时间（年）
    String beginstimeyear[] = {"", "2006", "2007", "2008", "2009"};
    //开学时间（月）
    String beginstimemonth[] = {"", "01", "02", "03", "04", "05", "06", "07",
                               "08",
                               "09",
                               "10", "11", "12"};
    //开学时间（日）
    String beginstimedate[] = {"", "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"};
    //毕业时间（年）
    String endtimeyear[] = {"", "2006", "2007", "2008", "2009"};
    //毕业时间（月）
    String endtimemonth[] = {"", "01", "02", "03", "04", "05", "06", "07", "08",
                            "09",
                            "10", "11", "12"};
    //毕业时间（日）
    String endtimedate[] = {"", "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"};
    JComboBox cboendtimeyear = new JComboBox(endtimeyear);
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JComboBox cbobeginstimedate = new JComboBox(beginstimedate);
    JLabel jLabel3 = new JLabel();
    JComboBox cbobeginstimeyear = new JComboBox(beginstimeyear);
    JComboBox cbobeginstimemonth = new JComboBox(beginstimemonth);
    JTextField txtclassno = new JTextField();
    JComboBox cboclassSemester = new JComboBox(Semester);
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JComboBox cboclasscategory = new JComboBox(category);
    JLabel jLabel8 = new JLabel();