Shulou(Shulou.com)06/03 Report--

公众号：java乐园

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

一、 pom.xml文件引用

org.mybatis mybatis-spring 1.3.2 org.mybatis.spring.boot mybatis-spring-boot-starter 1.3.2

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

mybatis: mapperLocations: classpath:sc/provider/dao/*.xml #configLocation: classpath:mybatis-config.xml

三、 编写mapper文件user-mapper.xml

select id, userName, age, position from t_user where id = #{id,jdbcType=INTEGER} select id, userName, age, position from t_user insert into t_user ( id, userName, age, position ) values ( #{id,jdbcType=INTEGER}, #{userName,jdbcType=VARCHAR}, #{age,jdbcType=INTEGER}, #{position,jdbcType=VARCHAR} ) update t_user set userName = #{userName,jdbcType=VARCHAR}, age = #{age,jdbcType=INTEGER}, position = #{position,jdbcType=VARCHAR} where id = #{id,jdbcType=INTEGER} delete from t_user where id = #{id,jdbcType=INTEGER}

四、 编写UserDao.java

package sc.provider.dao;import java.util.List;import sc.provider.model.User;public interface UserDao { User getUser(Long id); List 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工程上改造）

一、 依赖必不可少

org.mybatis mybatis-spring 1.3.2 org.mybatis.spring.boot mybatis-spring-boot-starter 1.3.2

二、 删除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;@Mapperpublic 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 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@MapperScan(basePackages="sc.provider.dao")public class ProviderApplication { public static void main(String[] args) { SpringApplication.run(ProviderApplication.class, args); }}

经过以上步骤就把使用xml方式的mybatis改造成使用annotation方式的mybatis了。

2、启动注册中心sc-eureka-server，启动sc-eureka-client-provider-annotation（使用sc-eureka-client-provider项目改造），验证是否改造成功

方式一：

Method 2:

Enclosed names are those configured in application.yml.

3, use the postman method corresponding restful interface, here will not visit one by one, you can refer to the access method of the previous article

Add:

http://127.0.0.1:8300/user/addUser

Inquiry:

http://127.0.0.1:8300/user/getUser/4

List:

http://127.0.0.1:8300/user/listUser

Update:

http://127.0.0.1:8300/user/updateUser

Delete:

http://127.0.0.1:8300/user/deleteUser/2

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.