本文介绍如何在JSP中使用JavaBean来连接Access数据库，使用JavaBean代码看起来更优雅。

package conn;                            //导入包
import java.sql.*;                        //导入数据库操作的类

public class DBConnAccess                //构造方法，初始化
{

    private Connection conn;            //连接对象
    private Statement stmt;                //语句对象
    private ResultSet rs;                //结果集对象
    private String accessdriver;        //保存Access驱动程序字符串
    private String accessURL;             //保存Access连接字符串

    public DBConnAccess()
    {
        //Access驱动程序
        accessdriver = "sun.jdbc.odbc.JdbcOdbcDriver";       
        //连接字符串
        accessURL = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
        conn = null;
    }

    //该方法从参数得到数据库路径，并加到连接字符串后面,然后再建立连接
    public Connection getConnToAccess(String dbpath){
        try{
            accessURL=accessURL+dbpath;
            Class.forName(accessdriver);
            conn = DriverManager.getConnection(accessURL);
            }catch(Exception e){
                System.out.println("操作数据库出错，请仔细检查");
                System.err.println(e.getMessage());
            }
        return conn;
    }
   
   //关闭数据库连接
    public void close()
    {
        try{
            //rs.close();
            //stmt.close();
            conn.close();
        }catch(SQLException sqlexception){
            sqlexception.printStackTrace();
        }
    }
}

调用方法如下：

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@ page contentType="text/html; charset=gb2312" language="java"
import="java.sql.*"  %>
<jsp:useBean id="DBConn" scope="page" class="conn.DBConnAccess"/>
<%
    //连接Access 数据库
    String dbpath="data/test.mdb";            //数据库的路径，请自行修改
    Connection conn=DBConn.getConnToAccess(application.getRealPath(dbpath));
    Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
         String sql="select * from username order by id";
    //String sql1="insert into username (uid,pwd) values('wsp','wsp')";
    //stmt.executeUpdate(sql1);
    ResultSet rs=stmt.executeQuery(sql);
   
    while(rs.next()){
    out.print("用户名:");
    out.print(rs.getString("uid")+" 密码:");
    out.println(rs.getString("pwd")+"<br>");
    }
    DBConn.close();
%>

注：本站部分信息可能源于互联网分享，如有侵权，请告知，我们将及时删除！