hjg
2023-10-08 a966b5abe5fb804464fe1cd09053a03fe94877fd
提交 | 用户 | 时间
1c4e40 1 package com.mandi.fendan.mapper;
A 2
3 import com.mandi.fendan.persist.FdVehicleRemark;
4 import org.apache.ibatis.annotations.*;
5
6 public interface FdVehicleRemarkMapper {
7     @Update("update FdVehicleRemark set remark=#{remark},vehicle=#{vehicle}  where businessNo =#{businessNO} ")
8     int update(FdVehicleRemark FdVehicleRemark);
9     @Insert("insert into FdVehicleRemark(businessNO,vehicle,remark) values(#{businessNO},#{vehicle},#{remark})")
10     FdVehicleRemark insert(FdVehicleRemark FdVehicleRemark);
11     @Select("select top 1 *from FdVehicleRemark where businessNo=#{businessNO} ")
12     FdVehicleRemark selectByBusinessNo(String businessNO);
13
14     @Delete("delete from FdVehicleRemark where businessNo=#{businessNo}")
15     int deleteByBusinessNo(@Param("businessNo") String businessNo);
16 }