JSP连接ORACLE示例代码

最新推荐文章于 2022-09-22 23:14:48 发布

原创最新推荐文章于 2022-09-22 23:14:48 发布 · 7.8k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #jsp #string #stylesheet #import #html

本文展示了一个使用Java连接Oracle数据库并查询数据的例子。通过设置数据库URL、用户名及密码，利用JDBC API进行数据库连接与数据检索操作。

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%> <%@ page import="oracle.jdbc.*"%> <%@ page import="java.sql.*" %> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!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> <% Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); ResultSet rs=null; String oraUrl="jdbc:oracle:thin:@127.0.0.1:1521:xtweb";//jdbc:oracle:thin:@localhost:1521:xtweb String oraUser="xtweb"; String oraPWD="xtweb"; try { DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); } catch (SQLException e) { out.print("数据库连接驱动出错！"); } try { Connection conn=DriverManager.getConnection(oraUrl,oraUser,oraPWD); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); rs=stmt.executeQuery("select * from T_TEST"); while(rs.next()) { out.print(rs.getString("ID")); out.print(":"); out.print(rs.getString("NAME")); out.print("<br>"); } rs.close(); stmt.close(); conn.close(); } catch (SQLException e) { System.out.println(e.toString()); out.print(e.toString()); } %> </body> </html>