--主配置文件(.yml)
mybatis:
mapper-locations: classpath:mapper/*.xml
type-aliases-package: com.dhht.model
config-location: classpath:mybatis-config.xml
--启动类添加dao层扫描注解
@MapperScan({"com.dhht.dao","com.dhht.client.dao"})
--自定义mybatis-config.xml配置文件(看自己需求)
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--<settings>
<setting name="logImpl" value="STDOUT_LOGGING" />
<setting name="mapUnderscoreToCamelCase" value="true" />
</settings>-->
<settings>
<setting name="logImpl" value="STDOUT_LOGGING" />
<setting name="callSettersOnNulls" value="true"/>
</settings>
<!-- 命名空间,需要采用bean的方式操作时需要在此注入 -->
<typeAliases>
<typeAlias type="com.dhht.util.page.Param" alias="pm"/>
<typeAlias type="com.dhht.util.page.Page" alias="page"/>
<typeAlias type="java.util.Map" alias="map"/>
<package name="com.dhht.model"/>
</typeAliases>
<!--<plugins>
<plugin interceptor="com.dhht.util.page.PagePlugin">
<property name="dialect" value="mysql"/>
<property name="pageSqlId" value=".*QueryPage.*"/>
</plugin>
</plugins>-->
<!--PageHelper分页插件-->
<!--<plugins>
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<property name="dialect" value="mysql"/>
</plugin>
</plugins>-->
</configuration>
--映射文件id自增长(此为mysql数据库方式，oracle会有所不同)
<insert id="addCropAtta" useGeneratedKeys="true" keyProperty="id" parameterType="com.dhht.model.Attachment">
insert into lv_attachment (flag, in_date,
is_deleted,image_type, attachment_no,name, path, url,crop_no)
values (#{flag,jdbcType=INTEGER}, #{inDate,jdbcType=TIMESTAMP},#{isDeleted,jdbcType=CHAR},#{imageType,jdbcType=VARCHAR},
#{attachmentNo,jdbcType=VARCHAR},#{name,jdbcType=VARCHAR},#{path,jdbcType=VARCHAR},#{url,jdbcType=VARCHAR},#{cropNo,jdbcType=VARCHAR})
</insert>
--批量插入/更新
int insertBatch(List<Map<String,Object>> list);-- dao接口层
<insert id="insertBatch" parameterType="java.util.List" >
insert into se_seal_order_seal (ID,SEAL_ORDER_ID,SEAL_ID)
values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.id},#{item.orderId},#{item.sealId})
</foreach>
</insert>
int updateBatchByMap(List<Map<String,Object>> list);-- dao接口层
<update id="updateBatchByMap" parameterType="java.util.List">
<foreach collection="list" item="item" separator=";">
update lv_attachment
set is_deleted = #{item.isDeleted},
flag = #{item.flag},
image_type = #{item.imageType},
crop_no = #{item.cropNo},
seal_no = #{item.sealNo},
crop_uuid = #{item.cropUuid},
seal_uuid = #{item.sealUuid}
where id = #{item.id}
</foreach>
</update>
--常用标签使用-(排序时使用${xx}传参数)
<select id="getMarkersiteListNew" parameterType="java.util.Map" resultType="java.util.Map">
SELECT
ms.id,ms.name,ms.address,ms.mobile AS phone,ce.score,mse.longitude,mse.latitude,spa.min_price,lsad.avg_time,s.seal_count as `count`,sp.`METERIAL_PRICE` AS gmPrice,
<choose>
<when test="isEmpLaLo != null and isEmpLaLo != ‘‘">
CALCU_LAT_LON_DISTANCE(${latitude},${longitude},mse.`LATITUDE`,mse.`LONGITUDE`) AS distance_t
</when>
<otherwise>
NULL AS distance_t
</otherwise>
</choose>
FROM
lv_marker_site ms
LEFT JOIN se_marker_site_expansion mse ON mse.`MARKER_SITE_ID`=ms.`id`
LEFT JOIN (SELECT MIN(pa.`METERIAL_PRICE`) AS min_price,MAX(pa.`METERIAL_PRICE`) AS max_price,pa.`MARKER_SITE_ID` FROM se_price_allocation pa GROUP BY pa.`MARKER_SITE_ID`) spa
ON spa.MARKER_SITE_ID=ms.`id`
LEFT JOIN (SELECT COUNT(ls.`id`) AS seal_count,ls.MARKER_SITE_ID FROM lv_seal ls WHERE ls.`status` in (‘1‘,‘4‘,‘5‘,‘6‘,‘7‘) and (ls.FETCH_DATE >= DATE_SUB(CURDATE(), INTERVAL 3 MONTH)) GROUP BY ls.MARKER_SITE_ID) s
ON (s.MARKER_SITE_ID=ms.`id`)
LEFT JOIN (SELECT sce.`MARKER_SITE_ID`,AVG(IF(ISNULL(sce.`SEAL_QUALITY`),0,sce.`SEAL_QUALITY`)+IF(ISNULL(sce.`SERVICE_QUALITY`),0,sce.`SERVICE_QUALITY`))/2 AS score FROM se_customer_evaluation sce GROUP BY sce.`MARKER_SITE_ID`) ce
ON ce.MARKER_SITE_ID=ms.`id`
LEFT JOIN (SELECT lsd.`marker_site_id`,AVG(DATEDIFF(lsd.`fetch_date`,lsd.`fill_date`)) AS avg_time FROM lv_seal lsd WHERE lsd.`fetch_date` IS NOT NULL AND lsd.`fill_date` IS NOT NULL GROUP BY lsd.`marker_site_id`) lsad
ON lsad.marker_site_id=ms.`id`
LEFT JOIN se_price_allocation sp ON (sp.MARKER_SITE_ID=ms.`id` AND sp.METERIAL_TYPE=‘05‘)
<where>
mse.BUSINESS_STATUS=1
<if test="adcode != null and adcode != ‘‘">
AND ms.`city_no`= ${adcode}
</if>
<if test="search != null and search != ‘‘">
AND ms.`name` LIKE CONCAT(‘%‘,#{search},‘%‘)
</if>
</where>
<choose>
<when test="sort eq ‘count‘">
ORDER BY `count` desc,gmPrice IS NULL,gmPrice,score DESC,avg_time IS NULL,avg_time
</when>
<when test="sort eq ‘price‘">
ORDER BY gmPrice IS NULL,gmPrice ${orb},score DESC,avg_time IS NULL,avg_time
</when>
<when test="sort eq ‘distance‘">
ORDER BY distance_t IS NULL,distance_t,ms.id,gmPrice IS NULL,gmPrice,score DESC,avg_time IS NULL,avg_time
</when>
<when test="sort eq ‘time‘">
ORDER BY avg_time IS NULL,avg_time
</when>
<otherwise>
ORDER BY score desc,gmPrice IS NULL,gmPrice,avg_time IS NULL,avg_time
</otherwise>
</choose>
</select>
--批量插入/更新
--批量插入/更新
原文：https://www.cnblogs.com/sung1024/p/11177994.html