java连接mysql查询数据(基础版，无框架)

依赖引入：

 <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.32</version> <!-- 根据实际情况调整版本 -->
        </dependency>

代码编写：

public class JdbcUtil {
   
    public static void main(String[] args) throws SQLException, ClassNotFoundException {
   
//        1.加载驱动
        Class.forName("com.mysql.cj.jdbc.Driver");
//        2.用户信息和url
        String url = "jdbc:mysql://localhost:3306/cms_base?useUnicode=true&characterEncoding=utf8&useSSL=true";
        String username="username";
        String password="passowrd";
//        3.连接成功，数据库对象 Connection
        Connection connection = DriverManager.getConnection(url,username,password);
//        4.执行SQL对象Statement，执行SQL的对象
        Statement statement = connection.createStatement();
//        5.执行SQL的对象去执行SQL，返回结果集
        String sql = "SELECT *FROM biz_book limit 10;";
        ResultSet resultSet = statement.executeQuery(sql);
        while(resultSet.next()){
   
            System.out.println("="+resultSet.getString("book_url"));
            System.out.println("="+resultSet.getString("book_name"));
        }
//        6.释放连接
        resultSet.close();
        statement.close();
        connection.close();
    }
}