<?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.uspring.cn.device.dao.DeviceImportMapper">
<!-- 安灯数据插入 -->
<insert id="insertDeviceAdCq" parameterType="com.uspring.cn.device.entity.deviceImport.DeviceAdCq">
INSERT INTO device_ad_cq (
factory_code, workshop, vsm, date, dev_repair, competency_check,
create_by, create_at, update_by, update_at, deleted
) VALUES (
#{factoryCode}, #{workshop}, #{vsm}, #{date}, #{devRepair}, #{competencyCheck},
#{createBy}, #{createAt}, #{updateBy}, #{updateAt}, #{deleted}
)
</insert>
<!-- 能力检测完成率插入 -->
<insert id="insertDeviceCompetencyCheckCq" parameterType="com.uspring.cn.device.entity.deviceImport.DeviceCompetencyCheckCq">
INSERT INTO device_competency_check_cq (
factory_code, workshop, vsm, date, competency_check_number,
create_by, create_at, update_by, update_at, deleted
) VALUES (
#{factoryCode}, #{workshop}, #{vsm}, #{date}, #{competencyCheckNumber},
#{createBy}, #{createAt}, #{updateBy}, #{updateAt}, #{deleted}
)
</insert>
<!-- 设备维修插入 -->
<insert id="insertDeviceCq" parameterType="com.uspring.cn.device.entity.deviceImport.DeviceCq">
INSERT INTO device_cq (
factory_code, workshop, vsm, date, dev_run_at,dev_fault_at,dev_avg_repair_target_at,
dev_avg_repair_at, dev_avg_interval_target_at,dev_avg_interval_at,
create_by, create_at, update_by, update_at, deleted
) VALUES (
#{factoryCode}, #{workshop}, #{vsm}, #{date}, #{devRunAt},#{devFaultAt},#{devAvgRepairTargetAt},
#{devAvgRepairAt}, #{devAvgIntervalTargetAt},#{devAvgIntervalAt},
#{createBy}, #{createAt}, #{updateBy}, #{updateAt}, #{deleted}
)
</insert>
<!-- 设备故障率插入 -->
<insert id="insertDeviceFaultTrendCq" parameterType="com.uspring.cn.device.entity.deviceImport.DeviceFaultTrendCq">
INSERT INTO device_fault_trend_cq (
factory_code, workshop, vsm, date,
fault_trend,create_by, create_at, update_by, update_at, deleted
) VALUES (
#{factoryCode}, #{workshop}, #{vsm}, #{date},
#{faultTrend}, #{createBy}, #{createAt}, #{updateBy}, #{updateAt}, #{deleted}
)
</insert>
<!-- 单次维修时长超过4小时的维修次数 --> -->
<insert id="insertDeviceRepairOneCq" parameterType="com.uspring.cn.device.entity.deviceImport.DeviceRepairOneCq">
INSERT INTO device_repair_one_cq (
factory_code, workshop, vsm, date,
value_one,repair,value_two,create_by, create_at, update_by, update_at, deleted
) VALUES (
#{factoryCode}, #{workshop}, #{vsm}, #{date},
#{faultTrend}, #{valueOne},#{repair},#{valueTwo},#{createBy}, #{createAt}, #{updateBy}, #{updateAt}, #{deleted}
)
</insert>
</mapper>mapper为什么报错?
最新发布
本文解析了HibernateJPA中出现的Nopropertysql错误原因，并提供了修改DAO实现类的具体解决方案。
扫一扫
832
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
