Struts-config.xml
<data-sources>
<data-source key="data" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<set-property property="url" value="jdbc:microsoft:sqlserver://localhost:1433;databaseName=t23" />
<set-property property="username" value="sa" />
<set-property property="password" value="" />
</data-source>
</data-sources>
DataSource ds=(DataSource)this.getServlet().getServletContext().getttribute("data");
Connection con=ds.getConnection();