Java连接Oracle数据库

待我称王封你为后i 2022-06-18 05:29 201阅读 0赞

## Java连接Oracle数据库 ##

将以一个小例子说明Java连接、查询Oracle数据库的过程。在本例子中使用的是Oracle 11g的数据库。首先确保Oracle安装成功，这里不再叙述安装过程。

*  **工程目录**
 *  **导入JAR包**  
    将Oracle安装路径下的几个jar包导入到工程中，如我的JAR路径为D:\\database\\db\_2\\jdbc\\lib。  
    ![这里写图片描述][SouthEast]
 *  **DBUtils.java**  
    DBUtils.java是连接数据库的工具类

package com.cug.test;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    
    public class DBUtils { 
    
        private static final String driverUrl = "oracle.jdbc.driver.OracleDriver";
        private static final String url = "jdbc:oracle:thin:@59.71.244.71:1521:ORCL";
        private static final String username = "SSUSER";    //数据库用户名
        private static final String password = "1234";      //密码
    
        public static Connection getConnection(){
            Connection connection = null;
            try {
                Class.forName(driverUrl);
                connection = DriverManager.getConnection(url, username, password);
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            System.out.println("连接成功！");
            return connection;
        }
    }

*  **DBTest.java**

package com.cug.test;
    
    import java.sql.Connection;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    public class DBTest { 
    
        public static void main(String[] args) {
            // TODO Auto-generated method stub
            Statement stmt = null;
            ResultSet res = null;
            Connection conn = null;
            String sql = " select * from SS_TESTDATA t";
    
            try {
                conn=DBUtils.getConnection();
                stmt = conn.createStatement();
                res = stmt.executeQuery(sql);
                while(res.next())
                {
                    int id = res.getInt("ID");
                    int age=res.getInt("AGE");
                    String name = res.getString("NAME");
                    String sex = res.getString("SEX");
                    System.out.println("ID:"+id+" NAME:"+name+" AGR:"+age+" SEX:"+sex);
                }
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }finally {
    
            }
        }
    
    }

运行DBTest.java可得结果：  
![这里写图片描述][SouthEast 1]

[SouthEast]: /images/20220618/5d05df973b3741a8b6130c3d73de7f07.png
[SouthEast 1]: /images/20220618/a9aae2bfe4e34d20854e4eab108ea065.png