车辆表后台

zhangzeli

2021-10-27 6ac20c074838fbe3bb59a262eade2f8dda2f4ca3

车辆表后台

 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/CarController.java

@@ -7,7 +7,9 @@
import cn.exrick.xboot.your.entity.Car;
import cn.exrick.xboot.your.service.ICarService;
import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.segments.MergeSegments;
import com.baomidou.mybatisplus.core.metadata.IPage;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
@@ -49,9 +51,12 @@

    @RequestMapping(value = "/getByPage", method = RequestMethod.GET)
    @ApiOperation(value = "分页获取")
    public Result<IPage<Car>> getByPage(PageVo page) {

        IPage<Car> data = iCarService.page(PageUtil.initMpPage(page));
    public Result<IPage<Car>> getByPage(String carNo,PageVo page) {
        QueryWrapper<Car> wrapper = new QueryWrapper<>();
        if(!StrUtil.isEmpty(carNo)){
            wrapper.like("car_no","%"+carNo+"%");
        }
        IPage<Car> data = iCarService.page(PageUtil.initMpPage(page),wrapper);
        return new ResultUtil<IPage<Car>>().setData(data);
    }


 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/CarMapper.java

@@ -11,6 +11,4 @@
 * @author zhangzeli
 */
public interface CarMapper extends BaseMapper<Car> {

    Car getOneByCarNo(@Param("carNo") String carNo);
}

 xboot-modules/xboot-your/src/main/resources/mapper/CarMapper.xml

@@ -1,12 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.exrick.xboot.your.mapper.CarMapper">

    <select id="getOneByCarNo" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List"/>
        from t_car
        where
        car_no = #{carNo,jdbcType=VARCHAR}
    </select>
</mapper>