Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at http://www.kyle-brown.com/ for other WebSphere information.
SCJO, SCJD, SCWCD, I-Net+, A+, Network+, MCSD, MCDBA, MCP, MCT
Originally posted by Ray Smilgius:
Here is some example code for sql called stored procedure that works:
<html>
<head>
<title>Database</title>
</head>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.Date" %>
<%@ page import="java.io.*" %>
<%response.setHeader("Cache-Control", "no-cache");%>
<%response.setHeader("pragma", "no-cache");%>
<%response.setDateHeader("Expires", -1);%>
<body>
<%!
public void ReplacePageInParentFrame(String sUrl)
{
}
%>
<% System.out.println("test"); %>
The current date is <%= new Date() %>.
<h2>Employee Phone Numbers</h2>
<table border="1">
<tr><th>ID Number<th>Name<th>Title</tr>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc dbc:mydatabase;UID=raymond;PWD=123456");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM Employees");
while(rs.next())
{
String employeeId = rs.getString("EmployeeID");
String employeeName = rs.getString("FirstName");
String employeeExt = rs.getString("Title");
out.print("<tr>");
out.print("<td>" + employeeId + "</td>");
out.print("<td>" + employeeName + "</td>");
out.print("<td>" + employeeExt + "</td>");
out.print("</tr>");
}
con.close();
%>
</table>
</body>
</html>
Hope it helps.
Ray
Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at http://www.kyle-brown.com/ for other WebSphere information.
Originally posted by Gregk:
I am trying to call a stored procedure in a jsp,
the procedure deletes from a database, taking as a parameter user name.Here is my code, for some reasone it is not working. The error I'm getting is Type OracleCallableStatement was not found.
Here is my code:
<% // the delete link has been clicked
String myName = "";
if(request.getParameter("deleteAll") != null) {
myName = request.getParameter("deleteAll");
Connection conn = coreModel.getConn();
OracleCallableStatement oraStmt1 =
(OracleCallableStatement)conn.prepareCall("{call DS_MOTD_PKG.DELETEALLMESSAGES(myName)}");
oraStmt1.execute();
}
%>
Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at http://www.kyle-brown.com/ for other WebSphere information.
Take a Minute, Donate an Hour, Change a Life
http://www.ashanet.org/workanhour/2006/?r=Javaranch_ML&a=81
Take a Minute, Donate an Hour, Change a Life
http://www.ashanet.org/workanhour/2006/?r=Javaranch_ML&a=81