nc65-

1.直接执行update语句

private static BaseDAO bd = null;

private static BaseDAO getBasedao(){undefined

if(bd == null){undefined

bd = new BaseDAO();

}

return bd;

}

getBasedao().executeUpdate(

"UPDATE fhjy_listmaintainb SET kpsqhx =‘N’ WHERE nvl(dr,0)=0 and "

2.SQL语句中添加 in的语句

import nc.ui.bd.ref.RefPubUtil;

RefPubUtil.getInSubSql(“Pk_sample”,codeList.toArray(new String[0]))+ " and nvl(dr,0) = 0 ");

3.查询一个值(两个值)的方法

import nc.jdbc.framework.processor.ColumnProcessor;

dept = getString(iq.executeQuery(sql, new ColumnProcessor()),null);

ArrayList result = (ArrayList) iq.executeQuery(sql, new BeanListProcessor(TaskVO.class));

4.查询多个值的方法

import nc.jdbc.framework.processor.ArrayListProcessor;

public Object[] queryMateiralMes(String pk_material) throws BusinessException {undefined

String sql = “select a.pk_material,a.pk_source,a.pk_measdoc,\n”

• " b.pk_taxcode,c.taxrate from bd_material a,bd_taxcode b ,bd_taxrate c\n"

• “where a.pk_mattaxes = b.mattaxes and b.pk_taxcode = c.pk_taxcode\n”

• “and a.pk_material=’”+pk_material

• “’ and a.latest=‘Y’ and a.enablestate=2\n”

• “and nvl(a.dr,0)=0 and nvl(b.dr,0)=0 and nvl(c.dr,0)=0”;

try {undefined

ArrayList list = (ArrayList) iq.executeQuery(sql,

new ArrayListProcessor());

if (list != null && list.size() > 0) {undefined

Object[] obj = (Object[]) list.get(0);

return obj;

}else{undefined

throw new BusinessException(“未找到”+ pk_material +“对应的物料信息!”);

}

} catch (DAOException e) {undefined

throw new BusinessException(“查找物料信息出错！”+e.getMessage());

}

}

5.流程平台动作处理接口（实现新增，删除，签字，审批，弃审）

//流程平台动作处理 服务接口

IPFBusiAction ifbaction = null;

private IPFBusiAction getIPFBsiAction(){undefined

if(ifbaction == null){undefined

ifbaction = NCLocator.getInstance().lookup(IPFBusiAction.class);

}

return ifbaction;

}

//destBill是aggvo

SapplyBillVO[] obj= (SapplyBillVO[]) getIPFBsiAction().processAction(“WRITE”, “4455”, null, destBill, null, null);

6.判空代码

public static String getString(Object value, String str) {undefined

if (value == null || value.toString().trim().length() == 0) {undefined

return str;

}

return value.toString().trim();

}

7.StringUtils 判断字符串是否为空

StringUtils.isNotEmpty(materialVOs[0].getPk_fac())；

8.ArrayUtils 判断集合是否为空

ArrayUtils.isNotEmpty(facVOs)

9.数据库查询工具（查询一个数组）

DataAccessUtils utils = new DataAccessUtils();

IRowSet rowset = utils.query(sql.toString());

String[] pk_checkbills = rowset.toOneDimensionStringArray();

10.刷新调用

nc.ui.pubapp.uif2app.actions.RefreshSingleAction refreshaction=new RefreshSingleAction();

refreshaction.doAction(e1);

11.根据id查询sm_user表的vo

IUserManageQuery userQry = NCLocator.getInstance().lookup(IUserManageQuery.class);

UserVO user = userQry.getUser(cuserid);

UserVO user = userQry.getUser(cuserid);

12.根据cuserid，明文密码校验

Boolean flag =RbacUserPwdUtil.checkUserPassword(user, oldpwd2);//根据cuserid，明文密码校验

13.根据明文密码和UserVO修改密码

IUserPasswordManage mange = NCLocator.getInstance().lookup(IUserPasswordManage.class);

mange.changeUserPassWord(user, newp