Java Servlet Programing Laungage

R4R^®

Java

Servlet

Servlet Basics

Java Servlet Tutorial

Servlet Introduction

Servlet Life Cycle

Non Life Cycle Method of Servlet Interface

How to run the Servlet program

Servlet Exception Handling

Implementation of GenericServlet

Difference between HttpGet() and HttpPost()

Difference between Attributes and Parameters

First Servlet Program

State Management

Servlet Cookies

HttpSession Object

Commonly used methods of HttpSession

Servlet sendRedirect

Example of sendRedirect

How a Servlet Works

Six steps to running your first Servlet

Play Video song using servlet

Manipulating multiple value parameters

Java Servlet Projects

Servlet Project 3

Java Servlet Examples

access servlet information

count number of time servlet access

display digital clock in servlet

access servlet cookie

getting information about session

Enumeration form values

Iterator form values

generate Fibonacci series

generate random numbers

generate random values

read data from file

write data into file

upload (save) file in hard disk

upload (save) multiple file in hard disk

store data into List

Java Servlet Interview materials

Servlet subjective question

Servlet Interview question

Servlet Objective question

Servlet FAQS

Java Servlet :Fetching All data from database table

Home

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();
	}

}