/**
* 保存/更新 中间库客商信息
* @param custBasVos
* @throws BusinessException
*/
// private void inputSupplier(SupplierDefineVO[] SupplierDefineVOs) throws BusinessException {
// Statement stmt = null;
// ResultSet rs = null;
// PreparedStatement pstmtinsert = null;
// PreparedStatement pstmtupdate = null;
// UFBoolean status = UFBoolean.TRUE;
// if(SupplierDefineVOs == null || SupplierDefineVOs.length == 0){
// throw new BusinessException("客商信息不存在!");
// }
// String sqlinsert = "insert into bd_cubasdoc(conaddr,custcode,custname,custprop,custshortname,linkman1,memo,phone1,pk_areacl,pk_corp," +
// "taxpayerid,pk_cubasdoc,def1,def2,def3,def4,def5,nratetype,sealflag_b,def6,def7,def8,def9,def10,def11,def12,def17,def18)" +
// "VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" ;
// String sqlupdate = "update bd_cubasdoc set conaddr=?,custcode=?,custname=?,custprop=?,custshortname=?,linkman1=?,memo=?,phone1=?,pk_areacl=?,pk_corp=?," +
// "taxpayerid=?,def1=?,def2=?,def3=?,def4=?,def5=?,nratetype=?,sealflag_b=?,def6=?,def7=?,def8=?,def9=?,def10=?,def11=?,def12=?,def17=?,def18=? where pk_cubasdoc=?" ;
// try{
// // 获取数据库连接
// InitEvn.getConnection();
// //获取Statement
// stmt = InitEvn.conn.createStatement();
// //设置事务属性
// InitEvn.conn.setAutoCommit(false);
// // 建立Statement对象
// pstmtinsert = InitEvn.conn.prepareStatement(sqlinsert,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
// pstmtupdate = InitEvn.conn.prepareStatement(sqlupdate,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
// int i=0;
// int j=0;
// for (SupplierDefineVO supplierDefineVO : SupplierDefineVOs) {
// //判断中间表中是否已存在此条客商信息
// //String custcode = (String) bo.findColValue("bd_cubasdoc", "custcode", "pk_cubasdoc = '" + supplierDefineVO.getPk_cubasdoc()+ "'");
// String sql="select * from bd_cubasdoc where pk_cubasdoc='"+supplierDefineVO.getPk_cubasdoc()+ "'";
// // 执行数据库查询语句
// rs = stmt.executeQuery(sql);
// //更新
// if(rs.next()){
// pstmtupdate.setString(1, supplierDefineVO.getConaddr());
// pstmtupdate.setString(2, supplierDefineVO.getCustcode());
// pstmtupdate.setString(3, supplierDefineVO.getCustname());
// pstmtupdate.setInt(4, supplierDefineVO.getCustprop());
// pstmtupdate.setString(5, supplierDefineVO.getCustshortname());
// pstmtupdate.setString(6, supplierDefineVO.getLinkman1());
// pstmtupdate.setString(7, supplierDefineVO.getMemo());
// pstmtupdate.setString(8, supplierDefineVO.getPhone1());
// pstmtupdate.setString(9, supplierDefineVO.getPk_areacl());
// pstmtupdate.setString(10, supplierDefineVO.getPk_corp());
// pstmtupdate.setString(11, supplierDefineVO.getTaxpayerid());//
// pstmtupdate.setString(12, supplierDefineVO.getDef1());
// pstmtupdate.setString(13, supplierDefineVO.getDef2());
// pstmtupdate.setString(14, supplierDefineVO.getDef3());
// pstmtupdate.setString(15, supplierDefineVO.getDef4());
// pstmtupdate.setString(16, supplierDefineVO.getDef5());
// pstmtupdate.setString(17, supplierDefineVO.getNratetype());
// pstmtupdate.setString(18, supplierDefineVO.getSealflag_b());
// pstmtupdate.setString(19, supplierDefineVO.getDef6());
// pstmtupdate.setString(20, supplierDefineVO.getDef7());
// pstmtupdate.setString(21, supplierDefineVO.getDef8());
// pstmtupdate.setString(22, supplierDefineVO.getDef9());
// pstmtupdate.setString(23, supplierDefineVO.getDef10());
// pstmtupdate.setString(24, supplierDefineVO.getDef11());
// pstmtupdate.setString(25, supplierDefineVO.getDef12());
// pstmtupdate.setString(26, supplierDefineVO.getDef17());
// pstmtupdate.setString(27, supplierDefineVO.getDef18());
// pstmtupdate.setString(28,supplierDefineVO.getPk_cubasdoc());
pstmtupdate2.addBatch();
// pstmtupdate.executeUpdate();
// i++;
// //插入
// }else{
// pstmtinsert.setString(1, supplierDefineVO.getConaddr());
// pstmtinsert.setString(2, supplierDefineVO.getCustcode());
// pstmtinsert.setString(3, supplierDefineVO.getCustname());
// pstmtinsert.setInt(4, supplierDefineVO.getCustprop());
// pstmtinsert.setString(5, supplierDefineVO.getCustshortname());
// pstmtinsert.setString(6, supplierDefineVO.getLinkman1());
// pstmtinsert.setString(7, supplierDefineVO.getMemo());
// pstmtinsert.setString(8, supplierDefineVO.getPhone1());
// pstmtinsert.setString(9, supplierDefineVO.getPk_areacl());
// pstmtinsert.setString(10, supplierDefineVO.getPk_corp());
// pstmtinsert.setString(11, supplierDefineVO.getTaxpayerid());//
// pstmtinsert.setString(12,supplierDefineVO.getPk_cubasdoc());//
// pstmtinsert.setString(13, supplierDefineVO.getDef1());
// pstmtinsert.setString(14, supplierDefineVO.getDef2());
// pstmtinsert.setString(15, supplierDefineVO.getDef3());
// pstmtinsert.setString(16, supplierDefineVO.getDef4());
// pstmtinsert.setString(17, supplierDefineVO.getDef5());
// pstmtinsert.setString(18, supplierDefineVO.getNratetype());
// pstmtinsert.setString(19, supplierDefineVO.getSealflag_b());
// pstmtinsert.setString(20, supplierDefineVO.getDef6());
// pstmtinsert.setString(21, supplierDefineVO.getDef7());
// pstmtinsert.setString(22, supplierDefineVO.getDef8());
// pstmtinsert.setString(23, supplierDefineVO.getDef9());
// pstmtinsert.setString(24, supplierDefineVO.getDef10());
// pstmtinsert.setString(25, supplierDefineVO.getDef11());
// pstmtinsert.setString(26, supplierDefineVO.getDef12());
// pstmtinsert.setString(27, supplierDefineVO.getDef17());
// pstmtinsert.setString(28, supplierDefineVO.getDef18());
pstmtinsert.addBatch();
// pstmtinsert.execute();
// j++;
// }
// }
pstmtinsert.executeBatch();
pstmtupdate2.executeBatch();
// LoggerUtil.outputLog("success", "更新客商信息"+i+"条,插入客商信息"+j+"条", modle, status);
// //提交,设置事务初始值
// InitEvn.conn.commit();
// InitEvn.conn.setAutoCommit(true);
// }catch(Exception e){
// e.printStackTrace();
// LoggerUtil.outputLog("error", "查询数据异常>>>>>>>>>>>>>>>>"+e.getMessage(), modle, status);
// throw new BusinessException("查询数据异常>>>>>>>>>>>>>>>>" + e.getMessage(), e);
// }finally{
// //关闭数据源
// InitEvn.releaseConnection();
// }
// }
jdbc保存和更新方法示例
最新推荐文章于 2024-01-09 10:25:00 发布