Mysql - java程序访问mysql - 《Java》

package com.zhanglei.jdbc;
import org.junit.Test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
/**
 * ClassName:JdbcTest01
 * Package:com.zhanglei.jdbc
 * Description:
 *
 * @Date:2021/8/2 10:47
 * @Author:zhanglei@3417529439@qq.com
 */
public class JdbcTest01 {
    @Test
    public void test() throws ClassNotFoundException, SQLException {
        //1.forName有返回值不一定需要接收啊，加载了这个类后会注册到DriverManager里面去的，后面getConnection自己会去匹配的，用不着你去操心
        Class.forName("com.mysql.jdbc.Driver");
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/my1", "root", "56785");
        String sql="create table zhanglei_jdbc01 (id int, name varchar(32), price double ,introdution text)";
        Statement statement = connection.createStatement();
        statement.execute(sql);
        statement.close();
        connection.close();
        System.out.println("~~成功~~");
    }
}

需要导入mysql-connector-java依赖，用于驱动
注册完驱动之后java自带的DriverManager就会根据ip和端口生成数据库连接