operdata.java~2~

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

package specialityproject;

import com.zdsoft.datacenter.*;
import com.zdsoft.datastore.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */

public class OperData{
  ASDatacenter dc;//数据中心对象
  public ASDatastore getZYKCByKCLX(int zy_id,int kclx_id) {
    ASDatastore ds = null;
    try {
      dc = new ASDatacenter(); //创建数据中心实例
      dc.connect(); //连接相应数据库;
      String sql = "select b.xqs as xqs from zy_dm a ,xz_dm b where a.zy_id = "+zy_id+" and a.xz_id = b.xz_id";
      ds = dc.retrieve(sql);

      sql = "select a.zy_id,a.kc_id,c.kc_code,c.kc_name,a.kclx_id,d.kclx_name,a.kslx_id,e.kslx_name,a.kc_hour,a.class_hour,a.self_hour,"+
            "a.class_experiment,a.class_discuss,a.class_computer,a.self_practice,";
      int xqs = ds.getItemInteger(0,"xqs").intValue();
      String table_tmp;
      for(int i = 1;i<=xqs;i++){
        table_tmp = "b"+i;
        sql += "(select week_hour from zy_kc_xq "+table_tmp+" where a.zy_id = "+table_tmp+".zy_id and a.kc_id = "+table_tmp+".kc_id and "+table_tmp+".xq_id ="+i+") as week_hour"+i+",";
      }
      sql = sql.substring(0,sql.length()-1);
      sql+=" from zy_kc_hour a, kc_dm c,kclx_dm d ,kslx_dm e where a.kslx_id = e.kslx_id and a.kclx_id = d.kclx_id and a.kc_id = c.kc_id and a.zy_id = "+zy_id+" and a.kclx_id = "+kclx_id;
      ds = dc.retrieve(sql);
      switch (xqs){
        case 1:{
          ds.setTitleLable(new String[]{
            "zy_id", "kc_id", "课程代码", "课程名称","kclx_id","课程类型","kslx_id","考试类型",
            "总学时","课堂讲授学时","自学学时","课内实验学时","课堂讨论学时","课内上机学时",
              "课外实践","第一学期(周学时)"});
          break;
        }
      case 2:{
        ds.setTitleLable(new String[]{
          "zy_id", "kc_id", "课程代码", "课程名称","kclx_id","课程类型","kslx_id","考试类型",
          "总学时","课堂讲授学时","自学学时","课内实验学时","课堂讨论学时","课内上机学时",
            "课外实践","第一学期(周学时)","第二学期(周学时)"});
        break;
      }
    case 3:{
      ds.setTitleLable(new String[]{
        "zy_id", "kc_id", "课程代码", "课程名称","kclx_id","课程类型","kslx_id","考试类型",
        "总学时","课堂讲授学时","自学学时","课内实验学时","课堂讨论学时","课内上机学时",
          "课外实践","第一学期(周学时)","第二学期(周学时)","第三学期(周学时)"});
      break;
    }
  case 4:{
    ds.setTitleLable(new String[]{
      "zy_id", "kc_id", "课程代码", "课程名称","kclx_id","课程类型","kslx_id","考试类型",
      "总学时","课堂讲授学时","自学学时","课内实验学时","课堂讨论学时","课内上机学时",
        "课外实践","第一学期(周学时)","第二学期(周学时)","第三学期(周学时)","第四学期(周学时)"});
    break;
  }
case 5:{
  ds.setTitleLable(new String[]{
    "zy_id", "kc_id", "课程代码", "课程名称","kclx_id","课程类型","kslx_id","考试类型",
    "总学时","课堂讲授学时","自学学时","课内实验学时","课堂讨论学时","课内上机学时",
    "课外实践","第一学期(周学时)","第二学期(周学时)","第三学期(周学时)","第四学期(周学时)",
      "第五学期(周学时)"});
  break;
}
case 6:{
  ds.setTitleLable(new String[]{
    "zy_id", "kc_id", "课程代码", "课程名称","kclx_id","课程类型","kslx_id","考试类型",
    "总学时","课堂讲授学时","自学学时","课内实验学时","课堂讨论学时","课内上机学时",
    "课外实践","第一学期(周学时)","第二学期(周学时)","第三学期(周学时)","第四学期(周学时)",
      "第五学期(周学时)","第六学期(周学时)"});
  break;
}
case 7:{
  ds.setTitleLable(new String[]{
    "zy_id", "kc_id", "课程代码", "课程名称","kclx_id","课程类型","kslx_id","考试类型",
    "总学时","课堂讲授学时","自学学时","课内实验学时","课堂讨论学时","课内上机学时",
    "课外实践","第一学期(周学时)","第二学期(周学时)","第三学期(周学时)","第四学期(周学时)",
      "第五学期(周学时)","第六学期(周学时)","第七学期(周学时)"});
  break;
}
case 8:{
  ds.setTitleLable(new String[]{
    "zy_id", "kc_id", "课程代码", "课程名称","kclx_id","课程类型","kslx_id","考试类型",
    "总学时","课堂讲授学时","自学学时","课内实验学时","课堂讨论学时","课内上机学时",
    "课外实践","第一学期(周学时)","第二学期(周学时)","第三学期(周学时)","第四学期(周学时)",
      "第五学期(周学时)","第六学期(周学时)","第七学期(周学时)","第八学期(周学时)"});
  break;
}
      }

    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    finally {
      dc.disconnect(); //关闭数据库连接
      return ds; //返回ASDatastore类的对象ds
    }
  }

  public ASDatastore getKCLXcount() {
    ASDatastore ds = null;
    try {
      dc = new ASDatacenter(); //创建数据中心实例
      dc.connect(); //连接相应数据库;
      String sql = "select * from kclx_dm"; //构造查询语句
      ds = dc.retrieve(sql); //执行数据中心实例的retrieve方法,返回ASDatastore(数据存储器)的一个实例;
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    finally {
      dc.disconnect(); //关闭数据库连接
      return ds; //返回ASDatastore类的对象ds
    }
  }

  public ASDatastore getZYInfo(int zy_id) {
    ASDatastore ds = null;
    try {
      dc = new ASDatacenter(); //创建数据中心实例
      dc.connect(); //连接相应数据库;
      String sql = "select a.zy_code,a.zy_name,b.xqs,b.xz_name,c.cc_name,d.xxxs_name from zy_dm a,xq_dm b,cc_dm c, xxxs_dm d where a.xz_id = b.xz_id"+
                   " and a.cc_id = c.cc_id and a.xxxs_id = d.xxxs_id and a.zy_id="+zy_id; //构造查询语句
      ds = dc.retrieve(sql); //执行数据中心实例的retrieve方法,返回ASDatastore(数据存储器)的一个实例;
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    finally {
      dc.disconnect(); //关闭数据库连接
      return ds; //返回ASDatastore类的对象ds
    }
  }
  public String getKCCode(int kc_id) {
    ASDatastore ds = null;
    String code ="";
    try {
      dc = new ASDatacenter(); //创建数据中心实例
      dc.connect(); //连接相应数据库;
      String sql = "select kc_code from kc_dm where kc_id="+kc_id; //构造查询语句
      ds = dc.retrieve(sql); //执行数据中心实例的retrieve方法,返回ASDatastore(数据存储器)的一个实例;
      code = ds.getItemString(0,"kc_code");
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    finally {
      dc.disconnect(); //关闭数据库连接
      return code;
    }
  }
  public ASDatastore getKCInfo(int zy_id) {
    ASDatastore ds = null;
    try {
      dc = new ASDatacenter(); //创建数据中心实例
      dc.connect(); //连接相应数据库;
      String sql = "select kc_id from zy_kc_hour where zy_id="+zy_id; //构造查询语句
      ds = dc.retrieve(sql); //执行数据中心实例的retrieve方法,返回ASDatastore(数据存储器)的一个实例;
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    finally {
      dc.disconnect(); //关闭数据库连接
      return ds; //返回ASDatastore类的对象ds
    }
  }
  public ASDatastore getXQInfo(int zy_id,int kc_id) {
    ASDatastore ds = null;
    try {
      dc = new ASDatacenter(); //创建数据中心实例
      dc.connect(); //连接相应数据库;
      String sql  = "select * from zy_kc_xq where zy_id = "+zy_id + " and kc_id = "+kc_id;
      ds = dc.retrieve(sql); //执行数据中心实例的retrieve方法,返回ASDatastore(数据存储器)的一个实例;
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    finally {
      dc.disconnect(); //关闭数据库连接
      return ds; //返回ASDatastore类的对象ds
    }
  }
  public String[] addZYJHinfo(Object[] obj,Object[][] objxq) {
    boolean flag = true;