atitit。获取表格的字段注释metadata的原理以及AND 字段表格描述文档方案
atitit。获取表格的字段注释metadata的原理以及AND 字段表格描述文档方案
1. 通过sql ide navicate获取（推荐）通过meatadata数据库获取 1
2.1. ResultSet的字段列表 fields（23个） 2
3. 通过phpmyadmin>>表结构，复制表头，word里面行专列 6
1. 通过sql ide navicate获取（推荐）通过meatadata数据库获取
mysql 数据字段文档
获取表单描述：
SELECT TABLE_NAME, TABLE_COMMENT FROM information_schema.tables
获取表行的备注：
select column_name,COLUMN_COMMENT from information_schema.`COLUMNS` where TABLE_NAME='mall_shop_info'
shop_intro店铺介绍
shop_notice店铺公告
shop_creat_time店铺创建时间
goods_num店铺产品数量
open_flg店铺关闭，1为关闭
lock_flg店铺锁定，1为锁定
map_x地图经线坐标
作者:: 老哇的爪子 Attilax 艾龙， EMAIL:1466519819@qq.com
转载请注明来源： http://blog.csdn.net/attilax
2. 通过代码获取
private static void t1() throws SQLException {
//t4();
Connection con=IocX.getBean(Connection.class);
DatabaseMetaData dbmd = con.getMetaData();
String tableName="mall_order_info";
ResultSet rs = dbmd.getColumns(con.getCatalog(), "%", tableName, null);
while(rs.next()) {
String columnName = rs.getString("COLUMN_NAME");
String columnType = rs.getString("TYPE_NAME");
int datasize = rs.getInt("COLUMN_SIZE");
int digits = rs.getInt("DECIMAL_DIGITS");
int nullable = rs.getInt("NULLABLE");
String COLUMN_COMMENT = rs.getString("REMARKS");
2.1. ResultSet的字段列表 fields（23个）
Line 5: column name: TABLE_CAT
Line 13: column name: TABLE_SCHEM
Line 19: column name: TABLE_NAME
Line 25: column name: COLUMN_NAME
Line 31: column name: DATA_TYPE
Line 37: column name: TYPE_NAME
Line 43: column name: COLUMN_SIZE
Line 49: column name: BUFFER_LENGTH
Line 55: column name: DECIMAL_DIGITS
Line 61: column name: NUM_PREC_RADIX
Line 67: column name: NULLABLE
Line 73: column name: REMARKS
Line 79: column name: COLUMN_DEF
Line 85: column name: SQL_DATA_TYPE
Line 91: column name: SQL_DATETIME_SUB
Line 97: column name: CHAR_OCTET_LENGTH
Line 103: column name: ORDINAL_POSITION
Line 109: column name: IS_NULLABLE
Line 115: column name: SCOPE_CATALOG
Line 121: column name: SCOPE_SCHEMA
Line 127: column name: SCOPE_TABLE
Line 133: column name: SOURCE_DATA_TYPE
Line 139: column name: IS_AUTOINCREMENT
[com.mysql.jdbc.Field@171be16
catalog: null
table name:
original table name: null
column name: TABLE_CAT
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@76c95b
catalog: null
table name:
original table name: null
column name: TABLE_SCHEM
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@9d966d
catalog: null
table name:
original table name: null
column name: TABLE_NAME
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@1feea1e
catalog: null
table name:
original table name: null
column name: COLUMN_NAME
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@bc6a08
catalog: null
table name:
original table name: null
column name: DATA_TYPE
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@1d54e44
catalog: null
table name:
original table name: null
column name: TYPE_NAME
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@1057212
catalog: null
table name:
original table name: null
column name: COLUMN_SIZE
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@843ce4
catalog: null
table name:
original table name: null
column name: BUFFER_LENGTH
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@1b9bccc
catalog: null
table name:
original table name: null
column name: DECIMAL_DIGITS
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@11a241f
catalog: null
table name:
original table name: null
column name: NUM_PREC_RADIX
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@139b06a
catalog: null
table name:
original table name: null
column name: NULLABLE
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@6d05ee
catalog: null
table name:
original table name: null
column name: REMARKS
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@1a07061
catalog: null
table name:
original table name: null
column name: COLUMN_DEF
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@32007f
catalog: null
table name:
original table name: null
column name: SQL_DATA_TYPE
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@bec229
catalog: null
table name:
original table name: null
column name: SQL_DATETIME_SUB
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@1bd2497
catalog: null
table name:
original table name: null
column name: CHAR_OCTET_LENGTH
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@ad6ab6
catalog: null
table name:
original table name: null
column name: ORDINAL_POSITION
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@138ecb8
catalog: null
table name:
original table name: null
column name: IS_NULLABLE
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@3d2ff1
catalog: null
table name:
original table name: null
column name: SCOPE_CATALOG
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@11684ac
catalog: null
table name:
original table name: null
column name: SCOPE_SCHEMA
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@1604c40
catalog: null
table name:
original table name: null
column name: SCOPE_TABLE
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@12e1a27
catalog: null
table name:
original table name: null
column name: SOURCE_DATA_TYPE
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1), com.mysql.jdbc.Field@1b70047
catalog: null
table name:
original table name: null
column name: IS_AUTOINCREMENT
original column name: null
MySQL data type: -1( Unknown MySQL Type # -1)]
3. 通过phpmyadmin>>表结构，复制表头，word里面行专列
3.1. word里面行专列
表格工具》》》转换为换行符号<p>
shop_id 店铺id
user_id 用户id
shop_name 店铺名称
shop_country 店铺所在国家
shop_province 店铺所在省份
shop_city 店铺所在城市
shop_district 店铺所在区
shop_address 店铺所在详细地址
shop_images 店铺介绍中的图片
shop_logo 店铺logo
shop_template_img 店铺模板大图
shop_template 店铺模板
shop_management 店铺主营
shop_intro 店铺介绍
shop_notice 店铺公告
shop_creat_time 店铺创建时间
goods_num 店铺产品数量
open_flg 店铺关闭，1为关闭
lock_flg 店铺锁定，1为锁定
map_x 地图经线坐标
map_y 地图纬线坐标
map_zoom 地图比例
count_imgsize 图片总大小
shop_categories 店铺最后分类
shop_domain 商店二级域名
