db Tag

Db tag is a command tag. It defines a jdbc data source to be used by sql tag.

The syntax is:

  <db connectionstring="jdbc connection string" driverclass="jdbc driver class name" id="myDB" user="xxx" password="yyy" />

For mysql database, use "jdbc:mysql://localhost/test" for connectionstring attribute and "com.mysql.jdbc.Driver" for driverclass attribute.

To access csv file or excel file, you can use JDBC-ODBC bridge driver.

Specify a unique id in db attribute.