和连接mssql没多大区别,就是有一个地方要转换成绝对路径,
不用设置数据源了.本来想着用mysql或者mssql呢.一想,算勒,还是ACC吧,比较方便,
也不用来回备份转数据什么勒,也就是做个例子么.嘿嘿.
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<%
String dbpath = "data\\data.mdb";
String realpath = application.getRealPath(dbpath);
String strurl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+realpath;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(strurl);
Statement stm = conn.createStatement();
ResultSet rs = stm.executeQuery("select * from test");
while (rs.next()) {
out.println(rs.getString(1));
out.println(rs.getString(2));
out.println("
");
}
out.println(realpath);
%>
String dbpath = “data\\data.mdb”; //双斜杠是转义的意思勒.
String realpath = application.getRealPath(dbpath); //把相对路径转换成绝对路径