Java Servlet Programing Laungage

Java Servlet Projects

Servlet Project 3

Java Servlet :Fetching data from database in servlet
Previous Home Next

This program shows you how to fetch all the rows from the database table via JDBC

ServletFetch.java

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class ServletFetch extends HttpServlet{
  public void doGet(HttpServletRequest request, HttpServletResponse response)
	     throws ServletException, IOException{
  try
  {
    response.setContentType("text/html");
    PrintWriter out = response.getWriter();
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection con=DriverManager.getConnection
		   ("jdbc:oracle:thin:@localhost:1521:xe","system","gaurav");
    Statement st = con.createStatement();
    ResultSet rs = st.executeQuery("Select * from logindetails");
    while(rs.next()){
    out.println("<body><table><th>") ;       
    out.println("Name" + "   " + "password" +"</th>" +"<br>");
    out.println(  rs.getString(1) + "   " + rs.getString(2) + "<br>");
    }
   }
   catch (Exception e)
   {
      System.out.println(e);
   }
  }
}

 

web.xml

<web-app>
	<servlet>
		<servlet-name>Hello</servlet-name>
		<servlet-class>ServletFetch</servlet-class>
	</servlet>
	<servlet-mapping>
	    <servlet-name>Hello</servlet-name>
		<url-pattern>ServletFetchingDataFromDatabase</url-pattern>
	</servlet-mapping>
</web-app>

index.html

<html>
	<head>
    	<title>Fetch data</title>
	</head>
	<body>
	    <a href="ServletFetchingDataFromDatabase">click here</a>
	</body>
</html>
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: