学生选课管理系统（数据库实验）

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ /* * DBAframe.java * * Created on 2009-5-9, 21:54:06 */ package db; import java.util.Vector; import javax.swing.JOptionPane; /** * * @author 李明 */ public class DBAframe extends javax.swing.JFrame { /** * */ private static final long serialVersionUID = 1L; /** Creates new form DBAframe */ public DBAframe() { initComponents(); } /** This method is called from within the constructor to * initialize the form. * WARNING: Do NOT modify this code. The content of this method is * always regenerated by the Form Editor. */ private void initComponents() { jPanel1 = new javax.swing.JPanel(); jPanel2 = new javax.swing.JPanel(); jScrollPane2 = new javax.swing.JScrollPane(); jTable = new javax.swing.JTable(); teacher_panel = new javax.swing.JPanel(); jLabel7 = new javax.swing.JLabel(); jLabel8 = new javax.swing.JLabel(); jLabel9 = new javax.swing.JLabel(); jLabel11 = new javax.swing.JLabel(); jLabel12 = new javax.swing.JLabel(); teacher_num = new javax.swing.JTextField(); teacher_name = new javax.swing.JTextField(); teacher_age = new javax.swing.JTextField(); teacher_depart = new javax.swing.JTextField(); teacher_sex = new javax.swing.JComboBox(); jLabel13 = new javax.swing.JLabel(); jTextField4 = new javax.swing.JTextField(); jLabel14 = new javax.swing.JLabel(); jTextField7 = new javax.swing.JTextField(); insertteacher = new javax.swing.JButton(); modifyteacher = new javax.swing.JButton(); search_teacher = new javax.swing.JButton(); stu_modify_panel = new javax.swing.JPanel(); jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); jLabel6 = new javax.swing.JLabel(); stu_num = new javax.swing.JTextField(); stu_name = new javax.swing.JTextField(); stu_age = new javax.swing.JTextField(); stu_depart = new javax.swing.JTextField(); stu_sex = new javax.swing.JComboBox(); jLabel5 = new javax.swing.JLabel(); jTextField3 = new javax.swing.JTextField(); jLabel10 = new javax.swing.JLabel(); jTextField6 = new javax.swing.JTextField(); insertstu = new javax.swing.JButton(); modifystu = new javax.swing.JButton(); search_student = new javax.swing.JButton(); course_panel = new javax.swing.JPanel(); jLabel15 = new javax.swing.JLabel(); jLabel16 = new javax.swing.JLabel(); jLabel17 = new javax.swing.JLabel(); jLabel18 = new javax.swing.JLabel(); insertcourse = new javax.swing.JButton(); course_num = new javax.swing.JTextField(); course_name = new javax.swing.JTextField(); advance_course = new javax.swing.JTextField(); credit = new javax.swing.JTextField(); jLabel19 = new javax.swing.JLabel(); shouke_teacher = new javax.swing.JTextField(); stu_info_panel = new javax.swing.JPanel(); jPanel4 = new javax.swing.JPanel(); method_choice = new javax.swing.JComboBox(); methodField = new javax.swing.JTextField(); searchstuButton = new javax.swing.JButton(); jLabel20 = new javax.swing.JLabel(); jScrollPane3 = new javax.swing.JScrollPane(); stuTable = new javax.swing.JTable(); course_info_panel = new javax.swing.JPanel(); jPanel5 = new javax.swing.JPanel(); methodjcombobox = new javax.swing.JComboBox(); infoField = new javax.swing.JTextField(); searchcourseButton = new javax.swing.JButton(); jLabel21 = new javax.swing.JLabel(); jScrollPane4 = new javax.swing.JScrollPane(); courseTable = new javax.swing.JTable(); jPanel6 = new javax.swing.JPanel(); jLabel22 = new javax.swing.JLabel(); jLabel23 = new javax.swing.JLabel(); jTextField1 = new javax.swing.JTextField(); jTextField2 = new javax.swing.JTextField(); insertdepartButton = new javax.swing.JButton(); modifydepartButton = new javax.swing.JButton(); jPanel3 = new javax.swing.JPanel(); jScrollPane1 = new javax.swing.JScrollPane(); jTree1 = new javax.swing.JTree(); jMenuBar1 = new javax.swing.JMenuBar(); jMenu1 = new javax.swing.JMenu(); jMenuItem2 = new javax.swing.JMenuItem(); jMenuItem3 = new javax.swing.JMenuItem(); jMenuItem4 = new javax.swing.JMenuItem(); jMenu2 = new javax.swing.JMenu(); jMenuItem1 = new javax.swing.JMenuItem(); jMenuItem5 = new javax.swing.JMenuItem(); cardlayout = new java.awt.CardLayout(); con = new Dbconnect(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jPanel2.setLayout(cardlayout); jScrollPane2.setViewportView(jTable); jPanel2.add(jScrollPane2, "card2"); jLabel7.setFont(new java.awt.Font("宋体", 0, 14)); jLabel7.setText("工号"); jLabel8.setFont(new java.awt.Font("宋体", 0, 14)); jLabel8.setText("姓名"); jLabel9.setFont(new java.awt.Font("宋体", 0, 14)); jLabel9.setText("年龄"); jLabel11.setFont(new java.awt.Font("宋体", 0, 14)); jLabel11.setText("性别"); jLabel12.setFont(new java.awt.Font("宋体", 0, 14)); jLabel12.setText("院系"); teacher_num.setFont(new java.awt.Font("宋体", 0, 14)); // NOI18N teacher_name.setFont(new java.awt.Font("宋体", 0, 14)); // NOI18N teacher_age.setFont(new java.awt.Font("宋体", 0, 14)); // NOI18N teacher_depart.setFont(new java.awt.Font("宋体", 0, 14)); // NOI18N teacher_sex.setEditable(true); teacher_sex.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "男", "女" })); jLabel13.setFont(new java.awt.Font("宋体", 0, 14)); jLabel13.setText("电子邮箱"); jTextField4.setFont(new java.awt.Font("宋体", 0, 14)); // NOI18N jLabel14.setFont(new java.awt.Font("宋体", 0, 14)); jLabel14.setText("QQ号码"); jTextField7.setFont(new java.awt.Font("宋体", 0, 14)); // NOI18N insertteacher.setText("添加"); insertteacher.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { insertteacherActionPerformed(evt); } }); modifyteacher.setText("修改"); modifyteacher.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { modifyteacherActionPerformed(evt); } }); search_teacher.setText("查找"); search_teacher.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { search_teacherActionPerformed(evt); } }); javax.swing.GroupLayout teacher_panelLayout = new javax.swing.GroupLayout(teacher_panel); teacher_panel.setLayout(teacher_panelLayout); teacher_panelLayout.setHorizontalGroup( teacher_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(teacher_panelLayout.createSequentialGroup() .addGap(118, 118, 118) .addGroup(teacher_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)