Java Servlet Programing Laungage

Java Servlet Projects

Servlet Project 3

Java Servlet :Fetching All data from database table
Previous Home Next

This example shows you how to fetch the all rows from the database table by using the JDBC and the servlet.

index.html

<html>
  <body>
   <a href="f1">FetchAll Data</a>
  </body>
</html>

 

web.xml

<web-app>
	<servlet>
	 <servlet-name>s1</servlet-name>
	 <servlet-class>FullDataFetch</servlet-class>
	</servlet>
	<servlet-mapping>
	 <servlet-name>s1</servlet-name>
	 <url-pattern>f1</url-pattern>
	</servlet-mapping>
</web-app>

FullDataFetch.java

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class FullDataFetch extends HttpServlet {
  public void doGet(HttpServletRequest request,
	HttpServletResponse response)throws ServletException,IOException
	{
	  response.setContentType("text/html");
	  PrintWriter out = response.getWriter();
	  try
	  {
		 Class.forName("oracle.jdbc.driver.OracleDriver");
		 Connection con=DriverManager.getConnection
			("jdbc:oracle:thin:@localhost:1521:xe","system","oracle");
		 PreparedStatement stmt=con.prepareStatement("Select * from emp  ");
		 ResultSet rset=stmt.executeQuery();
		 out.println("The data is:-");
		 while(rset.next())
		{
				
			out.println(rset.getString(1)+"\t"+rset.getString(2)+"<br>");
		}
		}
		catch(Exception e)
		{
			System.out.println(e);
		}
		out.close();
	}

}
Previous Home Next

Tolal:0 Click:

Show All Comments

Did not find what you were looking for leave your name and message. We will revert within 24 hours
Name:
eMail:
Comment / Feedback: