operdate.java

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

package basecode.xqsz;

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 OperDate {
  ASDatacenter dc;//数据中心对象
 public ASDatastore findallZy_info() {
   ASDatastore ds = null;
   try {
     dc = new ASDatacenter(); //创建数据中心实例
     dc.connect(); //连接相应数据库;
     String sql = "select xq_id,xq_name " +
         "from xq_dm "; //构造查询语句
     ds = dc.retrieve(sql); //执行数据中心实例的retrieve方法,返回ASDatastore(数据存储器)的一个实例;
     ds.setTitleLable(new String[]{
     "xq_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(xq_id) as xq_id from xq_dm";
     ASDatastore ds = dc.retrieve(sql);
     if (ds.getItemInteger(0, "xq_id").intValue() > 0) {
       sql = "select max(xq_id) as xq_id from xq_dm";
       ds = dc.retrieve(sql);
       id = ds.getItemInteger(0, "xq_id").intValue() + 1;
     }
     sql = "insert into xq_dm(xq_id,xq_name) values (" +
         id +
         ",'" + (String) obj[1] +
                  "')";
     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  xq_dm  set xq_name = '" + (String) obj[1] +"'"+
             " where xq_id=" + ( (Integer) obj[0]).intValue();
   System.out.println(sql);
   msg = dc.update(sql);
 }
 catch (Exception ex) {
   ex.printStackTrace();
 }
 finally {
   dc.disconnect();
   return msg;
 }
}

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

}