kkcc.java~1~

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

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


public class kkcc {
  ASDatacenter dc;
  public ASDatastore aabb() {
    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[] kkccadd_info(Object obj[]) {

    String msg[] = {
        "false", ""};
    ASDatastore ds = null;
    int id = 1;

    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.println("errer!");
    }
    finally {
      dc.disconnect();
 return msg;
    }

  }
}