eclipse连接MySql数据库(菜鸟入门之详细步骤)

曾经终败给现在 2022-04-05 15:17 181阅读 0赞

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

链接：https://pan.baidu.com/s/16khnhQhnA9W3wxfxDUir0Q   
提取码：n4u4

1.首先，eclipse连接Mysql数据库，需要下载Mysql的驱动(.jar包)

2.下载Mysql驱动去Mysql官网：[https://www.mysql.com/][https_www.mysql.com]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70][]

3.进入downloads页面：[https://www.mysql.com/downloads/][https_www.mysql.com_downloads]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 1][]

4.Downloads页面向下划(由于页面的更新，每次你进入的页面排版有可能不同),找到MySQL Connectors,点击LearnMore

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 2][]

5.点击LearnMore进入后，下拉页面，左边框找到Connectors,点击进入

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 3][]

6.找到java的jdbc驱动，点击DownLoad

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 4][]

7.注意，要选择你对应的操作系统（不然进入的是MySql安装页面）：如图

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 5][]

8.选择要下载的包，点击DownLoad

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 6][]

9.终于到直接下载页面：点这里下载

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 7][]

10.开始下载

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 8][]

11.在本地电脑找到驱动jar包即可

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 9][]

12.eclipse中的使用步骤

1）找到项目根部，右键，选择Properties

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 10][]

2).按图示步骤应用刚下载的jar包

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 11][]

3).在项目中查看

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 12][]

4).连接代码及截图

public Connection connectToMySql() \{  
        try \{  
            String driver = "com.mysql.cj.jdbc.Driver";//根据报错信息修改  
            String url="jdbc:mysql://localhost:3307/bighome?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false";//链接的mysql  
            Class.forName(driver).newInstance();//处理异常  
            Connection connection = DriverManager.getConnection(url,"root","填密码");//处理异常  
            System.out.println(connection.toString());//测试是否连接成功  
            return connection;  
        \} catch (Exception e) \{  
            e.printStackTrace();  
            System.out.println("error:数据库连接出错");  
        \}  
        return null;//catch之后执行  
    \}![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 13][]

5).ok,关于eclipse连接Mysql就结束啦。

[https_www.mysql.com]: https://www.mysql.com/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70]: /images/20220405/ea562325f4a44f01a592c2d8dcf3447e.png
[https_www.mysql.com_downloads]: https://www.mysql.com/downloads/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 1]: /images/20220405/4152db5bd58e4bc984236bc84607a32c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 2]: /images/20220405/2128f28d99c449b4b43cad3c696a76ae.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 3]: /images/20220405/843cb26b446c42a196c9033d027048af.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 4]: /images/20220405/1b9fca901430481e933d1ef547f47b49.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 5]: /images/20220405/02776a5f71fb4a27832886223c3ad323.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 6]: /images/20220405/af875de71580438ab62b7ded6a9a7698.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 7]: /images/20220405/3f7adef54e1e4836af79baeb09a1eb66.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 8]: /images/20220405/e3c583cffb134191a20bdfff05d0dbf7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 9]: /images/20220405/9ff0b0749a2940218ae09149d86ed45e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 10]: /images/20220405/222dc4de31ec4b65aee1a4cd7ad33d40.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 11]: /images/20220405/3aa3af3df1144b77a15afe828728d0bc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 12]: /images/20220405/3e1676ff1a2c4b74905544662733de7f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMDEzNjg1_size_16_color_FFFFFF_t_70 13]: /images/20220405/30a4c9772c6e4601b780068cd5d3a543.png