SpringBoot2.0 集成 mybatis、freemark、eureka、swagger

   当我们从SpringBoot1.0过渡到 2.0的时候,可能会遇到各种各样的问题,比如我集成的时候遇到过版本冲突,打包错误,eureka注册不上去,以及无法启动等问题,因此我写了一片博客记录下来。我这里采用的是SpringBoot2.0.2版本。

 1.先搭建一个项目eureka-server  eureka的注册与发现(这里不过多描述)   

主要变化:引入jar包改变

1.0版本eureka引用的jar包

<dependency>
        <groupId>org.springframework.cloud</groupId>
        <artifactId>spring-cloud-starter-eureka-server</artifactId>
    </dependency>

2.0版本eureka引用的jar包

<dependency>
   <groupId>org.springframework.cloud</groupId>
   <artifactId>spring-cloud-starter-netflix-eureka-server</artifactId>
</dependency>

详细代码访问我的github:https://github.com/ningcs/stocks/tree/master/config-server

2 先搭建一个web项目stocks-bonus

   2.1  集成freemark 

① 引入freemark  jar包

<dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-freemarker</artifactId>
</dependency>

<dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-web</artifactId>
</dependency>

   ② 添加配置文件:

#freemark配置
spring.resources.static-locations=classpath:/static/
spring.freemarker.template-loader-path=classpath:/views/templates/
spring.freemarker.cache=false
spring.freemarker.charset=UTF-8
spring.freemarker.check-template-location=true
spring.freemarker.content-type=text/html
spring.freemarker.expose-request-attributes=true
spring.freemarker.expose-session-attributes=true
spring.freemarker.request-context-attribute=request
spring.freemarker.suffix=.ftl
server.servlet-path=/api/*

 

   ③控制层请求访问即可。

@Controller
public class bonusPageController {

    @RequestMapping(value = "/getPage" )
    public String  getPage(){
        return "index";
    }

}

注:其中spring.freemarker.template-loader-path根据自己的需求设置。 

 2.2 集成mybatis

①引入 mybatis,以及durid连接池,mysql支持jar包

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

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

②添加连接池和数据库配置

#mybatis配置
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/stocks?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.type = com.alibaba.druid.pool.DruidDataSource
spring.datasource.filters = stat
spring.datasource.maxActive = 20
spring.datasource.initialSize = 1
spring.datasource.maxWait = 60000
spring.datasource.minIdle = 1
spring.datasource.timeBetweenEvictionRunsMillis = 60000
spring.datasource.minEvictableIdleTimeMillis = 300000
spring.datasource.validationQuery = select 'x'
spring.datasource.testWhileIdle = true
spring.datasource.testOnBorrow = false
spring.datasource.testOnReturn = false
spring.datasource.poolPreparedStatements = true
spring.datasource.maxOpenPreparedStatements = 20
#数据库配置
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/stocks?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

③ 读取配置文件

package com.example.demo.config;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;

import javax.sql.DataSource;
import java.sql.SQLException;

@Configuration
public class DruidConfig {

    private Logger logger = LoggerFactory.getLogger(getClass());

    @Value("${spring.datasource.url}")
    private String dbUrl;

    @Value("${spring.datasource.username}")
    private String username;

    @Value("${spring.datasource.password}")
    private String password;

    @Value("${spring.datasource.driver-class-name}")
    private String driverClassName;

    @Value("${spring.datasource.initialSize}")
    private int initialSize;

    @Value("${spring.datasource.minIdle}")
    private int minIdle;

    @Value("${spring.datasource.maxActive}")
    private int maxActive;

    @Value("${spring.datasource.maxWait}")
    private int maxWait;

    @Value("${spring.datasource.timeBetweenEvictionRunsMillis}")
    private int timeBetweenEvictionRunsMillis;

    @Value("${spring.datasource.minEvictableIdleTimeMillis}")
    private int minEvictableIdleTimeMillis;

    @Value("${spring.datasource.validationQuery}")
    private String validationQuery;

    @Value("${spring.datasource.testWhileIdle}")
    private boolean testWhileIdle;

    @Value("${spring.datasource.testOnBorrow}")
    private boolean testOnBorrow;

    @Value("${spring.datasource.testOnReturn}")
    private boolean testOnReturn;

    @Value("${spring.datasource.poolPreparedStatements}")
    private boolean poolPreparedStatements;

    @Value("${spring.datasource.filters}")
    private String filters;

    @Bean
    public ServletRegistrationBean druidServlet() {
        ServletRegistrationBean reg = new ServletRegistrationBean();
        reg.setServlet(new StatViewServlet());
        reg.addUrlMappings("/druid/*");
        reg.addInitParameter("loginUsername", "druid");
        reg.addInitParameter("loginPassword", "jiajian123456");
        return reg;
    }

    @Bean
    public FilterRegistrationBean filterRegistrationBean() {
        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();
        filterRegistrationBean.setFilter(new WebStatFilter());
        filterRegistrationBean.addUrlPatterns("/*");
        filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
        filterRegistrationBean.addInitParameter("profileEnable", "true");
        filterRegistrationBean.addInitParameter("principalCookieName", "USER_COOKIE");
        filterRegistrationBean.addInitParameter("principalSessionName", "USER_SESSION");
        return filterRegistrationBean;
    }

    @Bean
    @Primary
    public DataSource druidDataSource(){
        DruidDataSource datasource = new DruidDataSource();

        datasource.setUrl(this.dbUrl);
        datasource.setUsername(username);
        datasource.setPassword(password);
        datasource.setDriverClassName(driverClassName);
        datasource.setInitialSize(initialSize);
        datasource.setMinIdle(minIdle);
        datasource.setMaxActive(maxActive);
        datasource.setMaxWait(maxWait);
        datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
        datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
        datasource.setValidationQuery(validationQuery);
        datasource.setTestWhileIdle(testWhileIdle);
        datasource.setTestOnBorrow(testOnBorrow);
        datasource.setTestOnReturn(testOnReturn);
        datasource.setPoolPreparedStatements(poolPreparedStatements);
        try {
            datasource.setFilters(filters);
        } catch (SQLException e) {
            logger.error("druid configuration initialization filter", e);
        }
        return datasource;
    }

}

 注:可以通过 localhost:端口/druid 监控连接池状况

账号密码在这段代码中已配置。

@Bean
    public ServletRegistrationBean druidServlet() {
        ServletRegistrationBean reg = new ServletRegistrationBean();
        reg.setServlet(new StatViewServlet());
        reg.addUrlMappings("/druid/*");
        reg.addInitParameter("loginUsername", "druid");
        reg.addInitParameter("loginPassword", "jiajian123456");
        return reg;
    }

启动类

@EnableEurekaClient
@EnableSwagger2
@SpringBootApplication
@MapperScan("com.example.demo.mapper")
public class StocksBonusApplication {

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

MapperScan 是写代码访问数据库的路径(dao层),根据实际情况书写

 2.3集成eureka

①引入jar包

<dependency>
   <groupId>org.springframework.cloud</groupId>
   <artifactId>spring-cloud-starter-netflix-eureka-client</artifactId>
</dependency>

②在启动类上面添加@EnableEurekaClient

③配置文件

#eureka配置
eureka.client.serviceUrl.defaultZone=http://localhost:18170/eureka/

 2.4集成swagger

①引入jar包

<!--swagger-->
<dependency>
   <groupId>io.springfox</groupId>
   <artifactId>springfox-swagger2</artifactId>
   <version>2.6.1</version>
</dependency>
<dependency>
   <groupId>io.springfox</groupId>
   <artifactId>springfox-swagger-ui</artifactId>
   <version>2.6.1</version>
</dependency>

② 启动类添加@EnableSwagger2

③代码实例

package com.example.demo.controller;

import com.example.demo.mapper.ProductMapper;
import demo.entity.Product;
import demo.util.DrawLotteryUtil;
import demo.util.ResponseResult;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@Api(tags = "BonusController", description = "抽奖查询相关接口")
@RestController
@RequestMapping("/bonus")
public class BonusController {

    @Autowired
    private ProductMapper productMapper;

//    @ApiOperation(value = "1.会员登录", notes = "1.会员登录")
//    @ApiImplicitParams({
//            @ApiImplicitParam(name = "keyword", paramType = "query", value = "会员号或手机号", required = true, dataType = "String", defaultValue = "766647"),
//            @ApiImplicitParam(name = "password", paramType = "query", value = "密码", required = true, dataType = "String", defaultValue = "12345678"),
//            @ApiImplicitParam(name = "imgCode", paramType = "query", value = "图形验证码", required = true, dataType = "String", defaultValue = "1234"),
//    })
    //swagger 访问地址 http://localhost:18171/swagger-ui.html#!
    @ApiOperation(value = "1.获取奖品列表", notes = "1.获取奖品列表")
    @RequestMapping(value = "/getProductList" ,method = RequestMethod.GET)
    public ResponseResult getProductList(){
        return  new ResponseResult(ResponseResult.SUCCESS,"获取奖品列表",productMapper.getList());
    }

    @ApiOperation(value = "2.获取抽奖结果", notes = "2.获取抽奖结果")
    @RequestMapping(value = "/getBonusReult" ,method = RequestMethod.GET)
    public ResponseResult getBonusReult(){
        int index =0;
        List<Product> products=productMapper.getList();
        if (!products.isEmpty()){
            index= DrawLotteryUtil.drawGift(products);
        }
        return  new ResponseResult(ResponseResult.SUCCESS,"获取抽奖结果",products.get(index));
    }

}

 

3 微服务之间互相访问(feignClient)

新建项目stocks-news 配置跟stocks-bonus一样

①引入jar包

<dependency>
   <groupId>org.springframework.cloud</groupId>
   <artifactId>spring-cloud-starter-openfeign</artifactId>
</dependency>

②启动类添加@EnableFeignClients

③写微服务访问实例

package com.example.demo.service;

import demo.entity.Product;
import org.springframework.cloud.openfeign.FeignClient;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import java.util.List;

@FeignClient("stocks-bonus")
public interface ProductService {
    @RequestMapping(value = "/bonus/getProductList" ,method = RequestMethod.GET)
    public List<Product> getProductList();

}

④代码测试

package com.example.demo.controller;


import com.example.demo.service.ProductService;
import demo.entity.Product;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@Api(tags = "BonusController", description = "抽奖查询相关接口")
@RestController
@RequestMapping("/news")
public class BonusController {

    @Autowired
    private ProductService productService;

//    @ApiOperation(value = "1.会员登录", notes = "1.会员登录")
//    @ApiImplicitParams({
//            @ApiImplicitParam(name = "keyword", paramType = "query", value = "会员号或手机号", required = true, dataType = "String", defaultValue = "766647"),
//            @ApiImplicitParam(name = "password", paramType = "query", value = "密码", required = true, dataType = "String", defaultValue = "12345678"),
//            @ApiImplicitParam(name = "imgCode", paramType = "query", value = "图形验证码", required = true, dataType = "String", defaultValue = "1234"),
//    })
    //swagger 访问地址 http://localhost:18172/swagger-ui.html#!
    @ApiOperation(value = "1.获取奖品列表", notes = "1.获取奖品列表")
    @RequestMapping(value = "/getProductList" ,method = RequestMethod.GET)
    public List<Product> getProductList(){
        return productService.getProductList();
    }

}

具体代码访问github:https://github.com/ningcs/stocks

 

转载于:https://my.oschina.net/u/2851681/blog/1936736

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值