Hibernate插入重复数据

2019独角兽企业重金招聘Python工程师标准>>>

/**
	 * 功能：保存订单
	 * */
	@Override
	public boolean saveStudioOrders(StudioOrders orders) {
		StudioOrders $orders = this.studioOrdersDAO.saveVerification(orders);
		if ($orders != null) {
			orders.setId($orders.getId());
			$orders.setStoreId(orders.getStoreId());
			$orders.setStudioId(orders.getStudioId());
			$orders.setOrderCode(orders.getOrderCode());
			$orders.setOrderPrice(orders.getOrderPrice());
			$orders.setOrderPrePrice(orders.getOrderPrePrice());
			$orders.setOrderOldPrice(orders.getOrderOldPrice());
			$orders.setExpressPrice(orders.getExpressPrice());
			$orders.setOrderPrePriceOrder(orders.getOrderPrePriceOrder());
			$orders.setOrderProfit(orders.getOrderProfit());
			$orders.setOrderSettAmount(orders.getOrderSettAmount());
			$orders.setDivideRebate(orders.getDivideRebate());
			$orders.setDivideRebateAmount(orders.getDivideRebateAmount());
			$orders.setOrderStatus(orders.getOrderStatus());
			$orders.setPayTime(orders.getPayTime());
			$orders.setCustomerId(orders.getCustomerId());
			$orders.setCustomerMobile(orders.getCustomerMobile());
			$orders.setCustomerRemark(orders.getCustomerRemark());
			$orders.setInvoiceTitle(orders.getInvoiceTitle());
			$orders.setInvoiceContent(orders.getInvoiceContent());
			$orders.setCreateDT(orders.getCreateDT());
			$orders.setGoodsList(orders.getGoodsList());
			return this.studioOrdersDAO.saveStudioOrders($orders);
		}
		return false;
	}

public StudioOrders saveVerification(StudioOrders orders) {
		try {
			StringBuffer sql = new StringBuffer();
			sql.append("insert into studio_orders(store_id,studio_id,order_code,status) ");
			sql.append("select ");
			sql.append(String.format("'%s' as store_id,", orders.getStoreId()));
			sql.append(String.format("'%s' as studio_id,", orders.getStudioId()));
			sql.append(String.format("'%s' as order_code,", orders.getOrderCode()));
			sql.append(String.format("'%s' as status ", orders.getStatus().ordinal()));
			sql.append("from dual ");
			sql.append("where not exists");
			sql.append(String.format("(select * from studio_orders where order_code = '%s')", orders.getOrderCode()));
			Integer count = this.baseDAO.excuteSQL(sql.toString(), null);
			if (count != null && count.intValue() >= 1) {
				StudioOrders $orders = this.readStudioOrdersByOrderCode(orders.getOrderCode(), orders.getStoreId());
				if ($orders != null)
					return $orders;
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}

 

转载于:https://my.oschina.net/renliangrong/blog/1634395