package basecode.kkkk;
import com.zdsoft.datacenter.*;
import com.zdsoft.datastore.*;


public class cccc {
  ASDatacenter dc;
  public ASDatastore abc() {
    ASDatastore ds = null;
    try {
      dc = new ASDatacenter();
      dc.connect();
      String sql = "select * from kc_dm";
      ds = dc.retrieve(sql);
      ds.setTitleLable(new String[] {"課程號", "課程代碼", "課程名"});
    }
    catch (Exception ex) {
      System.out.print("數據庫連接失敗！");
    }
    finally {
      dc.disconnect();
      return ds;
    }
  }

  public String[] abc_add(Object obj[]){
    ASDatastore ds=null;
    int id=1;
    String msg[]={
        "false", ""};
    try {
      dc=new ASDatacenter();
      dc.connect();
      String sql="select count(kc_id) as id from kc_dm";
      ds=dc.retrieve(sql);
      if(ds.getItemInteger(0,"id").intValue()>0){
        sql="select max(kc_id) as id from kc_dm";
        ds=dc.retrieve(sql);
        id=ds.getItemInteger(0,"id").intValue()+1;
      }
      sql="insert into kc_dm(kc_id,kc_code,kc_name) values("+id+",'"+
          (String)obj[0]+"','"+(String)obj[1]+"')";
      msg=dc.update(sql);
      if(msg[0].equals("true")){
        msg[1]=id+"";
      }
    }
    catch(Exception ex){
      System.out.print("error!");
    }
    finally{
      dc.disconnect();
      return msg;
    }
  }
}