通过配置Database.xml文件实现不同数据源的连接。
ACCESS数据库:
<Database DriverName="sun.jdbc.odbc.JdbcOdbcDriver" DbUrl="jdbc:odbc:driver={MicrosoftAccessDriver(*.mdb)};DBQ=" UserName="" Password="" Name="help/books.mdb"/>
ACCESS数据库:
<Database DriverName="sun.jdbc.odbc.JdbcOdbcDriver" DbUrl="jdbc:odbc:driver={MicrosoftAccessDriver(*.mdb)};DBQ=d:/myweb/books.mdb" UserName="" Password=""/>
MySql数据库:
<Database DriverName="com.mysql.jdbc.Driver" DbUrl="jdbc:mysql://127.0.0.1/" Name="mysqlname" UserName="root" Password=""/>
MS SqlServer数据库:
<Database DriverName="com.microsoft.jdbc.sqlserver.SQLServerDriver" DbUrl="jdbc:microsoft:sqlserver://localhost:1433" Name="newlz" UserName="sa" Password=""/>
Oracle8/8i/9i数据库:
<Database DriverName="oracle.jdbc.driver.OracleDriver" DbUrl="jdbc:oracle:thin:@localhost:1521" Name="oraName" UserName="test" Password="test"/>
DB2数据库:
<Database DriverName="com.ibm.db2.jdbc.app.DB2Driver" DbUrl="jdbc:db2://localhost:5000/" Name="db2test" UserName="admin" Password=""/>
Sybase数据库:
<Database DriverName="com.sybase.jdbc.SybDriver" DbUrl="jdbc:sybase:Tds:localhost:5007/" Name="SybaseName" UserName="userid" Password="user_password"/>
PostgreSQL数据库:
<Database DriverName="org.postgresql.Driver" DbUrl="jdbc:postgresql://localhost/" Name="myDB" UserName="myuser" Password="mypassword"/>
Informix数据库:
<Database DriverName="com.informix.jdbc.IfxDriver" DbUrl="jdbc:informix-sqli://localhost:1533/myDB:INFORMIXSERVER=myserver" Name="myDB" UserName="myuser" Password="mypassword"/>
ODBC数据源:
<Database DriverName="sun.jdbc.odbc.JdbcOdbcDriver" DbUrl="jdbc:odbc:myodbc" Name="myDB" UserName="myuser" Password="mypassword"/>