ylrz_saas_pharmacy/java/scripts/VerifyDbUtf8.java

import java.io.PrintStream;
import java.nio.charset.StandardCharsets;
import java.nio.file.Files;
import java.nio.file.Path;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class VerifyDbUtf8 {
    public static void main(String[] a) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        Path out = Path.of("verify-db-utf8.txt");
        try (PrintStream ps = new PrintStream(Files.newOutputStream(out), true, StandardCharsets.UTF_8)) {
            try (Connection c = DriverManager.getConnection(
                    "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/fs_tenant_cs1"
                            + "?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8",
                    "root", "Ylrz_1q2w3e4r5t6y")) {
                try (Statement st = c.createStatement()) {
                    ResultSet rs = st.executeQuery(
                            "SELECT menu_id, menu_name FROM sys_menu WHERE menu_id IN (29949,29950,32481) ORDER BY menu_id");
                    ps.println("=== menus ===");
                    while (rs.next()) {
                        ps.println(rs.getLong(1) + " | " + rs.getString(2));
                    }
                    rs = st.executeQuery(
                            "SELECT scenario, customer_question, sales_answer FROM lobster_sales_corpus "
                                    + "WHERE source_type='industry_seed' LIMIT 3");
                    ps.println("=== industry seeds sample ===");
                    while (rs.next()) {
                        ps.println(rs.getString(1) + " | Q:" + rs.getString(2) + " | A:" + rs.getString(3));
                    }
                    rs = st.executeQuery(
                            "SELECT COUNT(*) FROM lobster_sales_corpus WHERE source_type='industry_seed'");
                    rs.next();
                    ps.println("industry_seed_total=" + rs.getInt(1));
                }
            }
        }
        System.out.println("written " + out.toAbsolutePath());
    }
}