merge

	/**
	 * 将bom_libpartattr表中的weight、cost、gmt_created分别移到
	 * bom_refreshattr表中的this_weight、this_cost、this_refresh_time
	 */
	public void refreshCostAndWeight() {
		String sql = "  MERGE INTO bom_refreshattr bre "
					+ " USING bom_libpartattr bli "
					+ " ON (bre.partpn=bli.partpn) "
					+ " WHEN MATCHED THEN "
					+ " 	UPDATE "
					+ " 	SET bre.this_weight = bli.weight,"
					+ " 		bre.this_cost = bli.cost,"
					+ " 		bre.this_refresh_time = bli.gmt_created "
					+ " WHEN NOT MATCHED THEN "
					+ " 	INSERT (bre.id,bre.gmt_created,bre.gmt_modified,bre.partpn,bre.this_weight,bre.this_cost,bre.this_refresh_time) "
					+ " 	VALUES (hibernate_sequence.nextval,sysdate,sysdate,bli.partpn,bli.weight,bli.cost,bli.gmt_created)";
		createSQLQuery(sql).executeUpdate();
	}