DaniWeb Forum Index > Web Development > JSP

JSP Error

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2006

Posts: 20

Reputation: muthumari is an unknown quantity at this point

Solved Threads: 0

muthumari

Offline

Newbie Poster

JSP Error

Apr 17th, 2006

// My JSP coding. This is stored in the following path ]http://localhost:8080/vennila/test.jsp

<HTML>
<HEAD><TITLE>DataBase Search</TITLE></HEAD>
<BODY>

<%@ page language="Java" import="java.sql.*" %>
<jsp:useBean id="db" scope="application" class="SQLBean.DbBean"/>
<jsp:setProperty name="db" property="*" />

<%!
ResultSet rs = null ;
ResultSetMetaData rsmd = null ;
int numColumns ;
int i;
%>
<center>
<h2> Results from </h2>
<hr>
<br><br>
<table>
<%
db.connect();
rs = db.execSQL("select * from emp1");
i = db.updateSQL("UPDATE emp1 set fname = 'hello world' where
empid=101");
out.println(i);

rsmd = rs.getMetaData();
numColumns = rsmd.getColumnCount();
for(int column=1; column <= numColumns; column++)
{
out.println(rsmd.getColumnName(column));
}
%>

<%
while(rs.next())
{
%>
<%= rs.getString("empid") %>
<BR>
<%
}
%>
<BR>
<%
db.close();
%>
Done
</table>
</body>
</HTML>

//My Java Package Coding. It is compiled and stored in the following path: C:\Program Files\Apache Tomcat 4.0\webapps\vennila\WEB-INF\classes\

package SQLBean;

import java.sql.*;
import java.io.*;

public class DbBean {

String dbURL = "sun.jdbc.odbc.JdbcOdbcDriver";
String dbDriver = "'jdbc dbc:emp','',''";
private Connection dbCon;

public DbBean(){
super();
}

public boolean connect() throws ClassNotFoundException,SQLException{
Class.forName(dbDriver);
dbCon = DriverManager.getConnection(dbURL);
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 int updateSQL(String sql) throws SQLException{
Statement s = dbCon.createStatement();
int r = s.executeUpdate(sql);
return (r == 0) ? 0 : r;
}

}

----------------- xxxx-------------------------

When i run the jsp in internet explorer its giving me the following error :

C:\Program Files\Apache Tomcat 4.0 work\localhost\vennila\test$jsp.java:72: Class SQLBean.DbBean not found.
SQLBean.DbBean db = null;
^

My Java file is stored in the following path : C:\Program Files\Apache Tomcat 4.0\webapps\vennila\WEB-INF\classes

My Class file is stored in the following path :
C:\Program Files\Apache Tomcat 4.0\webapps\vennila\WEB-INF\classes\SQLBean

:rolleyes: I am breaking my head towards this problem for the past 4 days. I am new to Bean concept. kindly help me to solve this problem.