Question

jsp 连接access数据库

麻烦请高手给我一段jsp连接access数据库的代码！
非常感谢！！

Answer 1

<%!
Connection con=null;
Statement sql=null;
ResultSet rs=null;
%>
<%
try{
con=DriverManager.getConnection("jdbc:odbc:sun","","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM chengji");
ResultSetMetaData mdrs=rs.getMetaData();
%>