请问如何解决？

sqlbean:
package yuanbean;
import java.sql.*;public class access_dbconnect{
        String  dbdriver = "oracle.jdbc.driver.OracleDriver";
String  dbname = "jdbc:oracle:thin:@server1:1521:orcl";
String  user = "whl";
String password = "whl";
Connection conn = null;
Statement stmt = null;
ResultSet rs =null;
public access_dbconnect(){
              try
  {
                  Class.forName(dbdriver);
              }
              catch(java.lang.ClassNotFoundException e){
                    System.err.println("Class access_dbconnect not fount!"+e.getMessage());
                   }
conn=DriverManager.getConnection(dbname,user,password);
        }
   public access_dbconnect(String  sdbdriver,String  sdbname,String  suser,String spassword){
              try
  {
                  dbdriver=sdbdriver;
  dbname=sdbname;
  user=suser;
  password=spassword;
  Class.forName(dbdriver);
              }
              catch(java.lang.ClassNotFoundException e){
                    System.err.println("Class access_dbconnect not fount!"+e.getMessage());
                   }
  conn=DriverManager.getConnection(dbname,user,password);
              
   }
       public ResultSet executeQuery(String sql){              try{
                  conn=DriverManager.getConnection(dbname,user,password);
                  Statement stmt=conn.createStatement();
                  rs=stmt.executeQuery(sql);                  if(rs == null)     // can't open recordset
                {
                  System.out.println("can't get ResultSet"); 
                }                                   }
              catch(SQLException ex){
                     System.err.println("aq.executeQuery:"+ex.getMessage());
               }
               return rs;       }       public ResultSet executeUpdate(String sql){              try{
                conn=DriverManager.getConnection(dbname,user,password);
                  Statement stmt=conn.createStatement();
                  rs=stmt.executeQuery(sql);
             }
              catch(SQLException ex){
                    System.err.println("aq.executeQuery:"+ex.getMessage());
             }
             return rs;
    }
  public void close()
  {
    try
{
    this.conn.close();
    this.stmt.close();
rs.close();
     }
 catch(Exception e)
 {
    e.printStackTrace();
 }
  }}
sql.jsp<%@ page language="java" import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312"%>
<html>
<head>
    <title>查询</title>
</head><body>
<jsp:useBean id="view" scope="page" class="sqlbean.access_dbconnect"/>
<%
  ResultSet rs;
  rs=view.executeQuery("select * from t_ddmx");
  while(rs.next())
      {
%>
姓名：<%=rs.getString("ddbh")%>
</p>
<%
rs.close();
view.close();
} %>
<hr>
</body>
</html>

解决方案 »

  1.   

    sql.jsp
    <jsp:useBean id="view" scope="page" class="yuanbean.access_dbconnect"/>
      

  2.   

    注意，javabean是以类名做为文件名，以包名做为文件夹名，根据你的写法，应该是在站点目录下的WEB-INF/classes/下新建一个yuanbean文件夹，然后将access_dbconnect.java放入其中（实际是生成的access_dbconnect.class，运行jsp时会自动生成）
    jsp中的引用为：<jsp:useBean id="view" scope="page" class="yuanbean.access_dbconnect"/>class=包名.类名