ylrz_saas_pharmacy/java/scripts/FixLobsterMenuNames.java

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

public class FixLobsterMenuNames {
    private static final String URL =
            "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/fs_tenant_cs1"
                    + "?useSSL=false&characterEncoding=utf8&serverTimezone=GMT%2B8";

    private static final Object[][] MENUS = {
            {29900, "\u9f99\u867e\u5f15\u64ce"},
            {32481, "\u5de5\u4f5c\u6d41\u6a21\u7248"},
            {29949, "\u5de5\u4f5c\u6d41\u6267\u884c"},
            {29905, "\u5b9e\u4f8b\u76d1\u63a7"},
            {29950, "\u5ba2\u6237\u753b\u50cf"},
            {29934, "\u5bf9\u5916\u89d2\u8272\u914d\u7f6e"},
            {29906, "\u8bdd\u672f\u4f18\u5316\u5ba1\u6838"},
            {3008, "\u52a8\u6001\u8282\u70b9\u5ba1\u6279"},
            {29912, "\u805a\u5408\u804a\u5929"},
            {29926, "\u8282\u70b9\u8be6\u60c5"},
    };

    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        try (Connection c = DriverManager.getConnection(URL, "root", "Ylrz_1q2w3e4r5t6y")) {
            try (PreparedStatement ps1 = c.prepareStatement("UPDATE sys_menu SET menu_name=? WHERE menu_id=?");
                 PreparedStatement ps2 = c.prepareStatement("UPDATE company_menu SET menu_name=? WHERE menu_id=?")) {
                for (Object[] row : MENUS) {
                    ps1.setString(1, (String) row[1]);
                    ps1.setInt(2, (Integer) row[0]);
                    ps1.addBatch();
                    ps2.setString(1, (String) row[1]);
                    ps2.setInt(2, (Integer) row[0]);
                    ps2.addBatch();
                }
                ps1.executeBatch();
                ps2.executeBatch();
            }
            System.out.println("Fixed " + MENUS.length + " menu names");
        }
    }
}