mybatis语句整理

1.与数据库对应的注解

      

@Data
@Accessors(chain = true)
@TableName("be_person_info")
public class BePersonInfo extends BaseEntity implements Serializable {
      private static final long serialVersionUID = 1L;

　　　　@TableField(exist = false)
　　　　private List<BusinessEntityData> businessEntityDataDtoList;

 

 

2.xml文件

<?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.jyb.system.modules.mapper.BeEnterpriseInfoMapper">
　　　

      

<select id="getEntityById" resultMap="entityMap">
select
be.*, bpi.*, bei.*, bed.*
from business_entity be
left join be_person_info bpi on bpi.be_id = be.id and bpi.del_flag = 0
left join be_enterprise_info bei on bei.be_id = be.id and bei.del_flag = 0
left join business_entity_data bed on bed.be_id = be.id and bed.del_flag = 0
where be.id = #{id} and be.del_flag = 0
</select>

　　

<resultMap id="entityMap" type="com.jyb.system.modules.entity.BusinessEntity">
<id property="id" column="id"/>
<result property="beName" column="be_name"/>
<result property="beType" column="be_type"/>
<result property="status" column="status"/>
<result property="email" column="email"/>
<result property="contacts" column="contacts"/>
<result property="contactsNumber" column="contacts_number"/>
<result property="telNumber" column="tel_number"/>
<result property="address" column="address"/>
<result property="delFlag" column="del_flag"/>
<result property="createBe" column="create_be"/>
<result property="createTime" column="create_time"/>
<result property="updateBe" column="update_be"/>
<result property="updateTime" column="update_time"/>
<association property="bePersonInfoDto"
javaType="com.jyb.system.modules.entity.BePersonInfo">
<result property="beId" column="be_id"></result>
<result property="certificateType" column="certificate_type"></result>
<result property="certificateNo" column="certificate_no"></result>
<result property="name" column="name"></result>
<result property="sex" column="sex"></result>
<result property="email" column="email"></result>
</association>
<association property="beEnterpriseInfoDto"
javaType="com.jyb.system.modules.entity.BeEnterpriseInfo">
<result property="beId" column="be_id"></result>
<result property="legalPerson" column="legal_person"></result>
<result property="legalPersonNo" column="legal_person_no"></result>
<result property="enterpriseName" column="enterprise_name"></result>
<result property="actualController" column="actual_controller"></result>
<result property="actualControllerNo" column="actual_controller_no"></result>
<result property="unifiedCode" column="unified_code"></result>
<result property="taxType" column="tax_type"></result>
</association>
<collection property="businessEntityDataDtoList"
javaType="java.util.List"
ofType="com.jyb.system.modules.entity.BusinessEntityData">
<result property="dataObjectKey" column="data_object_key"></result>
<result property="dataName" column="data_name"></result>
<result property="dataType" column="data_type"></result>
</collection>

</resultMap>

　　<result property="beName" column="be_name"/>

</mapper>