com.carfinance.module.vehicleservicemanage.domain.VehicleContraceVehsInfoRowMapper.java Source code

Introduction

Here is the source code for com.carfinance.module.vehicleservicemanage.domain.VehicleContraceVehsInfoRowMapper.java

Source

package com.carfinance.module.vehicleservicemanage.domain;

import org.springframework.jdbc.core.RowMapper;

import java.security.Timestamp;
import java.sql.ResultSet;
import java.sql.SQLException;

public class VehicleContraceVehsInfoRowMapper implements RowMapper<VehicleContraceVehsInfo> {
    public VehicleContraceVehsInfo mapRow(ResultSet rs, int arg1) throws SQLException {
        VehicleContraceVehsInfo vehicleContraceVehsInfo = new VehicleContraceVehsInfo();

        vehicleContraceVehsInfo.setId(rs.getLong("id"));
        vehicleContraceVehsInfo.setContrace_id(rs.getLong("contrace_id"));
        vehicleContraceVehsInfo.setVehicle_id(rs.getLong("vehicle_id"));
        vehicleContraceVehsInfo.setLicense_plate(rs.getString("license_plate"));
        vehicleContraceVehsInfo.setModel(rs.getString("model"));
        vehicleContraceVehsInfo.setCompany(rs.getString("company"));
        vehicleContraceVehsInfo.setIsother(rs.getInt("isother"));
        vehicleContraceVehsInfo.setDriving_user_id(rs.getLong("driving_user_id"));
        vehicleContraceVehsInfo.setDriving_user_name(rs.getString("driving_user_name"));
        vehicleContraceVehsInfo.setDriving_user_license_no(rs.getString("driving_user_license_no"));
        vehicleContraceVehsInfo.setVehicle_price(rs.getDouble("vehicle_price"));
        vehicleContraceVehsInfo.setCreate_by(rs.getLong("create_by"));
        vehicleContraceVehsInfo.setCreate_at(rs.getDate("create_at"));
        vehicleContraceVehsInfo.setUpdate_by(rs.getLong("update_by"));
        vehicleContraceVehsInfo.setUpdate_at(rs.getDate("update_at"));

        try {
            vehicleContraceVehsInfo.setKm(rs.getLong("km"));
        } catch (Exception e) {
        }

        try {
            vehicleContraceVehsInfo.setOther_vehicle_km(rs.getLong("other_vehicle_km"));
        } catch (Exception e) {
        }

        try {
            if (rs.getTimestamp("return_time") != null) {
                String return_time_str = rs.getTimestamp("return_time").toString();
                vehicleContraceVehsInfo.setReturn_time(return_time_str.substring(0, return_time_str.length() - 2));
            }
        } catch (Exception e) {
        }

        try {
            vehicleContraceVehsInfo.setReturn_km(rs.getLong("return_km"));
        } catch (Exception e) {
        }

        try {
            vehicleContraceVehsInfo.setReturn_org(rs.getLong("return_org"));
        } catch (Exception e) {
        }

        try {
            vehicleContraceVehsInfo.setOver_price(rs.getDouble("over_price"));
        } catch (Exception e) {
        }

        try {
            vehicleContraceVehsInfo.setStatus(rs.getInt("status"));
        } catch (Exception e) {
        }

        try {
            vehicleContraceVehsInfo.setEtc(rs.getString("etc"));
        } catch (Exception e) {
        }
        try {
            vehicleContraceVehsInfo.setEtc_money(rs.getDouble("etc_money"));
        } catch (Exception e) {
        }
        try {
            vehicleContraceVehsInfo.setOil_percent(rs.getInt("oil_percent"));
        } catch (Exception e) {
        }
        try {
            vehicleContraceVehsInfo.setRevert_oil_percent(rs.getInt("revert_oil_percent"));
        } catch (Exception e) {
        }
        try {
            vehicleContraceVehsInfo.setRevert_etc_money(rs.getInt("revert_etc_money"));
        } catch (Exception e) {
        }

        try {
            vehicleContraceVehsInfo.setDaily_price(rs.getDouble("daily_price"));
        } catch (Exception e) {
        }

        try {
            vehicleContraceVehsInfo.setSettlement_way(rs.getString("settlement_way"));
        } catch (Exception e) {
        }
        try {
            vehicleContraceVehsInfo.setFixed_price(rs.getDouble("fixed_price"));
        } catch (Exception e) {
        }

        try {
            vehicleContraceVehsInfo.setSystem_price(rs.getDouble("system_price"));
        } catch (Exception e) {
        }
        try {
            vehicleContraceVehsInfo.setReduction_price(rs.getDouble("reduction_price"));
        } catch (Exception e) {
        }
        try {
            vehicleContraceVehsInfo.setActually_price(rs.getDouble("actually_price"));
        } catch (Exception e) {
        }
        try {
            vehicleContraceVehsInfo.setTotal_actually(rs.getDouble("total_actually"));
        } catch (Exception e) {
        }

        try {
            vehicleContraceVehsInfo.setDispatch_status(rs.getInt("dispatch_status"));
        } catch (Exception e) {
        }

        return vehicleContraceVehsInfo;
    }
}