CheckMenuEncoding.java 709 B

123456789101112
  1. import java.sql.*;
  2. public class CheckMenuEncoding {
  3. public static void main(String[] a) throws Exception {
  4. Class.forName("com.mysql.cj.jdbc.Driver");
  5. String url = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/fs_tenant_cs1?useSSL=false&characterEncoding=utf8&serverTimezone=GMT%2B8";
  6. try (Connection c = DriverManager.getConnection(url, "root", "Ylrz_1q2w3e4r5t6y");
  7. Statement st = c.createStatement();
  8. ResultSet rs = st.executeQuery("SELECT menu_id, menu_name, HEX(menu_name) hx FROM sys_menu WHERE menu_id IN (29925,29951,32481) ORDER BY menu_id")) {
  9. while (rs.next()) System.out.println(rs.getLong(1)+" | "+rs.getString(2)+" | "+rs.getString(3));
  10. }
  11. }
  12. }