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

<%@ 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.102:1521:egovwwdb";

Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
try
{
//Class.forName(sDBDriver);
//conn = DriverManager.getConnection(sConnStr,"portal","portal");
//stmt = conn.createStatement();
   Context   ctx   =   new   InitialContext();  
   DataSource   ds   =(DataSource)ctx.lookup("jdbc/portal"); //jdbc/portal为JNDI 
   conn   =   ds.getConnection();  
   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();
}
%>