JDBC连接数据库（Mysql）

package com.jdbc.hello;

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

import org.junit.Test;

import com.jdbc.utils.JdbcUtils;

public class hello {
    @Test
    public void test() throws Exception {
        System.out.println("hello");

        // 注册驱动
        Class.forName("com.mysql.jdbc.Driver");

        // 获取连接
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=true", "root", "152500");

        // 编写sql
        String sql = "select * from category";

        // 创建语句执行者
        PreparedStatement st = conn.prepareStatement(sql);

        // 设置参数，此处无参数

        // 执行sql
        ResultSet rs = st.executeQuery();

        // 处理结果
        while (rs.next()) {
            System.out.println(rs.getString("cid") + "::" + rs.getString("cname"));
        }

        // 释放资源
        rs.close();
        st.cancel();
        conn.close();

    }

}