java⽣成报表_Java利⽤DynamicReports⽣成报表讲解DynamicReports 是⼀个基于 JasperReports 进⾏扩展的 Java 报表库，可⽤它来快速创建报表⽽⽆需可视化报表设计⼯具。它能够创建动态的报表设计，⽽⽆需可视化报表设计⼯具。可以⾮常快地创建报表并⽣成可以展⽰和打印的⽂档，也可以导出各种常见的格式如PDF、Excel、Word等。 DynamicReports的特点如下：
1)动态创建报表，完全抛弃设计器来设计
2)快速地创建报表、⽣成⽂件、显⽰、打印或导出到其它许多流⾏的格式(PDF、Excel、Word)
项⽬中增加 l 配置⽂件，具体内容如下：<?xml version="1.0" encoding="UTF-8"?>
4.0.0
Test
Test
0.0.1-SNAPSHOT
Test
Test
net.sourceforge.dynamicreports
dynamicreports-core
3.0.4
mysql公称抗拉强度
mysql-connector-java
5.1.22
在项⽬中选中 l ⽂件，右击执⾏ Run As -> Maven install 引⼊需要的jar包，再执⾏eclipse:eclipse命令。山野的呼唤
Java 执⾏⽣成报表，具体代码如下：db;
import java.awt.Color;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import net.sf.dynamicreports.jasper.builder.JasperReportBuilder;
import net.port.builder.DynamicReports;
import net.lumn.Columns;
import net.port.builderponent.Components;
import net.port.builder.datatype.DataTypes;
import net.port.builder.style.StyleBuilder;
import net.stant.HorizontalAlignment;
import net.ption.DRException;
public class ReportDemo {
private static Connection getConn() throws ClassNotFoundException,碱茅
SQLException {
Class.forName("sql.jdbc.Driver");
return (Connection) Connection(
"jdbc:mysql://127.0.0.1:3306/mysql", "root",
"123456");
}
public static void buildReport(Connection conn) {
JasperReportBuilder report = port();//创建空 JasperReport 报表
//样式属性
龙婕物联流量卡
StyleBuilder boldStl = DynamicReports.stl.style().bold();//加粗
StyleBuilder centerStl = DynamicReports.stl.style(boldStl)
.setHorizontalAlignment(HorizontalAlignment.CENTER);
StyleBuilder titleStl = DynamicReports.stl.style(centerStl)
.setFontSize(16);//字体⼤⼩
StyleBuilder columnTitleStl = DynamicReports.stl.style(centerStl)
.setBorder(DynamicReports.stl.pen1Point())
.setBackgroundColor(Color.LIGHT_GRAY);//设置标题颜⾊
.setHorizontalAlignment(HorizontalAlignment.CENTER),
.setHorizontalAlignment(HorizontalAlignment.CENTER),中国实验方剂学杂志
.setHorizontalAlignment(HorizontalAlignment.CENTER),
.setHorizontalAlignment(HorizontalAlignment.CENTER),
.setColumnTitleStyle(columnTitleStl)
.setHighlightDetailEvenRows(true)//⾏⾼亮
.("MYSQL USER").setStyle(titleStl))//标题名称
.pageFooter(Components.pageXofY().setStyle(centerStl))//页⾓
.
setDataSource("select *,'db' address from user", conn);//调⽤数据源并返回数据
try {
report.show();//显⽰报表
//Pdf(new FileOutputStream("D://test.pdf"));//⽣成PDF⽂件} catch (DRException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String orgs[]) {
Connection conn = null;
try {
电影侠女十三妹
conn = getConn();
} catch (ClassNotFoundException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
buildReport(conn);
}
}
