direct-access.jsp

来自「jsp在线考试系统」· JSP 代码 · 共 34 行

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
Connection con;
Statement stmt;
try{
       //Load  JDBC  driver
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       //注意DBQ的写法      
       
       String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=g:\\db1.mdb";//注意在Driver 和(*.mdb)之间要有一个空格！
       
       con = DriverManager.getConnection(url);
       //if(true){out.println("aaaaaaaaa");
       //return;}
       stmt = con.createStatement();
       String query ="select * from guest";
       
       ResultSet rs = stmt.executeQuery(query);
       
       while(rs.next())
       {
             String str = rs.getString("name");
             out.print(str+"<br>");
       }

}
catch(Exception e){
       e.printStackTrace();
       e.toString();
       if(true)out.println("bbbbbbb");
       return;
}
%>