java使用JDBC连接oracle数据库

最新推荐文章于 2023-12-16 15:12:26 发布

星时代曹波涛

最新推荐文章于 2023-12-16 15:12:26 发布

阅读量403

点赞数

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

本文链接：https://blog.csdn.net/qq_46213085/article/details/128524109

版权

JavaEE 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

导包

        <dependency>
            <groupId>com.oracle.database.jdbc</groupId>
            <artifactId>ojdbc8</artifactId>
            <scope>runtime</scope>
        </dependency>

使用

 Class.forName("oracle.jdbc.driver.OracleDriver");
        Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl", "BOTAO", "123456");
        Statement statement = connection.createStatement();
        //statement.execute("insert into \"user\" values (6,'刘琦',23)");
        ResultSet resultSet = statement.executeQuery("select * from \"user\" order by \"id\" asc");
        while (resultSet.next()) {
            Integer id = resultSet.getInt("id");
            String name = resultSet.getString("name");
            Integer age = resultSet.getInt("age");
            System.out.println(id + "\t" + name + "\t" + age);
        }
        resultSet.close();
        connection.close();