Connecting to multiple databases

amy

I have a webpage that gets Account Information.

Depending on the instance (which would be set based on link selected by the user), I need to get the information from different databases (example: dev or uat or PROD)..

what are the way(s) to do it (without using hibernate)?

P.S: For one database I have the following in the lt;appgt;-servlet.xml

lt;bean id=quot;dataSourcequot; class=quot;org..jdbc.datasource.DriverM  anagerDataSourcequot;gt;  lt;property name=quot;driverClassNamequot; value=quot;com.sybase.jdbc2.jdbc.SybDriverquot; /gt;  lt;property name=quot;uclquot; value=quot;dataserverortquot;/gt;  lt;property name=quot;usernamequot;  value=quot;userquot;/gt;  lt;property name=quot;passwordquot; value=quot;passwrdquot;/gt;lt;/beangt;
lt;bean id=quot;spdaoquot; class=quot;MyPkg.SpringAccountDaoquot;gt;    lt;property name=quot;dataSourcequot; ref=quot;dataSourcequot;/gt; lt;/beangt;