很菜的一个问题，jsp+javaBean连接数据库

来源：百度知道 编辑：UC知道 时间：2024/05/22 14:42:34
b.jsp:
<%@ page import="java.sql.*" %>

<jsp:useBean id = "myBean" class = "n.M" scope = "application" />
<%
ResultSet rs = myBean.execute("select * from b");
out.println(rs.getString(1));
%>

M.java:

package n;
import java.sql.*;

public class M
{
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDirver";
String url = "jdbc:odbc:MS Access Database;DBQ=d:\\b.mdb";
Connection conn = null;
ResultSet rs = null;
public M()
{
try
{
Class.forName(DBDriver);
}
catch(Exception e){}
}

public ResultSet execute(String sql)
{
try
{
conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(Except

public ResultSet execute(String sql)
{
try
{
Class.forName(DBDriver ).newInstance(); //在这里加这么一句
conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(Exception e){}
return rs;
}