// 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.