若依前后端分离框架集成UReport2，保存至数据库并结合业务使用导出 - IT评测·应用市场-qidao123.com

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

复制代码

@ImportResource("classpath:ureport-console-context.xml")
@SpringBootApplication(exclude = { DataSourceAutoConfiguration.class })
public class RuoYiApplication {
public static void main(String[] args) {
SpringApplication.run(RuoYiApplication.class, args);
System.out.println("(♥◠‿◠)ﾉﾞ若依启动成功 ლ(´ڡ`ლ)ﾞ \n" +
" .-------. ____ __ \n" +
" | _ _ \\ \\ \\ / / \n" +
" | ( ' ) | \\ _. / ' \n" +
" |(_ o _) / _( )_ .' \n" +
" | (_,_).' __ ___(_ o _)' \n" +
" | |\\ \\ | || |(_,_)' \n" +
" | | \\ `' /| `-' / \n" +
" | | \\ / \\ / \n" +
" ''-' `'-' `-..-' ");
}
@Bean
public ServletRegistrationBean buildUReportServlet(){
return new ServletRegistrationBean(new UReportServlet(),"/ureport/*");
}

复制代码

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd">
<import resource="classpath:ureport-console-context.xml" />
<bean id="propertyConfigurer" parent="ureport.props">
<property name="location">
<value>classpath:config.properties</value>
</property>
</bean>
</beans>

复制代码

ureport.disableHttpSessionReportCache=false
ureport.disableFileProvider=true
ureport.fileStoreDir=/WEB-INF/ureportfiles
ureport.debug=true

复制代码

'/ureport': {
target: 'http://localhost:8080',
ws:false,
changeOrigin: true,
pathRewrite: {
'^/ureport': '/ureport'
}
}

复制代码

<template>
<div v-loading="loading" :style="'height:'+ height">
<iframe :src="src" frameborder="no" style="width: 100%;height: 100%" scrolling="auto"/>
</div>
</template>
<script>
export default {
name: "Ureport",
data() {
return {
src: "/ureport/designer",
height: document.documentElement.clientHeight - 94.5 + "px;",
loading: true
};
},
mounted: function() {
setTimeout(() => {
this.loading = false;
}, 230);
const that = this;
window.onresize = function temp() {
that.height = document.documentElement.clientHeight - 94.5 + "px;";
};
}
};
</script>

复制代码

CREATE TABLE `ureport_file_tbl` (
`id_` int(11) NOT NULL AUTO_INCREMENT,
`name_` varchar(100) NOT NULL,
`content_` mediumblob,
`create_time_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4;

复制代码

package com.ruoyi.module.ureport;
import java.io.ByteArrayInputStream;
import java.io.InputStream;
import java.io.UnsupportedEncodingException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import com.bstek.ureport.provider.report.ReportFile;
import com.bstek.ureport.provider.report.ReportProvider;
import com.ruoyi.module.domain.UreportFileEntity;
import com.ruoyi.module.mapper.UreportFileMapper;
/**
* Mysql 报表存储
* @author hanshiyi
* @version 2023年5月9日
*
*/
@Component
// 该注解可以利用其 prefix属性值 + 类的属性名在yml中配置属性值
// @ConfigurationProperties(prefix = "ureport.mysql.provider")
public class MySQLProvider implements ReportProvider{
private static final String NAME = "mysql-provider";
// 特定前缀，ureport底层会调用 getPrefix 方法来获取报表操作的Provier类
private String prefix = "mysql:";
// 是否禁用
private boolean disabled;
@Autowired
private UreportFileMapper ureportFileMapper;
@Override
public InputStream loadReport(String file)
{
UreportFileEntity ureportFileEntity = ureportFileMapper.queryUreportFileEntityByName(getCorrectName(file));
byte[] content = ureportFileEntity.getContent();
ByteArrayInputStream inputStream = new ByteArrayInputStream(content);
return inputStream;
}
@Override
public void deleteReport(String file)
{
ureportFileMapper.deleteReportFileByName(getCorrectName(file));
}
@Override
public List<ReportFile> getReportFiles()
{
List<UreportFileEntity> list = ureportFileMapper.queryReportFileList();
List<ReportFile> reportList = new ArrayList<>();
for (UreportFileEntity ureportFileEntity : list) {
reportList.add(new ReportFile(ureportFileEntity.getName(), ureportFileEntity.getUpdateTime()));
}
return reportList;
}
@Override
public void saveReport(String file, String content)
{
file = getCorrectName(file);
UreportFileEntity ureportFileEntity = ureportFileMapper.queryUreportFileEntityByName(file);
Date currentDate = new Date();
byte[] cString = null;
try {
cString = content.getBytes("utf-8");
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
if(ureportFileEntity == null){
ureportFileEntity = new UreportFileEntity();
ureportFileEntity.setName(file);
ureportFileEntity.setContent(cString);
ureportFileEntity.setCreateTime(currentDate);
ureportFileEntity.setUpdateTime(currentDate);
ureportFileMapper.insertReportFile(ureportFileEntity);
}else{
ureportFileEntity.setContent(cString);
ureportFileEntity.setUpdateTime(currentDate);
ureportFileMapper.updateReportFile(ureportFileEntity);
}
}
@Override
public String getName() {
return NAME;
}
@Override
public boolean disabled() {
return disabled;
}
@Override
public String getPrefix() {
return prefix;
}
/**
* 获取没有前缀的文件名
* @param name
* @return
*/
private String getCorrectName(String name)
{
if(name.startsWith(prefix))
{
name = name.substring(prefix.length(), name.length());
}
return name;
}
}

复制代码

import com.bstek.ureport.export.ExportConfigureImpl;
import com.bstek.ureport.export.ExportManager;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.util.Map;
import java.util.Objects;
/**
导出excel、pdf
*/
public class ExportUtils {
public static void exportPdf(ExportManager exportManager, String sourcePath, String targetPath, Map<String, Object> param) throws Exception {
try {
OutputStream fos = new FileOutputStream(targetPath);
try {
ExportConfigureImpl exportConfigure = new ExportConfigureImpl(sourcePath, param, fos);
exportManager.exportPdf(exportConfigure);
} catch (Exception e) {
throw new Exception("exportPdf error", e);
} finally {
if (fos != null) {
try {
fos.close();
}catch(Exception e) {
throw new Exception("exportPdf error", e);
}
}
}
} catch (Exception e) {
throw new Exception("exportPdf error", e);
}
}
public static void exportExcel(ExportManager exportManager, String sourcePath, String targetPath, Map<String, Object> param) throws Exception {
try {
OutputStream fos = new FileOutputStream(targetPath);
try {
String ext = targetPath.substring(targetPath.indexOf(".") + 1);
ExportConfigureImpl exportConfigure = new ExportConfigureImpl(sourcePath, param, fos);
if (Objects.equals(ext, "xls")) {
exportManager.exportExcel97(exportConfigure);
} else {
if (!Objects.equals(ext, "xlsx")) {
throw new Exception("File name is not support!");
}
exportManager.exportExcel(exportConfigure);
}
} catch (Exception e) {
throw new Exception("exportExcel error", e);
} finally {
if (fos != null) {
try {
fos.close();
} catch (Exception e) {
throw new Exception("exportExcel error", e);
}
}
}
} catch (Exception e) {
throw new Exception("exportExcel error", e);
}
}
}

复制代码

ExportUtils.exportExcel(exportManager,sourcePath,filePath,dataMap);

复制代码

import com.bstek.ureport.export.html.HtmlReport;
import java.util.Map;
public interface ExportManager {
String BEAN_ID = "ureport.exportManager";
HtmlReport exportHtml(String var1, String var2, Map<String, Object> var3);
HtmlReport exportHtml(String var1, String var2, Map<String, Object> var3, int var4);
void exportPdf(ExportConfigure var1);
void exportExcel(ExportConfigure var1);
void exportExcel97(ExportConfigure var1);
void exportExcelWithPaging(ExportConfigure var1);
void exportExcel97WithPaging(ExportConfigure var1);
void exportExcelWithPagingSheet(ExportConfigure var1);
void exportExcel97WithPagingSheet(ExportConfigure var1);
void exportWord(ExportConfigure var1);
}

复制代码

String sourcePath = "mysql:测试导出模板.ureport.xml";

复制代码

String filePath = "D:/ureport/xxx.xlsx";

复制代码