<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="javax.naming.Context" %>
<%@ page import="javax.naming.InitialContext" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.DataSource" %>
Test DBCP
<%
DataSource ds;
try{
Context context = new InitialContext();
ds = (DataSource)context.lookup("java:comp/env/jdbc/dc");
Connection conn = ds.getConnection();
PreparedStatement pst = conn.prepareStatement("select * from bblb where rownum <= 2");
ResultSet rs = pst.executeQuery();
while(rs.next()){
out.println(rs.getString("mc"));
out.println("
");
}
}catch(Exception e){
e.printStackTrace();
out.println("数据库连接失败");
}
%>