Java Servlet Programing Laungage

Java Servlet Projects

Servlet Project 3

adplus-dvertising
Java Servlet :Fetching Data by Name
Previous Home Next

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