java连接oracle数据库

首先需要把oracle的驱动放到idea里面(oracle的驱动在product\11.2.0\dbhome_1\jdbc\lib这个目录下)

在src同级目录建立一个lib,然后把oracle的驱动发到lib目录下面

下一步需要点击Project Structure

这样就可以连接oracle了,下面附上代码

public class ConnectOracle {
    public static void main( String[] args ) {
        //1.加载驱动
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            //2.获取连接
            try {
                Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521/orcl", "scott", "tiger");
                //3.创建Statement对象(可以执行sql的对象)
                PreparedStatement preparedStatement = connection.prepareStatement("select * from emp");
                //4.获取结果集
                ResultSet resultSet = preparedStatement.executeQuery();
                //5.对数据进行处理
                while (resultSet.next()) {
                    Integer id = resultSet.getInt("EMPNO");
                    String dname = resultSet.getNString("ENAME");
                    String sal = resultSet.getNString("SAL");
                    System.out.println(id + " " + dname + " " + sal);
                }
                //6.关闭连接 先调用的最后关闭 关闭前判断是否存在
                if (resultSet != null) {
                    resultSet.close();
                }
                if (preparedStatement != null) {
                    preparedStatement.close();
                }
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
}

运行结果: