| 提交 | 用户 | 时间 | ||
| 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 | } | |
