江苏龙网

  1. 主页 > 生活百科 > >

如何在SpringBoot中集成MyBatis

SpringBoot

本文主要讲解如何在Springboot中逐步实现对MyBatis的集成应用 。
1、引入依赖在pom.xml文件中引入mybatis依赖 。
// pom.xml <dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId></dependency>2、参数配置在Application.yml配置文件中写入mybatis相关配置 。
mybatis:mapper-locations: classpath:mybatis/mapper/**/*.xml#注意：一定要对应mapper映射xml文件的所在路径type-aliases-package: com.knight.ygtcloud.base.entity# 注意：对应实体类的路径# spring boot集成mybatis的方式打印sqlconfiguration:log-impl: org.Apache.ibatis.logging.nologging.NoLoggingImpl #不打印SQLmap-underscore-to-camel-case: true #开启自动下划线格式转驼峰格式3、mapper文件编写mapper文件如下：
public interface SysUserMapper {int deleteByPrimaryKey(Long id);int insert(SysUser record);int insertSelective(SysUser record);SysUser selectByPrimaryKey(Long id);int updateByPrimaryKeySelective(SysUser record);int updateByPrimaryKey(SysUser record);}4、MapperScan注解在主应用Application上通过@MapperScan注解指定mapper文件的扫描路径 。
@MapperScan("com.myApp.dao")public class MyApplication {public static void main(String[] args) {SpringApplication.run(MyApplication .class, args);} }5、xml映射文件在配置文件指定路径（classpath:mybatis/mapper/**/*.xml）下编写mapper对应的xml映射文件，参考内容如下：
【如何在SpringBoot中集成MyBatis】<?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.knight.ygtcloud.base.dao.SysUserMapper"><resultMap id="BaseResultMap" type="com.knight.ygtcloud.base.entity.SysUser"><id column="id" jdbcType="BIGINT" property="id" /><result column="login_name" jdbcType="VARCHAR" property="loginName" /><result column="mix_pd" jdbcType="VARCHAR" property="mixPd" /><result column="user_name" jdbcType="VARCHAR" property="userName" /><</resultMap><sql id="Base_Column_List">id, login_name, mix_pd, user_name, user_type, user_code, sex, note, mobile, dept_first_id,dept_first_name, dept_second_id, dept_second_name, org_id, org_name, email, state,openId, userId, create_time, create_id, create_name, head_image, phone_image, lock_times,lock_time, account_type, tech_title_key, tech_title_value, is_expert, sickness_id_list,sickness_name_list, duty_key, duty_value, education_key, education_value, create_org_id,create_org_name, wx_nick_name, wx_country, wx_province, wx_city, belong_org_province_id,belong_org_province_name, belong_org_city_id, belong_org_city_name, belong_org_county_id,belong_org_county_name, belong_org_town_id, belong_org_town_name, belong_org_village_id,belong_org_village_name, online_state</sql><select id="selectByPrimaryKey" parameterType="JAVA.lang.Long" resultMap="BaseResultMap">select<include refid="Base_Column_List" />from sys_userwhere id = #{id,jdbcType=BIGINT}</select><delete id="deleteByPrimaryKey" parameterType="java.lang.Long">delete from sys_userwhere id = #{id,jdbcType=BIGINT}</delete></mapper>


    推荐阅读


    上一篇：WPS-工资条批量操作可以这样用

    下一篇：在 Java 中节省内存：实现最小的内存占用