帮我看看通过JSP与Access直接连接有什么问题?如果代码没错,还需要其它的设置吗?<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.text.*"%> <%
try
{
Class.forName("sun.jdb.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\Program Files\\Apache Software Foundation\\Tomcat 5.5\\webapps\\ROOT\\bbs\\guestbook.mdb";
Connection con=DriverManager.getConnection(url,"","");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from guestbook");
while (rs.next())
{
out.println(rs.getString("Name"));
}
}
catch(Exception ex)
{
out.println("ex==="+ex);
} rs.close();
con.close();
%>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.text.*"%> <%
try
{
Class.forName("sun.jdb.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\Program Files\\Apache Software Foundation\\Tomcat 5.5\\webapps\\ROOT\\bbs\\guestbook.mdb";
Connection con=DriverManager.getConnection(url,"","");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from guestbook");
while (rs.next())
{
out.println(rs.getString("Name"));
}
}
catch(Exception ex)
{
out.println("ex==="+ex);
} rs.close();
con.close();
%>
url=jdbc:odbc:数据源名称
package oa.db;
/**
* <p>数据库连接专用包 </p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company:juanjuan book shop online </p>
* @by :
* @version 1.0
*/
import java.sql.*;
public class opendb {
public Connection conn;
public Statement stmt;
public ResultSet rs=null;
public String sqlStr="";public opendb() {
this.connect();
}
public boolean connect(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=d:/jsp/oa/database/oa_database.mdb";
conn=DriverManager.getConnection(url,"root","8888");
stmt = conn.createStatement ();
}catch(Exception ee){
System.out.println("connect db error:"+ee.getMessage());
return false;
}
return true;
}//用于执行查询数据库的操作
//返回查询结果集
public ResultSet execQuery(String sql)
String url ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=d:/jsp/oa/database/oa_database.mdb";
ResultSet rs=null;
try {
conn = DriverManager.getConnection(url,"root","8888");
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
//stmt.close();
} catch(SQLException ex) {
System.err.println("opendb.execQuery(): " + ex.getMessage());
} return rs;
}