Java Servlet Programing Laungage

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

Java Servlet :Fetching Data by Name

This example shows you how to fetch the row from the database table by providing the unique name using JDBC and servlet.

index.html

<html>
  <body>
   <form action="fetch" method="get">
   UserName<input type="text" name="txtName"><br>
   <input type="submit" value="login"><br>
   </form>
  </body>
</html>

web.xml

<web-app>
	<servlet>
	 <servlet-name>s1</servlet-name>
	 <servlet-class>Fetch</servlet-class>
	</servlet>
	<servlet-mapping>
	 <servlet-name>s1</servlet-name>
	 <url-pattern>fetch</url-pattern>
	</servlet-mapping>
</web-app>

Fetch.java

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Fetch extends HttpServlet {
public void doGet(HttpServletRequest request,
  HttpServletResponse response)throws ServletException,IOException 
{
  String name=request.getParameter("txtName");
  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 where name=? ");
	stmt.setString(1, name);
	ResultSet rset=stmt.executeQuery();
	out.println("The data is:-");
	while(rset.next())
	{
		out.println(rset.getString(1)+"\t"+rset.getString(2));
	}
	}
	catch(Exception e)
	{
	  System.out.println(e);
	}
	  out.close();
	}
}

Java Topics

Core Java Programming Language

Servlet Programming Language

Java Server Pages (JSP)

Struts Framework

Spring Framework

Hibernate Framework

APIS( iText & POI)

Java 2 Platform, Micro Edition (J2ME)

JavaServer Faces (JSF)

Hot Topics

Interview & FAQs

More Links