classinfo.java

S1项目本需求规格说明描述了北大青鸟ACCP教学管理系统项目的要求

                   }
                   this.txtClassNo.setText("");
                   this.txtMaster.setText("");
                   this.txaRemark.setText("");
                   this.cmbType.setSelectedItem("");
                   this.cmbTerm.setSelectedItem("");
                   this.txtBeginDate.setText("");
                   this.txtEndDate.setText("");

                   sql.close();
                   nod.close();
               }
           } catch (Exception ex) {
               ex.printStackTrace();

           }

    }

    public void btnshuaxin_actionPerformed(ActionEvent e) {
               this.txtClassNo.setText("");
               this.cmbType.setSelectedItem("");
               this.cmbTerm.setSelectedItem("");
               this.txtMaster.setText("");
               this.txtBeginDate.setText("");
               this.txtEndDate.setText("");
                this.txaRemark.setText("");
    }

    public void bntjiansuo_actionPerformed(ActionEvent e) {
        try {
                       String sql="select ClassNo,ClassType,Term,Master,BeginDate,EndDate,Remark from ClassInfo where 1=1 ";
                       /*if (!this.txtClassNo.getText().equals("")) {
                           sql += " and ClassNo = '" + this.txtClassNo.getText() + "'";
                       }
                       if (!categoryname.equals("")) {
                           sql += " and ClassType ='" + categoryname + "'";
                       }
                       if (!Semestername.equals("")) {
                           sql += " and ClassTerm ='" + Semestername + "'";
                       }
                       if(this.txtMaster.getText().length()>0){
                           sql+=" and Master like '%"+this.txtMaster.getText()+"%'";
                       }
                       if(this.txtBeginDate.getText().length()>0){
                           sql+=" and BeginDate like '%"+this.txtBeginDate.getText()+"%'";
                       }
                       if(this.txtEndDate.getText().length()>0){
                           sql+=" and EndDate like '%"+this.txtEndDate.getText()+"%'";
                       }
                       if(this.txaRemark.getText().length()>0){
                           sql+=" and Remark like '%"+this.txaRemark.getText()+"%'";
                       }*/
                       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                       Connection conn = DriverManager.getConnection("jdbc:odbc:xiangmu");
                       PreparedStatement ps = conn.prepareStatement(sql);
                       ResultSet rs= ps.executeQuery();
                       bg.setRowCount(0);
                       while(rs.next()){
                           Object val[]={rs.getString(1),rs.getString(2),
                           rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),
                        rs.getString(7)};
                        bg.addRow(val);
                       }
                       jTable1.updateUI();
                       rs.close();
                       ps.close();
                       conn.close();
                   }
                 catch (Exception ex) {
                       JOptionPane.showMessageDialog(this, "检索失败！");
            }

    }

    public void jTable1_mouseClicked(MouseEvent e) {
        int row = this.jTable1.getSelectedRow();
        if (row > -1) {
            this.txtClassNo.setText(this.jTable1.getValueAt(row, 0).toString());
            this.cmbType.setSelectedItem(this.jTable1.getValueAt(row, 1).toString());
            this.cmbTerm.setSelectedItem(this.jTable1.getValueAt(row, 2).toString());
            this.txtMaster.setText(this.jTable1.getValueAt(row, 3).
                                            toString());
            this.txtBeginDate.setText(this.jTable1.getValueAt(row, 4).
                                            toString());
            this.txtEndDate.setText(this.jTable1.getValueAt(row, 5).
                                            toString());
            this.txaRemark.setText(this.jTable1.getValueAt(row, 6).
                                         toString());
        }
    }

    public void btnEdit_actionPerformed(ActionEvent e) {
        try {
                      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动程序
                      Connection conn = DriverManager.getConnection("jdbc:odbc:xiangmu");//注册驱动并连接数据库
                      PreparedStatement ps = conn.prepareStatement(
                              "update ClassInfo set ClassNo=?,ClassType=?,Term=?,Master=?,BeginDate=?,EndDate=?,Remark=? where ClassNo=?");//创建执行语句的对象
                      int selRow=jTable1.getSelectedRow();
                      ps.setString(2, this.cmbType.getSelectedItem().toString());
                      ps.setString(1, this.txtClassNo.getText());
                      ps.setString(3, this.cmbTerm.getSelectedItem().toString());
                      ps.setString(4, this.txtMaster.getText());
                      ps.setString(5, this.txtBeginDate.getText());
                      ps.setString(6, this.txtEndDate.getText());
                      ps.setString(7, this.txaRemark.getText());
                      ps.setString(8,jTable1.getValueAt(selRow,0).toString());
                      int rows = ps.executeUpdate();//执行语句,返回受影响行数
                      if (rows > 0) {
                          jTable1.setValueAt(this.cmbType.getSelectedItem().toString(),selRow,1);
                          jTable1.setValueAt(this.txtClassNo.getText(),selRow,0);
                          jTable1.setValueAt(this.cmbTerm.getSelectedItem().toString(),selRow,2);
                          jTable1.setValueAt(this.txtMaster.getText(),selRow,3);
                          jTable1.setValueAt(this.txtBeginDate.getText(),selRow,4);
                          jTable1.setValueAt(this.txtEndDate.getText(),selRow,5);
                          jTable1.setValueAt(this.txaRemark.getText(),selRow,6);
                          JOptionPane.showMessageDialog(this, "修改成功！");
                      } else {
                          JOptionPane.showMessageDialog(this, "修改失败！");
                      }
                      ps.close();
                      conn.close();
                  } catch (Exception ex) {
                      JOptionPane.showMessageDialog(this, "修改失败！");
           }

    }

    public void this_windowOpened(WindowEvent e) {
        denglu obj = new denglu();
        userType = obj.cmbUserType.getSelectedItem().toString();
        if (denglu.userType.equals("普通用户")) {
            this.btnEdit.setEnabled(false);
            this.btnDel.setEnabled(false);
        }
    }
}


class ClassInfo_btnEdit_actionAdapter implements ActionListener {
    private ClassInfo adaptee;
    ClassInfo_btnEdit_actionAdapter(ClassInfo adaptee) {
        this.adaptee = adaptee;
    }

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


class ClassInfo_jTable1_mouseAdapter extends MouseAdapter {
    private ClassInfo adaptee;
    ClassInfo_jTable1_mouseAdapter(ClassInfo adaptee) {
        this.adaptee = adaptee;
    }

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


class ClassInfo_jTable1_mouseMotionAdapter extends MouseMotionAdapter {
    private ClassInfo adaptee;
    ClassInfo_jTable1_mouseMotionAdapter(ClassInfo adaptee) {
        this.adaptee = adaptee;
    }
}


class ClassInfo_jScrollPane1_mouseMotionAdapter extends MouseMotionAdapter {
    private ClassInfo adaptee;
    ClassInfo_jScrollPane1_mouseMotionAdapter(ClassInfo adaptee) {
        this.adaptee = adaptee;
    }
}


class ClassInfo_bntjiansuo_actionAdapter implements ActionListener {
    private ClassInfo adaptee;
    ClassInfo_bntjiansuo_actionAdapter(ClassInfo adaptee) {
        this.adaptee = adaptee;
    }

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


class ClassInfo_btnshuaxin_actionAdapter implements ActionListener {
    private ClassInfo adaptee;
    ClassInfo_btnshuaxin_actionAdapter(ClassInfo adaptee) {
        this.adaptee = adaptee;
    }

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


class ClassInfo_btnAdd_actionAdapter implements ActionListener {
    private ClassInfo adaptee;
    ClassInfo_btnAdd_actionAdapter(ClassInfo adaptee) {
        this.adaptee = adaptee;
    }

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


class ClassInfo_this_windowAdapter extends WindowAdapter {
    private ClassInfo adaptee;
    ClassInfo_this_windowAdapter(ClassInfo adaptee) {
        this.adaptee = adaptee;
    }

    public void windowOpened(WindowEvent e) {
        adaptee.this_windowOpened(e);
    }
}


class ClassInfo_btnDel_actionAdapter implements ActionListener {
    private ClassInfo adaptee;
    ClassInfo_btnDel_actionAdapter(ClassInfo adaptee) {
        this.adaptee = adaptee;
    }

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


class ClassInfo_btnExit_actionAdapter implements ActionListener {
    private ClassInfo adaptee;
    ClassInfo_btnExit_actionAdapter(ClassInfo adaptee) {
        this.adaptee = adaptee;
    }

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