Struts-config.xml

view plaincopy to clipboardprint?
<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> 
<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>

view plaincopy to clipboardprint?
DataSource ds=(DataSource)this.getServlet().getServletContext().getAttribute(”data”);  
  Connection con=ds.getConnection();