JAVA使用JDBC连接oracle数据库

最新推荐文章于 2024-05-07 10:13:38 发布

独行侠谁也不带

最新推荐文章于 2024-05-07 10:13:38 发布

阅读量7.3k

点赞数 1

分类专栏： JAVA全栈文章标签： oracle 数据库 java

本文链接：https://blog.csdn.net/xielong8866/article/details/128493932

版权

首先给出代码和输出：

//import java.sql.DriverManager;
//import java.sql.SQLException;

import java.sql.*;

public class DatabaseConnect {
    public static void main(String[] args) throws Exception
    {
        connDatabase();
    }
    public static void connDatabase()
    {
        try {
            Class.forName("oracle.jdbc.OracleDriver");
            Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.10.150:1521/orcl11g","xielong","xielong");
            System.out.println(conn);
            Statement s = conn.createStatement();
            String sql="select * from xielong";
            ResultSet result=s.executeQuery(sql);
            while(result.next()) {
                int age = result.getInt("age");
                String name = result.getString("name");
                System.out.println(name+"今年"+age+"岁了&#