Setting the connection information

The method setConnection(String strURL, String strUID, String strPSWD, String strJdbcDriver) is for you to set connection information.

Where,

• String strURL
  The URL of the database. For the format of the URL, refer to the instructions of your JDBC driver.
• String strUID
  The user ID for the driver.
• String strPSWD
  The user's password for the driver.
• String strJdbcDriver
  The fully qualified name of the class. The class is responsible for connecting to the database and fetching data. For example, com.sybase.jdbc.SybDriver or oracle.jdbc.driver.OracleDriver. If not specified, the default will be used.

This method is for JRRunViewer and JRDirectViewer. It enables you to set connection information before the running of a report. You can allow others to specify the user ID and password before the running of a report to ensure security. Another application of this method is to enable users to select a different database before the running of a report, so that they can see different report results. Usually in this case, the two databases have the same structure, which eases the work of having to build further catalogs.

For example, this method can be called as follows:

setConnection("jdbc:Oracle:thin:@204.177.148.30:1521:orcl","scott","tiger","oracle.jdbc.driver.OracleDriver");