JDBC 程序编写步骤
-
注册驱动 - 加载Driver类
-
获取连接 - 得到Connection
-
执行增删改查 - 发送SQL给mysql执行
-
释放资源 - 关闭相关连接
package com.jdbc;
import com.mysql.cj.jdbc.Driver;
import org.junit.jupiter.api.Test;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class Jdbc02 {
@Test//方式1
public void connect01() throws SQLException {
Driver driver = new Driver();
String url = "jdbc:mysql://localhost:3306/bd01";
Properties properties = new Properties();
properties.setProperty("user", "root");
properties.setProperty("password", "123456");
Connection connect = driver.connect(url, properties);
System.out.println("第一种方法:" + connect);