| | |
|---|
| | | // 数据库名 |
|---|
| | | String dbName = "xlzx"; |
|---|
| | | // 数据库连接 |
|---|
| | | String url = "jdbc:mysql://rm-2vc47rysl5jt6gv312o.mysql.cn-chengdu.rds.aliyuncs.com:3306/" |
|---|
| | | String url = "jdbc:mysql://1.95.0.51:8306/" |
|---|
| | | + dbName |
|---|
| | | + "?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTT&nullCatalogMeansCurrent=true"; |
|---|
| | | // 用户名 |
|---|
| | | String userName = "root_dev"; |
|---|
| | | String userName = "root"; |
|---|
| | | // 密码 |
|---|
| | | String password = "00aabb00"; |
|---|
| | | String password = "Root2024!"; |
|---|
| | | |
|---|
| | | // 查询数据库表名、注释 |
|---|
| | | String tableSql = "SELECT TABLE_NAME AS tableName,TABLE_COMMENT AS tableComment FROM information_schema.`TABLES` WHERE TABLE_SCHEMA = '" + dbName + "'" + |
|---|
