Call Stored Procedure Using Servlet

Call Stored Procedure Using Servlet.java

package examadmin;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class LoginAdmin extends HttpServlet 
{	
	private static final long serialVersionUID = 1L;
	Connection con;
	ResultSet rs; 
	PreparedStatement ps;
	CallableStatement cs,cs1;
       
    public LoginAdmin() 
    {
        super();
        con=ExamConnection.getConnection();
    }

    public void process(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, SQLException 
	{
		try
		{
			cs=con.prepareCall("{call get_login_id(?,?)}");  
			
			cs.setString(1, id);
			cs.setString(2, pwd);
			rs=cs.executeQuery(); 
			rs.last();
			String ename=rs.getString("ename");
			System.out.println("Employee name :"+ename);		 
		}
		catch(SQLExecption e)
		{
			System.out.println(e);
		}
	}
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{		
		this.process(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{
		this.process(request, response);
	}
}