ylrz_saas_pharmacy/java/scripts/RenameWorkflowMenu32481.java

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

public class RenameWorkflowMenu32481 {
    private static final String HOST = "cq-cdb-8fjmemkb.sql.tencentcdb.com:27220";
    private static final String USER = "root";
    private static final String PASS = "Ylrz_1q2w3e4r5t6y";
    private static final String NAME = "\u5de5\u4f5c\u6d41\u6a21\u7248";

    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        updateTable("fs_tenant_cs1", "sys_menu");
        updateTable("fs_tenant_cs1", "company_menu");
        updateTable("ylrz_saas", "tenant_sys_menu");
        updateTable("ylrz_saas", "sys_menu");
        System.out.println("Renamed menu 32481 to " + NAME);
    }

    private static void updateTable(String db, String table) throws Exception {
        String url = "jdbc:mysql://" + HOST + "/" + db + "?useSSL=false&characterEncoding=utf8&serverTimezone=GMT%2B8";
        try (Connection c = DriverManager.getConnection(url, USER, PASS)) {
            if (!tableExists(c, table)) {
                System.out.println("skip " + db + "." + table + " (missing)");
                return;
            }
            try (PreparedStatement ps = c.prepareStatement(
                    "UPDATE " + table + " SET menu_name=? WHERE menu_id=32481")) {
                ps.setString(1, NAME);
                int n = ps.executeUpdate();
                System.out.println(db + "." + table + " updated rows=" + n);
            }
            try (Statement st = c.createStatement();
                 ResultSet rs = st.executeQuery(
                         "SELECT menu_name FROM " + table + " WHERE menu_id=32481")) {
                if (rs.next()) {
                    System.out.println("  -> " + rs.getString(1));
                }
            }
        }
    }

    private static boolean tableExists(Connection c, String table) throws Exception {
        try (ResultSet rs = c.getMetaData().getTables(c.getCatalog(), null, table, null)) {
            return rs.next();
        }
    }
}