支付行业的网站怎么做,深圳 网站建设,展示网站开发,wordpress 压缩包UReport是一款基于单元格迭代模型的纯Java中式报表引擎。它架构于Spring之上#xff0c;因此与企业应用具有良好的集成能力。UReport提供了基于Eclipse插件与基于网页的两种报表模版设计方式#xff0c;采用类Excel报表模版设计风格#xff0c;简单、易上手#xff0c;可在…UReport是一款基于单元格迭代模型的纯Java中式报表引擎。它架构于Spring之上因此与企业应用具有良好的集成能力。UReport提供了基于Eclipse插件与基于网页的两种报表模版设计方式采用类Excel报表模版设计风格简单、易上手可在不编程的情况下完成绝大多数报表模版的设计工作。
UReport的主要作用体现在以下几个方面
报表设计UReport支持简单、复杂报表的设计能够很好地嵌合实际业务需求。无论是通过纯SQL还是配置的方式都可以实现针对不同人员的报表管理。数据实时处理UReport能够根据实时数据自动调整参数以达到最佳效果。这种自动调整参数的能力使得模型能够快速响应并精确预测同时减少人工参与的次数提升模型的投入产出比。参数优化UReport是一种强大的参数优化技术它能够帮助用户改进模型参数最大化模型性能并减少人工参与提高模型的运行效率。通过UReport的帮助用户可以更快地实现模型的优化提升性能加快产品开发进度从而节省大量时间和金钱。
首先看一下整体目录 最终显示结果: 一需要引入相关依赖pom.xml
?xml version1.0 encodingUTF-8?
project xmlnshttp://maven.apache.org/POM/4.0.0xmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsdmodelVersion4.0.0/modelVersiongroupIdcom.crwl/groupIdartifactIdureport/artifactIdversion1.0-SNAPSHOT/versionpropertiesjava.version1.8/java.versionproject.build.sourceEncodingUTF-8/project.build.sourceEncodingmaven.compiler.source1.8/maven.compiler.sourcemaven.compiler.target1.8/maven.compiler.targetspring-cloud.version2.1.1.RELEASE/spring-cloud.versionflowable.version6.5.0/flowable.version/propertiesdependenciesdependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-jdbc/artifactIdversion2.0.9.RELEASE/version/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactIdversion2.0.9.RELEASE/version/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-data-redis/artifactIdversion2.0.9.RELEASE/version/dependencydependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdoptionaltrue/optionalversion1.16.20/version/dependencydependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.33/version/dependencydependencygroupIdcom.alibaba/groupIdartifactIdfastjson/artifactIdversionRELEASE/version/dependencydependencygroupIdcom.alibaba/groupIdartifactIdfastjson/artifactIdversionRELEASE/version/dependencydependencygroupIdcn.hutool/groupIdartifactIdhutool-all/artifactIdversion4.6.10/version/dependencydependencygroupIdcom.jfinal/groupIdartifactIdactiverecord/artifactIdversion4.8/version/dependencydependencygroupIdcom.alibaba/groupIdartifactIddruid/artifactIdversion1.1.6/version/dependencydependencygroupIdcom.bstek.ureport/groupIdartifactIdureport2-console/artifactIdversion2.2.9/version/dependencydependencygroupIdcom.bstek.ureport/groupIdartifactIdureport2-core/artifactIdversion2.2.9/version/dependency/dependencies
/project二配置resources:
1. application.yaml
server:port: 9090servlet:context-path: /pro
spring:http:encoding:force: trueenabled: truecharset: UTF-8datasource:driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/j2eedb?useUnicodetruecharacterEncodingutf8serverTimezoneGMT%2B8useSSLfalseallowMultiQueriestruenullNamePatternMatchesAlltrueusername: rootpassword: 123456type: com.alibaba.druid.pool.DruidDataSourceresources:static-locations: classpath:/,classpath:/static/2. config目录下config.properties
#ureport.fileStoreDirD:/myfile/ureportfiles
ureport.disableFileProvidertrue
ureport.fileToDbStoreDirD:/ureportDbfiles
ureport.disableFileDbProviderfalse
ureport.contextPath/pro3. config目录下context.xml
?xml version1.0 encodingUTF-8?
beans xmlnshttp://www.springframework.org/schema/beansxmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsdimport resourceclasspath:ureport-console-context.xml /bean idpropertyConfigurer parentureport.propsproperty namelocationslistvalueclasspath:config/config.properties/value/list/property/beanbean idureport.fielToDataBaseProvider classcom.report.provider.FileToDatabaserProviderproperty namefileStoreDir value${ureport.fileToDbStoreDir}/propertyproperty namedisabled value${ureport.disableFileDbProvider}/property/bean
/beans三配置数据源DataSourceConfig.java
package com.report.config;import com.alibaba.druid.pool.DruidDataSource;
import com.report.model._MappingKit;
import com.jfinal.plugin.activerecord.ActiveRecordPlugin;
import com.jfinal.plugin.activerecord.CaseInsensitiveContainerFactory;
import com.jfinal.plugin.activerecord.dialect.MysqlDialect;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy;import javax.sql.DataSource;Configuration
public class DataSourceConfig {PrimaryBeanConfigurationProperties(prefix spring.datasource)public DataSource druidDataSource() {return new DruidDataSource();}/*** 设置数据源代理*/Beanpublic TransactionAwareDataSourceProxy transactionAwareDataSourceProxy() {TransactionAwareDataSourceProxy transactionAwareDataSourceProxy new TransactionAwareDataSourceProxy();transactionAwareDataSourceProxy.setTargetDataSource(druidDataSource());return transactionAwareDataSourceProxy;}/*** 设置ActiveRecord*/Beanpublic ActiveRecordPlugin activeRecordPlugin() {ActiveRecordPlugin arp new ActiveRecordPlugin(transactionAwareDataSourceProxy());arp.setDialect(new MysqlDialect());arp.setContainerFactory(new CaseInsensitiveContainerFactory(true));//忽略大小写arp.setShowSql(true);arp.getEngine().setToClassPathSourceFactory();//arp.addSqlTemplate(sql/all.sql);_MappingKit.mapping(arp);arp.start();System.out.println(调用Jfinal ActiveRecordPlugin 成功);return arp;}
}四配置返回结果类Result.java
package com.report.dto;
import com.report.enums.ResultEnum;
import java.io.Serializable;public class Result implements Serializable {/****/private static final long serialVersionUID 3337439376898084639L;/*** 处理状态*/private Integer code;/*** 处理信息*/private String msg;private String serverID;/*** 返回值*/private Object data;private int total;private Object rows;/*** 成功传入data使用最多** param data* return*/public static Result success(Object data) {return Result.success(data,请求成功);}/*** 成功传入data使用最多* param msg* return*/public static Result success(String msg) {Result result new Result();result.setCode(ResultEnum.SUCCESS.getCode());result.setMsg(msg);return result;}/*** 成功传入rows和total* param rows* param total* return*/public static Result success(Object rows,int total) {Result result new Result();result.setCode(ResultEnum.SUCCESS.getCode());result.setMsg(请求成功);result.setRows(rows);result.setTotal(total);return result;}/*** 成功传入data 和 msg* param data* param msg* return*/public static Result success(Object data, String msg) {Result result new Result();result.setCode(ResultEnum.SUCCESS.getCode());result.setMsg(msg);result.setData(data);return result;}/*** 失败* return*/public static Result error() {return Result.error(请求失败);}/*** 失败 传入 msg* param msg* return*/public static Result error(String msg) {return Result.error(msg,ResultEnum.FAILURE);}public static Result error(String msg ,ResultEnum resultEnum){Result result new Result();result.setCode(resultEnum.getCode());result.setMsg(msg);return result;}public Integer getCode() {return code;}public void setCode(Integer code) {this.code code;if(null ! this.data this.data.getClass().getName().equals(com.crwl.commonserver.dto.CurrUser)){this.data null;}}public String getMsg() {return msg;}public void setMsg(String msg) {this.msg msg;}public String getServerID() {return serverID;}public void setServerID(String serverID) {this.serverID serverID;}public Object getData() {return data;}public void setData(Object data) {this.data data;}public int getTotal() {return total;}public void setTotal(int total) {this.total total;}public Object getRows() {return rows;}public void setRows(Object rows) {this.rows rows;}Overridepublic String toString() {return Result{ code code , msg msg \ , serverID serverID \ , data data , total total , rows rows };}
}五返回枚举类ResultEnum.java
package com.report.enums;
/*** 返回状态*/
public enum ResultEnum {/*** 200 OK //客户端请求成功* 400 Bad Request //客户端请求有语法错误不能被服务器所理解* 401 Unauthorized //请求未经授权这个状态代码必须和 WWW-Authenticate 报头域一起使用* 403 Forbidden //服务器收到请求但是拒绝提供服务* 404 Not Found //请求资源不存在eg输入了错误的 URL* 500 Internal Server Error //服务器发生不可预期的错误* 503 Server Unavailable //服务器当前不能处理客户端的请求一段时间后可能恢复正常*/SUCCESS(200, 操作成功),ERROR(500,操作失败), FAILURE(404, 请求的网页不存在),INVALID(503,服务不可用),LOGINOVERTIME(1000,登录超时);private ResultEnum(Integer code, String data) {this.code code;this.data data;}private Integer code;private String data;public Integer getCode() {return code;}public void setCode(Integer code) {this.code code;}public String getData() {return data;}public void setData(String data) {this.data data;}
}六BaseReport.java
package com.report.model.base;import com.jfinal.plugin.activerecord.IBean;
import com.jfinal.plugin.activerecord.Model;import java.util.Date;SuppressWarnings({serial, unchecked})
public abstract class BaseReportM extends BaseReportM extends ModelM implements IBean {public M setId(Integer id) {set(id, id);return (M)this;}public Integer getId() {return getInt(id);}public M setRptCode(String rptCode) {set(rpt_code, rptCode);return (M)this;}public String getRptCode() {return getStr(rpt_code);}public M setRptName(String rptName) {set(rpt_name, rptName);return (M)this;}public String getRptName() {return getStr(rpt_name);}public M setRptType(Integer rptType) {set(rpt_type, rptType);return (M)this;}public Integer getRptType() {return getInt(rpt_type);}public M setUreportName(String ureportName) {set(ureport_name, ureportName);return (M)this;}public String getUreportName() {return getStr(ureport_name);}public M setRptUrl(String rptUrl) {set(rpt_url, rptUrl);return (M)this;}public String getRptUrl() {return getStr(rpt_url);}public M setRemark(String remark) {set(remark, remark);return (M)this;}public String getRemark() {return getStr(remark);}public M setSort(Integer sort) {set(sort, sort);return (M)this;}public Integer getSort() {return getInt(sort);}public M setStatus(Integer status) {set(status, status);return (M)this;}public Integer getStatus() {return getInt(status);}public M setCreateUser(String createUser) {set(create_user, createUser);return (M)this;}public String getCreateUser() {return getStr(create_user);}public M setCreateDate(Date createDate) {set(create_date, createDate);return (M)this;}public Date getCreateDate() {return getDate(create_date);}public M setUpdateUser(String updateUser) {set(update_user, updateUser);return (M)this;}public String getUpdateUser() {return getStr(update_user);}public M setUpdateDate(Date updateDate) {set(update_date, updateDate);return (M)this;}public Date getUpdateDate() {return getDate(update_date);}
}七_MappingKit.java
package com.report.model;
import com.jfinal.plugin.activerecord.ActiveRecordPlugin;
public class _MappingKit {public static void mapping(ActiveRecordPlugin arp) {arp.addMapping(ur_report, id, Report.class);}
}八Report.java
package com.report.model;import com.report.model.base.BaseReport;
/*** Generated by JFinal.*/
SuppressWarnings(serial)
public class Report extends BaseReportReport {public static final Report dao new Report().dao();
}九DsProvider.java
package com.report.provider;import com.bstek.ureport.definition.datasource.BuildinDatasource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;//提供ureport 内置数据源连接
Component(dsScoreSys)
public class DsProvider implements BuildinDatasource {Autowiredprivate DataSource dataSource;Overridepublic String name() {return 内置数据源;}Overridepublic Connection getConnection() {try {return dataSource.getConnection();} catch (SQLException e) {e.printStackTrace();return null;}}
}
十 FileToDatabaserProvider.java
package com.report.provider;import com.bstek.ureport.exception.ReportException;
import com.bstek.ureport.provider.report.ReportFile;
import com.bstek.ureport.provider.report.ReportProvider;
import com.report.model.Report;
import org.apache.commons.io.IOUtils;
import org.apache.commons.lang.StringUtils;import java.io.*;
import java.util.*;public class FileToDatabaserProvider implements ReportProvider {private String prefixfileToDb:;private String fileStoreDir;private String disabled;Overridepublic InputStream loadReport(String file) {if(StringUtils.isNotEmpty(file)){String[] arr file.split();Report report null;if(null ! arr arr.length2){report Report.dao.findById(Integer.parseInt(arr[1]));file report.getUreportName();}else{report Report.dao.findFirst( select * from ur_report t where t.ureport_name?, file);}if(null ! report) {if (file.startsWith(prefix)) {file file.substring(prefix.length(), file.length());}String fullPath fileStoreDir / file;try {return new FileInputStream(fullPath);} catch (FileNotFoundException e) {throw new ReportException(e);}}else{throw new ReportException(报表文件不存在);}}else{throw new ReportException(报表文件不存在);}}Overridepublic void deleteReport(String file) {Report report Report.dao.findFirst( select * from ur_report t where t.ureport_name?,file);if(null ! report){if(file.startsWith(prefix)){filefile.substring(prefix.length(),file.length());}String fullPathfileStoreDir/file;File fnew File(fullPath);if(f.exists()){f.delete();}report.delete();}}Overridepublic ListReportFile getReportFiles() {ListReport reportList Report.dao.find(select * from ur_report t where t.rpt_type2 );File filenew File(fileStoreDir);ListReportFile listnew ArrayList();
// if(reportList ! null) {
// for(Report reportStore:reportList) {
// ReportFile reportFile new ReportFile(reportStore.getRptName(),reportStore.getCreateDate());
// list.add(reportFile);
// }
// }
// return list;for(File f:file.listFiles()){Calendar calendarCalendar.getInstance();calendar.setTimeInMillis(f.lastModified());Report report null;for(int i0; ireportList.size();i){Report r reportList.get(i);String reportName r.getUreportName();if(StringUtils.isNotEmpty(reportName)){reportName reportName.substring(prefix.length(), reportName.length());if(f.getName().equals(reportName)){report r;}}}if(null ! report){list.add(new ReportFile(f.getName(),calendar.getTime()));
// list.add(new ReportFile(report.getId(),f.getName(),calendar.getTime()));}}Collections.sort(list, new ComparatorReportFile(){Overridepublic int compare(ReportFile f1, ReportFile f2) {return f2.getUpdateDate().compareTo(f1.getUpdateDate());}});return list;}Overridepublic void saveReport(String file, String content) {try {if(StringUtils.isNotEmpty(file)) {String[] arr file.split();Report report null;if(null ! arr arr.length2){report Report.dao.findById(Integer.parseInt(arr[0]));file arr[1];}else{report Report.dao.findFirst( select * from ur_report t where t.ureport_name?, file);if (report null) {report new Report();}}report.setUreportName(file);report.setRptUrl(ureport/preview?_u file);if (file.startsWith(prefix)) {file file.substring(prefix.length(), file.length());}String fullPath fileStoreDir / file;FileOutputStream outStream null;try {outStream new FileOutputStream(new File(fullPath));IOUtils.write(content, outStream, utf-8);} catch (Exception ex) {throw new ReportException(ex);} finally {if (outStream ! null) {try {outStream.close();} catch (IOException e) {e.printStackTrace();}}}report.setUpdateDate(new Date());if (null ! report.getId()) {report.update();} else {report.setCreateDate(new Date());report.setRptType(2);report.save();}}else{throw new ReportException(报表文件不存在);}} catch (Exception e) {throw new ReportException(e);}}Overridepublic String getName() {return 数据库文件系统;}Overridepublic boolean disabled() {return false;}Overridepublic String getPrefix() {return prefix;}public void setFileStoreDir(String fileStoreDir) {this.fileStoreDir fileStoreDir;}public void setDisabled(String disabled) {this.disabled disabled;}
}十一ReportServiceImpl.java
package com.report.service.impl;import com.report.model.Report;
import com.report.service.ReportService;
import com.jfinal.plugin.activerecord.Page;
import org.apache.commons.lang.StringUtils;
import org.springframework.stereotype.Service;Service
public class ReportServiceImpl implements ReportService {private final String table ur_report;Overridepublic PageReport getPageList(Integer currentPage, Integer pageSize, String rptName, String rptType) {StringBuilder sql new StringBuilder();sql.append( from table t where 11 );if(StringUtils.isNotEmpty(rptName)){sql.append( and instr(t.rpt_name,rptName )0 );}if(StringUtils.isNotEmpty(rptType)){sql.append( and t.rpt_typerptType);}sql.append( order by t.sort desc );PageReport pageList Report.dao.paginate(currentPage,pageSize,select t.* ,sql.toString());return pageList;}
}十二ReportService.java
package com.report.service;
import com.report.model.Report;
import com.jfinal.plugin.activerecord.Page;public interface ReportService {/**** 获取表格数据* param currentPage* param pageSize* param rptName* param rptType* return*/PageReport getPageList(Integer currentPage, Integer pageSize, String rptName, String rptType);
}十三主类UreportApplication.java
package com.report;import com.bstek.ureport.console.UReportServlet;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.ImportResource;
import org.springframework.transaction.annotation.EnableTransactionManagement;/*** 入口类*/
SpringBootApplication()
EnableTransactionManagement
ImportResource(classpath:config/context.xml)
ComponentScan(basePackages {com.report.*})
public class UreportApplication {public static void main(String[] args) {SpringApplication.run(UreportApplication.class, args);}//ureport报表Beanpublic ServletRegistrationBean buildUReprtServlet(){return new ServletRegistrationBean(new UReportServlet(),/ureport/*);}
}最后贴上表设计
