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> 相关推荐
lklong 2020-11-22
oraclemch 2020-11-06
shilukun 2020-10-10
周嘉笙 2020-11-09
zhuzhufxz 2020-09-16
bfcady 2020-08-16
Hody 2020-08-16
FightFourEggs 2020-08-16
数据库设计 2020-08-16
yanghuatong 2020-08-16
dbasunny 2020-08-16
罗罗 2020-08-16
ihuaqiang 2020-08-16
choice0 2020-07-30
娜娜 2020-07-28
solarspot 2020-07-28
踩风火轮的乌龟 2020-07-26
娜娜 2020-07-20
xwb 2020-07-19
娜娜 2020-07-18
流云追风 2020-07-04
dataminer 2020-06-25
娜娜 2020-06-22
zhangchaoming 2020-06-21