Springboot集成UReport2

1.pom.xml引入依赖

<dependency>
          <groupId>com.bstek.ureport</groupId>
           <artifactId>ureport2-console</artifactId>
           <version>2.2.9</version>
</dependency>

2.编写config配置类

@Configuration
@ImportResource("classpath:context.xml")
@Slf4j
public class UReportConfig implements BuildinDatasource {

    @Resource
    private DataSource dataSource;

    //注册servlet组件
    @Bean
    public ServletRegistrationBean registrationBean() {
      return new ServletRegistrationBean(new UReportServlet(), "/ureport/*");

    }

    @Override
    public String name() {
        return "myDataSource";
    }

    @Override
    public Connection getConnection() {
        try {
            return dataSource.getConnection();
        } catch (SQLException e) {
            log.error("uReport 数据源 获取连接失败！-{}", e.getMessage());
        }
        return null;
    }
}

3.resources下添加相关配置文件

1) context.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

    <import resource="classpath:ureport-console-context.xml"/>

    <bean id="propertyConfigurer" parent="ureport.props">
        <property name="location">
            <value>file:${config.path}/ureport-config.properties</value>
        </property>
    </bean>

</beans>

2) ureport-config.properties

#ureport报表xml文件存放目录
ureport.fileStoreDir=F:\\work\\yyglpt\\service-test\\src\\main\\resources\\report

3) application.properties中添加指定${config.path}

config.path=F:\\work\\yyglpt\\service-test\\src\\main\\resources

4.编写相应Service:

1) 给Service起一个标识名

2) 方法的3个参数是固定写法,不能更改

@Service("roadService")
public class RoadService {
  /**
     * 路产管理月报
     * @param dsName
     * @param datasetName
     * @param parameters
     * @return
     */
    public List<RoadManageReport> queryRoadManageReport(String dsName, String datasetName, Map<String, Object> parameters) {
        String month = (String) parameters.get("month");
        List<RoadManageReport> list = initRoadManageReports();
        for (RoadManageReport report : list) {
            report.setMonthSum(getMonthSum());
            report.setYearSum(getYearSum(month));
        }

        return list;
    }  
}