<?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.idmind.qgdj.cms.dao.FakeReportMapper" >
<resultMap id="BaseResultMap" type="com.idmind.qgdj.cms.domain.FakeReport" >
<id column="fake_report_id" property="fakeReportId" jdbcType="INTEGER" />
<result column="fake_class" property="fakeClass" jdbcType="INTEGER" />
<result column="push_user_id" property="pushUserId" jdbcType="INTEGER" />
<result column="title_name" property="titleName" jdbcType="VARCHAR" />
<result column="title_image" property="titleImage" jdbcType="VARCHAR" />
<result column="push_time" property="pushTime" jdbcType="TIMESTAMP" />
<result column="click_count" property="clickCount" jdbcType="INTEGER" />
<result column="comm_count" property="commCount" jdbcType="INTEGER" />
<result column="share_count" property="shareCount" jdbcType="INTEGER" />
<result column="audit_status" property="auditStatus" jdbcType="INTEGER" />
<result column="is_delete" property="isDelete" jdbcType="INTEGER" />
<result column="content" property="content" jdbcType="LONGVARCHAR" />
</resultMap>
当前表domain的FakeReport 自定义id 继承上面的BaseResultMap
<resultMap type="com.idmind.qgdj.cms.domain.FakeReport" id="UserBaseMap" extends="BaseResultMap">
一一对应查询 当前表FakeReport类的users 关联表数据库的字段 关联表的domian,Users
</resultMap> Users表的包名package com.idmind.qgdj.cms.domain;
// package com.idmind.qgdj.cms.domain; <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
// public class FakeReport { select
// /** 打假举报ID */
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.idmind.qgdj.cms.dao.FakeReportMapper" >
<resultMap id="BaseResultMap" type="com.idmind.qgdj.cms.domain.FakeReport" >
<id column="fake_report_id" property="fakeReportId" jdbcType="INTEGER" />
<result column="fake_class" property="fakeClass" jdbcType="INTEGER" />
<result column="push_user_id" property="pushUserId" jdbcType="INTEGER" />
<result column="title_name" property="titleName" jdbcType="VARCHAR" />
<result column="title_image" property="titleImage" jdbcType="VARCHAR" />
<result column="push_time" property="pushTime" jdbcType="TIMESTAMP" />
<result column="click_count" property="clickCount" jdbcType="INTEGER" />
<result column="comm_count" property="commCount" jdbcType="INTEGER" />
<result column="share_count" property="shareCount" jdbcType="INTEGER" />
<result column="audit_status" property="auditStatus" jdbcType="INTEGER" />
<result column="is_delete" property="isDelete" jdbcType="INTEGER" />
<result column="content" property="content" jdbcType="LONGVARCHAR" />
</resultMap>
当前表domain的FakeReport 自定义id 继承上面的BaseResultMap
<resultMap type="com.idmind.qgdj.cms.domain.FakeReport" id="UserBaseMap" extends="BaseResultMap">
一一对应查询 当前表FakeReport类的users 关联表数据库的字段 关联表的domian,Users
<associationproperty="users" column="push_user_id" javaType="com.idmind.qgdj.cms.domain.Users"
关联表UsersMapper类的查询方法selectByPrimaryKey
select="com.idmind.qgdj.cms.dao.UsersMapper.selectByPrimaryKey"/>
// 在当前表类里get和set users类
// <collection property="" 一对多的查询 其它不变 ofType=" "></collection></resultMap> Users表的包名package com.idmind.qgdj.cms.domain;
// package com.idmind.qgdj.cms.domain; <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
// public class FakeReport { select
// /** 打假举报ID */