Click here to watch in Youtube : https://www.youtube.com/watch?v=ClqBBHZ8Zio&index=2&list=UUhwKlOVR041tngjerWxVccw
Click the below Image to Enlarge
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpz4IJACq390L3hpTEuJWQSGMieq1C_UfR-_4Wgqrc7dk_FjYh7Uovh6pU_zjm3FGj_iXt60ljsamDXTbeDvw2YbPATwLIMCm8euSeoYZcZLqD5QoFit5xqScdlLW9wJavk8MSUQSN3io/s1600/JDBC-Servlets+-+BoneCP+DataSource+Oracle+-+Tomcat.jpg) |
JDBC|Servlets : BoneCP DataSource Oracle - Tomcat |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBbs5RkYC_cVGvpwx-NT-wn8LqXlDxDV1aGKTWiubewW5e0QLABQrtACCGETc0xzIXhQVv4YMmWcIdU9ZmwU9vJn7CnWMd1k7r8sBAChBsDBX7qxzUU4Cxdot6wCqGvV32NSKHLupBU34/s1600/JDBC-Servlets+-+BoneCP+DataSource+Oracle+-+Tomcat.jpg) |
JDBC|Servlets : BoneCP DataSource Oracle - Tomcat |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-je08ptdhgVXvXIpL3NNRK_C5SaxNEv_oCX0V2PnGFY_mIg-qOgn9h5cHwWwjDKt5mpdW8z4Cl41WBxUh5WZQfCs1tu7N-OsZlgqSrCrLa1TyBGB2uAa9qelPR0feciLWS7Jerd5gs2k/s1600/JDBC-Servlets+-+BoneCP+DataSource+Oracle+-+Tomcat.jpg) |
JDBC|Servlets : BoneCP DataSource Oracle - Tomcat |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfGwHaEfSVZVHBB4b2sEt4GBhT67yoi33vUjeSpJXQbBDFCwtYFCo1Xg9x_D7MgvWrBl3otcRc9h0bGwFgk2Y6OlLsSenZaMkwRbodfFXsuY9tnGQcCQU9ScNzKKDNcgOBrPACT9xiG6M/s1600/JDBC-Servlets+-+BoneCP+DataSource+Oracle+-+Tomcat.jpg) |
JDBC|Servlets : BoneCP DataSource Oracle - Tomcat |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6znVw4wECypI0pjNJSat8Wawo0ff_64S7TZVeyb1GJ3p6zoCKplzJuRRa3okhIr4yHR6MguJqYWZq6eT-LzFks4fqhdx_7UAFZVefTQ5YNIvgpqrXHSYSZCmxEvdprN573Co0NgRsQPk/s1600/JDBC-Servlets+-+BoneCP+DataSource+Oracle+-+Tomcat.jpg) |
JDBC|Servlets : BoneCP DataSource Oracle - Tomcat |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjd3EfnGpBD5U_i7BRtVXvyOsAAV2Fgk78C6DhJrARK4LEHWiFrEoCn0Kr86058GijVHJcf5MLD2v93VaI03hfBNtBcPkn5CxGeULaZZw6AqEFcUNQNaMgQIkohgg8EXOALu5D8GXMyYyM/s1600/JDBC-Servlets+-+BoneCP+DataSource+Oracle+-+Tomcat.jpg) |
JDBC|Servlets : BoneCP DataSource Oracle - Tomcat |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6kMI73Ql-ECA1OT7kgbCIq3on0AXx9Xp-MZhx4a5QJtTkMUIcug7Up6DdrfBfx6rgRV-ucF4gcz43k18rEwOX5ZKDg0es8rDMtQmdHXWposeVl5LJ6At1cFo6npUhezxjc6FqKooAtvo/s1600/JDBC-Servlets+-+BoneCP+DataSource+Oracle+-+Tomcat.jpg) |
JDBC|Servlets : BoneCP DataSource Oracle - Tomcat |
ConnectionManager.java
import com.jolbox.bonecp.BoneCPDataSource;
public class ConnectionManager
{
private static BoneCPDataSource boneCPDataSource = null;
public static BoneCPDataSource getBoneCPDataSource()
{
return boneCPDataSource;
}
public static void setBoneCPDataSource( BoneCPDataSource boneCPDataSource )
{
ConnectionManager.boneCPDataSource = boneCPDataSource;
}
public static BoneCPDataSource configureBoneCPDataSource()
{
try
{
/*
* load the database driver (make sure this is in your classpath!)
*/
Class.forName("oracle.jdbc.OracleDriver");
/*
* setup the BoneCPDataSource
*/
BoneCPDataSource boneCPDataSource = new BoneCPDataSource();
boneCPDataSource.setJdbcUrl("jdbc:oracle:thin:@localhost:1521:xe");
boneCPDataSource.setUsername("hr");
boneCPDataSource.setPassword("hr");
boneCPDataSource.setMinConnectionsPerPartition(5);
boneCPDataSource.setMaxConnectionsPerPartition(10);
boneCPDataSource.setPartitionCount(1);
setBoneCPDataSource(boneCPDataSource);
System.out
.println("contextInitialized.....boneCPDataSource is configured");
}
catch( Exception exe )
{
exe.printStackTrace();
}
return boneCPDataSource;
}
public static void closeBoneCPDataSource()
{
try
{
BoneCPDataSource boneCPDataSource = ConnectionManager
.getBoneCPDataSource();
if( boneCPDataSource != null )
{
/*
* This method must be called only once when the application
* stops.
*/
boneCPDataSource.close();
System.out
.println("contextDestroyed.....boneCPDataSource is closed!");
}
}
catch( Exception e )
{
e.printStackTrace();
}
}
}
ContextListener.java
import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;
public class ContextListener implements ServletContextListener
{
@Override
public void contextInitialized( ServletContextEvent arg0 )
{
System.out.println("\n---------------------------------------------");
System.out.println("ContextInitialized Method has been Called......");
ConnectionManager.configureBoneCPDataSource();
System.out.println("---------------------------------------------\n");
}
@Override
public void contextDestroyed( ServletContextEvent arg0 )
{
System.out.println("\n---------------------------------------------");
System.out.println("contextDestroyed Method has been Called......");
ConnectionManager.closeBoneCPDataSource();
System.out.println("---------------------------------------------\n");
}
}
EmployeeInfoServlet.java
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.jolbox.bonecp.BoneCPDataSource;
public class EmployeeInfoServlet extends HttpServlet
{
private static final long serialVersionUID = 1L;
BoneCPDataSource boneCPDataSource = null;
public void init( ServletConfig config )
{
try
{
System.out
.println("-----------------------------------------------------");
System.out
.println("init method has been called and servlet is initialized");
boneCPDataSource = ConnectionManager.getBoneCPDataSource();
System.out.println("Got BoneCPDataSource : " + boneCPDataSource);
System.out
.println("-----------------------------------------------------");
}
catch( Exception exe )
{
exe.printStackTrace();
}
}
public void doGet( HttpServletRequest request, HttpServletResponse response )
throws ServletException, IOException
{
System.out
.println("-----------------------------------------------------");
System.out.println("doGet method has been called");
System.out
.println("-----------------------------------------------------");
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String title = "Employee Information From Oracle Database";
out.print("<html><body bgcolor=\"#f0f0f0\">");
out.print("<h1 align=\"center\">" + title + "</h1>\n");
showEmployeeInformation(out);
out.print("</body></html>");
}
public void destroy()
{
System.out
.println("-----------------------------------------------------");
System.out
.println("destroy method has been called and servlet is destroyed");
System.out
.println("-----------------------------------------------------");
}
private void showEmployeeInformation( PrintWriter out )
{
Connection connection = null;
Statement stmt = null;
try
{
/*
* Get connection from the DataSource
*/
connection = boneCPDataSource.getConnection();
/*
* Execute the Query
*/
stmt = connection.createStatement();
String sql = "select employee_id,first_name,last_name,email,phone_number from employees";
ResultSet rs = stmt.executeQuery(sql);
/*
* Iterate the ResultSet and get each row Information.
*/
while( rs.next() )
{
/*
* Retrieve by column name
*/
int id = rs.getInt("employee_id");
String firstName = rs.getString("first_name");
String lastName = rs.getString("last_name");
String email = rs.getString("email");
String phoneNumber = rs.getString("phone_number");
/*
* Display values
*/
out.print("employee_id: " + id + "<br>");
out.print("first_name: " + firstName + "<br>");
out.print("last_name: " + lastName + "<br>");
out.print("email: " + email + "<br>");
out.println("phone_number: " + phoneNumber + "<br>");
out.println("-------------------------------------------"
+ "<br>");
}
rs.close();
}
catch( Exception e )
{
e.printStackTrace();
}
finally
{
/*
* finally block used to close resources
*/
try
{
if( stmt != null )
{
stmt.close();
}
}
catch( SQLException sqlException )
{
sqlException.printStackTrace();
}
try
{
if( connection != null )
{
connection.close();
}
}
catch( SQLException sqlException )
{
sqlException.printStackTrace();
}
}
}
}
No comments:
Post a Comment