java连接mysql数据库

java连接mysql数据库

注意

编译器选择使用idea
大家注意mysql的版本，我的是8.0.26
所以我导入了mysql的依赖。

<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.26</version>
</dependency>

1. 准备sql语句

create database study;

create table people(
    name varchar(10),
    age int,
    phone varchar(100),
    email varchar(100)
);

向数据库中添加数据，如下。

---

首先准备实体类

public class People {

    private String name;
    private int age;
    private String phone;
    private String email;

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    // 输出people
    @Override
    public String toString() {
        return "People{" +
                "name='" + name + '\'' +
                ", age=" + age +
                ", phone='" + phone + '\'' +
                ", email='" + email + '\'' +
                '}';
    }
}

不使用工具类，简单实现连接数据库并查询

import aa.entity.People;

import java.sql.*;

public class main {
    public static void main(String[] args) {

        try {
            //1. 加载驱动
            Class.forName("com.mysql.cj.jdbc.Driver");//固定写法
            //2. 用户信息和url
            String url = "jdbc:mysql://127.0.0.1:3306/study?useUnicode=true&characterEncoding=utf8&&useSSL=false";
            String name = "**";
            String password = "**";
            //3. 连接成功，返回数据库对象  connection代表数据库
            Connection connection = DriverManager.getConnection(url, name, password);
            //4. 执行SQL的对象 statement 执行SQL的对象
            Statement statement = connection.createStatement();
            //5. 执行SQL的对象 去执行SQL   可能存在结果，查看返回结果
            String sql = "SELECT * FROM people";
            ResultSet resultSet = statement.executeQuery(sql);//返回的结果集,结果集中封装了我们全部查询的结果
            // 构造一个people的对象
            People people = new People();
            while (resultSet.next()) {
                people.setAge((Integer) resultSet.getObject("age"));
                people.setName((String) resultSet.getObject("name"));
                people.setPhone((String) resultSet.getObject("phone"));
                people.setEmail((String) resultSet.getObject("email"));
            }
            System.out.println(people.toString());
            //6. 释放连接
            resultSet.close();
            statement.close();
            connection.close();
        } catch (ClassNotFoundException | SQLException e) {
            throw new RuntimeException(e);
        }
    }
}

查询结果，如下。