placeorder

package com.placeorder;

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

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;


@WebServlet("/placeorder")
public class placeorder extends HttpServlet {
	private static final long serialVersionUID = 1L;


    public placeorder() {
        super();

    }


	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		HttpSession session=request.getSession();
		int x=(int) session.getAttribute("itemid");
		int request_quantity=50;
		try {
			Class.forName("oracle.jdbc.Driver.OracleDriver");

		Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","hr","Admin");
		Statement st=con.createStatement();
		int r=st.executeUpdate("insert into warehouse(itemid,quantity) values(x,request_quantity)");
		if(r==1)
		{
			System.out.println("THE AVAILABLE QUANTITY IS");
			ResultSet rs=st.executeQuery("select * from warehouse");
			while(rs.next())
			{
				System.out.println(rs.get);
			}
		}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}


	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

	}

}