一对多标签字段

<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":"查询成功"}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值