mysql javaAPI

导入依赖项

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

连接数据库

static final String DB_URL = "jdbc:mysql://localhost:3306/source";
static final String USER = "root";
static final String PASS = "123456";

public static void main(String[] args) throws SQLException {
    Connection connection = DriverManager.getConnection(DB_URL, USER, PASS);
    connection.close();
	}
}

插入数据

package MySql;

import java.sql.*;

public class Test1 {
    static final String DB_URL = "jdbc:mysql://localhost:3306/source";
    static final String USER = "root";
    static final String PASS = "123456";

    public static void main(String[] args) throws SQLException {
        Connection connection = DriverManager.getConnection(DB_URL, USER, PASS);
        PreparedStatement ps = connection.prepareStatement("insert into t_student values(?,?,?,?);");
        ps.setString(1,"scofield");
        ps.setString(2,"45");
        ps.setString(3,"89");
        ps.setString(4,"100");
        ps.executeUpdate();
        ps.close();
        connection.close();
    }
}

查询数据

package MySql;

import java.sql.*;

public class Test2 {
    static final String DB_URL = "jdbc:mysql://localhost:3306/source";
    static final String USER = "root";
    static final String PASS = "123456";

    public static void main(String[] args) throws SQLException {
        Connection connection = DriverManager.getConnection(DB_URL, USER, PASS);
        Statement statement = connection.createStatement();
        ResultSet res = statement.executeQuery("select English from t_student where Name = 'scofield';");
        while(res.next()){
            System.out.println(res.getString("English"));
        }
        connection.close();
    }
}