jsp用jdbc方式访问数据库示例代码

<%@ page language="java" import="java.io.*,java.sql.*,javax.sql.* ,javax.naming.*"%>
<%@ page contentType="text/html;charset=gb2312" %>
<%

String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin:@10.1.63.202:1521:portaldb";

Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
try
{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr,"portal","portal");
stmt = conn.createStatement();   
   stmt = conn.createStatement();
   rs = stmt.executeQuery("select * from dhcc_portal_log");
   while (rs.next()){
  out.println("" + rs.getInt(1) + "");
  out.println(":"+"<br>");
  out.println(rs.getString("url"));
}
}
catch(Exception e)
{
   out.println(e.getMessage());
  e.printStackTrace();
}
finally
{
  if(stmt!=null)stmt.close();
  if(rs!=null)rs.close();  
  if(conn!=null)conn.close();
}
%>