Purchase.java

package com.verizon;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Purchase extends HttpServlet{


	public void doGet(HttpServletRequest req, HttpServletResponse res)throws IOException, ServletException
	{
		try
		{
			String buffer=" ", name=null, category=null;
			int quant=0;
			int id=1, cost=1, total=0;
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","hr","Admin");
			Statement st=con.createStatement();
			ResultSet rs=st.executeQuery("Select * from orderdetails");
			ResultSet rs1=st.executeQuery("Select * from inventory");
			while(rs.next())
			{
				id=rs.getInt(1);

				quant=Integer.parseInt(rs.getString(2));

				cost=Integer.parseInt(rs.getString(3));
				total=total+(cost*quant);
				buffer=buffer+" Item ID: "+id+" Quantity: "+quant+" Cost per piece: "+cost+" ";
			}
			while(rs1.next())
			{
				name=rs1.getString(2);
				category=rs1.getString(4);
				buffer=buffer+" Name: "+name+" Category: "+category+" ";
			}
			RequestDispatcher rd=req.getRequestDispatcher("/cartValue.jsp");
			req.setAttribute("user",buffer);
			req.setAttribute("co",total);
			rd.forward(req, res);


		}catch(Exception e){e.printStackTrace();}



	}



}