JAVA-JDBC连接mysql数据库

DAY02-JAVA-JDBC连接mysql数据库

工具类

import java.sql.*;
public class DBUtil {
public static Connection getConnection() throws ClassNotFoundException, SQLException {
    //1. 加载驱动
    Class.forName("com.mysql.cj.jdbc.Driver");
    //2. 创建连接
    Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/WZBC?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8","root","12345678");
    return connection;
}
//7. 关闭连接
public static void colse(ResultSet resultSet, Statement statement,Connection connection) throws SQLException {
    if (resultSet == null){
        statement.close();
        connection.close();
    }else{
        resultSet.close();
        statement.close();
        connection.close();
    }
}

}

import DBUtil;
import org.junit.Test;
import java.sql.*;

查找

public class Find {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
    Connection connection = DBUtil.getConnection();
    //3. 写sql语句
    String sql = "select * from tb_user";
    //4. 获得statement对象
    PreparedStatement statement = connection.prepareStatement(sql);
    //5. 执行SQL语句，得到结果集
    ResultSet resultSet = statement.executeQuery();
    //6. 处理结果集
    while(resultSet.next()){
        System.out.println(resultSet.getInt(1));
        System.out.println(resultSet.getString(2));
        System.out.println(resultSet.getString(3));
    }
    //7. 关闭连接
    DBUtil.colse(resultSet,statement,connection);
}

删除

@Test
public void delete() throws SQLException, ClassNotFoundException {
    Connection connection = DBUtil.getConnection();
    String sql = "delete from tb_user where id = 1";
    PreparedStatement statement = connection.prepareStatement(sql);
    //5. 执行SQL语句，得到结果集
    statement.executeUpdate();
    //7. 关闭连接
    DBUtil.colse(null,statement,connection);
}

更新

@Test
public void update() throws SQLException, ClassNotFoundException {
    Connection connection = DBUtil.getConnection();
    String sql = "update tb_user set username = '张三',password = 12345678 where id = 2";
    PreparedStatement statement = connection.prepareStatement(sql);
    //5. 执行SQL语句，得到结果集
    statement.executeUpdate();
    //7. 关闭连接
    DBUtil.colse(null,statement,connection);
}

增加

@Test
public void add() throws SQLException, ClassNotFoundException {
    Connection connection = DBUtil.getConnection();
    String sql = "insert into tb_user(username,password) values('小美',12345678)";
    PreparedStatement statement = connection.prepareStatement(sql);
    //5. 执行SQL语句，得到结果集
    statement.executeUpdate();
    //7. 关闭连接
    DBUtil.colse(null,statement,connection);
}

}