main连接mysql

package com.zhuanzhuan.hunter_offer_web;

import cn.hutool.core.convert.Convert;
import cn.hutool.core.util.StrUtil;
import cn.hutool.json.JSONObject;
import cn.hutool.json.JSONUtil;

import java.sql.*;
import java.util.Arrays;

import static com.zhuanzhuan.hunter_offer_web.enums.VivoOrderStatusEnum.*;

public class Test {
    public static void main(String[] args) {
//        System.out.println(
//            JSONUtil.toJsonStr(getVivoOrderStatusDescList())
//        );
//
//        System.out.println(
//            JSONUtil.toJsonStr(getVivoOrderStatusCodesByDescArr(Arrays.asList("退全款中", "已取消")))
//        );

//        System.out.println(
//            JSONUtil.toJsonStr("a,b,c".split(","))
//        );
//        System.out.println(
//            getDescByCode(10)
//        );

//        System.out.println(Convert.toStr(null,""));

//        System.out.println(StrUtil.format("{}爱吃{}", "xys", "鸡腿"));

        String url = "jdbc:mysql://43.143.213.90:3306/zz_lenovo?allowMultiQueries=true&useSSL=false&useUnicode=true&characterEncoding=utf-8&useAffectedRows=true&serverTimezone=Asia/Shanghai";
        String username = "";
        String password = "";

        try (Connection connection = DriverManager.getConnection(url, username, password)) {
            System.out.println("Connected to the database!");

            // 示例：查询表中的数据
            String sql = "SELECT * FROM user_info";
            PreparedStatement statement = connection.prepareStatement(sql);
            ResultSet resultSet = statement.executeQuery();

            // 获取列的数量
            ResultSetMetaData rsmd = resultSet.getMetaData();
            int columnCount = rsmd.getColumnCount();

            // 打印列名
            for (int i = 1; i <= columnCount; i++) {
                System.out.print(rsmd.getColumnName(i) + "\t");
            }
            System.out.println();

            // 遍历每一行记录
            while (resultSet.next()) {
                for (int i = 1; i <= columnCount; i++) {
                    // 获取每一列的值
                    Object value = resultSet.getObject(i);
                    System.out.print(value + "\t");
                }
                System.out.println();
            }


        } catch (SQLException e) {
            System.err.println("Error connecting to the database: " + e.getMessage());
        }
    }
}