JDBC连接Oracle

最新推荐文章于 2025-07-16 12:44:54 发布

yxw6596

最新推荐文章于 2025-07-16 12:44:54 发布

阅读量269

点赞数

CC 4.0 BY-SA版权

分类专栏： java 文章标签： Oracle JDBC

本文链接：https://blog.youkuaiyun.com/yxw6596/article/details/98441731

java 专栏收录该内容

3 篇文章

订阅专栏

本文介绍了如何通过JDBC与Oracle数据库建立连接，包括导入Oracle JDBC驱动包，详细阐述了JDBC的六个基本步骤，从注册驱动到关闭资源，并提供了完整的示例代码。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

通过JDBC与Oracle建立连接

1、首先需要导入数据库驱动包，相关驱动包可以在安装Oracle路径下的jdbc文件夹找到，或者网上下载相关对应Oracle版本的驱动包

2、JDBC的六大步骤

注册驱动
获取连接
获取执行sql语句对象
执行sql语句
处理结果集
关闭资源

//1.加载JDBC驱动程序
Class.forName(driver);
//2.分配一个connect对象，获取连接
con = DriverManager.getConnection(url, user, password);

System.out.println("连接成功");
//3.获取执行sql语句
String sql = "select * from \"Persions\"";
//4.分配一个prepareStatement对象，执行查询语句
pstm = con.prepareStatement(sql);
//5.返回pstm对象，迭代结果
rs = pstm.executeQuery();
while (rs.next()) {
    int id_p = rs.getInt("ID_P");
    String lastname = rs.getString("LASTNAME");
    String firstname = rs.getString("FIRSTNAME");
    String address = rs.getString("ADDRESS");
    String city = rs.getString("CITY");
    System.out.println(id_p+"\t" + lastname+"\t" + firstname+"\t" + address+"\t" + city);
}

// 6.关闭连接资源
if (rs != null) {
    try {
        rs.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }
} else if (pstm != null) {
    try {
        pstm.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }
} else if (con != null ) {
    try {
        con.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

附：完整代码

package com.JDBCDemo.util;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.DriverManager;

public class JDBCUtil {

    public static void main(String[] args) {

         String driver = "oracle.jdbc.OracleDriver";
         String url = "jdbc:oracle:thin:@localhost:1521:orcl";
         String user = "yxw";
         String password = "123456";

        Connection con = null;
        PreparedStatement pstm = null;
        ResultSet rs = null;

        Boolean flag = false;

        try {
            //加载JDBC驱动程序
            Class.forName(driver);
            //分配一个connect对象
            con = DriverManager.getConnection(url, user, password);

            System.out.println("连接成功");
            //sql字符串
            String sql = "select * from \"Persions\"";
            //分配一个prepareStatement对象，执行查询语句
            pstm = con.prepareStatement(sql);
            //返回pstm对象，迭代结果
            rs = pstm.executeQuery();
            while (rs.next()) {
                int id_p = rs.getInt("ID_P");
                String lastname = rs.getString("LASTNAME");
                String firstname = rs.getString("FIRSTNAME");
                String address = rs.getString("ADDRESS");
                String city = rs.getString("CITY");
                System.out.println(id_p+"\t" + lastname+"\t" + firstname+"\t" + address+"\t" + city);
            }
            flag = true;
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            // 关闭连接资源
            if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            } else if (pstm != null) {
                try {
                    pstm.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            } else if (con != null ) {
                try {
                    con.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }

        }
        if (flag) {
            System.out.println("执行成功");
        } else {
            System.out.println("执行失败");
        }
    }
}