通过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