有关NC65通过sql语句对数据库进行操作

//方法一适用与自定义的数据库表查询返回对象

String sqlQueryUrl = "select * from GL_URLCOM where code='PersonDelete'";

IUAPQueryBS bs = NCLocator.getInstance().lookup(IUAPQueryBS.class);
List<Object> listUU = (List<Object>) bs.executeQuery(
sqlQueryUrl.toString(), new ArrayListProcessor());
if (listUU != null && listUU.size() > 0) {


Object[] objs1 = (Object[]) listUU.get(0);
apiUrl = (String) objs1[2];
}

//方法二适用与uap发布并且执行sql建立的数据库表增删改

private BaseDAO dao;


private BaseDAO getDao() {
if (dao == null) {
dao = new BaseDAO();
}
return dao;
}

StringBuffer sql = new StringBuffer();String sqlQueryDept = "select a.code,a.pk_org,a.pk_group from org_dept a left join org_deptcomp b on a.code=b.nccode ";

getDao().executeUpdate(sql.toString());

//方法三 数据库的增删改查

import cn.itf.update.Iupdate;

Iupdate itf = (Iupdate)NCLocator.getInstance().lookup(Iupdate.class);
//增删改

itf.update(sql);

//查询

itf.queryArrangeSaleOrder(sql);