1、ODBC桥
数据准备:
CREATE TABLE student
(
"NUMBER" varchar2(6) NOT NULL,
name varchar2(8) NULL,
sex number(1),
birthday timestamp NULL,
height number(3,2) NULL
);
insert into student ("NUMBER",name,sex,birthday,height) values ( '000001','黎明',1,TO_DATE('15-4月 -1990','dd-Mon-
yyyy'),1.78);
insert into student ("NUMBER",name,sex,birthday,height) values ( '000002','赵怡春',0,TO_DATE('17-12月 -1992','dd-Mon-
yyyy'),1.77);
insert into student ("NUMBER",name,sex,birthday,height) values ( '000003','张富平',1,TO_DATE('1-2月 -1995','dd-Mon-
yyyy'),1.78);
insert into student ("NUMBER",name,sex,birthday,height) values ( '000004','白丽',0,TO_DATE('20-11月 -1996','dd-Mon-
yyyy'),1.73);
insert into student ("NUMBER",name,sex,birthday,height) values ( '000005','牛玉德',1,TO_DATE('1-5月 -1993','dd-Mon-
yyyy'),1.74);
insert into student ("NUMBER",name,sex,birthday,height) values ( '000006','姚华',0,TO_DATE('12-5月 -1996','dd-Mon-
yyyy'),1.77);
insert into student ("NUMBER",name,sex,birthday,height) values ( '000007','胡歌',1,TO_DATE('30-6月 -1995','dd-Mon-
yyyy'),1.77);
建立数据源,选择Oracle in Ora10gDb_home1
代码:
<%@ page c%>
<%@page import="java.sql.*"%>
<html>
<head>
</head>
<body>
<%
Connection con;
Statement stm;
ResultSet res;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:StuSQL","system","sys");
stm = con.createStatement();
res = stm.executeQuery("select * from student");
while (res.next()) {
out.print(res.getString(1) + "<br>");
}
con.close();
} catch (Exception ex) {
System.out.println(ex.getMessage());
}
%>
</body>
</html>
2、专用驱动
将ojdbc14.jar文件放入lib中
代码:
<%@ page c%>
<%@page import="java.sql.*"%>
<html>
<head>
</head>
<body>
<%
Connection con;
Statement stm;
ResultSet res;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","system","sys");
stm = con.createStatement();
res = stm.executeQuery("select * from student");
while (res.next()) {
out.print(res.getString(1)+"<br>");
}
con.close();
} catch (Exception ex) {
System.out.println(ex.getMessage());
}
%>
</body>
</html>
更多可见:http://blog.csdn.net/m13666368773/article/details/7234171