muthumari 0 Newbie Poster

// 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;
}


}

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

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.