easbos查询及过滤方法.docVIP

1、SQL 操作 1.1 SQl查询，区别客户端和服务端 StringBuffer sql = new StringBuffer(select sum(t.fsublocalamount) as sumSubAmount from t_ht_subcontractbill t where t.fcontractbillid =); sql.append(editData.getId()).append( ); //客户端 ISQLExecutor executor = SQLExecutorFactory.getRemoteInstance(sql.toString()); //服务端 ISQLExecutor executor = SQLExecutorFactory.getLocalInstance(ctx,sql.toString()); IRowSet rs = executor.executeSQL(); if(rs.next())// while(rs.next()) { //... } 1.2 DataUtils使用，注:DbUtil很多模块定义了此工具类，请查看再使用 1.2.1 简单查询 String sql =select t1.fid from ct_ht_serviceproject t1 ,CT_HT_ServiceInvitePro t2 where t1.fid=t2.CFProNameID; //com.kingdee.eas.util.app.DbUtil IRowSet rs=DbUtil.executeQuery(ctx, sql); while(rs.next()){ //... } 1.2.2 参数查询 StringBuffer sb = new StringBuffer(); sb.append( select t1.fid from ct_ht_serviceproject t1 ,CT_HT_ServiceInvitePro t2 where t1.fid=t2.CFProNameID ); sb.append( and t1.fid =? ); sb.append( and t1.fstatus =? ); Object[] params = new Object[2]; params[0] = billID;//方法传递的参数 params[1] = status;//方法传递的参数 return DbUtil.executeQuery(ctx, sql, params); 1.2.3 简单处理执行 StringBuffer sql = new StringBuffer(200); sql.append( /*dialect*/ update CT_HT_ServiceExpertLib t ); sql.append( set t.cfpositiondepnumber =(select a.fnumber from t_org_admin a where a.fid = t.cfpositiondeptid) ); sql.append( where t.cfexpertid =).append(editData.getExpert().getId().toString()).append( ); sql.append( and t.cfpositiondeptid is not null ); DbUtil.execute(ctx,sql); 1.2.4 批处理参数传递执行 StringBuffer sb = new StringBuffer(); sb.append( insert into t_table_xx values(?, ?) ); List paramsList = new ArrayList(); Object[] params1 = new Object[2]; params1[0] = test1; params1[1] = test2; Object[] params2 = new Object[2]; params2[0] = test1; params2[1] = test2; paramsList.add(params2); DbUtil.executeBatch(ctx, sb.toString(), paramsList); 1.2.5 存储过程执行 //mapDate 为存放数据的Map对像 sql = /