Background
When users are making web report, they always have to connect to data source. As users’ data requirements are differ in thousand ways, so users often need to define data source by themselves. Sometimes, this may be very complex.
Solution
RAQ Report is a free excel-like
java reporting tool. RAQ Report gives two methods to solve this problem.
1. Connect to data source with the API of RAQ Report. And the program is as follows:
context.setDefDataSourceName("demo");
context.setConnection("demo",con);
DataSourceConfig dsoc = new DataSourceConfig(2,
true, "GBK", "GBK", false);
context.setDataSourceConfig("demo", dsoc);
2. Connect to data source with jdbc. And the program is as follows:
public java.sql.Connection getConnection() throws Exception {
Connection conn=null;
try{
Class.forName("org.hsqldb.jdbcDriver");
}catch(ClassNotFoundException cne){
cne.printStackTrace();
}
try{
conn= DriverManager.getConnection("jdbc:hsqldb:hsql://localhost:9001/runqianDB","sa","");
}catch(SQLException e){
e.printStackTrace();
}
return conn;
}
When developing web reporting project, users can connect to data source easily with these two methods provided by RAQ Report. Accoding to real business, users can choose a better one.