Java Servlet Programing Laungage

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>

Home

Java Topics

Core Java Programming Language

Advanced Java

Servlet Programming Language

Java Server Pages (JSP)

Java 2 Platform, Micro Edition (J2ME)

JavaServer Faces (JSF)

Hot Topics