连接ACCESS数据库的问题
<%@page contentType="text/html; charset=GBK" import="java.sql.*"%>
<html>
<head>
<title>jsp2</title>
</head>
<body bgcolor="#ffffff">
<%
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String dburl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=test.mdb";
Connection conn = DriverManager.getConnection(dburl);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from T1");
String tmp = "";
while (rs.next()) {
tmp = rs.getString("MTV");
}
System.out.println(tmp);
session.setAttribute("path",tmp);
rs.close();
stmt.close();
conn.close();
}
catch(Exception ex) {
out.println("Error "+ex.getMessage());
}
%>
</body>
</html>
在JB的环境下。。。。
会出现以下错误。。Error [Microsoft][ODBC Microsoft Access Driver] 找不到文件 '(未知的)'。