Java数据库连接和增删改查

工具类的实现

import java.sql.*;

public class JdbcUtil {
    public static Connection getConnection() throws SQLException, ClassNotFoundException {
        Class.forName("com.mysql.jdbc.Driver");
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/wzbc", "root" , "123456");
        return connection;
    }
    public static void closeAll(ResultSet resultSet, Statement statement, Connection connection) throws SQLException {
        if(resultSet!= null) {
            resultSet.close();
        }
        if(statement!= null) {
            statement.close();
        }
        if(connection!= null) {
            connection.close();
        }
    }
}

增加操作

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class Insert {
    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        Connection conn = JdbcUtil.getConnection();
        System.out.println("创建连接成功");
        String sql = "insert into tb_user(id,username,password) values('3','WangWu','123456')";
        PreparedStatement statement = conn.prepareStatement(sql);
        statement.executeUpdate();
        JdbcUtil.closeAll(null,statement,conn);
    }
}

删除操作

public class Delete {
    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        Connection conn = JdbcUtil.getConnection();
        System.out.println("创建连接成功");
        String sql = "delete from tb_user where id = 3";
        PreparedStatement statement = conn.prepareStatement(sql);
        statement.executeUpdate();
        JdbcUtil.closeAll(null,statement,conn);
    }
}

修改操作

public class Alter{
    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        Connection conn = JdbcUtil.getConnection();
        System.out.println("创建连接成功");
        String sql = "update tb_user set password = '123' where id = 3";
        PreparedStatement statement = conn.prepareStatement(sql);
        statement.executeUpdate();
        JdbcUtil.closeAll(null,statement,conn);
    }
}

查询操作

public class Query{
    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        Connection conn = JdbcUtil.getConnection();
        System.out.println("创建连接成功");
        String sql = "select * from tb_user";
        PreparedStatement statement = conn.prepareStatement(sql);
        statement.executeQuery();
        ResultSet resultSet = statement.executeQuery();
        while(resultSet.next()){
            System.out.println(resultSet.getInt(1));
            System.out.println(resultSet.getString(2));
            System.out.println(resultSet.getString(3));
        }

        JdbcUtil.closeAll(resultSet,statement,conn);

    }
}

连接数据库的七个步骤

1、JDBC所需的四个参数（user，password，url，driverClass）
2、加载JDBC驱动程序
•for.class中调用静态代码块自行加载
3、创建数据库的连接
•要连接数据库，需要向java.sql.DriverManager请求并获得Connection对象，该对象就代表一个数据库的连接
4、创建一个preparedStatement
•Statement接口提供了三种执行SQL语句的方法：executeQuery 、executeUpdate和execute*
5、执行SQL语句
6、遍历结果集
7、处理异常，关闭JDBC对象资源