New file |
| | |
| | | package cn.exrick.xboot.your.mapper; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import cn.exrick.xboot.your.entity.Violation; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.core.toolkit.Constants; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import org.apache.ibatis.annotations.*; |
| | | import org.apache.ibatis.type.JdbcType; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * 违章记录数据处理层 |
| | | * @author zhangzeli |
| | | */ |
| | | public interface ViolationMapper extends BaseMapper<Violation> { |
| | | |
| | | @Select("SELECT a.*,b.car_no as temp FROM t_violation a LEFT JOIN t_car b ON a.car_id=b.id ${ew.customSqlSegment} ") |
| | | @Results({@Result(column="temp", property="carNo", jdbcType = JdbcType.VARCHAR)}) |
| | | IPage<Violation> page2(Page initMpPage, @Param(Constants.WRAPPER) QueryWrapper<Violation> wrapper); |
| | | } |