eclipse连接oracle(菜鸟入门之详细步骤)

末蓝、 2022-04-08 12:18 979阅读 0赞

为了方便，在这里给出百度网盘链接地址，可直接下载到jar包。

链接：https://pan.baidu.com/s/12kL7\_3Zx3lmaqW-lRTj\_gg   
提取码：amnv

一.首先去oracle官网，下载oracle的驱动jar包。

进网址：[https://www.oracle.com/database/technologies/appdev/jdbc.html][https_www.oracle.com_database_technologies_appdev_jdbc.html]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70][]

2.下拉，找到JDBC Download,点击进入

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 1][]

3.点击置顶的最新版本

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 2][]

4.注意同意协议

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 3][]

5.下拉找到要下载的文件，点击下载![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 4][]

6.点击会进入登录界面，没有就注册一个即可

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 5][]

7.登录成功后，会自动弹出下载框

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 6][]

8.下载成功

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 7][]

9.eclipse中的应用  
1)右键项目根目录，找到Properties

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 8][]

2).按图示步骤执行

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 9][]

3).项目中查看是否导入成功

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 10][]

4).连接代码及截图

public Connection getConnection() \{  
        Connection conn = null;  
        try \{  
        Class.forName("oracle.jdbc.driver.OracleDriver"); //加载数据库驱动  
        System.out.println("数据库驱动加载成功！");    //输出的信息  
        String url = "jdbc:oracle:thin:@localhost:1521:xe";    //获取连接URL  
        String user = "scott"; //连接用户名  
        String password = "填密码"; //连接密码  
        conn = DriverManager.getConnection(url, user, password); //获取数据库连接  
        if (conn != null) \{  
        System.out.println("成功的与Oracle数据库建立连接！！");  
        \}  
        \} catch (Exception e) \{  
        e.printStackTrace();  
        \}   
        return conn; //返回Connection实例   
        \}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 11][]

5).连接Oracle就完成了

[https_www.oracle.com_database_technologies_appdev_jdbc.html]: https://www.oracle.com/database/technologies/appdev/jdbc.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70]: /images/20220405/e96d9a5a10354ee58cce165f4dee52cb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 1]: /images/20220405/bcab1706646e4c97a642635e8b5283f7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 2]: /images/20220405/52827b83cede416fa9682cf2c95b52d5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 3]: /images/20220405/192c049dadd04f618bb1e930f9ae51ce.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 4]: /images/20220405/bfffe03ed81b487d8f504b05d3c524f4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 5]: /images/20220405/54c58bd33c3b4b7d937b1dc816ec9674.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 6]: /images/20220405/567b3fc404344c00a5fc6363e94be2d1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 7]: /images/20220405/d8a6ec9ccc934631a75eccf354d76702.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 8]: /images/20220405/a43e29861a1246929f93f8d62b81bdb6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 9]: /images/20220405/8c791b7283c24b58a130b7593d6dea02.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 10]: /images/20220405/5d6a6b9f8a00447688cade2b9637747a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 11]: /images/20220405/a0193ec061814779bb282db5042742bd.png