[SpringBoot]SpringBoot结合Mybatis小记

添加Mabatis

配置文件中加入如下

 新建mybatisConfig.xmlz

<?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>
<properties>
	<property name="driver" value="com.alibaba.druid.pool.DruidDataSource"/>
	<property name="url" value="jdbc:mysql://**.**.**.**:**/**?characterEncoding=UTF-8"/>
	<property name="username" value="MYUSERNAME"/>
	<property name="password" value="MYPASSWORD"/>
</properties>

   <!-- 环境，可以配置多个，default：指定采用哪个环境 -->
   <environments default="test">
      <!-- id：唯一标识 -->
      <environment id="test">
         <!-- 事务管理器，JDBC类型的事务管理器 -->
         <transactionManager type="JDBC" />
         <!-- 数据源，池类型的数据源 -->
         <dataSource type="POOLED">
			<property name="driver" value="com.alibaba.druid.pool.DruidDataSource"/>
			<property name="url" value="jdbc:mysql://**.**.**.**:**/**?characterEncoding=UTF-8"/>
			<property name="username" value="MYUSERNAME"/>
			<property name="password" value="MYPASSWORD"/>	
         </dataSource>
      </environment>
      <environment id="development">
         <!-- 事务管理器，JDBC类型的事务管理器 -->
         <transactionManager type="JDBC" />
         <!-- 数据源，池类型的数据源 -->
         <dataSource type="POOLED">
            <property name="driver" value="${driver}" /> <!-- 配置了properties，所以可以直接引用 -->
            <property name="url" value="${url}" />
            <property name="username" value="${username}" />
            <property name="password" value="${password}" />
         </dataSource>
      </environment>
   </environments>
  </configuration>

修改pom.xml文件

<dependcies>下添加(版本按需调整)

 

 <project>下添加(用于指定xml的路径)

 

新建mapper和service

 rsidMapper.java

package com.pky.roadshow.mapper;

import org.apache.ibatis.annotations.Mapper;

@Mapper

public interface rsidMapper{
	int getrscount();
}

  rsidMapper.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.pky.roadshow.mapper.rsidMapper">
	<select id="getrscount" resultType="int">
		select count(*) from RS_ROAD_SHOW rs
	</select>
</mapper>

  rsidService.java

package com.pky.roadshow.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service

public class rsidService{
	@Autowired
	com.pky.roadshow.mapper.rsidMapper rsidMapper;
	
	public int getrscount() {
		return rsidMapper.getrscount();
		
	}
}

controller里添加

	@Autowired
	rsidService rsidsrv;

即可如下调用

int rscount=rsidsrv.getrscount();

可以运行

备注:

Illegal reflective access by org.apache.ibatis.reflection.Reflector

Please consider reporting this to the maintainers of org.apache.ibatis.reflection.Reflector

 解决方案:提高mybatis版本(或者使用较早jdk)