简洁好用的数据库表结构文档生成器

/* * screw-core - 简洁好用的数据库表结构文档生成工具 * Copyright © 2020 SanLi (qinggang.zuo@gmail.com) * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Lesser General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ package cn.smallbun.screw.core.query.dm; import static cn.smallbun.screw.core.constant.DefaultConstants.PERCENT_SIGN; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import java.util.concurrent.ConcurrentHashMap; import java.util.concurrent.ConcurrentMap; import java.util.stream.Collectors; import javax.sql.DataSource; import cn.smallbun.screw.core.exception.QueryException; import cn.smallbun.screw.core.mapping.Mapping; import cn.smallbun.screw.core.metadata.Column; import cn.smallbun.screw.core.metadata.Database; import cn.smallbun.screw.core.metadata.PrimaryKey; import cn.smallbun.screw.core.query.AbstractDatabaseQuery; import cn.smallbun.screw.core.query.dm.model.DmColumnModel; import cn.smallbun.screw.core.query.dm.model.DmDatabaseModel; import cn.smallbun.screw.core.query.dm.model.DmPrimaryKeyModel; import cn.smallbun.screw.core.query.dm.model.DmTableModel; import cn.smallbun.screw.core.util.Assert; import cn.smallbun.screw.core.util.CollectionUtils; import cn.smallbun.screw.core.util.ExceptionUtils; import cn.smallbun.screw.core.util.JdbcUtils; /** * 达梦数据库查询 * * @author SanLi * Created by jincy@neusoft.com + qinggang.zuo@gmail.com / 2689170096@qq.com on 2020/9/17 17:40 */ @SuppressWarnings("serial") public class DmDataBaseQuery extends AbstractDatabaseQuery { private final ConcurrentMap<String, List<DmTableModel>> tablesMap = new ConcurrentHashMap<>(); private static final String DM_QUERY_TABLE_SQL = "" + "select " + " ut.table_name TABLE_NAME, " + " utc.comments COMMENTS " + "from " + " user_tables ut " + "left join USER_TAB_COMMENTS utc " + "on " + " ut.table_name=utc.table_name "; private static final String DM_QUERY_COLUMNS_SQL = "" + "select " + " ut.table_name TABLE_NAME , " + " uc.column_name COLUMN_NAME , " //+ " case uc.data_type when 'INT' then uc.data_type when 'CLOB' then uc.data_type when 'BLOB' then uc.data_type when 'INTEGER' then uc.data_type else concat(concat(concat(uc.data_type, '('), uc.data_length), ')') end case AS COLUMN_TYPE , " + " case uc.data_type when 'CLOB' then uc.data_type when 'BLOB' then uc.data_type else concat(concat(concat(uc.data_type, '('), uc.data_length), ')') end case AS COLUMN_TYPE , " + " uc.data_length COLUMN_LENGTH , " + " uc.DATA_PRECISION DATA_PRECISION, " + " uc.DATA_SCALE DECIMAL_DIGITS, " + " case uc.NULLABLE when 'Y' then '1' else '0' end case NULLABLE," + " uc.DATA_DEFAULT COLUMN_DEF, " + " ucc.comments REMARKS " + "from " + " user_tables ut " + "left join USER_TAB_COMMENTS utc " + "on " + " ut.table_name=utc.table_name " + "left join user_tab_columns uc " + "on " + " ut.table_name=uc.table_name " + "left join user_col_comments ucc " + "on " + " uc.table_name =ucc.table_name " + " and uc.column_name=ucc.column_name " + "where 1=1 "; private static final String DM_QUERY_PK_SQL = "" + "SELECT " + "C.OWNER AS TABLE_SCHEM, " + "C.TABLE_NAME , " + "C.COLUMN_NAME , " + "C.POSITION AS KEY_SEQ , " + "C.CONSTRAINT_NAME AS PK_NAME " + "FROM " + " ALL_CONS_COLUMNS C, " + " ALL_CONSTRAINTS K "