jdbc连接docker安装的mysql的步骤

2023-05-06 08:22| 来源: 网络整理| 查看: 265

jdbc连接docker安装的mysql的步骤原创

太阳上的雨天 2023-05-05 17:31:51 ©著作权

文章标签 mysql docker intellij-idea System bc 文章分类 JavaScript 前端开发

©著作权归作者所有：来自51CTO博客作者太阳上的雨天的原创作品，请联系作者获取转载授权，否则将追究法律责任

1. 安装mysql服务2. 安装jdk1.83. 安装idea4. 下载jar包 mysql-connector-java-8.0.28.jar

[下载地址]

创建数据库、数据表CREATE DATABASE `jdbc` CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `users` ( `id` int(11) NOT NULL, `NAME` varchar(40) DEFAULT NULL, `PASSWORD` varchar(40) DEFAULT NULL, `email` varchar(60) DEFAULT NULL, `birthday` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;创建Project->Maven->jdbc(name)

jdbc连接docker安装的mysql的步骤_mysql

下载jar包. mac选择Platform Independent

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-wxE7Kv7U-1647268317075)(http://images.caixiaoxin.cn/jdbc1-1024x667.jpeg)]

导入jar包下载目录解压mysql-connector-java-8.0.28.zip，复制mysql-connector-java-8.0.28.jar打开idea，新建lib目录,将复制的jar包，粘贴到lib目录下

3954d1ebec75fd55a85.png)

右键点击mysql-connector-java-8.0.28.jar，选择 Add as Library连接数据库,创建Demo.java

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-hgLB5RVC-1647268317076)(http://blog.caixiaoxin.cn/jdbc4.jpeg)]

import java.sql.*; public class Demo { static final String JDBC_DRIVER = "com.mysql.jdbc.Driver"; static final String DB_URL = "jdbc:mysql://127.0.0.1:3306/jdbc?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC"; static final String USER = "root"; static final String PASS = "root"; public static void main(String[] args) { Connection connection = null; Statement statement = null; try { Class.forName(JDBC_DRIVER); System.out.println("连接数据库..."); connection = DriverManager.getConnection(DB_URL, USER, PASS); System.out.println("实例化Statement对象"); statement = connection.createStatement(); String sql; sql = "select * from users"; ResultSet rs = statement.executeQuery(sql); while (rs.next()) { int id = rs.getInt("id"); String name = rs.getString("name"); String password = rs.getString("password"); String email = rs.getString("email"); String bidthday = rs.getString("birthday"); System.out.println("ID: " + id); System.out.println(", 名字: " + name); System.out.println(", 密码: " + password); System.out.println(", 邮箱: " + email); System.out.println(", 生日: " + bidthday); } rs.close(); statement.close(); connection.close(); } catch (SQLException e ){ e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } finally { try { if (statement != null) statement.close(); } catch (SQLException e2) { } try { if (connection != null) connection.close(); } catch (SQLException e) { e.printStackTrace(); } } System.out.println("Goodbye"); } }

点击运行，结果如下

jdbc连接docker安装的mysql的步骤_bc_02

赞收藏评论分享举报

上一篇：前任程序员留下的坑！！！！

下一篇：Lumen5.6配置redis

【本文地址】

公司简介

联系我们