<data-sources>
\n<data-source type=”org.apache.tomcat.dbcp.dbcp.BasicDataSource<\/B>“>
\n <set-property
\n property=”driverClassName”
\n value=”com.mysql.jdbc.Driver” \/>
\n <set-property
\n property=”url”
\n value=”jdbc:mysql:\/\/localhost:3306\/strutsdatabase?autoReconnect=true” \/>
\n <set-property
\n property=”username”
\n value=”root” \/>
\n <set-property
\n property=”password”
\n value=”” \/>
\n <set-property
\n property=”maxActive”
\n value=”10″ \/>
\n <set-property
\n property=”maxWait”
\n value=”5000″ \/>
\n <set-property
\n property=”defaultAutoCommit”
\n value=”false” \/>
\n <set-property
\n property=”defaultReadOnly”
\n value=”false” \/>
\n <set-property
\n property=”validationQuery”
\n value=”SELECT COUNT(*) FROM test” \/>
\n<\/data-source>
\n<\/data-sources>
\n <\/PRE><\/TD><\/TR><\/TBODY><\/TABLE><\/DIV>
\nCreate action Class to Test the DataSource<\/B>
Now we will write the code of Action class for getting the connection form DataSource:
<\/FONT>
\n\n
\n
\n
\npackage <\/B><\/FONT>test;<\/FONT>
<\/FONT>
import <\/B><\/FONT>javax.servlet.http.HttpServletRequest;<\/FONT>
import <\/B><\/FONT>javax.servlet.http.HttpServletResponse;<\/FONT>
<\/FONT>
import <\/B><\/FONT>org.apache.struts.action.Action;<\/FONT>
import <\/B><\/FONT>org.apache.struts.action.ActionForm;<\/FONT>
import <\/B><\/FONT>org.apache.struts.action.ActionForward;<\/FONT>
import <\/B><\/FONT>org.apache.struts.action.ActionMapping;<\/FONT>
<\/FONT>
import <\/B><\/FONT>java.sql.*;<\/FONT>
<\/FONT>
public class <\/B><\/FONT>TestDataSource <\/FONT>extends <\/B><\/FONT>Action<\/FONT>
{<\/FONT>
<\/FONT>public <\/B><\/FONT>ActionForward execute<\/FONT>(<\/FONT>
<\/FONT>ActionMapping mapping,<\/FONT>
<\/FONT>ActionForm form,<\/FONT>
<\/FONT>HttpServletRequest request,<\/FONT>
<\/FONT>HttpServletResponse response<\/FONT>) <\/FONT>throws <\/B><\/FONT>Exception<\/FONT>{<\/FONT>
<\/FONT>
<\/FONT>javax.sql.DataSource dataSource;<\/FONT>
<\/FONT>java.sql.Connection myConnection=<\/FONT>null<\/B><\/FONT>;<\/FONT>
<\/FONT>try <\/B><\/FONT>{<\/FONT>
<\/FONT>dataSource = getDataSource<\/FONT>(<\/FONT>request<\/FONT>)<\/FONT>;<\/FONT>
<\/FONT>myConnection = dataSource.getConnection<\/FONT>()<\/FONT>;<\/FONT>
<\/FONT>Statement stmt=myConnection.createStatement<\/FONT>()<\/FONT>;<\/FONT>
<\/FONT>ResultSet rst=stmt.executeQuery<\/FONT>(<\/FONT>“select username from test”<\/FONT>)<\/FONT>;<\/FONT>
<\/FONT>System.out.println<\/FONT>(<\/FONT>“******************************************”<\/FONT>)<\/FONT>;<\/FONT>
<\/FONT>System.out.println<\/FONT>(<\/FONT>“********Out Put from TestDataSource ******”<\/FONT>)<\/FONT>;<\/FONT>
<\/FONT>while<\/B><\/FONT>(<\/FONT>rst.next<\/FONT>()){<\/FONT>
<\/FONT>System.out.println<\/FONT>(<\/FONT>“User Name is: ” <\/FONT>+ rst.getString<\/FONT>(<\/FONT>“username”<\/FONT>))<\/FONT>;<\/FONT>
<\/FONT>}<\/FONT>
<\/FONT>System.out.println<\/FONT>(<\/FONT>“******************************************”<\/FONT>)<\/FONT>;<\/FONT>
<\/FONT>rst.close<\/FONT>()<\/FONT>;<\/FONT>
<\/FONT>stmt.close<\/FONT>()<\/FONT>;<\/FONT>
<\/FONT>\/\/ do what you wish with myConnection<\/FONT>
<\/FONT>} <\/FONT>catch <\/B><\/FONT>(<\/FONT>SQLException sqle<\/FONT>) {<\/FONT>
<\/FONT>getServlet<\/FONT>()<\/FONT>.log<\/FONT>(<\/FONT>“Connection.process”<\/FONT>, sqle<\/FONT>)<\/FONT>;<\/FONT>
<\/FONT>} <\/FONT>finally <\/B><\/FONT>{<\/FONT>
<\/FONT>\/\/enclose this in a finally block to make<\/FONT>
<\/FONT>\/\/sure the connection is closed<\/FONT>
<\/FONT>try <\/B><\/FONT>{<\/FONT>
<\/FONT>myConnection.close<\/FONT>()<\/FONT>;<\/FONT>
<\/FONT>} <\/FONT>catch <\/B><\/FONT>(<\/FONT>SQLException e<\/FONT>) {<\/FONT>
<\/FONT>getServlet<\/FONT>()<\/FONT>.log<\/FONT>(<\/FONT>“Connection.close”<\/FONT>, e<\/FONT>)<\/FONT>;<\/FONT>
<\/FONT>}<\/FONT>
<\/FONT>}<\/FONT>
<\/FONT>
<\/FONT>
<\/FONT>return <\/B><\/FONT>mapping.findForward<\/FONT>(<\/FONT>“success”<\/FONT>)<\/FONT>;<\/FONT>
<\/FONT>}<\/FONT>
} <\/FONT><\/CODE> <\/TD><\/TR><\/TBODY><\/TABLE><\/DIV> |
|