JDBC connection using bean

hi ranchers

i am trying to connect to the oracle database with the help of beans & jsp
i am not that familiar with and i am using netbeans as an interface
can you please help me with the procedure of connecting to the database

i have created a database in oracle of name emplyoee with first name ,last name and empno

this is my bean page

and this is my jsp page

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%--
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library... action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
--%>
<%--
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> 
--%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

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

<%@ page language="Java" import="java.sql.*" %>

<jsp:useBean id="db" scope="request" class="DbBean" />   [size=18] [u]//ERR CANNOT FIND SYMBOL[/u][/size]
<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();

try { 
          rs = db.execSQL("select * from EMPLOYEE");  
          i = db.updateSQL("UPDATE employee set FIRSTNME = 'hello world' where EMPNO='001'"); 
          out.println(i); 
        }catch(SQLException e) { 
              throw new ServletException("Your query is not working", e);        
              }

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

<%         
      while(rs.next()) {  
%>      
<%= rs.getString("EMPNO") %> 
<BR>  
<% 
                }  
%>  
<BR>  
<%

db.close();

%>

Done

</table>

</body>

</HTML>

ITS SHOWING ME AN ERROR in jsp page i have specifed it below
please help me with the procedure and rectify errors if any

<jsp:useBean id="db" scope="request" class="DbBean" /> //ERR CANNOT FIND SYMBOL

What is the error ?

What error?

1."<jsp:useBean id="db" scope="request" class="DbBean" />" --> class = "DbBean" this should be fully qualified name. i.e, class must be in some packages. example : class = "bean.DbBean"

2. Here what is the significance of <jsp:setProperty name="db" property="*" /> ?

3.by the way: Establishing Database connection in jsp is highly discouraged[Avoid Scriplet]

the error i am getting is cannot find symbol in the jsp page at the line 22

I agree this is poor practice. That said, where is the code that sets DBBean in the request? It should be in a servlet somewhere. If it doesn't exist, that explains why the bean isn't in the request.