java ireport jasperreport 配套使用(二) 使用JDBC Datasource

 

 

报表是用来展现数据,而数据来源有多种,例如

数据库,xml,Excel,JavaBean,其他格式文件等,而在报表中常用的是数据库.

所以使用ireport生成报表,必须了解jdbc基本知识,会写查询sql.

 

准备工作:

1,oracle数据库 scott模式;

2,oracle jdbc jar包;

3,将oracle jdbc jar加入ireport classpath.

 

1,可能你并不熟悉oracle,但是假如你熟悉mysql或sql server也是ok的.

2,如果你使用oracle作为JDBC数据,那么你须将oracle jdbc jar加入到classpath.

如果你使用mysql,sql server须将其相应jar包j加入到classpath.

3,ireport连接到也是需要jdbc jar的,所也要加入到ireport的classpath.

步骤如下图箭头所示:

 

在ireport中写select查询语句

如下图:

 

 

写好查询SQL之后在report inspect视图中(window->report inspect),

展开Fields节点,就会看到在刚刚report query窗口中的所有fields.

 

1,选中相应的field,拖拽到details band区域.

2,给每个field在column header band区域加上column header.

结果如下图:

 

 

3,最后别忘了修改 report properties:

report language:Java,

when no data:all sections,no detail

 

下面写Java代码到处报表

因为用到jdbc连接,所以新建一个java类(JDBCUtils.java)

package com.jasper.connection; import java.sql.DriverManager; import java.sql.SQLException; import java.util.logging.Logger; import oracle.jdbc.OracleConnection; public class JDBCUtils { private static oracle.jdbc.OracleConnection conn = null; private static final String className = "oracle.jdbc.driver.OracleDriver"; private static final String localUrl = "jdbc:oracle:thin:@127.0.0.1:1521:case"; private static Logger log = Logger.getLogger(JDBCUtils.className); private JDBCUtils(){ } public static JDBCUtils getInstance(){ return new JDBCUtils(); } public OracleConnection getLocalConnection(){ try{ Class.forName(className); conn = (OracleConnection) DriverManager.getConnection(localUrl,"scott","tiger"); }catch (ClassNotFoundException e) { log.info("Class for jdbc name error."); e.printStackTrace(); }catch (SQLException e) { log.info("Get connection error."); e.printStackTrace(); } return conn; } public static void closeConnection(){ if(conn != null){ try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } } 

 

Servlet代码(IreportDataSourceServlet.servlet)

package com.jasper; import java.io.IOException; import java.sql.Connection; import java.util.HashMap; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.jasper.connection.JDBCUtils; public class IreportDataSourceServlet extends HttpServlet { private static final long serialVersionUID = 1L; public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Map<String, String> paramMap = new HashMap<String, String>(); Connection conn = JDBCUtils.getInstance().getLocalConnection(); ReportGenerator generator = new ReportGenerator(); generator.PDFGenerator(response, "ireport_datasource.jasper", paramMap,conn); JDBCUtils.closeConnection(); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doGet(request, response); } } 

 

web.xml代码

<servlet> <servlet-name>IreportDataSourceServlet</servlet-name> <servlet-class>com.jasper.IreportDataSourceServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>IreportDataSourceServlet</servlet-name> <url-pattern>/IreportDataSourceServlet</url-pattern> </servlet-mapping>  

 

html代码

<a href="IreportDataSourceServlet" mce_href="IreportDataSourceServlet">use jdbc datasoure to display data</a><br/> 

 

将项目重新发布到server.

在地址栏打开页面,点击链接,生成pdf.

ireport datasource pdf.jpg