J_Sylar的博客

kettle工具的下载与部署  参考点击打开链接启动时点击spoon.bat 窗口会一闪而过 耐心等几秒钟，真正的界面会慢慢出来

sql向上递归 (查找包含自己的父级id等信息) SELECT T2.id,T2.dep_name,T2.dep_level,T2.dep_type FROM ( SELECT @r AS _id, ( SELECT @r := parent_id FROM dep_info WHERE id = _id) AS parent_id, @l := @l + 1 AS lvl F...

//社保导出表头名 //{字段名称，排序号，level(1.2.3...代表从高到低)，父级序号} public static final String[][] empInsuredHeader = { {"公司名称", "0", "1", "-1"}, {"养老保险", "1", "1", "-1"}, //养老 {"社保基数", "2", ...