springboot整合mybatis

整合mybatis

基础配置

• 启动类添加@MapperScan

• 配置文件

  #=================================数据库相关配置====================================
  spring.datasource.driver-class-name=com.mysql.jdbc.Driver
  spring.datasource.url=jdbc:mysql://10.1.1.1:3306/db?useUnicode=true&characterEncoding=utf-8&userSSL=false
  spring.datasource.username=root
  spring.datasource.password=xxxxxx
  #如果不使用默认的数据源 （com.zaxxer.hikari.HikariDataSource）
  spring.datasource.type =com.alibaba.druid.pool.DruidDataSource
  
  
  # mybatis 下划线转驼峰配置,两者都可以
  #mybatis.configuration.mapUnderscoreToCamelCase=true
  mybatis.configuration.map-underscore-to-camel-case=true
  
  #打印sql，方便调试
  mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
  

configuration

mappers

<mappers>
    <mapper resource="mapper/VideoMapper.xml"/>
</mappers>

typeAliases

<typeAliases>
    <typeAlias type="com.xdclass.xdmybatis.domain.Video" alias="Video"></typeAlias>
	<package name="com.xdclass.xdmybatis.domain"/>
	<<可以将包里的所以类自动取别名>>
</typeAliases>

environments

<!--引入properties文件-->
<properties resource="db.properties"/>
<!--环境的配置-->
<environments default="development">
    <environment id="development">
       <!-- 配置事务-->
        <transactionManager type="JDBC"></transactionManager>
       <!-- 配置数据源-->
        <dataSource type="POOLED">
            <property name="driver" value="${jdbc.driver}"/>
            <property name="url" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
        </dataSource>
    </environment>
</environments>

setting

基础语法

• Select

  @Select("select * from video")
      @Results({
              @Result(column = "cover_img",property = "coverImg"),
              @Result(column = "create_time",property = "createTime")
      })
  

• Insert

  @Insert("INSERT INTO `video` ( `title`, `summary`, " +
              "`cover_img`, `view_num`, `price`, `create_time`," +
              " `online`, `point`)" +
              "VALUES" +
              "(#{title}, #{summary}, #{coverImg}, #{viewNum}, #{price},#{createTime}" +
              ",#{online},#{point});")
  @Options(useGeneratedKeys=true, keyProperty="id", keyColumn="id")
  

• Delete

  @Delete("DELETE FROM video WHERE id =#{id}")
  

• UpdateProvider(动态语句构建)

  InsertProvider DeleteProvider SelectProvider

  @UpdateProvider(type = VideoProvider.class,method = "updateVideo")
  int update(Video Video);
  
  public class VideoProvider {
      public String updateVideo(final Video video){
          return new SQL(){{
              UPDATE("video")
              //条件写法.
              if(video.getTitle()!=null){
                  SET("title=#{title}");
              }
              WHERE("id=#{id}");
          }}.toString();
      }
  }
  

PageHelper分页使用

config类

@Configuration
public class MyBatisConfig {
    @Bean
    public PageHelper pageHelper(){
        PageHelper pageHelper = new PageHelper();
        Properties p = new Properties();
        // 设置为true时，会将RowBounds第一个参数offset当成pageNum页码使用
        p.setProperty("offsetAsPageNum","true");
        //设置为true时，使用RowBounds分页会进行count查询
        p.setProperty("rowBoundsWithCount","true");
        p.setProperty("reasonable","true");
        pageHelper.setProperties(p);
        return pageHelper;
    }
}

pom.xml

		<!-- 分页插件依赖 -->
		<dependency>
			<groupId>com.github.pagehelper</groupId>
			<artifactId>pagehelper</artifactId>
			<version>4.1.0</version>
		</dependency>

使用

PageHelper.startPage(page,size);
PageInfo<Video> pageInfo = new PageInfo<>(list);//参数，查询出的数据
//总条数 pageInfo.getTotal()
//总页数 pageInfo.getPages()
//当前页 page
//数据   pageInfo.getList()