(1)根据条件查询
语法: nc.ui.trade.business.HYPubBO_Client.queryByCondition(VO类,查询条件);
说明: 查询条件 -- 通常只包括where 关键字后面的部分
返回值是一个VO类型的数组
String sql = "initcode = 'DB999'";
SysinittempVO[] sitvo = (SysinittempVO)nc.ui.trade.business.HYPubBO_Client.queryByCondition(SysinittempVO.class,sql);
(2)插入操作
语法: nc.ui.trade.business.HYPubBO_Client.insert(VO类对象);
SysinitVO sysinitvo = new SysinitVO();
sysinitvo.setPk_org("001");
nc.ui.trade.business.HYPubBO_Client.insert(sysinitvo);
(3)更新操作
语法: nc.ui.trade.business.HYPubBO_Client.update(VO数组类型对象);
PmBdAdjustcauseVO[] pbacvo = (PmBdAdjustcauseVO[])nc.ui.trade.business.HYPubBO_Client.queryByCondition(PmBdAdjustcauseVO.class,null);
for(int i = 0; i < pbacvo.length; i++){
pbacvo[i].setVdef1("2/2/2/2/2");
nc.ui.trade.business.HYPubBO_Client.update(pbacvo[i]);
}
(4)删除操作
语法: nc.ui.trade.business.HYPubBO_Client.delete(VO数组类型对象);
String sql = "initcode='DB999'";
SysinttempVO[] sitvo = (SysinttempVO[])nc.ui.trade.business.HYPubBO_Client.queryByCondition(SysinittempVO.class,sql);
nc.ui.trade.business.HYPubBO_Client.delete(sitvo[0]);