operdata.java

一個學校的教学综合管理系统,包含了很多的功能。

package basecode.bjxx;

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 findallZy_info() {
    ASDatastore ds = null;
    try {
      dc = new ASDatacenter(); //创建数据中心实例
      dc.connect(); //连接相应数据库;
      String sql = "select a.bj_id,a.bj_code,a.bj_name,a.jxd_id,b.jxd_name,a.bj_teacher,a.teacher_phone " +
          "from bj_dm a,jxd_dm b where a.jxd_id = b.jxd_id"; //构造查询语句
      ds = dc.retrieve(sql); //执行数据中心实例的retrieve方法,返回ASDatastore(数据存储器)的一个实例;
      ds.setTitleLable(new String[]{
      "xjdID", "班级代码", "班级名称", "jxd_id","所属教学点","班主任", "班主任电话"});
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    finally {
      dc.disconnect(); //关闭数据库连接
      return ds; //返回ASDatastore类的对象ds
    }
  }

  public String[] addZy_info(Object[] obj) {
    String msg[] = {
        "false", ""};
    int id = 1;
    try {
      dc = new ASDatacenter(); //创建数据中心实例
      dc.connect(); //连接相应数据库;
      String sql = "select count(bj_id) as bj_id from bj_dm";
      ASDatastore ds = dc.retrieve(sql);
      if (ds.getItemInteger(0, "bj_id").intValue() > 0) {
        sql = "select max(bj_id) as bj_id from bj_dm";
        ds = dc.retrieve(sql);
        id = ds.getItemInteger(0, "bj_id").intValue() + 1;
      }
      sql = "insert into bj_dm(bj_id,bj_code,bj_name,jxd_id,bj_teacher,teacher_phone) values (" +
          id +
          ",'" + (String) obj[1] +
          "','" + (String) obj[2] +
          "'," + ( (Integer) obj[3]).intValue() +
          ",'" + (String) obj[4] +
          "','" + (String) obj[5] +
          "')";
      msg = dc.update(sql);
      if (!msg[0].equals("false"))
        msg[1] = id + "";
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    finally {
      dc.disconnect();
      return msg;
    }
  }

  public String[] modZy_info(Object[] obj) {
  String msg[] = {
      "false", ""};
  try {
    dc = new ASDatacenter(); //创建数据中心实例 bj_id =,
    dc.connect(); //连接相应数据库;
    String sql = "update  bj_dm  set bj_code = '" + (String) obj[1] +
        "',bj_name= '" + (String) obj[2] +
        "',jxd_id= " + ((Integer) obj[3]).intValue() +
        ",bj_teacher= '" + (String) obj[4] +
        "',teacher_phone= '" + (String) obj[5] +
        "' where bj_id=" + ( (Integer) obj[0]).intValue();
    msg = dc.update(sql);
  }
  catch (Exception ex) {
    ex.printStackTrace();
  }
  finally {
    dc.disconnect();
    return msg;
  }
}

  public String[] DelByZyid(int zy_id) {
    String msg[] = {
        "false", ""};
    String columnName[];
    try {
      dc = new ASDatacenter();
      dc.connect();
      msg = dc.update("delete from bj_dm where bj_id = " + zy_id);
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    finally {
      dc.disconnect();
      return msg;
    }
  }
}