5、springcloud整合mybatis注解方式_Java

1、上一篇学习了服务提供者provider，但是并不是单单就学习了服务提供者。中间还穿插使用了hikari数据源和spring cloud整合mybatis。但是上篇使用mybatis时还是沿用了老的方式，需要配置mapper对应的xml文件。先来看看上篇使用mybatis的主要步骤

一、 pom.xml文件引用

<groupid>org.mybatis</groupid>

<artifactid>mybatis-spring</artifactid>

</dependency>

<groupid>org.mybatis.spring.boot</groupid>

<artifactid>mybatis-spring-boot-starter</artifactid>

</dependency>

二、application.yml配置文件加入mybtias配置项

mybatis:

mapperlocations: classpath:sc/provider/dao/*.xml

#configlocation: classpath:mybatis-config.xml

三、编写mapper文件user-mapper.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" >

select id, username, age, position from t_user where id = #{id,jdbctype=integer}

</select>

select id, username, age, position from t_user

</select>

insert into t_user (

id, username, age, position

) values (

#{id,jdbctype=integer},

#{username,jdbctype=varchar},

#{age,jdbctype=integer},

#{position,jdbctype=varchar}

)

</insert>

update t_user set

username = #{username,jdbctype=varchar},

age = #{age,jdbctype=integer},

position = #{position,jdbctype=varchar}

where id = #{id,jdbctype=integer}

</update>

delete from t_user

where id = #{id,jdbctype=integer}

</delete>

</mapper>

四、编写userdao.java

package sc.provider.dao;

import java.util.list;

import sc.provider.model.user;

public interface userdao {

user getuser(long id);

list<user> listuser();

int adduser(user user);

int updateuser(user user);

int deleteuser(long id);

}

五、在providerapplication.java添加@mapperscan(basepackages="sc.provider.dao")

经过上面五个步骤才能使用mybatis。本篇将和大家看看不能简化spring cloud 整合mybatis的步骤（在sc-eureka-client-provider工程上改造）

一、依赖必不可少

<groupid>org.mybatis</groupid>

<artifactid>mybatis-spring</artifactid>

</dependency>

<groupid>org.mybatis.spring.boot</groupid>

<artifactid>mybatis-spring-boot-starter</artifactid>

</dependency>

二、删除application.yml关于mybatis的配置

三、删除mapper文件user-mapper.xml文件

四、改造userdao.java类

package sc.provider.dao;

import java.util.list;

import org.apache.ibatis.annotations.delete;

import org.apache.ibatis.annotations.insert;

import org.apache.ibatis.annotations.mapper;

import org.apache.ibatis.annotations.select;

import org.apache.ibatis.annotations.update;

import sc.provider.model.user;

@mapper

public interface userdao {

@select(value="select id, username, age, position from t_user where id = #{id,jdbctype=integer}")

user getuser(long id);

@select(value="select id, username, age, position from t_user")

list<user> listuser();

@insert(value="insert into t_user (id, username, age, position) values ( #{id,jdbctype=integer},#{username,jdbctype=varchar},#{age,jdbctype=integer},#{position,jdbctype=varchar})")

int adduser(user user);

@update(value="update t_user set username = #{username,jdbctype=varchar},age = #{age,jdbctype=integer},position = #{position,jdbctype=varchar} where id = #{id,jdbctype=integer}")

int updateuser(user user);

@delete(value=" delete from t_user where id = #{id,jdbctype=integer}")

int deleteuser(long id);

}

五、 @mapperscan注解必不可少

package sc.provider;

import org.mybatis.spring.annotation.mapperscan;

import org.springframework.boot.springapplication;

import org.springframework.boot.autoconfigure.springbootapplication;

import org.springframework.cloud.netflix.eureka.enableeurekaclient;

@springbootapplication

@enableeurekaclient