Springboot + Dubbo 构建多模块项目 (四)

这一节给Springboot项目集成 Mybatis 和 MySql数据库。

1.springboot-service添加依赖

        <!-- spring-boot整合mybatis -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.0</version>
        </dependency>
        <!-- mysql驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
        </dependency>

2.springboot-service 创建DAO接口：

package com.myapp.core.mapper;

import org.apache.ibatis.annotations.Mapper;

/**
 * @author :zzb
 * @createDate :2019/6/26 17:57
 * @desc :
 */
@Mapper
public interface IUserDao {

    int addUser(String name,String pwd);
}

3.springboot-service Resources 下创建 IUserDao.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.myapp.core.mapper.IUserDao" >

    <resultMap id="BaseResultMap" type="com.myapp.core.model.pojo.user" >
        <id column="id" property="id" jdbcType="INTEGER" />
        <result column="name" property="name" jdbcType="VARCHAR" />
        <result column="pwd" property="pwd" jdbcType="VARCHAR" />
    </resultMap>

    <insert id="addUser" parameterType="String">
        INSERT into user001(`NAME`,pwd) VALUES(#{name},#{pwd})
    </insert>
</mapper>

对用BIZ层进行调用DAO层接口：

package com.myapp.core.service.impl;

import com.myapp.core.mapper.IUserDao;
import com.myapp.core.service.HelloAService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

/**
 * @author :zzb
 * @createDate :2019/6/25 15:55
 * @desc :
 */
@Service("helloAService")
public class HelloAServiceImpl implements HelloAService {

    @Resource
    private IUserDao userDao;

    @Override
    public String sayHello(String name) {
        System.out.println("----------------------002-----------------执行BIZ层service--------------------------------");
        userDao.addUser("zzb0001","zzb0001");
        return name+"-------Service";
    }
}

4. Springboot 启动类添加注解 @MapperScan("com.myapp.core.mapper")  ##对应其创建DA

package com.myapp.core;

import com.alibaba.dubbo.spring.boot.annotation.EnableDubboConfiguration;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@EnableDubboConfiguration
@MapperScan("com.myapp.core.mapper")
public class SpringbootServiceApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringbootServiceApplication.class, args);
    }

}

5.application.yml 添加相应内容：

##服务端口
server:
  port: 8334

##配置zookeeper
spring:
  dubbo:
    application:
      name: dubbo-provider
      registry: zookeeper://192.168.1.104:2181
  datasource: ##配置数据源
    url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8
    username: root
    password: root
    driver-class-name: com.mysql.jdbc.Driver

##mybatis配置
mybatis:
  type-aliases-package: com.myapp.core.model.*
  mapper-locations: classpath:mapper/*/*.xml

配置完成，启动即可实现链接数据库操作。

完整项目请参考 GitHub Springboot