specialityproject_add_mod.java~1~

这是一个图书和学生信息的管理系统,它可以在数据库里面增加,修改,删除数据来管理图书和学生信息

package specialityproject;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.*;
import com.zdsoft.gui.*;
import com.zdsoft.util.*;
import com.zdsoft.datacenter.*;
import com.zdsoft.datastore.*;
import com.zdsoft.exception.*;
import java.beans.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */

public class SpecialityProject_add_mod extends ASDialog
{
  SpecialityProject_list sp_list;
  private String oper;
  String titlename[];
  int zyid;
  int kcid;
  int kclxid;
  int kslxid;
  ASDatacenter dc;
  private JPanel jPanel2 = new JPanel();
  private BorderLayout borderLayout1 = new BorderLayout();
  private JPanel jPanel5 = new JPanel();
  private JLabel jLabel12 = new JLabel();
  private TitledBorder titledBorder1;
  private JButton saveButton = new JButton();
  private JPanel jPanel8 = new JPanel();
  private JButton cancelButton = new JButton();
  private JPanel jPanel1 = new JPanel();
  private TitledBorder titledBorder2;
  private BorderLayout borderLayout2 = new BorderLayout();
  private JPanel jPanel9 = new JPanel();
  private TitledBorder titledBorder3;
  private TitledBorder titledBorder4;
  private TitledBorder titledBorder5;
  private GridBagLayout gridBagLayout3 = new GridBagLayout();
  private JLabel jLabel18 = new JLabel();
  private JLabel code = new JLabel();
  private JLabel jLabel20 = new JLabel();
  private ASComboBox kclx = new ASComboBox("kclx_id","kclx_name","kclx_dm","1=1");
  private JLabel jLabel22 = new JLabel();
  private ASComboBox kslx = new ASComboBox("kslx_id","kslx_name","kslx_dm","1=1");
  private JPanel jPanel4 = new JPanel();
  private BorderLayout borderLayout3 = new BorderLayout();
  private TitledBorder titledBorder6;
  private JLabel jLabel17 = new JLabel();
  private JLabel jLabel16 = new JLabel();
  private JLabel jLabel15 = new JLabel();
  private JLabel jLabel14 = new JLabel();
  private JLabel jLabel13 = new JLabel();
  private GridBagLayout gridBagLayout2 = new GridBagLayout();
  private JCheckBox jCheckBox8 = new JCheckBox();
  private JCheckBox jCheckBox7 = new JCheckBox();
  private JCheckBox jCheckBox6 = new JCheckBox();
  private JCheckBox jCheckBox5 = new JCheckBox();
  private JCheckBox jCheckBox3 = new JCheckBox();
  private JCheckBox jCheckBox4 = new JCheckBox();
  private JCheckBox jCheckBox2 = new JCheckBox();
  private JCheckBox jCheckBox1 = new JCheckBox();
  private JLabel jLabel30 = new JLabel();
  private JTextField xkzs_7 = new JTextField();
  private JTextField xkzs_6 = new JTextField();
  private JTextField xkzs_5 = new JTextField();
  private JTextField xkzs_4 = new JTextField();
  private JTextField xkzs_3 = new JTextField();
  private JTextField mzks_2 = new JTextField();
  private JTextField xkzs_2 = new JTextField();
  private JTextField mzks_1 = new JTextField();
  private JTextField xkzs_1 = new JTextField();
  private JLabel jLabel5 = new JLabel();
  private JPanel jPanel7 = new JPanel();
  private JLabel jLabel3 = new JLabel();
  private JLabel jLabel2 = new JLabel();
  private JLabel jLabel1 = new JLabel();
  private JLabel jLabel29 = new JLabel();
  private JLabel jLabel28 = new JLabel();
  private JLabel jLabel27 = new JLabel();
  private JLabel jLabel26 = new JLabel();
  private JLabel jLabel25 = new JLabel();
  private JLabel jLabel24 = new JLabel();
  private JLabel jLabel23 = new JLabel();
  private JTextField mzks_8 = new JTextField();
  private JTextField mzks_7 = new JTextField();
  private JTextField mzks_6 = new JTextField();
  private JTextField mzks_5 = new JTextField();
  private JTextField mzks_4 = new JTextField();
  private JTextField mzks_3 = new JTextField();
  private JTextField xkzs_8 = new JTextField();
  private TitledBorder titledBorder7;
  private JPanel jPanel3 = new JPanel();
  private BorderLayout borderLayout4 = new BorderLayout();
  private GridBagLayout gridBagLayout4 = new GridBagLayout();
  private JLabel jLabel45 = new JLabel();
  private JLabel jLabel44 = new JLabel();
  private JLabel jLabel43 = new JLabel();
  private JLabel jLabel42 = new JLabel();
  private JLabel jLabel41 = new JLabel();
  private JLabel jLabel40 = new JLabel();
  private JTextField knsy = new JTextField();
  private JLabel jLabel37 = new JLabel();
  private JLabel jLabel36 = new JLabel();
  private JLabel jLabel35 = new JLabel();
  private JLabel jLabel34 = new JLabel();
  private JLabel jLabel33 = new JLabel();
  private JTextField kwsj = new JTextField();
  private JTextField kttl = new JTextField();
  private JLabel jLabel32 = new JLabel();
  private JTextField knsj = new JTextField();
  private JPanel jPanel6 = new JPanel();
  private JTextField ktjs = new JTextField();
  private JTextField zx = new JTextField();
  private JLabel jLabel4 = new JLabel();
  private TitledBorder titledBorder8;
  private JTextField zxs = new JTextField();
  private JLabel jLabel6 = new JLabel();
  private JLabel jLabel7 = new JLabel();
  private JLabel jLabel11 = new JLabel();
  private JLabel name = new JLabel();
  private JLabel xz = new JLabel();
  private JLabel jLabel10 = new JLabel();
  private JLabel cc = new JLabel();
  private JLabel jLabel39 = new JLabel();
  private JLabel xxxs = new JLabel();
  private TitledBorder titledBorder9;
  private JPanel jPanel11 = new JPanel();
  private GridBagLayout gridBagLayout1 = new GridBagLayout();
  private JLabel jLabel21 = new JLabel();
  private ASComboBox kcname;
  private JLabel jLabel8 = new JLabel();
  private JLabel jLabel9 = new JLabel();
  private ASDatastore dsm;
  private ASTable tablem;
  private int zy_id;
  private ASDatastore ds_zyinfo;
  private int xqrow;
  private int xqs;
  int kc_id;
  private JLabel jLabel19 = new JLabel();
  private JLabel kcdm = new JLabel();
  private int in;
  private int kclx_id;
  private boolean flagp = false;
  public SpecialityProject_add_mod(SpecialityProject_list sp_list,ASDatastore ds,ASTable table,int zy_id)
  {
    this.oper = "mod";
    this.dsm = ds;
    this.tablem = table;
    this.zy_id = zy_id;
    this.sp_list = sp_list;
    try
    {
      jbInit();

    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
  }
  public SpecialityProject_add_mod(SpecialityProject_list sp_list,int zy_id)
  {
    this.sp_list = sp_list;
    this.oper = "add";
    this.zy_id = zy_id;
    try
    {
      jbInit();

    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
  }
  private void init(){
    try {
      OperData od = new OperData();
      ds_zyinfo = od.getZYInfo(zy_id);
      if(ds_zyinfo.getRowCount()>0){
        code.setText(ds_zyinfo.getItemString(0,"zy_code"));
        name.setText(ds_zyinfo.getItemString(0,"zy_name"));
        xz.setText(ds_zyinfo.getItemString(0,"xz_name"));
        cc.setText(ds_zyinfo.getItemString(0,"cc_name"));
        xxxs.setText(ds_zyinfo.getItemString(0,"xxxs_name"));
        xqs = ds_zyinfo.getItemInteger(0,"xqs").intValue();
        switch(xqs){
          case 1:{
            jCheckBox1.setEnabled(true);
            break;
          }
          case 2:{
            jCheckBox1.setEnabled(true);
            jCheckBox2.setEnabled(true);
            break;
          }
          case 3:{
            jCheckBox1.setEnabled(true);
            jCheckBox2.setEnabled(true);
            jCheckBox3.setEnabled(true);
            break;
          }
          case 4:{
            jCheckBox1.setEnabled(true);
            jCheckBox2.setEnabled(true);
            jCheckBox3.setEnabled(true);
            jCheckBox4.setEnabled(true);
            break;
          }
          case 5:{
            jCheckBox1.setEnabled(true);
            jCheckBox2.setEnabled(true);
            jCheckBox3.setEnabled(true);
            jCheckBox4.setEnabled(true);
            jCheckBox5.setEnabled(true);
            break;
          }
          case 6:{
            jCheckBox1.setEnabled(true);
            jCheckBox2.setEnabled(true);
            jCheckBox3.setEnabled(true);
            jCheckBox4.setEnabled(true);
            jCheckBox5.setEnabled(true);
            jCheckBox6.setEnabled(true);
            break;
          }
          case 7:{
            jCheckBox1.setEnabled(true);
            jCheckBox2.setEnabled(true);
            jCheckBox3.setEnabled(true);
            jCheckBox4.setEnabled(true);
            jCheckBox5.setEnabled(true);
            jCheckBox6.setEnabled(true);
            jCheckBox7.setEnabled(true);
            break;
          }
          case 8:{
            jCheckBox1.setEnabled(true);
            jCheckBox2.setEnabled(true);
            jCheckBox3.setEnabled(true);
            jCheckBox4.setEnabled(true);
            jCheckBox5.setEnabled(true);
            jCheckBox6.setEnabled(true);
            jCheckBox7.setEnabled(true);
            jCheckBox8.setEnabled(true);
            break;
          }
        }
      }
      if(oper.equals("add")){
        ds_zyinfo = od.getKCInfo(zy_id);
        String condiction = "kc_id not in(";
        if(ds_zyinfo.getRowCount()>0){
          for (int i = 0;i<ds_zyinfo.getRowCount();i++){
            condiction += ds_zyinfo.getItemInteger(i,"kc_id").intValue()+",";
          }
          condiction = condiction.substring(0,condiction.length()-1)+")";
          kcname = new ASComboBox("kc_id","kc_name","kc_dm",condiction);
        }
        else
          kcname = new ASComboBox("kc_id","kc_name","kc_dm","1=1");
      }
      else{
        int row = tablem.getSelectedRow();
        jLabel9.setText(dsm.getItemString(row,"kc_name"));
        kc_id = dsm.getItemInteger(row,"kc_id").intValue();
        kcdm.setText(dsm.getItemString(row,"kc_code"));
        kclx_id = dsm.getItemInteger(row,"kclx_id").intValue();
        kclx.setSelectvalue(kclx_id);
        kslx.setSelectvalue(dsm.getItemInteger(row,"kslx_id").intValue());
        zxs.setText(dsm.getItemInteger(row,"kc_hour")+"");
        ktjs.setText(dsm.getItemObject(row,"class_hour")==null?"":dsm.getItemInteger(row,"class_hour")+"");
        zx.setText(dsm.getItemObject(row,"self_hour")==null?"":dsm.getItemInteger(row,"self_hour")+"");
        knsy.setText(dsm.getItemObject(row,"class_experiment")==null?"":dsm.getItemInteger(row,"class_experiment")+"");
        kttl.setText(dsm.getItemObject(row,"class_discuss")==null?"":dsm.getItemInteger(row,"class_discuss")+"");
        knsj.setText(dsm.getItemObject(row,"class_computer")==null?"":dsm.getItemInteger(row,"class_computer")+"");
        kwsj.setText(dsm.getItemObject(row,"self_practice")==null?"":dsm.getItemInteger(row,"self_practice")+"");
        ds_zyinfo = od.getXQInfo(zy_id,kc_id);
        xqrow = ds_zyinfo.getRowCount();
        if(xqrow>0){
          for (int i = 0;i<xqrow;i++){
            int xq = ds_zyinfo.getItemInteger(i,"xq_id").intValue();
            switch(xq){
              case 1:{
                jCheckBox1.setSelected(true);
                xkzs_1.setEditable(true);
                xkzs_1.setEnabled(true);
                xkzs_1.setBackground(Color.white);
                xkzs_1.setText(ds_zyinfo.getItemInteger(i,"xq_week")+"");

                mzks_1.setEditable(true);
                mzks_1.setEnabled(true);
                mzks_1.setBackground(Color.white);
                mzks_1.setText(ds_zyinfo.getItemInteger(i,"week_hour")+"");
                break;