FileDocCategorySizeDatePackage
StoredProcServlet.javaAPI DocExample3159Tue Jul 22 09:41:32 BST 2003com.jspservletcookbook

StoredProcServlet

public class StoredProcServlet extends HttpServlet

Fields Summary
DataSource
pool
Constructors Summary
Methods Summary
public voidaddRaceEvent(java.util.List values)


        if (values == null)
            throw new SQLException("Invalid parameter in addRaceEvent method.");
            
        Connection conn = null;
        
        conn = getConnection();
        
        if (conn == null )
        throw new SQLException("Invalid Connection in addRaceEvent method");
        
        java.util.Iterator it = values.iterator(); 
        
        CallableStatement cs = null;
        
        //Create an instance of the CallableStatement
        cs = conn.prepareCall( "{call addEvent (?,?,?)}" );
    
        for (int i = 1; i <= values.size(); i++)
            cs.setString(i,(String) it.next()); 
        
        //Call the inherited PreparedStatement.executeUpdate() method
        cs.executeUpdate();
        
       // return the connection to the pool
       conn.close();

  
public voiddoGet(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response)

    
        String eventName = request.getParameter("eName");
        String location = request.getParameter("eLocation");
        String date = request.getParameter("eDate");
        
        List paramList = new ArrayList();
        paramList.add(eventName);
        paramList.add(location);
		paramList.add(date);

		try{
        
        addRaceEvent(paramList);
        
        } catch (SQLException sqle){  throw new ServletException(sqle.getMessage()); }
        
        response.setContentType("text/html");
        java.io.PrintWriter out = response.getWriter();
        out.println("<html><head><title>Add an Event</title></head><body>");
        out.println("<h2>The Event named "+ eventName +" has been added to the database</h2>");
        
        out.println("</body>");
        out.println("</html>");
    
        out.close();
      
     
public java.sql.ConnectiongetConnection()


    Connection  conn = null;
    
    try{
    
         conn = pool.getConnection();
         
    } catch (SQLException sqle){
    
        throw new ServletException(sqle.getMessage());
    
    } finally {
    
      return conn;
      
      }
    
    
public voidinit()

        
         Context env = null;
        
       try{
           
             env = (Context) new InitialContext().lookup("java:comp/env");
             
             pool  = (DataSource) env.lookup("jdbc/oracle-8i-athletes");
             
             if (pool == null)
                 throw new ServletException("'oracle-8i-athletes' is an unknown DataSource");
             
        } catch (NamingException ne) { 
        
           throw new ServletException(ne);

        }