JAVABEAN连接数据库的问题,请各位高手帮帮忙!

JAVABEAN连接数据库的代码如下:
package db;
import java.io.*;
import java.sql.*;
public class DatabaseCon{
  public Connection con;
  public String URL="oracle.jdbc.driver.OracleDriver";
  public String Message;
  public boolean connection(){
    try{
         Class.forName("jdbc:oracle:thin:@localhost:1521:orcl");
         }
         catch(ClassNotFoundException ex){
              Message=ex.getMessage();
              System.exit(-1);
          }
     try{
          con=DriverManager.getConnection(URL,"system","wang");
          return true;
        }
        catch(SQLException ex){
           Message=ex.getMessage();
           return false;
          }
         }
    public boolean close(){
          try{
               con.close();
               return true;
             }
          catch(Exception ex){
               Message=ex.getMessage();
               return false;
          }
        }
       }
db包复制到了D:\Tomcat 5.5\webapps\Bean\WEB-INF\classes的文件下
JSP连接数据库代码如下:
<body bgcolor="#ffffff">
   <jsp:useBean id="im" class="db.DatabaseCon" scope="page">
   </jsp:useBean>
   <% im.connection();
       if(im.connection())
          {
             Statement stmt=im.con.createStatement();
             String sql="select * from student";
             ResultSet rs=stmt.executeQuery(sql);%>


       <table border="1">
             <tr><td>学号</td>
                 <td>姓名</td>
                  <td>成绩</td></tr>

             <%while(rs.next()){%>
              <tr><td><%=rs.getString(1)%></td>
                  <td><%=rs.getString(2)%></td>
                  <td><%=rs.getInt(3)%></td>
               </tr>
               <%}%>
               </table>
               <%}%>
              <%else{
               out.print("数据库连接失败");}%>
  </body>
</html>
为什么会出现Severity and Description Path Resource Location Creation Time Id
db cannot be resolved to a type Bean/WebRoot textbean.jsp line 27 1221815945328 355
db错误?各位高手帮忙看一下!

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","wang"); 写错了吧！
恩,JSP不能保存,老是说db类型错误
然后在JSP上面也要写import java.sql.*和一些相关的
Class12已经加到里面了,以前单独的连接程序都连上了,就是用JAVABEAN出现这样的错误.
<%@ page language="java" import="java.sql.*" contentType="text/html;charset=gb2312"%>都写了
你的url写错了。。
我写了个，你换个用户名就可以。jsp你那样写就可以。。
package test;import java.io.StringReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/*******************************************************************************
* 发送邮件，记录邮件信息
******************************************************************************/
public class testDB {
String sql="";
public static void main(String[] args){
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String sql = null;
String driver ="oracle.jdbc.driver.OracleDriver";
String url ="jdbc:oracle:thin:@10.130.12.33:1521:oracle9i";
String user ="ccicdb";
String pwd ="ccic123";
try {
String msg = "ssssssssssssssssssssssss";
Class.forName(driver);
System.out.println("加载驱动成功！");
conn = DriverManager.getConnection(url,user,pwd);
System.out.println("连接数据库成功！");
stmt = conn.createStatement();
sql="select primeKeyNum from crm_primeKey where tablename='crm_deliver' for update";
PreparedStatement pstat = conn.prepareStatement(sql);
rs = pstat.executeQuery();
if(rs.next()){
System.out.println(rs.getInt(1));
}
int next = rs.getInt(1)+1;
rs.close();
Thread.sleep(60000);
sql = "update crm_primeKey set primeKeyNum = "+next+" where tablename='crm_deliver'";
pstat = conn.prepareStatement(sql);
pstat.executeUpdate();
conn.commit();
stmt.close();
conn.close();
System.out.println("关闭数据库连接成功！");
} catch (Exception e) {
// TODO 自动生成 catch 块
e.printStackTrace();
} }
}
对了，有个通用的
需要在页面上写url。。
package com.ccic;
import java.sql.*;public class DataBase {
private String DBDriver = "oracle.jdbc.OracleDriver"; private String ConnStr = "jdbc:oracle:thin:@//192.168.1.2:1521/orcl"; private Connection conn = null; private Statement stmt = null; private ResultSet rs = null;

// private CallableStatement cs =null; private String userName = "ccicdb"; private String pass = "ccic123";
public DataBase() {
try {
Class.forName(DBDriver);
} catch (ClassNotFoundException e) {
System.err.println("database():" + e.getMessage());
}
} public ResultSet executeQuery(String sql) {
try {
conn = DriverManager.getConnection(ConnStr, userName, pass);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
System.out.println("executeQuery:" + e.getMessage());
}
return rs;
}

   public void java_oracle(){
    try{
    conn = DriverManager.getConnection(ConnStr, userName, pass);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
CallableStatement proc = conn.prepareCall("{ call procUsersAdd(?,?) }");
proc.setString(1,"dfd");
proc.setString(2,"dfd");
proc.executeQuery();
     }catch (SQLException e) {
System.out.println("java_oracle:" + e.getMessage());
}
   } public void executeUpdate(String sql) {
try {
conn = DriverManager.getConnection(ConnStr, userName, pass);
conn.setAutoCommit(false);
stmt = conn.createStatement();
try {
stmt.executeUpdate(sql);
conn.commit();
} catch (SQLException e) {
conn.rollback();
System.out.println("Database Exception:" + e.getMessage());
}
} catch (SQLException e) {
System.err.println("excuteUpdate:" + e.getMessage());
}
} public void closeStmt() {
try {
stmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} public void closeConn() {
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

}。。jsp  String sql1 = "select t.comcode,t.comcname from cc_company t ";
ResultSet rs1 = database.executeQuery(sql1);
%>