cartAdd.java

package com.verizon;

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

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

public class cartAdd extends HttpServlet{
	public void doGet(HttpServletRequest req, HttpServletResponse res)
	{
		try
		{
			RequestDispatcher rd=null;
			int i=1;
			int id=Integer.parseInt(req.getParameter("item"));
			String name=null, cost=null, category=null, quant=null;
			quant=req.getParameter("quan");

			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 inventory where item_id="+id);
			while(rs.next())
			{
				name=rs.getString(2);

				category=rs.getString(4);
				cost=rs.getString(5);
			}
			rs.close();
			i=st.executeUpdate("Insert into orderdetails values ("+id+",'"+quant+"','"+cost+"')");
			rd=req.getRequestDispatcher("/additionToCart.jsp");
			rd.forward(req, res);
		}catch(Exception e){
			e.printStackTrace();
		}
		}
	}