Week-11 Extract data from the tables,display them in the catalogue page using JDBC

Week-11:                                                                                               Date:

------------------------------------------------------------------------------------------------------------

AIM: Extract data from the tables and display them in the catalogue page using JDBC.

DESCRIPTION:

            Create tables in the database which contain the details of items (books in our case like Book name, Price, Quantity, Amount)) of each category. Modify your catalogue page (week 2) in such a way that you should connect to the database and extract data from the tables and display them in the catalogue page using JDBC.

PROGRAM:

Retrieve.java:

import javax.servlet.*;

import javax.servlet.http.*;

import java.sql.*;

import java.io.*;

import java.util.*;

public class Retrieve extends HttpServlet

{

public void service(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException

{

res.setContentType("text/html");

PrintWriter out=res.getWriter();

try{

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con=DriverManager.getConnection("jdbc:oracle:thin:@195.100.101.158:1521:cclab","scott","tiger");

Statement s=con.createStatement();

ResultSet r=s.executeQuery("select * from cart");

out.println("<center> <table border=1>");

out.println("<thead> <th> Book name </th> <th> Price </th> <th> Quantity </th> <th> Amount </th> </thead>");

while(r.next())

{

out.println("<tr> <td> "+r.getString(1)+"</td> ");

out.println("<td> "+r.getString(2)+"</td> ");

out.println("<td> "+r.getInt(3)+"</td> ");

out.println("<td> "+r.getString(4)+"</td> </tr>");

}

out.println("</table></center>");

con.close();

}

catch(SQLException sq)

{

out.println("sql exception"+sq);

}

catch(ClassNotFoundException cl)

{

out.println("class not found"+cl);

}

}

}

web.xml:

<web-app>

<servlet>

<servlet-name>set</servlet-name>

<servlet-class>Cartenter</servlet-class>

</servlet>

<servlet>

<servlet-name>display</servlet-name>

<servlet-class>Retrieve</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>set</servlet-name>

<url-pattern>/enterdata</url-pattern>

</servlet-mapping>

<servlet-mapping>

<servlet-name>display</servlet-name>

<url-pattern>/display1</url-pattern>

</servlet-mapping>

</web-app>

http://wikibrand.blogspot.in

CREATE THE TABLE AND INSERT VALUES INTO THE TABLE:                                  

http://wikibrand.blogspot.in

OUTPUT:

http://wikibrand.blogspot.in

RESULT:

The data is extracted from the tables and displayed in the catalogue page using JDBC

SOURCE :PVPSIT FOR JNTU