java连接oracle

最新推荐文章于 2023-04-20 10:14:06 发布

stinge

最新推荐文章于 2023-04-20 10:14:06 发布

阅读量69

点赞数

分类专栏： web开发文章标签： java 数据库

web开发专栏收录该内容

17 篇文章 0 订阅

订阅专栏

java连接oracle

1.下载oracle的驱动包

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html

2.设置环境变量，在CLASS_PATH中加入包的地址

将class12.jar包放在项目的WEB——INF/lib目录下

3.设置连接参数

选择Driver template ： oracle(thin driver)

测试连接

Io Exception: The Network Adapter could not establish the connection

端口出错，默认是1521，需要打开监听器，所开启监听器端口

mytest是数据库的SID

4.测试jsp连接数据库

<%@ page language="java" import="java.sql.*" pageEncoding="UTF-8"%>
<%@ page import="java.util.*"%>
<%
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">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
  </head>
  
  <body>
    This is my JSP page. <br>
    <%Class.forName("oracle.jdbc.driver.OracleDriver"); 
    Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1522:mytest","system","o123456");
    Statement stmt = con.createStatement();
    ResultSet rs = stmt.executeQuery("select * from test");
    %>
    <b>hello</b>
    <%=rs %>
    <%
    rs.close();
    stmt.close();
    con.close();
     %>
  </body>
</html>