jsp连接ACCESS

来源:百度文库 编辑:神马文学网 时间:2024/03/29 21:34:50
一.建立数据库
1.建立jcc.mdb数据库及user表
2.添加测试数据
二.在<%wwwroot%>/下,新建Access数据库连接文件Select.jsp
Select.jsp源码如下:
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>


<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){
out.print(e);
}
try{
String strDirPath=application.getRealPath(request.getRequestURI());
strDirPath=strDirPath.substring(0,strDirPath.lastIndexOf('\\'))+"\\";
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+strDirPath+"jcc.mdb";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM user");
out.println("User-list"+"
");
while(rs.next()){
out.print(rs.getString(1)+" ");
out.print(rs.getString(2)+"
");
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception ex){
out.print(ex);
}
%>