测试Oracle数据库的连接_pdo::setattribute测试orcale连通性-优快云博客

本文链接：https://blog.youkuaiyun.com/xiaolong8/article/details/4742661

本文介绍了一种使用Java进行Oracle数据库连接的方法，通过查找数据源而非直接加载驱动来获取数据库连接。示例代码展示了如何从ECC_staff_manager表中查询前10条记录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

测试Oracle数据库的连接。

代码包含两种方法： 1）加载驱动 2）查找数据源

<%@ page language="java" import="java.util.*,java.sql.*,javax.sql.*,javax.naming.*,org.apache.log4j.*;" pageEncoding="GBK"%> <% response.setCharacterEncoding("GBK"); %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>My JSP 'index.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page">  </head> <body> <% try { //Class.forName("oracle.jdbc.driver.OracleDriver"); //Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@134.128.138.69:1521:tccs", "username", "password"); Context ctx = new InitialContext(); DataSource ds=(DataSource)ctx.lookup("java:comp/env/ECCTestDataSource"); Connection conn=ds.getConnection(); Statement stmt=(Statement) conn.createStatement(); ResultSet rs=stmt.executeQuery("select staff_name from ecc_staff_manager g where rownum<10 "); int rsCount=0; while(rs.next()){ String strTemp=(String)rs.getString("staff_name"); out.println(strTemp+"<br>"); rsCount++; } //logger.debug("总数: " + rsCount); } catch (NamingException e) { // TODO Auto-generated catch block //e.printStackTrace(); out.println("NamingException"); } catch (SQLException se) { out.println("SQLException"); // TODO Auto-generated catch block se.printStackTrace(); //} catch (ClassNotFoundException ce){ // out.println("ClassNotFoundException"); } catch (Exception e){ out.println("Exception"); } %> </body> </html>