添加新的三张数据库表格

riku

2019-09-02 733060b40566eb40969ec69e450d1fb24f4b579c

添加新的三张数据库表格

 src/main/kotlin/com/flightfeather/obd/domain/entity/AlarmData.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,619 @@
package com.flightfeather.obd.domain.entity;

import java.util.Date;
import javax.persistence.*;

@Table(name = "obd_alarm_data")
public class AlarmData {
    @Id
    private Integer id;

    @Column(name = "obd_vin")
    private String obdVin;

    @Column(name = "alarm_time")
    private Date alarmTime;

    @Column(name = "alarm_lng")
    private Double alarmLng;

    @Column(name = "alarm_lat")
    private Double alarmLat;

    @Column(name = "alarm_protocol")
    private Integer alarmProtocol;

    @Column(name = "alarm_mil")
    private Integer alarmMil;

    @Column(name = "alarm_id_code")
    private String alarmIdCode;

    @Column(name = "alarm_verification_code")
    private String alarmVerificationCode;

    @Column(name = "alarm_fault_code_num")
    private Integer alarmFaultCodeNum;

    @Column(name = "alarm_fault_code")
    private String alarmFaultCode;

    @Column(name = "alarm_speed")
    private Integer alarmSpeed;

    @Column(name = "alarm_air_pressure")
    private Double alarmAirPressure;

    @Column(name = "alarm_engine_torque")
    private Double alarmEngineTorque;

    @Column(name = "alarm_friction_torque")
    private Double alarmFrictionTorque;

    @Column(name = "alarm_engine_rpm")
    private Integer alarmEngineRpm;

    @Column(name = "alarm_start_fuel_flow")
    private Double alarmStartFuelFlow;

    @Column(name = "alarm_scr_upstream_NO")
    private Double alarmScrUpstreamNo;

    @Column(name = "alarm_scr_downstream_NO")
    private Double alarmScrDownstreamNo;

    @Column(name = "alarm_remain_reactant")
    private Double alarmRemainReactant;

    @Column(name = "alarm_air_input")
    private Double alarmAirInput;

    @Column(name = "alarm_scr_input_temp")
    private Double alarmScrInputTemp;

    @Column(name = "alarm_scr_output_temp")
    private Double alarmScrOutputTemp;

    @Column(name = "alarm_DPF")
    private Double alarmDpf;

    @Column(name = "alarm_engine_coolant_temp")
    private Double alarmEngineCoolantTemp;

    @Column(name = "alarm_fuel_level")
    private Double alarmFuelLevel;

    @Column(name = "alarm_location_status")
    private Integer alarmLocationStatus;

    @Column(name = "alarm_total_mileage")
    private Double alarmTotalMileage;

    @Column(name = "alarm_engine_torque_mode")
    private String alarmEngineTorqueMode;

    @Column(name = "alarm_accelerator_pedal")
    private Double alarmAcceleratorPedal;

    @Column(name = "alarm_total_oil_consumption")
    private Double alarmTotalOilConsumption;

    @Column(name = "alarm_urea_box_temp")
    private Double alarmUreaBoxTemp;

    @Column(name = "alarm_urea_volume")
    private Integer alarmUreaVolume;

    @Column(name = "alarm_total_urea_consume")
    private Double alarmTotalUreaConsume;

    @Column(name = "alarm_DPF_temp")
    private Double alarmDpfTemp;

    @Column(name = "alarm_firmware_version")
    private String alarmFirmwareVersion;

    /**
     * @return id
     */
    public Integer getId() {
        return id;
    }

    /**
     * @param id
     */
    public void setId(Integer id) {
        this.id = id;
    }

    /**
     * @return obd_vin
     */
    public String getObdVin() {
        return obdVin;
    }

    /**
     * @param obdVin
     */
    public void setObdVin(String obdVin) {
        this.obdVin = obdVin == null ? null : obdVin.trim();
    }

    /**
     * @return alarm_time
     */
    public Date getAlarmTime() {
        return alarmTime;
    }

    /**
     * @param alarmTime
     */
    public void setAlarmTime(Date alarmTime) {
        this.alarmTime = alarmTime;
    }

    /**
     * @return alarm_lng
     */
    public Double getAlarmLng() {
        return alarmLng;
    }

    /**
     * @param alarmLng
     */
    public void setAlarmLng(Double alarmLng) {
        this.alarmLng = alarmLng;
    }

    /**
     * @return alarm_lat
     */
    public Double getAlarmLat() {
        return alarmLat;
    }

    /**
     * @param alarmLat
     */
    public void setAlarmLat(Double alarmLat) {
        this.alarmLat = alarmLat;
    }

    /**
     * @return alarm_protocol
     */
    public Integer getAlarmProtocol() {
        return alarmProtocol;
    }

    /**
     * @param alarmProtocol
     */
    public void setAlarmProtocol(Integer alarmProtocol) {
        this.alarmProtocol = alarmProtocol;
    }

    /**
     * @return alarm_mil
     */
    public Integer getAlarmMil() {
        return alarmMil;
    }

    /**
     * @param alarmMil
     */
    public void setAlarmMil(Integer alarmMil) {
        this.alarmMil = alarmMil;
    }

    /**
     * @return alarm_id_code
     */
    public String getAlarmIdCode() {
        return alarmIdCode;
    }

    /**
     * @param alarmIdCode
     */
    public void setAlarmIdCode(String alarmIdCode) {
        this.alarmIdCode = alarmIdCode == null ? null : alarmIdCode.trim();
    }

    /**
     * @return alarm_verification_code
     */
    public String getAlarmVerificationCode() {
        return alarmVerificationCode;
    }

    /**
     * @param alarmVerificationCode
     */
    public void setAlarmVerificationCode(String alarmVerificationCode) {
        this.alarmVerificationCode = alarmVerificationCode == null ? null : alarmVerificationCode.trim();
    }

    /**
     * @return alarm_fault_code_num
     */
    public Integer getAlarmFaultCodeNum() {
        return alarmFaultCodeNum;
    }

    /**
     * @param alarmFaultCodeNum
     */
    public void setAlarmFaultCodeNum(Integer alarmFaultCodeNum) {
        this.alarmFaultCodeNum = alarmFaultCodeNum;
    }

    /**
     * @return alarm_fault_code
     */
    public String getAlarmFaultCode() {
        return alarmFaultCode;
    }

    /**
     * @param alarmFaultCode
     */
    public void setAlarmFaultCode(String alarmFaultCode) {
        this.alarmFaultCode = alarmFaultCode == null ? null : alarmFaultCode.trim();
    }

    /**
     * @return alarm_speed
     */
    public Integer getAlarmSpeed() {
        return alarmSpeed;
    }

    /**
     * @param alarmSpeed
     */
    public void setAlarmSpeed(Integer alarmSpeed) {
        this.alarmSpeed = alarmSpeed;
    }

    /**
     * @return alarm_air_pressure
     */
    public Double getAlarmAirPressure() {
        return alarmAirPressure;
    }

    /**
     * @param alarmAirPressure
     */
    public void setAlarmAirPressure(Double alarmAirPressure) {
        this.alarmAirPressure = alarmAirPressure;
    }

    /**
     * @return alarm_engine_torque
     */
    public Double getAlarmEngineTorque() {
        return alarmEngineTorque;
    }

    /**
     * @param alarmEngineTorque
     */
    public void setAlarmEngineTorque(Double alarmEngineTorque) {
        this.alarmEngineTorque = alarmEngineTorque;
    }

    /**
     * @return alarm_friction_torque
     */
    public Double getAlarmFrictionTorque() {
        return alarmFrictionTorque;
    }

    /**
     * @param alarmFrictionTorque
     */
    public void setAlarmFrictionTorque(Double alarmFrictionTorque) {
        this.alarmFrictionTorque = alarmFrictionTorque;
    }

    /**
     * @return alarm_engine_rpm
     */
    public Integer getAlarmEngineRpm() {
        return alarmEngineRpm;
    }

    /**
     * @param alarmEngineRpm
     */
    public void setAlarmEngineRpm(Integer alarmEngineRpm) {
        this.alarmEngineRpm = alarmEngineRpm;
    }

    /**
     * @return alarm_start_fuel_flow
     */
    public Double getAlarmStartFuelFlow() {
        return alarmStartFuelFlow;
    }

    /**
     * @param alarmStartFuelFlow
     */
    public void setAlarmStartFuelFlow(Double alarmStartFuelFlow) {
        this.alarmStartFuelFlow = alarmStartFuelFlow;
    }

    /**
     * @return alarm_scr_upstream_NO
     */
    public Double getAlarmScrUpstreamNo() {
        return alarmScrUpstreamNo;
    }

    /**
     * @param alarmScrUpstreamNo
     */
    public void setAlarmScrUpstreamNo(Double alarmScrUpstreamNo) {
        this.alarmScrUpstreamNo = alarmScrUpstreamNo;
    }

    /**
     * @return alarm_scr_downstream_NO
     */
    public Double getAlarmScrDownstreamNo() {
        return alarmScrDownstreamNo;
    }

    /**
     * @param alarmScrDownstreamNo
     */
    public void setAlarmScrDownstreamNo(Double alarmScrDownstreamNo) {
        this.alarmScrDownstreamNo = alarmScrDownstreamNo;
    }

    /**
     * @return alarm_remain_reactant
     */
    public Double getAlarmRemainReactant() {
        return alarmRemainReactant;
    }

    /**
     * @param alarmRemainReactant
     */
    public void setAlarmRemainReactant(Double alarmRemainReactant) {
        this.alarmRemainReactant = alarmRemainReactant;
    }

    /**
     * @return alarm_air_input
     */
    public Double getAlarmAirInput() {
        return alarmAirInput;
    }

    /**
     * @param alarmAirInput
     */
    public void setAlarmAirInput(Double alarmAirInput) {
        this.alarmAirInput = alarmAirInput;
    }

    /**
     * @return alarm_scr_input_temp
     */
    public Double getAlarmScrInputTemp() {
        return alarmScrInputTemp;
    }

    /**
     * @param alarmScrInputTemp
     */
    public void setAlarmScrInputTemp(Double alarmScrInputTemp) {
        this.alarmScrInputTemp = alarmScrInputTemp;
    }

    /**
     * @return alarm_scr_output_temp
     */
    public Double getAlarmScrOutputTemp() {
        return alarmScrOutputTemp;
    }

    /**
     * @param alarmScrOutputTemp
     */
    public void setAlarmScrOutputTemp(Double alarmScrOutputTemp) {
        this.alarmScrOutputTemp = alarmScrOutputTemp;
    }

    /**
     * @return alarm_DPF
     */
    public Double getAlarmDpf() {
        return alarmDpf;
    }

    /**
     * @param alarmDpf
     */
    public void setAlarmDpf(Double alarmDpf) {
        this.alarmDpf = alarmDpf;
    }

    /**
     * @return alarm_engine_coolant_temp
     */
    public Double getAlarmEngineCoolantTemp() {
        return alarmEngineCoolantTemp;
    }

    /**
     * @param alarmEngineCoolantTemp
     */
    public void setAlarmEngineCoolantTemp(Double alarmEngineCoolantTemp) {
        this.alarmEngineCoolantTemp = alarmEngineCoolantTemp;
    }

    /**
     * @return alarm_fuel_level
     */
    public Double getAlarmFuelLevel() {
        return alarmFuelLevel;
    }

    /**
     * @param alarmFuelLevel
     */
    public void setAlarmFuelLevel(Double alarmFuelLevel) {
        this.alarmFuelLevel = alarmFuelLevel;
    }

    /**
     * @return alarm_location_status
     */
    public Integer getAlarmLocationStatus() {
        return alarmLocationStatus;
    }

    /**
     * @param alarmLocationStatus
     */
    public void setAlarmLocationStatus(Integer alarmLocationStatus) {
        this.alarmLocationStatus = alarmLocationStatus;
    }

    /**
     * @return alarm_total_mileage
     */
    public Double getAlarmTotalMileage() {
        return alarmTotalMileage;
    }

    /**
     * @param alarmTotalMileage
     */
    public void setAlarmTotalMileage(Double alarmTotalMileage) {
        this.alarmTotalMileage = alarmTotalMileage;
    }

    /**
     * @return alarm_engine_torque_mode
     */
    public String getAlarmEngineTorqueMode() {
        return alarmEngineTorqueMode;
    }

    /**
     * @param alarmEngineTorqueMode
     */
    public void setAlarmEngineTorqueMode(String alarmEngineTorqueMode) {
        this.alarmEngineTorqueMode = alarmEngineTorqueMode == null ? null : alarmEngineTorqueMode.trim();
    }

    /**
     * @return alarm_accelerator_pedal
     */
    public Double getAlarmAcceleratorPedal() {
        return alarmAcceleratorPedal;
    }

    /**
     * @param alarmAcceleratorPedal
     */
    public void setAlarmAcceleratorPedal(Double alarmAcceleratorPedal) {
        this.alarmAcceleratorPedal = alarmAcceleratorPedal;
    }

    /**
     * @return alarm_total_oil_consumption
     */
    public Double getAlarmTotalOilConsumption() {
        return alarmTotalOilConsumption;
    }

    /**
     * @param alarmTotalOilConsumption
     */
    public void setAlarmTotalOilConsumption(Double alarmTotalOilConsumption) {
        this.alarmTotalOilConsumption = alarmTotalOilConsumption;
    }

    /**
     * @return alarm_urea_box_temp
     */
    public Double getAlarmUreaBoxTemp() {
        return alarmUreaBoxTemp;
    }

    /**
     * @param alarmUreaBoxTemp
     */
    public void setAlarmUreaBoxTemp(Double alarmUreaBoxTemp) {
        this.alarmUreaBoxTemp = alarmUreaBoxTemp;
    }

    /**
     * @return alarm_urea_volume
     */
    public Integer getAlarmUreaVolume() {
        return alarmUreaVolume;
    }

    /**
     * @param alarmUreaVolume
     */
    public void setAlarmUreaVolume(Integer alarmUreaVolume) {
        this.alarmUreaVolume = alarmUreaVolume;
    }

    /**
     * @return alarm_total_urea_consume
     */
    public Double getAlarmTotalUreaConsume() {
        return alarmTotalUreaConsume;
    }

    /**
     * @param alarmTotalUreaConsume
     */
    public void setAlarmTotalUreaConsume(Double alarmTotalUreaConsume) {
        this.alarmTotalUreaConsume = alarmTotalUreaConsume;
    }

    /**
     * @return alarm_DPF_temp
     */
    public Double getAlarmDpfTemp() {
        return alarmDpfTemp;
    }

    /**
     * @param alarmDpfTemp
     */
    public void setAlarmDpfTemp(Double alarmDpfTemp) {
        this.alarmDpfTemp = alarmDpfTemp;
    }

    /**
     * @return alarm_firmware_version
     */
    public String getAlarmFirmwareVersion() {
        return alarmFirmwareVersion;
    }

    /**
     * @param alarmFirmwareVersion
     */
    public void setAlarmFirmwareVersion(String alarmFirmwareVersion) {
        this.alarmFirmwareVersion = alarmFirmwareVersion == null ? null : alarmFirmwareVersion.trim();
    }
}

 src/main/kotlin/com/flightfeather/obd/domain/entity/ObdUser.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,91 @@
package com.flightfeather.obd.domain.entity;

import javax.persistence.*;

@Table(name = "obd_user")
public class ObdUser {
    @Id
    private Integer id;

    @Column(name = "obd_vin")
    private String obdVin;

    @Column(name = "obd_user_id")
    private Double obdUserId;

    @Column(name = "obd_user_name")
    private String obdUserName;

    @Column(name = "obd_user_password")
    private String obdUserPassword;

    /**
     * @return id
     */
    public Integer getId() {
        return id;
    }

    /**
     * @param id
     */
    public void setId(Integer id) {
        this.id = id;
    }

    /**
     * @return obd_vin
     */
    public String getObdVin() {
        return obdVin;
    }

    /**
     * @param obdVin
     */
    public void setObdVin(String obdVin) {
        this.obdVin = obdVin == null ? null : obdVin.trim();
    }

    /**
     * @return obd_user_id
     */
    public Double getObdUserId() {
        return obdUserId;
    }

    /**
     * @param obdUserId
     */
    public void setObdUserId(Double obdUserId) {
        this.obdUserId = obdUserId;
    }

    /**
     * @return obd_user_name
     */
    public String getObdUserName() {
        return obdUserName;
    }

    /**
     * @param obdUserName
     */
    public void setObdUserName(String obdUserName) {
        this.obdUserName = obdUserName == null ? null : obdUserName.trim();
    }

    /**
     * @return obd_user_password
     */
    public String getObdUserPassword() {
        return obdUserPassword;
    }

    /**
     * @param obdUserPassword
     */
    public void setObdUserPassword(String obdUserPassword) {
        this.obdUserPassword = obdUserPassword == null ? null : obdUserPassword.trim();
    }
}

 src/main/kotlin/com/flightfeather/obd/domain/entity/ThresholdValue.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,499 @@
package com.flightfeather.obd.domain.entity;

import javax.persistence.*;

@Table(name = "obd_threshold_value")
public class ThresholdValue {
    @Id
    private Integer id;

    @Column(name = "obd_vin")
    private String obdVin;

    @Column(name = "th_mil")
    private Integer thMil;

    @Column(name = "th_fault_code_num")
    private Integer thFaultCodeNum;

    @Column(name = "th_fault_code")
    private String thFaultCode;

    @Column(name = "th_speed")
    private Integer thSpeed;

    @Column(name = "th_air_pressure")
    private Double thAirPressure;

    @Column(name = "th_engine_torque")
    private Double thEngineTorque;

    @Column(name = "th_friction_torque")
    private Double thFrictionTorque;

    @Column(name = "th_engine_rpm")
    private Integer thEngineRpm;

    @Column(name = "th_start_fuel_flow")
    private Double thStartFuelFlow;

    @Column(name = "th_scr_upstream_NO")
    private Double thScrUpstreamNo;

    @Column(name = "th_scr_downstream_NO")
    private Double thScrDownstreamNo;

    @Column(name = "th_remain_reactant")
    private Double thRemainReactant;

    @Column(name = "th_air_input")
    private Double thAirInput;

    @Column(name = "th_scr_input_temp")
    private Double thScrInputTemp;

    @Column(name = "th_scr_output_temp")
    private Double thScrOutputTemp;

    @Column(name = "th_DPF")
    private Double thDpf;

    @Column(name = "th_engine_coolant_temp")
    private Double thEngineCoolantTemp;

    @Column(name = "th_fuel_level")
    private Double thFuelLevel;

    @Column(name = "th_location_status")
    private Integer thLocationStatus;

    @Column(name = "th_total_mileage")
    private Double thTotalMileage;

    @Column(name = "th_engine_torque_mode")
    private String thEngineTorqueMode;

    @Column(name = "th_accelerator_pedal")
    private Double thAcceleratorPedal;

    @Column(name = "th_total_oil_consumption")
    private Double thTotalOilConsumption;

    @Column(name = "th_urea_box_temp")
    private Double thUreaBoxTemp;

    @Column(name = "th_urea_volume")
    private Integer thUreaVolume;

    @Column(name = "th_total_urea_consume")
    private Double thTotalUreaConsume;

    @Column(name = "th_DPF_temp")
    private Double thDpfTemp;

    /**
     * @return id
     */
    public Integer getId() {
        return id;
    }

    /**
     * @param id
     */
    public void setId(Integer id) {
        this.id = id;
    }

    /**
     * @return obd_vin
     */
    public String getObdVin() {
        return obdVin;
    }

    /**
     * @param obdVin
     */
    public void setObdVin(String obdVin) {
        this.obdVin = obdVin == null ? null : obdVin.trim();
    }

    /**
     * @return th_mil
     */
    public Integer getThMil() {
        return thMil;
    }

    /**
     * @param thMil
     */
    public void setThMil(Integer thMil) {
        this.thMil = thMil;
    }

    /**
     * @return th_fault_code_num
     */
    public Integer getThFaultCodeNum() {
        return thFaultCodeNum;
    }

    /**
     * @param thFaultCodeNum
     */
    public void setThFaultCodeNum(Integer thFaultCodeNum) {
        this.thFaultCodeNum = thFaultCodeNum;
    }

    /**
     * @return th_fault_code
     */
    public String getThFaultCode() {
        return thFaultCode;
    }

    /**
     * @param thFaultCode
     */
    public void setThFaultCode(String thFaultCode) {
        this.thFaultCode = thFaultCode == null ? null : thFaultCode.trim();
    }

    /**
     * @return th_speed
     */
    public Integer getThSpeed() {
        return thSpeed;
    }

    /**
     * @param thSpeed
     */
    public void setThSpeed(Integer thSpeed) {
        this.thSpeed = thSpeed;
    }

    /**
     * @return th_air_pressure
     */
    public Double getThAirPressure() {
        return thAirPressure;
    }

    /**
     * @param thAirPressure
     */
    public void setThAirPressure(Double thAirPressure) {
        this.thAirPressure = thAirPressure;
    }

    /**
     * @return th_engine_torque
     */
    public Double getThEngineTorque() {
        return thEngineTorque;
    }

    /**
     * @param thEngineTorque
     */
    public void setThEngineTorque(Double thEngineTorque) {
        this.thEngineTorque = thEngineTorque;
    }

    /**
     * @return th_friction_torque
     */
    public Double getThFrictionTorque() {
        return thFrictionTorque;
    }

    /**
     * @param thFrictionTorque
     */
    public void setThFrictionTorque(Double thFrictionTorque) {
        this.thFrictionTorque = thFrictionTorque;
    }

    /**
     * @return th_engine_rpm
     */
    public Integer getThEngineRpm() {
        return thEngineRpm;
    }

    /**
     * @param thEngineRpm
     */
    public void setThEngineRpm(Integer thEngineRpm) {
        this.thEngineRpm = thEngineRpm;
    }

    /**
     * @return th_start_fuel_flow
     */
    public Double getThStartFuelFlow() {
        return thStartFuelFlow;
    }

    /**
     * @param thStartFuelFlow
     */
    public void setThStartFuelFlow(Double thStartFuelFlow) {
        this.thStartFuelFlow = thStartFuelFlow;
    }

    /**
     * @return th_scr_upstream_NO
     */
    public Double getThScrUpstreamNo() {
        return thScrUpstreamNo;
    }

    /**
     * @param thScrUpstreamNo
     */
    public void setThScrUpstreamNo(Double thScrUpstreamNo) {
        this.thScrUpstreamNo = thScrUpstreamNo;
    }

    /**
     * @return th_scr_downstream_NO
     */
    public Double getThScrDownstreamNo() {
        return thScrDownstreamNo;
    }

    /**
     * @param thScrDownstreamNo
     */
    public void setThScrDownstreamNo(Double thScrDownstreamNo) {
        this.thScrDownstreamNo = thScrDownstreamNo;
    }

    /**
     * @return th_remain_reactant
     */
    public Double getThRemainReactant() {
        return thRemainReactant;
    }

    /**
     * @param thRemainReactant
     */
    public void setThRemainReactant(Double thRemainReactant) {
        this.thRemainReactant = thRemainReactant;
    }

    /**
     * @return th_air_input
     */
    public Double getThAirInput() {
        return thAirInput;
    }

    /**
     * @param thAirInput
     */
    public void setThAirInput(Double thAirInput) {
        this.thAirInput = thAirInput;
    }

    /**
     * @return th_scr_input_temp
     */
    public Double getThScrInputTemp() {
        return thScrInputTemp;
    }

    /**
     * @param thScrInputTemp
     */
    public void setThScrInputTemp(Double thScrInputTemp) {
        this.thScrInputTemp = thScrInputTemp;
    }

    /**
     * @return th_scr_output_temp
     */
    public Double getThScrOutputTemp() {
        return thScrOutputTemp;
    }

    /**
     * @param thScrOutputTemp
     */
    public void setThScrOutputTemp(Double thScrOutputTemp) {
        this.thScrOutputTemp = thScrOutputTemp;
    }

    /**
     * @return th_DPF
     */
    public Double getThDpf() {
        return thDpf;
    }

    /**
     * @param thDpf
     */
    public void setThDpf(Double thDpf) {
        this.thDpf = thDpf;
    }

    /**
     * @return th_engine_coolant_temp
     */
    public Double getThEngineCoolantTemp() {
        return thEngineCoolantTemp;
    }

    /**
     * @param thEngineCoolantTemp
     */
    public void setThEngineCoolantTemp(Double thEngineCoolantTemp) {
        this.thEngineCoolantTemp = thEngineCoolantTemp;
    }

    /**
     * @return th_fuel_level
     */
    public Double getThFuelLevel() {
        return thFuelLevel;
    }

    /**
     * @param thFuelLevel
     */
    public void setThFuelLevel(Double thFuelLevel) {
        this.thFuelLevel = thFuelLevel;
    }

    /**
     * @return th_location_status
     */
    public Integer getThLocationStatus() {
        return thLocationStatus;
    }

    /**
     * @param thLocationStatus
     */
    public void setThLocationStatus(Integer thLocationStatus) {
        this.thLocationStatus = thLocationStatus;
    }

    /**
     * @return th_total_mileage
     */
    public Double getThTotalMileage() {
        return thTotalMileage;
    }

    /**
     * @param thTotalMileage
     */
    public void setThTotalMileage(Double thTotalMileage) {
        this.thTotalMileage = thTotalMileage;
    }

    /**
     * @return th_engine_torque_mode
     */
    public String getThEngineTorqueMode() {
        return thEngineTorqueMode;
    }

    /**
     * @param thEngineTorqueMode
     */
    public void setThEngineTorqueMode(String thEngineTorqueMode) {
        this.thEngineTorqueMode = thEngineTorqueMode == null ? null : thEngineTorqueMode.trim();
    }

    /**
     * @return th_accelerator_pedal
     */
    public Double getThAcceleratorPedal() {
        return thAcceleratorPedal;
    }

    /**
     * @param thAcceleratorPedal
     */
    public void setThAcceleratorPedal(Double thAcceleratorPedal) {
        this.thAcceleratorPedal = thAcceleratorPedal;
    }

    /**
     * @return th_total_oil_consumption
     */
    public Double getThTotalOilConsumption() {
        return thTotalOilConsumption;
    }

    /**
     * @param thTotalOilConsumption
     */
    public void setThTotalOilConsumption(Double thTotalOilConsumption) {
        this.thTotalOilConsumption = thTotalOilConsumption;
    }

    /**
     * @return th_urea_box_temp
     */
    public Double getThUreaBoxTemp() {
        return thUreaBoxTemp;
    }

    /**
     * @param thUreaBoxTemp
     */
    public void setThUreaBoxTemp(Double thUreaBoxTemp) {
        this.thUreaBoxTemp = thUreaBoxTemp;
    }

    /**
     * @return th_urea_volume
     */
    public Integer getThUreaVolume() {
        return thUreaVolume;
    }

    /**
     * @param thUreaVolume
     */
    public void setThUreaVolume(Integer thUreaVolume) {
        this.thUreaVolume = thUreaVolume;
    }

    /**
     * @return th_total_urea_consume
     */
    public Double getThTotalUreaConsume() {
        return thTotalUreaConsume;
    }

    /**
     * @param thTotalUreaConsume
     */
    public void setThTotalUreaConsume(Double thTotalUreaConsume) {
        this.thTotalUreaConsume = thTotalUreaConsume;
    }

    /**
     * @return th_DPF_temp
     */
    public Double getThDpfTemp() {
        return thDpfTemp;
    }

    /**
     * @param thDpfTemp
     */
    public void setThDpfTemp(Double thDpfTemp) {
        this.thDpfTemp = thDpfTemp;
    }
}

 src/main/kotlin/com/flightfeather/obd/domain/mapper/AlarmDataMapper.kt

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
package com.flightfeather.obd.domain.mapper

import com.flightfeather.obd.domain.MyMapper
import com.flightfeather.obd.domain.entity.AlarmData
import org.apache.ibatis.annotations.Mapper

@Mapper
interface AlarmDataMapper : MyMapper<AlarmData>

 src/main/kotlin/com/flightfeather/obd/domain/mapper/ObdUserMapper.kt

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
package com.flightfeather.obd.domain.mapper

import com.flightfeather.obd.domain.MyMapper
import com.flightfeather.obd.domain.entity.ObdUser
import org.apache.ibatis.annotations.Mapper

@Mapper
interface ObdUserMapper : MyMapper<ObdUser>

 src/main/kotlin/com/flightfeather/obd/domain/mapper/ThresholdValueMapper.kt

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
package com.flightfeather.obd.domain.mapper

import com.flightfeather.obd.domain.MyMapper
import com.flightfeather.obd.domain.entity.ThresholdValue
import org.apache.ibatis.annotations.Mapper

@Mapper
interface ThresholdValueMapper : MyMapper<ThresholdValue>

 src/main/kotlin/com/flightfeather/obd/lightshare/bean/BaseJson.kt

@@ -1,10 +1,15 @@
package com.flightfeather.obd.lightshare.bean

import com.fasterxml.jackson.annotation.JsonIgnoreProperties
import com.fasterxml.jackson.annotation.JsonInclude

/**
 * åŸºç¡€Json结构，所有的数据以此为基类
 * @author riku
 * Date: 2019/8/27
 */
@JsonInclude(JsonInclude.Include.NON_NULL)
@JsonIgnoreProperties(ignoreUnknown = true)
open class BaseJson{
    val cmdCode: Int? = null
}

 src/main/kotlin/com/flightfeather/obd/lightshare/bean/ObdDataVo.kt

@@ -1,10 +1,8 @@
package com.flightfeather.obd.lightshare.bean

import com.fasterxml.jackson.annotation.JsonIgnoreProperties
import com.google.gson.annotations.SerializedName
import java.util.*

@JsonIgnoreProperties(ignoreUnknown = true)
class ObdDataVo :  BaseJson() {
    var id: Int? = null
    @SerializedName("vin")

 src/main/kotlin/com/flightfeather/obd/repository/impl/ObdDataDaoImpl.kt

@@ -31,7 +31,7 @@

        //分页
        val offset = (pageSize?.times(pageNum?.minus(1) ?: 0)) ?: 0
        val a = PageHelper.offsetPage<ObdData>(offset, pageSize ?: 10)
        PageHelper.offsetPage<ObdData>(offset, pageSize ?: 10)
        val result = obdDataMapper.selectByExample(example)

        val resultList = mutableListOf<ObdDataVo>()

 src/main/resources/application.yml

@@ -1,7 +1,7 @@
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://47.100.191.150:3306/obd?serverTimezone=Asia/Shanghai&prepStmtCacheSize=517&cachePrepStmts=true&autoReconnect=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false
    url: jdbc:mysql://47.100.191.150:3306/obd?serverTimezone=GMT&prepStmtCacheSize=517&cachePrepStmts=true&autoReconnect=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false
    username: obd
    password: obd2019


 src/main/resources/generator/generatorConfig.xml

@@ -45,8 +45,9 @@
            <property name="enableSubPackages" value="true"/>
        </javaClientGenerator>
        <!-- è¦ç”Ÿæˆçš„表 tableName是数据库中的表名或视图名 domainObjectName是实体类名-->
        <table tableName="obd_data" domainObjectName="ObdData" enableCountByExample="false"
               enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
               selectByExampleQueryId="false"/>
        <!--<table tableName="obd_data" domainObjectName="ObdData" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/>-->
        <table tableName="obd_user" domainObjectName="ObdUser" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/>
        <table tableName="obd_threshold_value" domainObjectName="ThresholdValue" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/>
        <table tableName="obd_alarm_data" domainObjectName="AlarmData" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/>
    </context>
</generatorConfiguration>

 src/main/resources/mapper/AlarmDataMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,58 @@
<?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.flightfeather.obd.domain.mapper.AlarmDataMapper">
  <resultMap id="BaseResultMap" type="com.flightfeather.obd.domain.entity.AlarmData">
    <!--
      WARNING - @mbg.generated
    -->
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="obd_vin" jdbcType="VARCHAR" property="obdVin" />
    <result column="alarm_time" jdbcType="TIMESTAMP" property="alarmTime" />
    <result column="alarm_lng" jdbcType="DOUBLE" property="alarmLng" />
    <result column="alarm_lat" jdbcType="DOUBLE" property="alarmLat" />
    <result column="alarm_protocol" jdbcType="INTEGER" property="alarmProtocol" />
    <result column="alarm_mil" jdbcType="INTEGER" property="alarmMil" />
    <result column="alarm_id_code" jdbcType="VARCHAR" property="alarmIdCode" />
    <result column="alarm_verification_code" jdbcType="VARCHAR" property="alarmVerificationCode" />
    <result column="alarm_fault_code_num" jdbcType="INTEGER" property="alarmFaultCodeNum" />
    <result column="alarm_fault_code" jdbcType="VARCHAR" property="alarmFaultCode" />
    <result column="alarm_speed" jdbcType="INTEGER" property="alarmSpeed" />
    <result column="alarm_air_pressure" jdbcType="DOUBLE" property="alarmAirPressure" />
    <result column="alarm_engine_torque" jdbcType="DOUBLE" property="alarmEngineTorque" />
    <result column="alarm_friction_torque" jdbcType="DOUBLE" property="alarmFrictionTorque" />
    <result column="alarm_engine_rpm" jdbcType="INTEGER" property="alarmEngineRpm" />
    <result column="alarm_start_fuel_flow" jdbcType="DOUBLE" property="alarmStartFuelFlow" />
    <result column="alarm_scr_upstream_NO" jdbcType="DOUBLE" property="alarmScrUpstreamNo" />
    <result column="alarm_scr_downstream_NO" jdbcType="DOUBLE" property="alarmScrDownstreamNo" />
    <result column="alarm_remain_reactant" jdbcType="DOUBLE" property="alarmRemainReactant" />
    <result column="alarm_air_input" jdbcType="DOUBLE" property="alarmAirInput" />
    <result column="alarm_scr_input_temp" jdbcType="DOUBLE" property="alarmScrInputTemp" />
    <result column="alarm_scr_output_temp" jdbcType="DOUBLE" property="alarmScrOutputTemp" />
    <result column="alarm_DPF" jdbcType="DOUBLE" property="alarmDpf" />
    <result column="alarm_engine_coolant_temp" jdbcType="DOUBLE" property="alarmEngineCoolantTemp" />
    <result column="alarm_fuel_level" jdbcType="DOUBLE" property="alarmFuelLevel" />
    <result column="alarm_location_status" jdbcType="INTEGER" property="alarmLocationStatus" />
    <result column="alarm_total_mileage" jdbcType="DOUBLE" property="alarmTotalMileage" />
    <result column="alarm_engine_torque_mode" jdbcType="VARCHAR" property="alarmEngineTorqueMode" />
    <result column="alarm_accelerator_pedal" jdbcType="DOUBLE" property="alarmAcceleratorPedal" />
    <result column="alarm_total_oil_consumption" jdbcType="DOUBLE" property="alarmTotalOilConsumption" />
    <result column="alarm_urea_box_temp" jdbcType="DOUBLE" property="alarmUreaBoxTemp" />
    <result column="alarm_urea_volume" jdbcType="INTEGER" property="alarmUreaVolume" />
    <result column="alarm_total_urea_consume" jdbcType="DOUBLE" property="alarmTotalUreaConsume" />
    <result column="alarm_DPF_temp" jdbcType="DOUBLE" property="alarmDpfTemp" />
    <result column="alarm_firmware_version" jdbcType="VARCHAR" property="alarmFirmwareVersion" />
  </resultMap>
  <sql id="Base_Column_List">
    <!--
      WARNING - @mbg.generated
    -->
    id, obd_vin, alarm_time, alarm_lng, alarm_lat, alarm_protocol, alarm_mil, alarm_id_code, 
    alarm_verification_code, alarm_fault_code_num, alarm_fault_code, alarm_speed, alarm_air_pressure, 
    alarm_engine_torque, alarm_friction_torque, alarm_engine_rpm, alarm_start_fuel_flow, 
    alarm_scr_upstream_NO, alarm_scr_downstream_NO, alarm_remain_reactant, alarm_air_input, 
    alarm_scr_input_temp, alarm_scr_output_temp, alarm_DPF, alarm_engine_coolant_temp, 
    alarm_fuel_level, alarm_location_status, alarm_total_mileage, alarm_engine_torque_mode, 
    alarm_accelerator_pedal, alarm_total_oil_consumption, alarm_urea_box_temp, alarm_urea_volume, 
    alarm_total_urea_consume, alarm_DPF_temp, alarm_firmware_version
  </sql>
</mapper>

 src/main/resources/mapper/ObdUserMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
<?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.flightfeather.obd.domain.mapper.ObdUserMapper">
  <resultMap id="BaseResultMap" type="com.flightfeather.obd.domain.entity.ObdUser">
    <!--
      WARNING - @mbg.generated
    -->
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="obd_vin" jdbcType="VARCHAR" property="obdVin" />
    <result column="obd_user_id" jdbcType="DOUBLE" property="obdUserId" />
    <result column="obd_user_name" jdbcType="VARCHAR" property="obdUserName" />
    <result column="obd_user_password" jdbcType="VARCHAR" property="obdUserPassword" />
  </resultMap>
  <sql id="Base_Column_List">
    <!--
      WARNING - @mbg.generated
    -->
    id, obd_vin, obd_user_id, obd_user_name, obd_user_password
  </sql>
</mapper>

 src/main/resources/mapper/ThresholdValueMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,49 @@
<?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.flightfeather.obd.domain.mapper.ThresholdValueMapper">
  <resultMap id="BaseResultMap" type="com.flightfeather.obd.domain.entity.ThresholdValue">
    <!--
      WARNING - @mbg.generated
    -->
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="obd_vin" jdbcType="VARCHAR" property="obdVin" />
    <result column="th_mil" jdbcType="INTEGER" property="thMil" />
    <result column="th_fault_code_num" jdbcType="INTEGER" property="thFaultCodeNum" />
    <result column="th_fault_code" jdbcType="VARCHAR" property="thFaultCode" />
    <result column="th_speed" jdbcType="INTEGER" property="thSpeed" />
    <result column="th_air_pressure" jdbcType="DOUBLE" property="thAirPressure" />
    <result column="th_engine_torque" jdbcType="DOUBLE" property="thEngineTorque" />
    <result column="th_friction_torque" jdbcType="DOUBLE" property="thFrictionTorque" />
    <result column="th_engine_rpm" jdbcType="INTEGER" property="thEngineRpm" />
    <result column="th_start_fuel_flow" jdbcType="DOUBLE" property="thStartFuelFlow" />
    <result column="th_scr_upstream_NO" jdbcType="DOUBLE" property="thScrUpstreamNo" />
    <result column="th_scr_downstream_NO" jdbcType="DOUBLE" property="thScrDownstreamNo" />
    <result column="th_remain_reactant" jdbcType="DOUBLE" property="thRemainReactant" />
    <result column="th_air_input" jdbcType="DOUBLE" property="thAirInput" />
    <result column="th_scr_input_temp" jdbcType="DOUBLE" property="thScrInputTemp" />
    <result column="th_scr_output_temp" jdbcType="DOUBLE" property="thScrOutputTemp" />
    <result column="th_DPF" jdbcType="DOUBLE" property="thDpf" />
    <result column="th_engine_coolant_temp" jdbcType="DOUBLE" property="thEngineCoolantTemp" />
    <result column="th_fuel_level" jdbcType="DOUBLE" property="thFuelLevel" />
    <result column="th_location_status" jdbcType="INTEGER" property="thLocationStatus" />
    <result column="th_total_mileage" jdbcType="DOUBLE" property="thTotalMileage" />
    <result column="th_engine_torque_mode" jdbcType="VARCHAR" property="thEngineTorqueMode" />
    <result column="th_accelerator_pedal" jdbcType="DOUBLE" property="thAcceleratorPedal" />
    <result column="th_total_oil_consumption" jdbcType="DOUBLE" property="thTotalOilConsumption" />
    <result column="th_urea_box_temp" jdbcType="DOUBLE" property="thUreaBoxTemp" />
    <result column="th_urea_volume" jdbcType="INTEGER" property="thUreaVolume" />
    <result column="th_total_urea_consume" jdbcType="DOUBLE" property="thTotalUreaConsume" />
    <result column="th_DPF_temp" jdbcType="DOUBLE" property="thDpfTemp" />
  </resultMap>
  <sql id="Base_Column_List">
    <!--
      WARNING - @mbg.generated
    -->
    id, obd_vin, th_mil, th_fault_code_num, th_fault_code, th_speed, th_air_pressure, 
    th_engine_torque, th_friction_torque, th_engine_rpm, th_start_fuel_flow, th_scr_upstream_NO, 
    th_scr_downstream_NO, th_remain_reactant, th_air_input, th_scr_input_temp, th_scr_output_temp, 
    th_DPF, th_engine_coolant_temp, th_fuel_level, th_location_status, th_total_mileage, 
    th_engine_torque_mode, th_accelerator_pedal, th_total_oil_consumption, th_urea_box_temp, 
    th_urea_volume, th_total_urea_consume, th_DPF_temp
  </sql>
</mapper>