JAVA连接Oracle9i代码＆JSP连接Oracle 9i 示例

最新推荐文章于 2021-04-08 19:44:26 发布

reallyafei

最新推荐文章于 2021-04-08 19:44:26 发布

阅读量1.4k

点赞数

分类专栏： ORACLE JAVA 文章标签： oracle java jsp string 数据库 jdbc

本文链接：https://blog.csdn.net/reallyafei/article/details/1487784

版权

JAVA 同时被 2 个专栏收录

19 篇文章 0 订阅

订阅专栏

ORACLE

14 篇文章 0 订阅

订阅专栏

JAVA连接Oracle 9i代码

import java.sql.*;
class dbtest
{
public static void main(String args[]) throws SQLException
{
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@192.168.0.94:1521:ORAC","scott","tiger");

Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from dept");
while(rs.next())
{
System.out.println(rs.getString(1) +"----"+ rs.getString(2));
}

System.out.println("数据库操作成功，恭喜你");

rs.close();
stmt.close();
conn.close();
}
}

JSP连接Oracle 9i 示例

<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.168.0.94:1521:orac";
String user="scott";
String password="tiger";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from dept";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
<%=rs.getString(1)%>----<%=rs.getString(2)%> <br>
<%}%>

<%out.print("数据库操作成功，恭喜你");%>

<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>

注:192.168.0.94为主机IP地址,也可以写你的主机名,ORAC为你的数据库的SID
即服务名.