通过java jdbc 链接MySQL数据库,生成数据字典下载到xlsx
单main方法执行
String dbName = "activationservice";
String URL = "jdbc:mysql://127.0.0.1:3306/" + dbName + "?characterEncoding=utf-8&serverTimezone=GMT%2B8";
String USER = "root";
String PASSWORD = "root";
//导出Excel的路径
String filePath = "E:/" + dbName + "-db-dict-export.xls";
WritableWorkbook wwb = null;
1