Shulou(Shulou.com)06/01 Report--

Jasper how to configure dynamic data sources, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

Jasper itself does not support dynamic data sources, and the available solution is to customize the data sources through api. The actual operation is to dynamically set the connection attributes of jdbc, such as url, user name and password, after judging the conditions. For example:

String userName = userDetails.getUsername (); / / obtain a connection based on the username. String dataSourceURI = ""; if (userName.equalsIgnoreCase ("admin")) {dataSourceURI = "/ datasources/ds_1"; userName = "xx";... } else if {... } connection = getRepositoryDatasource (dataSourceURI); try {parameterValues.put (JRParameter.REPORT_CONNECTION, connection.getDataSource (). GetConnection ());} catch (SQLException sqle) {sqle.printStackTrace ();}

Although API achieves dynamic data sources, the process is still quite complex. In addition, it will lead to high coupling between custom classes and applications, and it is also troublesome to maintain later.

If there is an aggregator, this problem can be easily dealt with. For example, an enterprise with a large volume of business stores its annual data in a separate server. When querying data (such as order tables) on an annual basis, it is necessary to dynamically connect the corresponding libraries.

The aggregator SPL is done in a word.

ABC1=connect (dataSource) / get dataSource connect

2=A1.query ("select * from orders") / Execution query

Among them, "connect (dataSource)" is to obtain the database connection, and "dataSource" is the aggregator parameter, which year can be passed to obtain the corresponding database connection.

The above scenario is only the simplest fetch requirement, and it is even more difficult for Jasper if it involves the mixed operation of multiple data sources, and there is even no solution.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.