Sppringboot整合mybatis

1maven中添加mybatis相关的额依赖

	<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>

		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.3.2</version>
		</dependency>
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid-spring-boot-starter</artifactId>
			<version>1.1.9</version>
		</dependency>

2、添加对应的配置文件

#与数据库链接相关的东东
spring.datasource.url=jdbc:mysql://172.16.20.91:3306/signature
spring.datasource.username: root
spring.datasource.password: root
spring.datasource.driver-class-name: com.mysql.jdbc.Driver

#mapper对应的位置
mybatis.mapper-locations=classpath:mapper/*.xml
#扫描对应的dao层接口
mybatis.type-aliases-package=com.zztl.signature.dao

3、添加对应的dao层接口

@Mapper
public interface BtcRawMapper {

    public void saveBtc(Map<String,String> params);
}

4、添加对应的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.sz.zztl.dao.BtcRawMapper">
    <insert id="saveBtc" parameterType="java.util.Map" >
            insert into zztl_signature_key_btc(pub_key,pri_key,create_time,update_time)
            values(#{pubkey},#{prikey},NOW(),NOW())

    </insert>
    
</mapper>

记住 再启动类添加扫描注释

@MapperScan("mapper接口对应的包名")