用java连接数据源

<%@ page import="java.sql.*,org.loushang.waf.ComponentFactory,javax.sql.DataSource,javax.naming.*"%>
<%
 Context ic=new InitialContext();
 DataSource dao=(DataSource)ic.lookup("jdbc/sh");
 Connection con=dao.getConnection();
 PreparedStatement ps=con.prepareStatement("select * from yc_sequence");
 ResultSet rs=ps.executeQuery();
 while(rs.next()) out.println(rs.getString(1));
 rs.close();
 ps.close();
 con.close();
 /*
 DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
 DataSource dao=(DataSource)ComponentFactory.getBean("dataSource");
 Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:publish","system","admin");
 PreparedStatement ps=con.prepareStatement("select * from yc_sequence");
 ResultSet rs=ps.executeQuery();
 while(rs.next()) out.println(rs.getString(1));
 rs.close();
 ps.close();
 con.close();
 */
%>