Hi All,
I m getting "Error: 500 Unable to compile class for JSP" error messages
while executing a jsp program.
My aim is to execute a query from user input.
I m using 3 programs for that.2 for jsp and 1 bean program.
list1x.jsp is my main program which calls list3x.jsp,which in fact calls
DbBean1 class.
I have saved list1x.jsp and list3x.jsp
in d:\java\jswdk-1.0.1\examples\jsp and DbBean1.class in
d:\java\jswdk-1.0.1\examples\web-inf\jsp\beans\com\wrox\jspexamples
directory.
My programs are
list1x.jsp
<html>
<head>
<title>
Executing a query
</title>
</head>
<body>
<%@ page language="java" errorPage="ErrorPage.jsp" %>
<%@ include file="Header.html" %>
Choose database:
<form method="GET"
action="http://147.0.1.41:8080/examples/jsp/list3x.jsp">
Input SQL if you know your query:
<p>
<input type=text name=inputSQL size=40>
<p>
<input type=submit>
</form>
</body>
</html>
list3x.jsp
<html>
<head>
<title>
Database Search
</title>
</head>
<body>
<%@ page language="java" import="java.sql.*" errorPage="ErrorPage.jsp" %>
<%@ include file="Header.html" %>
<jsp:useBean id="db" scope="request" class="com.wrox.jspexamples.DbBean1"
/>
<jsp:setProperty name="db" property="*" />
<%! int numColumns;
ResultSet rs = null;
ResultSetMetaData rsmd = null;
%>
<center>
<h2>Results from</h2>
<h2><%= request.getParameter("inputSQL") %></h2>
<hr>
<br><br>
<table border="1" bgcolor="#cccc99" bordercolor="#003366">
<tr>
<%
String sql = request.getParameter("inputSQL");
try {
db.connect();
} catch (ClassNotFoundException e) {
throw new ServletException("Database drivers not available", e);
} catch (SQLException e) {
throw new ServletException("Database URL is wrong", e);
}
try {
rs = db.execSQL(sql);
} catch (SQLException e) {
throw new ServletException("Your query isn't working. " +
"Do you want to browse the database? " +
"If so, leave the SQL input empty", e);
}
try {
rsmd = rs.getMetaData();
numColumns = rsmd.getColumnCount();
for (int column = 1; column <= numColumns; column++) {
%>
<th><%= rsmd.getColumnName(column) %></th>
<%
}
%>
</tr>
<%
while (rs.next()) {
%>
<tr>
<%
for (int column = 1; column <= numColumns; column++) {
%>
<td><%= rs.getString(column) %></td>
<% } %>
</tr>
<% }
rs.close();
db.close();
} catch (SQLException e) {
throw new ServletException("Database error. The query worked, " +
"but the display didn't", e);
}
%>
</table>
</center>
</body>
</html>
DbBean1.java is
package com.wrox.jspexamples;
import java.sql.*;
import java.io.*;
public class DbBean1 {
String dbURL;
String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
private Connection dbCon;
public DbBean1() {
super();
}
public boolean connect() throws ClassNotFoundException, SQLException {
Class.forName(this.getDbDriver());
dbCon = DriverManager.getConnection(this.getDbURL());
return true;
}
public void close() throws SQLException {
dbCon.close();
}
public ResultSet execSQL(String sql) throws SQLException {
Statement s = dbCon.createStatement();
ResultSet r = s.executeQuery(sql);
return (r == null) ? null : r;
}
public String getDbDriver() {
return this.dbDriver;
}
public void setDbDriver(String newValue) {
this.dbDriver = newValue;
}
public String getDbURL() {
return this.dbURL;
}
public void setDbURL(String newValue) {
this.dbURL = newValue;
}
}
Any one who can help me.. to save my valuable time
Thanx in advance
Biren
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
