<resultMap id="ResultMap" type="com.spdb.quality.inspection.task.domain.vo.RulePropertiesUniteVO" autoMapping="true">
<id column="rule_no" jdbcType="VARCHAR" property="ruleNo" />
<collection property="subRuleProperties" ofType="com.spdb.quality.inspection.task.domain.entity.SubRuleProperties" autoMapping="true">
<id column="sub_rule_no" property="subRuleNo"></id>
<result column="schecksql" property="checkSql"></result>
<result column="sdatelatitude" property="dateLatitude"></result>
<result column="scheckdatabase" property="checkDatabase"></result>
<result column="screatetime" property="createTime"></result>
<result column="supdatetime" property="updateTime"></result>
<result column="screateby" property="createBy"></result>
</collection>
</resultMap>
#查询时实体类和表里字段对应上,标签里不写全字段也能查出所有字段值
{"total":1,
"rows":[{"ruleNo":"RPT126620230210000001",
"ruleGroupNo":"RPT1266",
"checkSql":"select 1 from dual",
"dateLatitude":"0",
"checkDatabase":"U_RPT",
"startTime":"13:48:00",
"endTime":"23:50:00",
"maxExecuteCount":5,
"alertExecuteCount":1,
"intervalCheckTime":3,
"executeFrequency":"0 0 1 * * ?",
"mdisPdName":null,
"mdisProject":null,
"emailText":"",
"emailTextTemp":"",
"emailArrTemp":"[]",
"misfirePolicy":"3",
"concurrent":"1",
"rpIsEnable":"1",
"batchType":"1",
"projectId":"10",
"createTime":"2023-02-10 13:05:30",
"updateTime":"2023-02-10 16:11:27",
"createBy":"12010917",
"subRuleProperties":[{
"subRuleNo":"RPT126620230210000036",
"fkRuleGroupNo":"RPT1266",
"checkSql":"select 1 from dual",
"dateLatitude":"0",
"checkDatabase":"U_RPT",
"checkComment":"规则5",
"lowerBoundary":1.00,
"upperBoundary":2.00,
"createTime":"2023-02-10 16:11:27",
"updateTime":"2023-02-10 16:11:27",
"createBy":"12053707",
"factUnit":"千"
}]",
"noticeFlag":"[\"email\",\"newcall\"]",
"appType":"RPT",
"isSend":"0",
"isEnable":"0",
"logicalName":null}],
"code":200,
"msg":"查询成功"}
一对多标签字段
于 2023-03-08 16:14:27 首次发布