package com.mandi.fendan.mapper;
|
|
import com.mandi.fendan.persist.FdVehicleRemark;
|
import org.apache.ibatis.annotations.*;
|
|
public interface FdVehicleRemarkMapper {
|
@Update("update FdVehicleRemark set remark=#{remark},vehicle=#{vehicle} where businessNo =#{businessNO} ")
|
int update(FdVehicleRemark FdVehicleRemark);
|
@Insert("insert into FdVehicleRemark(businessNO,vehicle,remark) values(#{businessNO},#{vehicle},#{remark})")
|
FdVehicleRemark insert(FdVehicleRemark FdVehicleRemark);
|
@Select("select top 1 *from FdVehicleRemark where businessNo=#{businessNO} ")
|
FdVehicleRemark selectByBusinessNo(String businessNO);
|
|
@Delete("delete from FdVehicleRemark where businessNo=#{businessNo}")
|
int deleteByBusinessNo(@Param("businessNo") String businessNo);
|
}
|
