`
stinge
  • 浏览: 150404 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

java连接oracle

 
阅读更多

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>
 

 

 

分享到：
| oracle 创建数据库
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

Magicbox
Global site tag (gtag.js) - Google Analytics