创建java项目，链接MySql数据库

墨蓝 2022-12-17 02:25 144阅读 0赞

## 创建项目 ##

打开IDEA开发工具，“New Project”  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 2]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 3]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 4]  
复制mysql-connector-java驱动(链接MySql驱动)到“libs”目录下  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 5]  
添加驱动  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 6]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 7]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 8]  
若是项目还没有jdk，需添加jdk  
![!\[若是项目还没有jdk，需添加jdk\](https://img-blog.csdnimg.cn/20201021152844697.png?x-oss-process=image/watermark,type\_ZmFuZ3poZW5naGVpdGk,shadow\_10,text\_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw==,size\_16,color\_FFFFFF,t\_70\#pic\_center][jdk_jdk_https_img-blog.csdnimg.cn_20201021152844697.png_x-oss-process_image_watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 9]

package com.dgd.test;
    
    import java.sql.*;
    
    /** * @author lam * @create 2020-10-21-15:25 * 测试数据库 */
    public class DBTest { 
        //mysql驱动包名
        private static final String DRIVER_NAME = "com.mysql.jdbc.Driver";
        //数据库连接地址
        // ?useSSL=false不校验ssl证书
        private static final String URL = "jdbc:mysql://localhost:3306/test?useSSL=false";
        //用户名,root更换成你自己的mysql用户名
        private static final String USER_NAME = "root";
        //密码，123456更换成你自己设定的密码，
        private static final String PASSWORD = "123456";
        public static void main(String[] args){ 
            Connection connection = null;
            try { 
                //加载mysql的驱动类
                Class.forName(DRIVER_NAME);
                //获取数据库连接
                connection = DriverManager.getConnection(URL, USER_NAME, PASSWORD);
                //mysql查询语句
                String sql = "SELECT name FROM test.info";
                PreparedStatement prst = connection.prepareStatement(sql);
                //结果集
                ResultSet rs = prst.executeQuery();
                while (rs.next()) { 
                    System.out.println("用户名:" + rs.getString("name"));
                }
                rs.close();
                prst.close();
            } catch (Exception e) { 
                e.printStackTrace();
            }finally { 
                if (connection != null) { 
                    try { 
                        connection.close();
                    } catch (SQLException e) { 
                        e.printStackTrace();
                    }
                }
            }
        }
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/87eabc22fd8c452881d18cca0395b395.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221123/c1fe6162fd42426c9ec2ba162b3a3ab5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20221123/9f434c1c539749c0affdcd9584a8c063.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 3]: /images/20221123/1bc8f00f30ec4e5aa38e07cb696b552e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 4]: /images/20221123/30b3f5237267480186c844cbe5337c13.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 5]: /images/20221123/3b8cd1d8f8e84bab9103b576ba0245e0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 6]: /images/20221123/f651528d292a4d3a886015780b1c1115.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 7]: /images/20221123/7f5f1ee1480f4526b8a71d8de1c30074.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 8]: /images/20221123/288d27abbfc048fe989ce1a7fdc14e13.png
[jdk_jdk_https_img-blog.csdnimg.cn_20201021152844697.png_x-oss-process_image_watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/99bcc60341d64a6a9a6015021d1c3505.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xhbURlbmdHRw_size_16_color_FFFFFF_t_70_pic_center 9]: /images/20221123/2503e38f8727409383cf3cb913042f13.png