useful tools, excel import mysql,swagger

http://www.th7.cn/Program/java/201602/765943.shtml------swagger

 

http://blog.csdn.net/csfreebird/article/details/7381971-----maven-plugin

http://www.cnblogs.com/liyropt/archive/2012/12/31/2841053.html---gitstatus

 

方法二，把excel文件生成.sql文件就ok

 1.在需要导入的数据最后一列，写入一个excel公式,如下
　　=concatenate("insert into employee(name,birthday,email,hobby)values('",rc[-4],"','",rc[-3],"','",rc[-2],"','",rc[-1],"');")
2..将最后一列选中，复制数据到一个文本文件，将该文本文件另存为一个.sql文件(别忘了删除第一行的“sql”)。
 注：如果有日期的话就把公式修改一下
=concatenate("insert into employee(name,birthday,email,hobby)values('",rc[-4],"','",text(rc[-3],"yyyy-mm-dd hh:mm:ss"),"','",rc[-2],"','",rc[-1],"');")