jdbc连接数据库（idea）

﹏ヽ暗。殇╰゛Y 2024-05-23 14:11 68阅读 0赞

### jdbc连接数据库（idea） ###

1、按照自己的数据库的版本，下载对应的mysql的jar包，网址：https://mvnrepository.com/artifact/mysql/mysql-connector-java/5.1.47  
![在这里插入图片描述][6f2ac360469f44eaa1c288740317986d.png]  
2、在idea中导入MySQL的jar包  
![在这里插入图片描述][d2e0b4f4f5d14a17a2ed5576d0a71e38.png]3、代码演示

package testDB;
    
    import java.sql.*;
    
    public class DemoDB {
        
        private final static String drive = "com.mysql.jdbc.Driver";
        private final static String url = "jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8";
        private final static String user = "root";
        private final static String passwd = "root";
        private final static String sql = "select * from testWeb";
        public static void main(String[] args) {
        
            getConnection();
        }
    
        public static void getConnection(){
        
            Connection connection = null;
            try{
        
                Class.forName(drive);       //加载驱动
                connection = DriverManager.getConnection(url, user, passwd);    //连接数据库
                //增删改查
                Statement statement = connection.createStatement();
                ResultSet resultSet = statement.executeQuery(sql);
                while (resultSet.next()){
           //遍历每行数据
                    System.out.println(resultSet.getString("name")+","+resultSet.getString("address"));     //打印字段值
                }
            } catch (ClassNotFoundException | SQLException e) {
        
                e.printStackTrace();
            }
        }
    }

[6f2ac360469f44eaa1c288740317986d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/23/fb98febeada84a4db2d7ddcb92fc7e16.png
[d2e0b4f4f5d14a17a2ed5576d0a71e38.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/23/ac1dfc657c9a408c9f0adbb933d23da8.png