Ejecutar procedimiento almacenado en JSP.

<%@page language=”java” session=”false” import=”java.sql.*,java.io.*”%>

<%

try {
  Class.forName(“com.mysql.jdbc.Driver”).newInstance();
  Connection databaseConnection = DriverManager.getConnection(“jdbc:mysql://server/data base name,user,password);           
  Statement myStatement = databaseConnection.createStatement();
  ResultSet myResult = myStatement.executeQuery(“CALL nameofStoreProcedure(‘param1′,’param2′…’)”);
   while (myResult.next()) {
    out.println(myResult.getString(“Name of column”);   

  }
  databaseConnection.close();           
 }catch (Exception e){
  out.println(“Error: ” + e.getMessage());
 }

%>

Advertisement