| 123456789101112 |
- import java.sql.*;
- public class CheckMenuEncoding {
- public static void main(String[] a) throws Exception {
- Class.forName("com.mysql.cj.jdbc.Driver");
- String url = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/fs_tenant_cs1?useSSL=false&characterEncoding=utf8&serverTimezone=GMT%2B8";
- try (Connection c = DriverManager.getConnection(url, "root", "Ylrz_1q2w3e4r5t6y");
- Statement st = c.createStatement();
- 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")) {
- while (rs.next()) System.out.println(rs.getLong(1)+" | "+rs.getString(2)+" | "+rs.getString(3));
- }
- }
- }
|