GitHub - langgithub/java2DB: excel 中字典信息生成ddl建表语句

langgithub / java2DB Public

Notifications You must be signed in to change notification settings
Fork 1
Star 1

excel 中字典信息生成ddl建表语句

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 3 Commits
.idea		.idea
lib		lib
src/com/lang/java2		src/com/lang/java2
target		target
build.xml		build.xml
db.properties		db.properties
readme.txt		readme.txt

Repository files navigation

1.针对Excel往MySQL中导入数据
2.Excel文件类型确定


id	            varchar	50	主键
fk_order_id	    varchar	50	订单编号
goods_package	varchar	50	货物包装
goods_no	    varchar	50	商品编号
goods_name   	varchar	50	品名
goods_spec	    varchar	50	规格
model	        varchar	50	型号


3.使用方法
ToMySQL