ecap操作本地数据库
http://96.0.45.49:9082/sitdev/sitdev数据库96.0.40.136lcsdbecapdev123456重空批量调拨打印T_Ibd_TellerStoringdescribe table T_Ibd_TellerStoringselect * from T_Ibd_TellerStoringselect SourceBranch,ReceiveTeller1,DestinationBranch,ReceiveTeller2 from T_Ibd_TellerStoring where SourceBranch = '06050'
int page_num = 10;String[] elementNames = {"HB_SourceBranch","HB_DefaultString10","HB_DestinationBranch","HB_ReceiveTeller"};String[] elementNames_num = {"HB_Transaction_Detail_LEN"};String sql = "select SourceBranch,ReceiveTeller1,DestinationBranch,ReceiveTeller2 from T_Ibd_TellerStoring where SourceBranch = '06050'";String sql_num = "select count(*) from T_Ibd_TellerStoring where SourceBranch = '06050'";if($ECAP_NOWPAGENUM == null || "".equals($ECAP_NOWPAGENUM) || $ECAP_NOWPAGENUM == 0){ $ECAP_NOWPAGENUM = 1;}int st_no = (($ECAP_NOWPAGENUM - 1) * page_num) + 1;com.adtec.client.util.DataPoolTool.deleteElementValues(com.adtec.struct.ECAPTxRunInfo.getInstance().getIpID(), elementNames);com.adtec.client.DBServiceTool.selectIntoDataPool(sql,st_no,page_num,elementNames);com.adtec.client.util.DataPoolTool.deleteElementValues(com.adtec.struct.ECAPTxRunInfo.getInstance().getIpID(), elementNames_num);com.adtec.client.DBServiceTool.selectIntoDataPool(sql_num,1,1,elementNames_num);$ECAP_ALLPAGENUM = (($HB_Transaction_Detail_LEN)/page_num) + 1;