import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;


public class Insertion extends HttpServlet
{
   public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException
   {

      	 //get input from the user
    	 String id = request.getParameter("Id");	  
	 String name = request.getParameter("Name"); 
      	  
	 PrintWriter out = response.getWriter();
	  
      Connection conn = null;
      try
      {
	 //load the oracle driver
         Class.forName("oracle.jdbc.driver.OracleDriver");
         
	//connect to the database 
	conn = DriverManager.getConnection(
                   "jdbc:oracle:thin:@localhost:1521:databasename","sqlpluslogin","ssqlpluspassword");

        //create statement object 
	Statement stmt = conn.createStatement();
          
        //create statement object 
	if(Integer.parseInt(id)>0 && Integer.parseInt(id) <= 99)
      	  {
          	ResultSet rs = stmt.executeQuery("insert into Student values("+Integer.parseInt(id)+",'"+name+"')");		
		out.println("Id: "+id+" and "+"Name: "+name+" added successfully.");
      	  }
      	  else
      	 {	
      	 	out.println("Id must be between 1 and 99.");
      	 }
      }
      	catch(NumberFormatException e)
	{
               out.println("Must enter Integer as an Id.");
               return;
        }
      	catch(SQLException e)
      	{
         	out.println(e.getMessage());
         	while((e = e.getNextException()) != null)
            	out.println(e.getMessage());
      	}
      	catch(ClassNotFoundException e)
      	{
         out.println(e.getMessage());
      	}
      	finally
      	{
         	//Clean up resources, close the connection.
         	if(conn != null)
         	{
            	try
            	{
              		 conn.close();
            	}
            	catch (Exception ignored) {}
         }
      } 
   }
}