- <%
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:/DataBase/books.mdb"; //注意修改路径,最好用java反射或取Connection con=DriverManager.getConnection(url) ;
- Statement stmt=con.createStatement();
- ResultSet rst=stmt.executeQuery("select * from book");
- while(rst.next())
- {
- out.println("<tr>");
- out.println("<td>"+rst.getString("bookId")+"</td>");
- out.println("<td>"+rst.getString("bookName")+"</td>");
- out.println("<td>"+rst.getString("publisher")+"</td>");
- out.println("<td>"+rst.getFloat("price")+"</td>");
- out.println("</tr>");
- }
- //关闭连接、释放资源
- rst.close();
- stmt.close();
- con.close();
- %>
JAVA链接ACCESS数据库
最新推荐文章于 2024-08-12 15:45:48 发布