oracle插入返回主键&&根据时间获取最新的一条数据

约定不等于承诺〃 2022-06-09 07:22 192阅读 0赞

<select id="queryMaxVehRecordByOutFactory" parameterType="java.util.Map" resultType="com.extracme.volvopark.netty.domain.BrakeOpen">
    	  SELECT 
    	  		orderSeq,vin,orderStatus,timeType
    	  FROM 
    	  (
    		   SELECT 
    				o.ORDER_SEQ orderSeq,v.VIN vin,o.ORDER_STATUS orderStatus,o.TIME_CLASSIFICATION timeType
    			FROM 
    				ORDER_INFO o
    			INNER JOIN   
    				VEHICLE_INFO v
    			ON 
    				o.VIN=v.VIN
    			where   
    				TO_CHAR(SYSDATE , 'YYYYMMDDHH24MI') > o.PLAN_PICKUPTIME
    	   			AND o.REAL_PICKUPTIME IS NOT NULL 
    	    		
    	    		and o.ORDER_TYPE = 2
    				
    				AND (v.RFID =  #{rfid,jdbcType=VARCHAR} or v.RFID1 =  #{rfid,jdbcType=VARCHAR} or v.RFID2 =  #{rfid,jdbcType=VARCHAR} or v.RFID3 =  #{rfid,jdbcType=VARCHAR} or v.RFID4 = #{rfid,jdbcType=VARCHAR})
    			ORDER BY o.PLAN_RETURNTIME DESC 
    		) where rownum=1
     </select> ----------------插入返回主键   
       <insert id="insertParkOrFactoryOut" parameterType="com.extracme.volvopark.netty.domain.VehicleInOutInfo">
        <selectKey resultType="java.lang.Long" order="BEFORE" keyProperty="vehicleInOutInfoSeq">  
          SELECT VEH_INOUT_SEQ.NEXTVAL from DUAL 
       	</selectKey>
        insert into VEHICLE_IN_OUT_INFO
        <trim prefix="(" suffix=")" suffixOverrides=",">
         <if test="vehicleInOutInfoSeq != null">
            VEHICLE_IN_OUT_INFO_SEQ,
          </if>
          <if test="vin != null">
            VIN,
          </if>
       
          
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
       	 <if test="vehicleInOutInfoSeq != null">
          	#{vehicleInOutInfoSeq,jdbcType=DECIMAL},
           </if>
          <if test="vin != null">
            #{vin,jdbcType=VARCHAR},
          </if> </trim>
    
      </insert>
    
    ps：
     
     
     private Long vehicleInOutInfoSeq;