一个简单的jsp连接access数据库的程序

2023-07-20 04:19:32

<%@?page?contentType="text/html;charset=gb2312"%>?

<%@?page?import="java.sql.*"%>?

<html>?

<body>?

<%?

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");?

String?url="jdbc:odbc:driver={Microsoft?Access?Driver?(*.mdb)};?DBQ=d://zb.mdb";?

Connection?conn=?DriverManager.getConnection(url,"","");?

Statement?stmt=conn.createStatement();?

String?sql="select?*?from?zb";?

ResultSet?rs=stmt.executeQuery(sql);?

while(rs.next())?{%>?

<%=rs.getString(1)%>?

<%=rs.getString(2)%>

<br?/>?

<%}%>?

<%rs.close();?

stmt.close();?

conn.close();?

%>?

</body>?

</html>?

继续阅读