java开发_mysql中获取数据库表描述_源码下载

发布时间：2020-12-14 06:30:14 所属栏目：Java 来源：网络整理

导读：在mysql数据库中，有两张表： , test_table 我们需要获取表：表的描述信息，然后把描述信息插入到表： data_element_config 中记录结果数据库表：情况 data_element_config 表情况： `de_name` ( ) `de_group` ( ) `memo` ( ) `data_type` ( ) `value_che

在mysql数据库中，有两张表：

,test_table

我们需要获取表：表的描述信息，然后把描述信息插入到表：data_element_config中记录结果

数据库表：情况

data_element_config表情况：

`de_name` () `de_group` () `memo` () `data_type` () `value_check` () `yx_bj` () ) ENGINEInnoDB CHARSETutf8;

表情况：

() AUTO_INCREMENT COMMENT () COLLATE utf8_bin COMMENT () COLLATE utf8_bin COMMENT () COMMENT () COMMENT () COMMENT () COLLATE utf8_bin COMMENT () b COMMENT InnoDB CHARSETutf8 COLLATEutf8_bin COMMENT;

DataBaseBO serialVersionUID = 171777003280248377L String SELECT_SQL_FIELD = " column_name as field," String SELECT_SQL_TYPE = " data_type as type," String SELECT_SQL_MEMO = " column_comment as memo," String SELECT_SQL_MUNERIC_LENGTH = " numeric_precision as munericLength," String SELECT_SQL_NUMERIC_SCALE = " numeric_scale as numericScale," String SELECT_SQL_ISNULLABLE = " is_nullable as isNullable," String SELECT_SQL_EXTRA = " CASE WHEN extra = 'auto_increment' THEN 1 ELSE 0 END as extra," String SELECT_SQL_ISDEFAULT = " column_default as isDefault," String SELECT_SQL_CHARACTER_LENGTH = " character_maximum_length AS characterLength " String selectSQL = "SELECT " + SELECT_SQL_FIELD + SELECT_SQL_TYPE + SELECT_SQL_MEMO + SELECT_SQL_MUNERIC_LENGTH + SELECT_SQL_NUMERIC_SCALE + SELECT_SQL_ISNULLABLE + SELECT_SQL_EXTRA + SELECT_SQL_ISDEFAULT + SELECT_SQL_CHARACTER_LENGTH + " FROM Information_schema.columns WHERE table_Name = " List .driver = .dbName = .passwrod = .userName = .url = .sql = .port = .ip = .dbType = List setTables(List .tables =

DataElementConfigBO serialVersionUID = -5951470192914621265L name,那么在生成DE的过程中系统不知道
name字段，，如果一个字段是TEST
DEMO的，那么在生成DE的时候，就很容易区分了
DE_TEST_NAME和DE_DEMO_NAME
true,不用去修改 1,表示有效的
0,则在生成DE的时候，该类会被标记为：@Deprecated data_element_config的sql语句 String insertIntoSQL = "INSERT INTO DATA_ELEMENT_CONFIG(DE_NAME,DE_GROUP,MEMO,DATA_TYPE,VALUE_CHECK,YX_BJ) VALUES (" .deName = .deGroup = .memo = setDataType( .dataType = .valueCheck = .yxBj = .insertIntoSQL = }

DataBaseBO dataBaseBO = dataBaseBO.setDbName("sworddemo" dataBaseBO.setDriver("com.mysql.jdbc.Driver" dataBaseBO.setUserName("root" dataBaseBO.setPasswrod("gzcss" dataBaseBO.setTableName("'test_table'" dataBaseBO.setSql(dataBaseBO.getSelectSQL() + DataElementConfigTool tool = List list = System.out.println(" Field Type Null Key Default Extra memo" (list != DataElementConfigBO decBo = tool.getDataElementConfigBO(bo,"gnzy" result = System.out.println("插入数据：" + (result == 1 ? "成功" : "失败" dataBaseBO.setIp(dataBaseBO.getIp() == ? "localhost" dataBaseBO.setPort(dataBaseBO.getPort() == ? "3306" dataBaseBO.setUrl("jdbc:mysql://" + dataBaseBO.getIp() + ":" + dataBaseBO.getPort() + "/" + List List list = ArrayList TableDescBO tableDescBO = Connection conn = PreparedStatement ps = ResultSet rs = tableDescBO = tableDescBO.setField(rs.getString(1 tableDescBO.setType(rs.getString(2 tableDescBO.setMemo(rs.getString(3 tableDescBO.setMunericLength(rs.getString(4 tableDescBO.setNumericScale(rs.getString(5 tableDescBO.setIsNullable(rs.getString(6 tableDescBO.setExtra(rs.getString(7 tableDescBO.setIsDefault(rs.getString(8 tableDescBO.setCharacterLength(rs.getString(9 } data_element_config中插入数据 -1,表示插入数据失败，否则成功 result = -1 (decBo != String sql = decBo.getInsertIntoSQL() + decBo.getDeName() + "," + decBo.getDeGroup() + "," + decBo.getMemo() + "," + decBo.getDataType() + "," + decBo.getValueCheck() + "," + decBo.getYxBj() + ")" Connection conn = PreparedStatement ps = result = close( } (oldType != && !oldType.equals("" oldType.substring(0,oldType.indexOf("(" data_element_config中对应的 de_group字段 DataElementConfigBO bo = (tableDescBO != bo = bo.setDeName("'" + tableDescBO.getField() + "'" bo.setDeGroup("'" + group + "'" bo.setValueCheck("'true'" bo.setYxBj("'1'" bo.setMemo("'" + tableDescBO.getMemo() + "'" bo.setDataType(1

TableDescBO serialVersionUID = 6450523501528806316L " " + field + " " + type + " " + isNullable + " " + key + " " + isDefault + " " + extra + " "+ .field = .type = .isNullable = .key = .isDefault = .extra = .numericScale = .munericLength = .characterLength = .memo = }

：

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!