摄像头信息

lxw

2023-09-06 eee6c42d5069316f598c7f0455f9dd93a96d84b8

摄像头信息

 src/main/java/com/whyc/mapper/CarCameraHisMapper.java

@@ -5,5 +5,10 @@
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

public interface CarCameraHisMapper extends CustomMapper<CarCameraHis>{

    //获取门禁历史数据
    List<CarCameraHis> getCarCameraHis(int carCameraId);
}

 src/main/java/com/whyc/pojo/CarCameraHis.java

@@ -19,4 +19,5 @@
    private int status;
    private Date recordTime;
    private int lastStatus;
    private CarCameraInf cameraInf;
}

 src/main/java/com/whyc/service/CarCameraHisService.java

@@ -20,10 +20,7 @@
    //获取门禁历史数据
    public Response getCarCameraHis(int carCameraId,int pageCurr,int pageSize) {
        PageHelper.startPage(pageCurr,pageSize);
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.eq("carcamera_id",carCameraId);
        wrapper.orderByDesc("record_time");
        List<CarCameraHis> list=hisMapper.selectList(wrapper);
        List<CarCameraHis> list=hisMapper.getCarCameraHis(carCameraId);
        PageInfo pageInfo=new PageInfo(list);
        return new Response().setII(1,list.size()>0,pageInfo,"获取门禁历史数据");
    }

 src/main/resources/mapper/CarCameraHisMapper.xml

New file
@@ -0,0 +1,28 @@
<?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="com.whyc.mapper.CarCameraHisMapper">

    <resultMap id="carcameraHis" type="CarCameraHis">
        <id property="num" column="num"></id>
        <result property="recordTime" column="record_time"></result>
        <result property="carcameraId" column="carcamera_id"></result>
        <result property="status" column="status"></result>
        <result property="lastStatus" column="last_status"></result>
        <association property="cameraInf" javaType="com.whyc.pojo.CarCameraInf"
                    column="{carCameraId=carcamera_id}"
                    select="selectCarCameraInf"></association>
    </resultMap>
    <select id="getCarCameraHis" resultMap="carcameraHis">
        SELECT *
        FROM db_environment_inf.tb_carcamera_his
        WHERE carcamera_id = #{carCameraId}
        order by  record_time desc
    </select>

    <select id="selectCarCameraInf" resultType="CarCameraInf">
        SELECT *
        FROM db_environment_inf.tb_carcamera_inf
        WHERE carcamera_id = #{carCameraId}
        limit 1
    </select>
</mapper>