| 123456789101112131415161718192021222324252627282930313233 |
- <%@ 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" %>
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="UTF-8">
- <title>Test DBCP</title>
- </head>
- <body>
- <%
- 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("<br/>");
- }
- }catch(Exception e){
- e.printStackTrace();
- out.println("数据库连接失败");
- }
- %>
- </body>
- </html>
|
