jsp(11)

JSP页面访问数据库的基础代码

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

<%

 try

 {

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

  String url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+application.getRealPath("db1.mdb");

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

  Statement state=conn.createStatement();

  ResultSet rs=state.executeQuery("select * from usertable");

  while(rs.next())
  {

   out.print(rs.getInt(1));

   out.print("&nbsp;");

   out.print(rs.getString(2));

   out.print("&nbsp;");

   out.print(rs.getString(3));

   out.print("&nbsp;");

   out.print("<br />");

  }

  state.close();

  conn.close();

 }

 catch(Exception e)

 {

  out.print(e);

 }

%>