Click here to watch in Youtube : https://www.youtube.com/watch?v=OqBXwAC6MSM&list=UUhwKlOVR041tngjerWxVccw&index=4
Click the below Image to Enlarge
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-zIozTcxtnB5UOr60x9wItvPqsdwXxEuF58qb-pL7aaJmeAgdNaDvY2B22Jc9jmifSmATxaHqnLQClQVRZcpdJdw1xLJHRFgzkepuFgzsESbiW7AXAUfHcnR9EoCGPk1y7TZVt4g92rk/s1600/JDBC-Servlets+-+Tomcat+Connection+Pooling+-+DBCP-+Oracle.jpg) |
JDBC|Servlets : Tomcat Connection Pooling - DBCP- Oracle |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEir-mkjIVitrY4wTJDRo_w_qdw9Y6pBbBDwIe1DdySgNz43nQX2kGs84juRxhMnkqU6pRWOkOuhvX3KNDX43lSf0wI8QEur3cWvjd5IRxDzustIoir3b0JlPgtXaLdC1QxigGlZ2DWQltg/s1600/JDBC-Servlets+-+Tomcat+Connection+Pooling+-+DBCP-+Oracle.jpg) |
JDBC|Servlets : Tomcat Connection Pooling - DBCP- Oracle |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQj3YGQLsnejfgj3yp7KReRWa2acfW81Pj4LgyiQssJ3LHR8ENUSJDb4iJ6BWWx24kPyS-tBydaDMShCnzCi-HXvyMMWXsMZF7GbPtl435Oij3YSIuYIcZHpVOPNqqqSCcddTU91v5nJc/s1600/JDBC-Servlets+-+Tomcat+Connection+Pooling+-+DBCP-+Oracle.jpg) |
JDBC|Servlets : Tomcat Connection Pooling - DBCP- Oracle |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjarpHuwa1XT4qFWmLYy797Vm5AyFUV8L-3c31w4ZzCoFR34STnktMmFAFhkQrTXwLI1pqloJYDSgO0UiTk9josjg4bD1Gd6aXH4-2C1UzoPZTeZqRIBC9QbuIKUI7h7T330Lp5jOzKU6g/s1600/JDBC-Servlets+-+Tomcat+Connection+Pooling+-+DBCP-+Oracle.jpg) |
JDBC|Servlets : Tomcat Connection Pooling - DBCP- Oracle |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_DItQ1dhsTgN6pFxLEhOhdw1TvVK6zw4jAB7GcfYUX8npw_lS-IPYYVPYkkI01QeBQLRYzLV4zxkYB0zdZMlmxa0AdqpTGPE_hW7Nkc9ByaQTIXvHYcOZ5UpwIwODVFYOu8LaSlQjjME/s1600/JDBC-Servlets+-+Tomcat+Connection+Pooling+-+DBCP-+Oracle.jpg) |
JDBC|Servlets : Tomcat Connection Pooling - DBCP- Oracle |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9KSdqDUrf9FixuOEqkV2azyuLoMo70xx2AkPLRfXM-KrC-5TfXv-wbFYx5fQuyGWl-0qrhOrMNfTNX_WP62hS5Mc4D6GH2RuEDPX08jHsR6cFbUmbUJ_Mn2AWVI4a2tHhwhhYAYp7vHs/s1600/JDBC-Servlets+-+Tomcat+Connection+Pooling+-+DBCP-+Oracle.jpg) |
JDBC|Servlets : Tomcat Connection Pooling - DBCP- Oracle |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_1_F7qIK9xco5pwbIAckYNjX0RUvg8QYpNFaVWZ-cz1Bdd2-SiwTrl8wdmru8531zev0tOTMbbDuxW9RnAnFH6ujhk6jTaul307BqgKktj3T-31qnrFS7oWcIjm7pT2v11_qZu7zb420/s1600/JDBC-Servlets+-+Tomcat+Connection+Pooling+-+DBCP-+Oracle.jpg) |
JDBC|Servlets : Tomcat Connection Pooling - DBCP- Oracle |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCmIEFUi8Bo3H2WWzL7sTSDqDCca_9gYKhY4eyA5ivPlF52myuorJOrBvKDtTV3PleZqqNYENkpJLNsZ2lIabG0CAWvakzR5zk9iXW9SDn3V86FQcMFRqtaXv0PfvX3w6d2nyhj_5Xujg/s1600/JDBC-Servlets+-+Tomcat+Connection+Pooling+-+DBCP-+Oracle.jpg) |
JDBC|Servlets : Tomcat Connection Pooling - DBCP- Oracle |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg93Sk8y43HJ4iGJsTqDE6Sx2dcGdMiyRfAmYPYu3RfnVVrERlCBZThv0K29CvG2cpRsMZd2Xhjm8oawbb346LOkOLwIYlt7Y6qATGCnYlD-ESut2X2YCYIQ9ub232YIigfJuAm3730qRw/s1600/JDBC-Servlets+-+Tomcat+Connection+Pooling+-+DBCP-+Oracle.jpg) |
JDBC|Servlets : Tomcat Connection Pooling - DBCP- Oracle |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4rMd9Ytsy93GRZ8dMF2EqALfkDJAxMjiUx1T09SlTZO5pQijnmXiigoYKlrH0XAE7h_e2bW6zFCqz4otBp0ISHmACfGytVdPNB3zbThpVwTlcWZQ21Pv44V94xSgZkD4iHtia0bM4PxE/s1600/JDBC-Servlets+-+Tomcat+Connection+Pooling+-+DBCP-+Oracle.jpg) |
JDBC|Servlets : Tomcat Connection Pooling - DBCP- Oracle |
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.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
public class EmployeeInfoServlet extends HttpServlet
{
private static final long serialVersionUID = 1L;
DataSource dataSource = null;
public void init( ServletConfig config )
{
try
{
System.out
.println("-----------------------------------------------------");
System.out
.println("init method has been called and servlet is initialized");
/*
* Using JDNI lookup get the DataSource.
*/
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup("java:/comp/env");
dataSource = (DataSource) envContext.lookup("jdbc/HRDB");
System.out.println("Using JDNI lookup got the DataSource : "
+ dataSource);
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 = dataSource.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("-------------------------------------------");
}
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();
}
}
}
}
Thanks
ReplyDelete