<%@ page language = "java" pageEncoding="utf-8"%>
<%@ page import = "java.util.*" %>
<%@ page import = "java.sql.*" %>
<%@ page import = "javax.sql.*" %>
<%@ page import = "javax.naming.*" %>
<%
?String jndi_name = "java:comp/env/jdbc/sid";
?String strSql = "select * from T_USER where rownum<2";
?Context ctx = null;
?DataSource ds = null;
?Connection conn = null;
?Statement stmt = null;
?ResultSet rs = null;
?try
?{
??ctx = new InitialContext();
??if( ctx == null ) out.println("no context");
??ds = (DataSource) ctx.lookup(jndi_name);
??if( ds == null ) out.println("no datasource");
??conn = ds.getConnection();
??stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,? ResultSet.CONCUR_READ_ONLY);
??rs = stmt.executeQuery(strSql);
??while(rs.next())
??{
???out.println("ID:" + rs.getString(1) +"<br />");
???out.println("姓名：" +rs.getString(2) +"<br />");
???out.println("年龄：" +rs.getString(3) +"<br />");
??}
?}
?catch(Exception ex)
?{
??ex.printStackTrace();
??out.println(ex.toString());
?}
?finally
?{
??if( rs != null )? rs.close();
??if( stmt != null ) stmt.close();
??if( conn != null)? conn.close();
??if( ctx != null ) ctx.close();
?}
%>
?
?
?
?