springboot整合UReport2

小灰灰 2020-11-06 12:49 2212阅读 3赞

### 1、首先新建一个springboot项目 ###

可以用idea直接新建,也可以在spring-boot官方提供的生成器生成项目，生成地址是:[https://start.spring.io/][https_start.spring.io]

### 2、配置pom.xml ###

<dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.1</version>
            </dependency>
    
            
            <dependency>
                <groupId>com.syyai.spring.boot</groupId>
                <artifactId>ureport-spring-boot-starter</artifactId>
                <version>2.2.9</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
                <exclusions>
                    <exclusion>
                        <groupId>org.junit.vintage</groupId>
                        <artifactId>junit-vintage-engine</artifactId>
                    </exclusion>
                </exclusions>
            </dependency>
        </dependencies>

### 3、配置application.yml配置文件 ###

spring:
      type: com.alibaba.druid.pool.DruidDataSource
      datasource:
        url: jdbc:mysql://localhost:3306/ureport?useUnicode=true&characterEncoding=UTF8&autoReconnect=true&useSSL=false&serverTimezone=Asia/Shanghai
        username: root
        password: 123456
        driver-class-name: com.mysql.cj.jdbc.Driver
      main:
        allow-bean-definition-overriding: true
    
    logback:
      logPath: /ureport/log
      level: INFO
    
    server:
      port: 8080

### 4、编写config代码类，用于配置UReport2 ###

import com.bstek.ureport.console.UReportServlet;
    import com.bstek.ureport.definition.datasource.BuildinDatasource;
    import org.slf4j.Logger;
    import org.slf4j.LoggerFactory;
    import org.springframework.boot.web.servlet.ServletRegistrationBean;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.context.annotation.ImportResource;
    
    import javax.annotation.Resource;
    import javax.sql.DataSource;
    import java.sql.Connection;
    import java.sql.SQLException;
    
    @ImportResource("classpath:ureport-console-context.xml")//不加项目能够启动但是会导致加载数据源报错或加载不了
    @Configuration
    public class UreportConfig implements BuildinDatasource {
        @Resource
        DataSource dataSource;
        private Logger log = LoggerFactory.getLogger(getClass());
    
        @Bean //定义ureport的启动servlet
        @SuppressWarnings("unchecked")
        public ServletRegistrationBean ureportServlet(){
            ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new UReportServlet());
            servletRegistrationBean.addUrlMappings("/ureport/*");
            return servletRegistrationBean;
        }
        @Override
        public String name() {
            return "myUReportDatasource";
        }
    
        @Override
        public Connection getConnection() {
            try {
                return dataSource.getConnection();
            } catch (SQLException e) {
                log.error("Ureport 数据源 获取连接失败！");
                e.printStackTrace();
            }
            return null;
        }
    
    }

### 5、启动项目，打开ureport设计页面 ###

访问:http://localhost:8080/ureport/designer

即可打开报表设计页面

[https_start.spring.io]: https://start.spring.io/