oracle的odbc

最新推荐文章于 2024-08-23 09:54:42 发布

山顶看数据

最新推荐文章于 2024-08-23 09:54:42 发布

阅读量361

点赞数

分类专栏： orcale 文章标签： oracle 数据库

本文链接：https://blog.csdn.net/li1579026891/article/details/126610847

版权

orcale 专栏收录该内容

2 篇文章 0 订阅

订阅专栏



import java.sql.*;

public class Jdbc {
    private static String driver = "oracle.jdbc.driver.OracleDriver";
    // private static String url = "jdbc:oracle:thin:@ip:port:db";
    private static String url = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS = (PROTOCOL=TCP)(HOST=ip)(PORT=port))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=service_name)))";
    private static String username = "";
    private static String password = "";

    public static Connection getConnection() {
        Connection con = null;
        try {
            Class.forName(driver);
            con = DriverManager.getConnection(url, username, password);
            return con;
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
        return null;
    }

    public static void close(Connection con, PreparedStatement pstmt, ResultSet rs) {
        // 关闭rs
        try {
            if (rs != null && !(rs.isClosed())) {
                rs.close();
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        // 关闭ps
        try {
            if (pstmt != null && !(pstmt.isClosed())) {
                pstmt.close();
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        // 关闭con
        try {
            if (con != null && !(con.isClosed())) {
                con.close();
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }

}

        Connection connection = Jdbc.getConnection();
        Statement statement = connection.createStatement();
        String sql = " select from  where rownum < 101 ";
        ResultSet resultSet = statement.executeQuery(sql);
        while (resultSet.next()){
            // 里面是获取的每一条数据
            oracleMetaDataInfo.setTablespace_name(resultSet.getString(1));
            oracleMetaDataInfo.setSegment_name(resultSet.getString(2));
            oracleMetaDataInfo.setSegment_type(resultSet.getString(3));
            oracleMetaDataInfo.setBytes(resultSet.getInt(4));
            oracleMetaDataInfo.setOwenr(resultSet.getString(5));
        }

<!-- 链接oracle -->
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc14</artifactId>
            <version>10.2.0.4.0</version>
        </dependency>