init

Helius

2021-02-26 de04085526eda992155716eda98af621ad681e4e

init

 README.md

@@ -1,4 +1 @@
## matrix-codeGenerator

matrix-codeGenerator

#codegen3.0


 matrix-codeGenerator.zip

Binary files differ

 pom.xml

New file
@@ -0,0 +1,94 @@
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <groupId>com.zkingsoft</groupId>

    <artifactId>CodeGenerator</artifactId>

    <version>0.0.1-SNAPSHOT</version>

    <name>CodeGenerator</name>

    <description>CodeGenerator</description>

    <dependencies>

        <dependency>

            <groupId>org.httpobjects.freemarker</groupId>

            <artifactId>httpobjects-freemarker</artifactId>

            <version>0.5.0</version>

        </dependency>



        <dependency>

            <groupId>commons-logging</groupId>

            <artifactId>commons-logging</artifactId>

            <version>1.0.4</version>

        </dependency>

        <dependency>

            <groupId>org.apache.logging.log4j</groupId>

            <artifactId>log4j-jcl</artifactId>

            <version>2.5</version>

            <classifier>sources</classifier>

        </dependency>



        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-context</artifactId>

            <version>3.2.11.RELEASE</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-context-support</artifactId>

            <version>3.2.11.RELEASE</version>

        </dependency>



        <dependency>

            <groupId>commons-io</groupId>

            <artifactId>commons-io</artifactId>

            <version>2.4</version>

        </dependency>

        <dependency>

            <groupId>commons-codec</groupId>

            <artifactId>commons-codec</artifactId>

            <version>1.3</version>

        </dependency>



        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-jdbc</artifactId>

            <version>3.2.12.RELEASE</version>

        </dependency>



        <dependency>

            <groupId>org.mybatis</groupId>

            <artifactId>mybatis</artifactId>

            <version>3.2.1</version>

        </dependency>

        <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

            <version>5.1.26</version>

        </dependency>



        <dependency>

            <groupId>commons-lang</groupId>

            <artifactId>commons-lang</artifactId>

            <version>2.6</version>

            <scope>provided</scope>

        </dependency>



        <dependency>

            <groupId>org.apache.poi</groupId>

            <artifactId>poi-ooxml</artifactId>

            <version>3.8</version>

        </dependency>

    </dependencies>

    <build>

        <plugins>

            <plugin>

                <groupId>org.apache.maven.plugins</groupId>

                <artifactId>maven-compiler-plugin</artifactId>

                <version>2.1</version>

                <configuration>

                    <source>1.7</source>

                    <target>1.7</target>

                </configuration>

            </plugin>

        </plugins>

    </build>



</project>

 src/main/java/com/matrix/codeGeneration/convert/DefaultNameConvert.java

New file
@@ -0,0 +1,88 @@
package com.matrix.codeGeneration.convert;



/**

 * 默认的名称实现的转换器

 * 
 * @author Administrator

 *

 */

public class DefaultNameConvert implements NameConvert {



    @Override

    public String propertyToColumn(String property) {

        StringBuffer columnName = new StringBuffer(property);

        for (int i = 0; i < columnName.length(); i++) {

            if (columnName.charAt(i) >= 'A' && columnName.charAt(i) <= 'Z') {

                String upcase = "_" + (columnName.charAt(i) + "").toLowerCase();

                columnName.replace(i, i + 1, upcase);

            }

        }

        return columnName.toString();

    }



    /**

     * 
     */

    @Override

    public String columnToProperty(String column) {

        // 如果数据库字段为大写则使用这里的方法

        // StringBuffer property = new

        // StringBuffer(tableNameToClassName(column.toLowerCase()));



        StringBuffer property = new StringBuffer(tableNameToClassName(column));

        String tempF = (property.charAt(0) + "").toLowerCase();

        property.replace(0, 1, tempF);

        return property.toString();

    }



    @Override

    public String classNameToTableName(String calssName) {

        return propertyToColumn(calssName).substring(1, propertyToColumn(calssName).length());

    }



    /**

     * 
     * 首字母改为大写 去除_ 下划线后一个字符变为大写字符

     */

    @Override

    public String tableNameToClassName(String tableName) {

        StringBuffer calssName = new StringBuffer(tableName);

        String tempF = (calssName.charAt(0) + "").toUpperCase();

        calssName.replace(0, 1, tempF);

        for (int i = 0; i < calssName.length(); i++) {

            if (calssName.charAt(i) == '_' && i + 1 < tableName.length()) {

                String upcase = (calssName.charAt(i + 1) + "").toUpperCase();

                calssName.replace(i, i + 2, upcase);

            }

        }

        return calssName.toString();

    }



    /**

     * 第一个字母大写

     */

    @Override

    public String propertyToMethod(String property) {

        StringBuffer method = new StringBuffer(property);

        String tempF = (method.charAt(0) + "").toUpperCase();

        method.replace(0, 1, tempF);

        return method.toString();

    }



    /**

     * 第一个字母小写

     */

    @Override

    public String classNameToVariableName(String className) {

        StringBuffer variableName = new StringBuffer(className);

        String tempF = (variableName.charAt(0) + "").toLowerCase();

        variableName.replace(0, 1, tempF);

        return variableName.toString();

    }



    public static void main(String[] args) {

        DefaultNameConvert convert = new DefaultNameConvert();

        System.out.println(convert.propertyToColumn("userName"));



    }

}


 src/main/java/com/matrix/codeGeneration/convert/DefaultTypeHandle.java

New file
@@ -0,0 +1,91 @@
package com.matrix.codeGeneration.convert;



import java.util.HashMap;



import com.matrix.codeGeneration.model.TypeHandle;

/**

 * 默认的类型处理器

 * @author Matrix-J

 *

 */

public class DefaultTypeHandle implements TypeHandle {

	
	
    public static HashMap<String, HashMap<String, String>> TypeMapping;

	
	
    static {

		
        TypeMapping = new HashMap<String, HashMap<String, String>>();

		
        /**

         * mysql映射设置

         */

        HashMap<String, String> mysqlMap = new HashMap<String, String>();

        mysqlMap.put("double", "Double");

        mysqlMap.put("int", "Integer");

        mysqlMap.put("bigint", "Long");

        mysqlMap.put("float", "Float");

        mysqlMap.put("varchar", "String");

        mysqlMap.put("tinyint", "Boolean");

        mysqlMap.put("datetime", "Date");

        mysqlMap.put("date", "Date");

        mysqlMap.put("text", "String");

        mysqlMap.put("char", "String");

        mysqlMap.put("enum", "String");

        mysqlMap.put("smallint", "Integer");

        mysqlMap.put("mediumtext", "String");

        mysqlMap.put("tinyint", "Integer");

        mysqlMap.put("tinyint", "Integer");

        mysqlMap.put("bit", "Integer");

        mysqlMap.put("real", "Double");

        mysqlMap.put("decimal", "BigDecimal");

        mysqlMap.put("numeric", "BigDecimal");

        mysqlMap.put("time", "Date");

        mysqlMap.put("year", "Date");

        mysqlMap.put("timestamp", "Date");

        mysqlMap.put("tinyblob", "byte[]");

        mysqlMap.put("blob", "byte[]");

        mysqlMap.put("mediumblob", "byte[]");

        mysqlMap.put("longblob", "byte[]");

        mysqlMap.put("longtext", "String");

        mysqlMap.put("tinytext", "String");

        mysqlMap.put("mediumtext", "String");

        mysqlMap.put("set", "String");

        mysqlMap.put("binary", "byte[]");

        mysqlMap.put("varbinary", "byte[]");

        mysqlMap.put("point", "String");

        mysqlMap.put("linestring", "String");

        mysqlMap.put("polygon", "String");

        mysqlMap.put("geometry", "String");

        mysqlMap.put("multipoint", "String");

        mysqlMap.put("multilinestring", "String");

        mysqlMap.put("multipolygon", "String");

        mysqlMap.put("geometrycollection", "String");

        TypeMapping.put("mysql", mysqlMap);

		
		
		
        /**============================================================================================================================================

         * oracleMap映射设置

         * ===========================================================================================================================================

         */

        HashMap<String, String> oracleMap = new HashMap<String, String>();

        oracleMap.put("CHAR", "String");

        oracleMap.put("VARCHAR2", "String");

        oracleMap.put("LONG", "String");

        oracleMap.put("NUMBER", "BigDecimal");

        oracleMap.put("VARCHAR", "String");

        oracleMap.put("DATE", "Date");

        oracleMap.put("TIMESTAMP", "Date");

        TypeMapping.put("oracle", oracleMap);

		
		
		
		
    }

	
	
	
	
}


 src/main/java/com/matrix/codeGeneration/convert/NameConvert.java

New file
@@ -0,0 +1,57 @@
package com.matrix.codeGeneration.convert;

/**

 * 名称转换接口

 * @author Matrix-J

 *

 */

public interface NameConvert {

    /**

     * 属性转数据库字段格式转换接口

     * 
     * @param property

     * @return

     */

    public String propertyToColumn(String property);



    /**

     * 数据库字段转属性格式转换接口

     * 
     * @param column

     * @return

     */

    public String columnToProperty(String column);

	
	
    /**

     * 表名类名转换接口

     * 
     * @param column

     * @return

     */

    public String tableNameToClassName(String tableName);

	
	
    /**

     * 类名表名转换接口

     * 
     * @param column

     * @return

     */

    public String classNameToTableName(String calssName);

    /**

     * 属性名称转方法名称

     * @param property

     * @return

     */

    public String propertyToMethod(String property);

	
    /**

     * 类名转类名的变量名

     * @param property

     * @return

     */

    public String classNameToVariableName(String className);

	
	
	
}


 src/main/java/com/matrix/codeGeneration/core/Generator.java

New file
@@ -0,0 +1,105 @@
package com.matrix.codeGeneration.core;



import java.io.BufferedWriter;

import java.io.File;

import java.io.FileWriter;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Locale;

import java.util.Map;

import java.util.Set;



import com.matrix.codeGeneration.model.CodeFile;

import com.matrix.codeGeneration.model.CodeModel;

import com.matrix.codeGeneration.model.OutDataSource;



import freemarker.template.Template;



/**

 * @author 姜友瑶

 * @e-mail:<935090232@qq.com>

 * @date 2015-10-23

 * @description 代码生成器

 */

public class Generator {



    public static void buildCodeFiles(OutDataSource outDataSource) {

        // 构建模型文件

        outDataSource.convertToTableModel();

        // 根据模型生成代码模型文件

        List<CodeFile> codeFileModel = generatorFile(outDataSource);

        // 根据模型文件生成实体文件

        createCodeFile(codeFileModel, outDataSource);

    }



    /**

     * 创建要生成的所有文件的模型

     * 
     * @param configuration

     * @return

     */

    private static List<CodeFile> generatorFile(OutDataSource outDataSource) {

        List<CodeFile> codeFiles = new ArrayList<CodeFile>();

        Set<String> modelSet = outDataSource.getCodeModels().keySet();

        // 由模型来生成对应的codeFile，因为模型最知道自己需要的数据是什么，codeFile不关心数据

        for (String modelName : modelSet) {

            CodeModel codeModel = outDataSource.getCodeModels().get(modelName);

            List<CodeFile> thisModelFiles = codeModel.buildCodeFile(outDataSource);

            codeFiles.addAll(thisModelFiles);

        }

        return codeFiles;

    }



    /**

     * 创建

     * 
     * @param configuration

     * @param dbModel

     * @return

     */

    private static void createCodeFile(List<CodeFile> codeFiles, OutDataSource coutDataSource) {

        try {

            freemarker.template.Configuration cfg = new freemarker.template.Configuration();

            cfg.setLocale(Locale.SIMPLIFIED_CHINESE);

            cfg.setDefaultEncoding("utf-8");

            cfg.setEncoding(Locale.SIMPLIFIED_CHINESE, "utf-8");

            cfg.setEncoding(Locale.SIMPLIFIED_CHINESE, "utf-8");

            for (CodeFile codeFile : codeFiles) {

                Map<String, Object> root = new HashMap<String, Object>();

                // 设置文件需要的数据

                root.putAll(codeFile.getData());

                // 生成代码文件

                System.out.println("生成" + codeFile.getFileName() + "文件...");

                cfg.setDirectoryForTemplateLoading(new File(coutDataSource.getUserTempLataHome()));

                // 获取模板（template）

                Template template = cfg.getTemplate(codeFile.getTemplateName(), "utf-8");

                // 把文件写入磁盘

                String filePath = coutDataSource.getTargetPath() + codeFile.getSavePath();

                File file = new File(filePath);

                if (file.getParentFile().exists() && file.exists()) {

                    File javaBean = new File(filePath + codeFile.getFileName());

                    javaBean.createNewFile();

                    BufferedWriter bf = new BufferedWriter(new FileWriter(javaBean));

                    template.process(root, bf);

                    bf.flush();

                    bf.close();

                } else {

                    if (file.mkdirs()) {

                        File javaBean = new File(filePath + codeFile.getFileName());

                        javaBean.createNewFile();

                        BufferedWriter bf = new BufferedWriter(new FileWriter(javaBean));

                        template.process(root, bf);

                        bf.flush();

                        bf.close();

                    } else {

                        System.out.println("创建文件失败" + filePath);

                    }

                }

            }

        } catch (Exception e) {

            e.printStackTrace();

        }

    }



}

 src/main/java/com/matrix/codeGeneration/core/MainClass.java

New file
@@ -0,0 +1,26 @@
package com.matrix.codeGeneration.core;



import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;



import com.matrix.codeGeneration.model.OutDataSource;



/**

 * @author 姜友瑶

 * @e-mail:<935090232@qq.com>

 * @date 2015-10-23

 * @description 代码生成器

 */

public class MainClass {



    public static void main(String[] args) {



        ApplicationContext context = new ClassPathXmlApplicationContext("config/code-generation.xml");

        // 根据需要注入自己的数据源

        OutDataSource outDataSource = (OutDataSource) context.getBean("outDataSource");

        // 生成代码文件

        Generator.buildCodeFiles(outDataSource);



    }



}

 src/main/java/com/matrix/codeGeneration/ext/AhcsModels.java

New file
@@ -0,0 +1,276 @@
package com.matrix.codeGeneration.ext;



import java.io.File;

import java.util.ArrayList;

import java.util.Date;

import java.util.HashMap;

import java.util.List;

import java.util.Map;



import org.apache.poi.ss.usermodel.DataFormatter;



import com.matrix.codeGeneration.model.CodeFile;

import com.matrix.codeGeneration.model.CodeModel;

import com.matrix.codeGeneration.model.CommonData;

import com.matrix.codeGeneration.model.Constant;

import com.matrix.codeGeneration.model.OutDataSource;

import com.matrix.codeGeneration.model.TableClassModel;

import com.matrix.codeGeneration.plugin.DateUtils;



/**

 * 平安意健险代码文件模型

 */

public class AhcsModels implements CodeModel {



    /**

     * 模型名称用来标识这个模型

     */

    String modelName="";



    /**

     * 包名

     */

    private String packageName="";



    /**

     * 名称后缀

     */

    private String suffixName="";



    /**

     * 名称前缀

     */

    private String prefixName="";



    /**

     * 文件扩展名称

     */

    private String fileExtName="";



    /**

     * 模板名称

     */

    private String templateName="";



    /**

     * 导入类列表

     */

    private Map<String, String> importList = new HashMap<>();



    /**

     * 类的变量名称

     */

    private String classVariableName="";



	   


    @Override

    public List<CodeFile> buildCodeFile(OutDataSource dataSource) {

        List<CodeFile> codeFileList = new ArrayList<>();

        for (TableClassModel tableClassModel : dataSource.getTableClassModels()) {

            Map<String, Object> fileData = new HashMap<>();

            System.out.println(tableClassModel.getClassName());

            System.out.println(this.modelName);

            System.out.println("--------------");



            if (Constant.JAVA_BEAN.equals(this.modelName)) {



                this.getImportList().put("Extend", "com.zkingsoft.anotations.Extend");



            } else if (Constant.MYBATIS_DAO.equals(this.modelName)) {

                this.setImportList(new HashMap<String, String>());

                this.getImportList().put("bean",

                        getModelQualifiedClassName(Constant.JAVA_BEAN, tableClassModel, dataSource));



                this.getImportList().put("List", "java.util.List");

                this.getImportList().put("Param", "org.apache.ibatis.annotations.Param");

                this.getImportList().put("PaginationVO", "com.zkingsoft.pojo.PaginationVO");

                this.getImportList().put("Map", "java.util.Map");



            } else if (Constant.MYBATIS_DAO_IMPL.equals(this.modelName)) {



            } else if (Constant.SERVICE.equals(this.modelName)) {



                this.setImportList(new HashMap<String, String>());

                this.getImportList().put("bean",

                        getModelQualifiedClassName(Constant.JAVA_BEAN, tableClassModel, dataSource));

                this.getImportList().put("List", "java.util.List");

                this.getImportList().put("BaseServices", "com.zkingsoft.constraint.BaseServices");

                this.getImportList().put("PaginationVO", "com.zkingsoft.pojo.PaginationVO");



            } else if (Constant.SERVICE_IMPL.equals(this.modelName)) {

                this.setImportList(new HashMap<String, String>());

                this.getImportList().put("bean",

                        getModelQualifiedClassName(Constant.JAVA_BEAN, tableClassModel, dataSource));



                this.getImportList().put("services",

                        getModelQualifiedClassName(Constant.SERVICE, tableClassModel, dataSource));

                this.getImportList().put("dao",

                        getModelQualifiedClassName(Constant.MYBATIS_DAO, tableClassModel, dataSource));

                this.getImportList().put("springframework.Service", "org.springframework.stereotype.Service");

                this.getImportList().put("Autowired", "org.springframework.beans.factory.annotation.Autowired");

                this.getImportList().put("List", "java.util.List");

                this.getImportList().put("Map", "java.util.Map");



            } else if (Constant.ACTION.equals(this.modelName)) {



                this.getImportList().put("Controller", "org.springframework.stereotype.Controller");

                this.getImportList().put("Resource", "javax.annotation.Resource");

                this.getImportList().put("AjaxResult", "com.zkingsoft.pojo.AjaxResult");

                this.getImportList().put("PaginationVO", "com.zkingsoft.pojo.PaginationVO");

                this.getImportList().put("WebUtil", "com.zkingsoft.util.WebUtil");

                this.getImportList().put("SaveRequestToken", "com.zkingsoft.anotations.SaveRequestToken");

                this.getImportList().put("RemoveRequestToken", "com.zkingsoft.anotations.RemoveRequestToken");

                this.getImportList().put("BaseController", "com.zkingsoft.constraint.BaseController");

                this.getImportList().put("RequestMapping", "org.springframework.web.bind.annotation.RequestMapping");

                this.getImportList().put("ResponseBody", "org.springframework.web.bind.annotation.ResponseBody");

            }

            fileData.put("importList", this.getImportList());

            CodeFile codeFile = new CodeFile();

            // 计算文件的名称

            codeFile.setFileName(getFileName(tableClassModel, this));

            codeFile.setSavePath(File.separator + getPackageName().replace(".", File.separator) + File.separator);

            fileData.put("codeModel", this);

            fileData.put("dataSource", dataSource);

            fileData.put("tableClassModel", tableClassModel);

            fileData.put("commonData", new CommonData());

            fileData.put("time", DateUtils.dateFormatStr(new Date(), "yyyy-MM-dd HH:mm"));



            fileData.put("ClassName", getModelClassName(this.getModelName(), tableClassModel, dataSource));

            codeFile.setData(fileData);

            codeFile.setTemplateName(this.templateName);

            codeFileList.add(codeFile);

        }

        return codeFileList;



    }



    /**

     * 计算文件名称

     * 
     * @param tableClassModel

     * @return

     */

    public String getFileName(TableClassModel tableClassModel, AhcsModels ahcsModels) {

        StringBuffer name = new StringBuffer();

        String prefix = ahcsModels.getPrefixName();

        String suffix = ahcsModels.getSuffixName();

        String extensionName = ahcsModels.getFileExtName();

        if (prefix != null) {

            name.append(prefix);

        }

        name.append(tableClassModel.getClassName());

        if (suffix != null) {

            name.append(suffix);

        }

        name.append(extensionName);

        return name.toString();

    }



    /**

     * 获取一个模型的变量名

     * 
     * @param modelName

     * @param dataSource

     * @return

     */

    public String getModelVariablesName(String modelName, TableClassModel tableClassModel, OutDataSource dataSource) {

        return dataSource.getNameConvert()

                .classNameToTableName(getModelClassName(modelName, tableClassModel, dataSource));

    }



    /**

     * 获取一个模型的全类名

     * 
     * @param modelName

     * @param dataSource

     * @return

     */

    public String getModelQualifiedClassName(String modelName, TableClassModel tableClassModel,

            OutDataSource dataSource) {

        AhcsModels ahcsMOdels = ((AhcsModels) dataSource.getCodeModels().get(modelName));

        String className = ahcsMOdels.getPackageName() + "." + ahcsMOdels.getPrefixName()

                + tableClassModel.getClassName() + ahcsMOdels.getSuffixName();

        return className;

    }



    /**

     * 获取一个模型的类名

     * 
     * @param modelName

     * @param dataSource

     * @return

     */

    public String getModelClassName(String modelName, TableClassModel tableClassModel, OutDataSource dataSource) {

        AhcsModels ahcsMOdels = ((AhcsModels) dataSource.getCodeModels().get(modelName));

        String className = ahcsMOdels.getPrefixName() + tableClassModel.getClassName() + ahcsMOdels.getSuffixName();

        return className;

    }



    public String getModelName() {

        return modelName;

    }



    public void setModelName(String modelName) {

        this.modelName = modelName;

    }



    public String getPackageName() {

        return packageName;

    }



    public void setPackageName(String packageName) {

        this.packageName = packageName;

    }



    public String getSuffixName() {

        return suffixName;

    }



    public void setSuffixName(String suffixName) {

        this.suffixName = suffixName;

    }



    public String getPrefixName() {

        return prefixName;

    }



    public void setPrefixName(String prefixName) {

        this.prefixName = prefixName;

    }



    public String getFileExtName() {

        return fileExtName;

    }



    public void setFileExtName(String fileExtName) {

        this.fileExtName = fileExtName;

    }



    public String getTemplateName() {

        return templateName;

    }



    public void setTemplateName(String templateName) {

        this.templateName = templateName;

    }



    public Map<String, String> getImportList() {

        return importList;

    }



    public void setImportList(Map<String, String> importList) {

        this.importList = importList;

    }



    public String getClassVariableName() {

        return classVariableName;

    }



    public void setClassVariableName(String classVariableName) {

        this.classVariableName = classVariableName;

    }

 
 


}


 src/main/java/com/matrix/codeGeneration/ext/ExcelDataSource.java

New file
@@ -0,0 +1,207 @@
package com.matrix.codeGeneration.ext;



import com.matrix.codeGeneration.convert.DefaultTypeHandle;

import com.matrix.codeGeneration.model.OutDataSource;

import com.matrix.codeGeneration.model.PropertyColumn;

import com.matrix.codeGeneration.model.TableClassModel;

import com.matrix.codeGeneration.plugin.ExcelImport;

import org.apache.commons.lang.StringUtils;



import java.io.File;

import java.io.IOException;

import java.util.*;



/**

 * excel数据源

 * 
 * @author jiangyouyao

 *

 */

public class ExcelDataSource extends OutDataSource {

    // excel文件地址

    private String sourcePath;

    private String author;



    private String dbType;



    public ExcelDataSource() {

    }



    @Override

    public List<TableClassModel> convertToTableModel() {



        Map<String, List<List<Object>>> analysisExcel = new HashMap<>();

        // 源文件路径

        File sourceDir = new File(sourcePath);

        if (!sourceDir.isDirectory()) {

            new Exception("目标目录不存在");

        }

        File[] files = sourceDir.listFiles();

        if (files != null) {

            for (File file : files) {

                if (file.canRead()) {// 是否为一个可读文件

                    String fileName = file.getName();

                    // 检查扩展名称

                    String extension = fileName.lastIndexOf(".") == -1 ? ""

                            : fileName.substring(fileName.lastIndexOf(".") + 1);

                    if (extension.equals("xls") || extension.equals("xlsx")) {

                        System.out.println(fileName);

                        // 读取excel文件的内容

                        try {

                            analysisExcel.putAll(ExcelImport.read2007ExcelAllShell(file, null, 6));

                        } catch (IOException e) {

                            e.printStackTrace();

                        }

                    }

                } else {

                    new RuntimeException(file.getName() + "文件不可读");

                }

            }

        }

        List<TableClassModel> models = analysisExcel(analysisExcel);

        this.setTableClassModels(models);

        return this.getTableClassModels();

    }



    /**

     * 解析excel文件中数据表信息

     * 
     * @param analysisExcel

     * @return

     */

    private List<TableClassModel> analysisExcel(Map<String, List<List<Object>>> analysisExcel) {

        List<TableClassModel> models = new ArrayList<>();

        Set<String> keys = analysisExcel.keySet();

        // 除了第一行，其他每一行代表一个字段，一个key是一个表

        for (String tableName : keys) {

            TableClassModel model = new TableClassModel();

            List<List<Object>> data = analysisExcel.get(tableName);

            // 设置数据表基本信息

            // 构建表名



            int nameIndex = tableName.indexOf("(");

            model.setTableMemo(tableName.substring(nameIndex+1, tableName.length()-1));

            model.setTableName(tableName.substring(0, nameIndex));

            // 设置类名和变量名称

            model.setClassName(getNameConvert().tableNameToClassName(model.getTableName()));

            model.setClassVariableName(getNameConvert().classNameToVariableName(model.getClassName()));

             
            // 该表需要展示到页面的字段个数

            int showCount=0;

            // 遍历设置字段信息

            for (int i = 1; i < data.size(); i++) {

                List<Object> row = data.get(i);

                PropertyColumn p = new PropertyColumn();

                // 列名

                String columnName = (String) row.get(0);

                p.setColumn(columnName);

                // 属性名称

                p.setProperty(getNameConvert().columnToProperty(columnName));



                // 字段类型、长度

                String type = (String) row.get(2);

                p.setFullJdbcType(type);



                // jdbc类型设置

                int index = type.indexOf("(") > 0 ? type.indexOf("(") : type.length();



                p.setJdbcType(type.substring(0, index).trim().replaceAll("2", ""));

                System.out.println("jdbctype=" + p.getJdbcType());

                // 基本类型

                p.setClassType(DefaultTypeHandle.TypeMapping.get(dbType).get(p.getJdbcType()));



                String isAllowNull = (String) row.get(3);



                if (isAllowNull != null && isAllowNull.equals("N")) {

                    isAllowNull = " NOT NULL ";

                } else {

                    isAllowNull = "";

                }



                p.setIsAllowNull(isAllowNull);



                // 备注中 [表示界面显示字段] [表示必填字段*]

                String memo = (String) row.get(1);

                int begin = memo.indexOf("[");

                int end = memo.indexOf("]");



                if (begin > -1 && end - begin > 1) {

                    showCount++;

                    // 显示到页面上的字段

                    String subString1 = memo.substring(begin, end);

                    boolean isNecessary = subString1.indexOf("*") > 0;

                    if (isNecessary) {

                        p.setShowName(memo.substring(begin + 1, end - 1));

                    } else {

                        p.setShowName(memo.substring(begin + 1, end));

                    }

                    p.setIsNecessary(isNecessary);

                    p.setIsVisible(true);

                    // 截取[符号前面的字段作为数据库的备注

                    p.setMemo(memo.substring(0, begin));

                } else {

                    p.setIsNecessary(false);

                    p.setIsVisible(false);

                    p.setMemo(memo);

                }

                // get，set方法名称

                p.setMethodName(getNameConvert().propertyToMethod(p.getProperty()));



                // 设置主键

                if (p.getMemo() != null && p.getMemo().equals("主键")) {

                    p.setIsPrimaryKey(true);

                    model.setPrimaryKey(p);

                } else {

                    p.setIsPrimaryKey(false);

                }



                // 索引

                String indexName = (String) row.get(5);

                if(null == indexName || "".equals(indexName)){

                    indexName = null;

                }

                p.setIndexName(indexName);



                // 设置jsp编辑页面字段长度限制

                String columnLengthStr = row.get(6) == null ? null : (String) row.get(6);

                if (columnLengthStr!=null && columnLengthStr.trim().length()>0) {

                    // 从excel中读取的数字默认是double类型的，所以做如下处理去掉小数点

                    Double columnLength = Double.parseDouble(columnLengthStr);

                    p.setColumnLength(columnLength.intValue()+"");

                }



                model.getMapping().add(p);

            }

            // 需要加上该表有多少个显示到list列表的字段个数

            model.setShowCount(showCount);

            models.add(model);

        }

        System.out.println(analysisExcel);

        return models;

    }



    public String getSourcePath() {

        return sourcePath;

    }



    public void setDbType(String dbType) {

        this.dbType = dbType;

    }



    public void setSourcePath(String sourcePath) {

        this.sourcePath = sourcePath;

    }



    public void setAuthor(String author) {

        this.author = author;

    }



    public String getAuthor() {

        return author;

    }



    public String getDbType() {

        return dbType;

    }



}


 src/main/java/com/matrix/codeGeneration/ext/Matrix4Models.java

New file
@@ -0,0 +1,318 @@
package com.matrix.codeGeneration.ext;



import java.io.File;

import java.util.ArrayList;

import java.util.Date;

import java.util.HashMap;

import java.util.List;

import java.util.Map;



import org.springframework.beans.BeanUtils;



import com.matrix.codeGeneration.model.CodeFile;

import com.matrix.codeGeneration.model.CodeModel;

import com.matrix.codeGeneration.model.CommonData;

import com.matrix.codeGeneration.model.Constant;

import com.matrix.codeGeneration.model.OutDataSource;

import com.matrix.codeGeneration.model.TableClassModel;

import com.matrix.codeGeneration.plugin.DateUtils;



/**

 * matrix4代码文件模型

 */

public class Matrix4Models implements CodeModel {



    /**

     * 模型名称用来标识这个模型

     */

    String modelName="";



    /**

     * 包名

     */

    private String packageName="";



    /**

     * 名称后缀

     */

    private String suffixName="";



    /**

     * 名称前缀

     */

    private String prefixName="";



    /**

     * 文件扩展名称

     */

    private String fileExtName="";



    /**

     * 模板名称

     */

    private String templateName="";



    /**

     * 导入类列表

     */

    private Map<String, String> importList = new HashMap<>();



    /**

     * 类的变量名称

     */

    private String classVariableName="";



	   


    @Override

    public List<CodeFile> buildCodeFile(OutDataSource dataSource) {

        List<CodeFile> codeFileList = new ArrayList<>();

        for (TableClassModel tableClassModel : dataSource.getTableClassModels()) {

            Map<String, Object> fileData = new HashMap<>();

            tableClassModel.setBeanClassName(getModelClassName(Constant.JAVA_BEAN,tableClassModel,dataSource));

            tableClassModel.setFullClassName(getModelClassName(modelName,tableClassModel,dataSource));

            tableClassModel.setQualifiedClassName(getModelQualifiedClassName(modelName,tableClassModel,dataSource));

            System.out.println(tableClassModel.getClassName());

            System.out.println(this.modelName);

            System.out.println("--------------");



            if (Constant.JAVA_BEAN.equals(this.modelName)) {



                this.getImportList().put("Extend", "com.matrix.core.anotations.Extend");

                this.getImportList().put("EntityDTO", "com.matrix.core.pojo.EntityDTO");

                this.getImportList().put("EntityDTOExt", "com.matrix.core.publicBean.EntityDTOExt");



            } else if (Constant.MYBATIS_DAO.equals(this.modelName)) {

                this.setImportList(new HashMap<String, String>());

                this.getImportList().put("bean",

                        getModelQualifiedClassName(Constant.JAVA_BEAN, tableClassModel, dataSource));



                this.getImportList().put("List", "java.util.List");

                this.getImportList().put("Param", "org.apache.ibatis.annotations.Param");

                this.getImportList().put("PaginationVO", "com.matrix.core.pojo.PaginationVO");

                this.getImportList().put("Map", "java.util.Map");



            } else if (Constant.MYBATIS_DAO_IMPL.equals(this.modelName)) {



            } else if (Constant.SERVICE.equals(this.modelName)) {



                this.setImportList(new HashMap<String, String>());

                this.getImportList().put("bean",

                        getModelQualifiedClassName(Constant.JAVA_BEAN, tableClassModel, dataSource));

                this.getImportList().put("List", "java.util.List");

                this.getImportList().put("BaseServices", "com.matrix.core.web.BaseServices");

                this.getImportList().put("PaginationVO", "com.matrix.core.pojo.PaginationVO");



            } else if (Constant.SERVICE_IMPL.equals(this.modelName)) {

                this.setImportList(new HashMap<String, String>());

                this.getImportList().put("bean",

                        getModelQualifiedClassName(Constant.JAVA_BEAN, tableClassModel, dataSource));



                this.getImportList().put("services",

                        getModelQualifiedClassName(Constant.SERVICE, tableClassModel, dataSource));

                this.getImportList().put("dao",

                        getModelQualifiedClassName(Constant.MYBATIS_DAO, tableClassModel, dataSource));

                this.getImportList().put("springframework.Service", "org.springframework.stereotype.Service");

                this.getImportList().put("Autowired", "org.springframework.beans.factory.annotation.Autowired");

                this.getImportList().put("List", "java.util.List");

                this.getImportList().put("Map", "java.util.Map");

                this.getImportList().put("MatrixConstance", "com.matrix.core.constance.MatrixConstance");

                this.getImportList().put("WebUtil", "com.matrix.core.tools.WebUtil");

                this.getImportList().put("GlobleException", "com.matrix.core.exception.GlobleException");

                this.getImportList().put("ModelUtils", "com.matrix.core.tools.ModelUtils");

                this.getImportList().put("SystemErrorCode", "com.matrix.core.constance.SystemErrorCode");

                this.getImportList().put("UUIDUtil", "com.matrix.core.tools.UUIDUtil");

                this.getImportList().put("PaginationVO", "com.matrix.core.pojo.PaginationVO");

                this.getImportList().put("SysUsers", "com.xincheng.common.bean.SysUsers");

				
				
                fileData.put("daoClassName", getModelClassName(Constant.MYBATIS_DAO, tableClassModel, dataSource));

                fileData.put("daoVariableName", getModelVariablesName(Constant.MYBATIS_DAO, tableClassModel, dataSource));

                fileData.put("serviceInterface", getModelClassName(Constant.SERVICE, tableClassModel, dataSource));

				
				
            } else if (Constant.ACTION.equals(this.modelName)) {

                this.getImportList().put("bean",

                        getModelQualifiedClassName(Constant.JAVA_BEAN, tableClassModel, dataSource));

                //this.getImportList().put("services",

                //        getModelQualifiedClassName(Constant.SERVICE, tableClassModel, dataSource));

                this.getImportList().put("Controller", "org.springframework.stereotype.Controller");

                this.getImportList().put("Autowired", "org.springframework.beans.factory.annotation.Autowired");

                this.getImportList().put("AjaxResult", "com.matrix.core.pojo.AjaxResult");

                this.getImportList().put("GlobleException", "com.matrix.core.exception.GlobleException");

                this.getImportList().put("PaginationVO", "com.matrix.core.pojo.PaginationVO");

                this.getImportList().put("WebUtil", "com.matrix.core.tools.WebUtil");

                this.getImportList().put("SaveRequestToken", "com.matrix.core.anotations.SaveRequestToken");

                this.getImportList().put("RemoveRequestToken", "com.matrix.core.anotations.RemoveRequestToken");

                this.getImportList().put("BaseController", "com.matrix.core.web.BaseAction");

                this.getImportList().put("RequestMapping", "org.springframework.web.bind.annotation.RequestMapping");

                this.getImportList().put("ResponseBody", "org.springframework.web.bind.annotation.ResponseBody");

                this.getImportList().put("AppConstance", "static com.xincheng.common.constance.AppConstance.*");

                this.getImportList().put("SystemMessageCode", "com.matrix.core.constance.SystemMessageCode");

                this.getImportList().put("SystemErrorCode", "com.matrix.core.constance.SystemErrorCode");

                this.getImportList().put("Map", "java.util.Map");

                this.getImportList().put("RedisUserLoginUtils", "com.matrix.core.redis.RedisUserLoginUtils");

                this.getImportList().put("SysUsers", "com.xincheng.commonApi.bean.SysUsers");

            }

            fileData.put("importList", this.getImportList());

            CodeFile codeFile = new CodeFile();

            // 计算文件的名称

            codeFile.setFileName(getFileName(tableClassModel, this));

            codeFile.setSavePath(File.separator + getPackageName().replace(".", File.separator) + File.separator);

            fileData.put("codeModel", this);

            fileData.put("beanQualifiedClassName", getModelQualifiedClassName(Constant.JAVA_BEAN, tableClassModel, dataSource));

            fileData.put("dataSource", dataSource);

            TableClassModel thisTableClassModel= new TableClassModel();

            BeanUtils.copyProperties(tableClassModel, thisTableClassModel);

            fileData.put("tableClassModel", thisTableClassModel);

            fileData.put("commonData", new CommonData());

            fileData.put("time", DateUtils.dateFormatStr(new Date(), "yyyy-MM-dd HH:mm"));

            fileData.put("ClassName", getModelClassName(this.getModelName(), tableClassModel, dataSource));

            codeFile.setData(fileData);

            codeFile.setTemplateName(this.templateName);

            codeFileList.add(codeFile);

        }

        return codeFileList;



    }



    /**

     * 计算文件名称

     * 
     * @param tableClassModel

     * @return

     */

    public String getFileName(TableClassModel tableClassModel, Matrix4Models ahcsModels) {

        StringBuffer name = new StringBuffer();

        String prefix = ahcsModels.getPrefixName();

        String suffix = ahcsModels.getSuffixName();

		
		
        String extensionName = ahcsModels.getFileExtName();

        if (prefix != null) {

            name.append(prefix);

        }

        // 这里判断如果是html 则应该将文件名首字母小写

        if(".html".equals(extensionName)) {

            String className = tableClassModel.getClassName();

            String initial = className.substring(0, 1).toLowerCase();

            name.append(initial+className.substring(1));

        }else {

            name.append(tableClassModel.getClassName());

        }

        if (suffix != null) {

            name.append(suffix);

        }

        name.append(extensionName);

        return name.toString();

    }



    /**

     * 获取一个模型的变量名

     * 
     * @param modelName

     * @param dataSource

     * @return

     */

    public String getModelVariablesName(String modelName, TableClassModel tableClassModel, OutDataSource dataSource) {

        return dataSource.getNameConvert()

                .classNameToVariableName(getModelClassName(modelName, tableClassModel, dataSource));

    }



    /**

     * 获取一个模型的全类名

     * 
     * @param modelName

     * @param dataSource

     * @return

     */

    public String getModelQualifiedClassName(String modelName, TableClassModel tableClassModel,

            OutDataSource dataSource) {

        Matrix4Models ahcsMOdels = ((Matrix4Models) dataSource.getCodeModels().get(modelName));

        String className = ahcsMOdels.getPackageName() + "." + ahcsMOdels.getPrefixName()

                + tableClassModel.getClassName() + ahcsMOdels.getSuffixName();

        return className;

    }



    /**

     * 获取一个模型的类名

     * 
     * @param modelName

     * @param dataSource

     * @return

     */

    public String getModelClassName(String modelName, TableClassModel tableClassModel, OutDataSource dataSource) {

        Matrix4Models ahcsMOdels = ((Matrix4Models) dataSource.getCodeModels().get(modelName));

        String className = ahcsMOdels.getPrefixName() + tableClassModel.getClassName() + ahcsMOdels.getSuffixName();

        return className;

    }

	
	


    public String getModelName() {

        return modelName;

    }



    public void setModelName(String modelName) {

        this.modelName = modelName;

    }



    public String getPackageName() {

        return packageName;

    }



    public void setPackageName(String packageName) {

        this.packageName = packageName;

    }



    public String getSuffixName() {

        return suffixName;

    }



    public void setSuffixName(String suffixName) {

        this.suffixName = suffixName;

    }



    public String getPrefixName() {

        return prefixName;

    }



    public void setPrefixName(String prefixName) {

        this.prefixName = prefixName;

    }



    public String getFileExtName() {

        return fileExtName;

    }



    public void setFileExtName(String fileExtName) {

        this.fileExtName = fileExtName;

    }



    public String getTemplateName() {

        return templateName;

    }



    public void setTemplateName(String templateName) {

        this.templateName = templateName;

    }



    public Map<String, String> getImportList() {

        return importList;

    }



    public void setImportList(Map<String, String> importList) {

        this.importList = importList;

    }



    public String getClassVariableName() {

        return classVariableName;

    }



    public void setClassVariableName(String classVariableName) {

        this.classVariableName = classVariableName;

    }

 
 


}


 src/main/java/com/matrix/codeGeneration/ext/OracleStyleNameConvert.java

New file
@@ -0,0 +1,86 @@
package com.matrix.codeGeneration.ext;



import com.matrix.codeGeneration.convert.NameConvert;



/**

 * oracle风格的名称实现的转换器

 * 
 * @author Administrator

 *

 */

public class OracleStyleNameConvert implements NameConvert {



    @Override

    public String propertyToColumn(String property) {

        StringBuffer columnName = new StringBuffer(property);

        for (int i = 0; i < columnName.length(); i++) {

            if (columnName.charAt(i) >= 'A' && columnName.charAt(i) <= 'Z') {

                String upcase = "_" + (columnName.charAt(i) + "").toLowerCase();

                columnName.replace(i, i + 1, upcase);

            }

        }

        return columnName.toString();

    }



    /**

     * 
     */

    @Override

    public String columnToProperty(String column) {

        // 如果数据库字段为大写则使用这里的方法

        StringBuffer property = new  StringBuffer(tableNameToClassName(column.toLowerCase()));

        String tempF = (property.charAt(0) + "").toLowerCase();

        property.replace(0, 1, tempF);

        return property.toString();

    }



    @Override

    public String classNameToTableName(String calssName) {

        return propertyToColumn(calssName).substring(1, propertyToColumn(calssName).length());

    }



    /**

     * 
     * 首字母改为大写 去除_ 下划线后一个字符变为大写字符

     */

    @Override

    public String tableNameToClassName(String tableName) {

        StringBuffer calssName = new StringBuffer(tableName.toLowerCase());

        String tempF = (calssName.charAt(0) + "").toUpperCase();

        calssName.replace(0, 1, tempF);

        for (int i = 0; i < calssName.length(); i++) {

            if (calssName.charAt(i) == '_' && i + 1 < tableName.length()) {

                String upcase = (calssName.charAt(i + 1) + "").toUpperCase();

                calssName.replace(i, i + 2, upcase);

            }

        }

        return calssName.toString();

    }



    /**

     * 第一个字母大写

     */

    @Override

    public String propertyToMethod(String property) {

        StringBuffer method = new StringBuffer(property);

        String tempF = (method.charAt(0) + "").toUpperCase();

        method.replace(0, 1, tempF);

        return method.toString();

    }



    /**

     * 第一个字母小写

     */

    @Override

    public String classNameToVariableName(String className) {

        StringBuffer variableName = new StringBuffer(className);

        String tempF = (variableName.charAt(0) + "").toLowerCase();

        variableName.replace(0, 1, tempF);

        return variableName.toString();

    }



    public static void main(String[] args) {

        OracleStyleNameConvert convert = new OracleStyleNameConvert();

        System.out.println(convert.columnToProperty("user_id"));

    }

}


 src/main/java/com/matrix/codeGeneration/model/Attribute.java

New file
@@ -0,0 +1,43 @@
package com.matrix.codeGeneration.model;



/**

 * 类属性

 * 
 * @author Matrix-J

 */

public class Attribute {



    /**

     * 注解

     */

    private String annotate;



    private String className;



    private String variableName;



    public String getAnnotate() {

        return annotate;

    }



    public void setAnnotate(String annotate) {

        this.annotate = annotate;

    }



    public String getClassName() {

        return className;

    }



    public void setClassName(String className) {

        this.className = className;

    }



    public String getVariableName() {

        return variableName;

    }



    public void setVariableName(String variableName) {

        this.variableName = variableName;

    }



}


 src/main/java/com/matrix/codeGeneration/model/CodeFile.java

New file
@@ -0,0 +1,65 @@
package com.matrix.codeGeneration.model;



import java.util.Map;



 
/**每一个codeFile 代表一个要生成的文件

 * 
 * @author jiangyouyao

 *

 */

public class CodeFile {



    /**

     * 模板文件名称

     */

    private String fileName;

    /**

     * 模板文件保存地址

     */

    private String savePath;

	
    /**

     * 模型文件地址

     */

    private String templateName;

	
	
    public String getTemplateName() {

        return templateName;

    }



    public void setTemplateName(String templateName) {

        this.templateName = templateName;

    }



    /**

     * 模板文件需要的数据

     */

    private Map<String, Object> data;



    public String getFileName() {

        return fileName;

    }



    public void setFileName(String fileName) {

        this.fileName = fileName;

    }



    public String getSavePath() {

        return savePath;

    }



    public void setSavePath(String savePath) {

        this.savePath = savePath;

    }



    public Map<String, Object> getData() {

        return data;

    }



    public void setData(Map<String, Object> data) {

        this.data = data;

    }



}


 src/main/java/com/matrix/codeGeneration/model/CodeModel.java

New file
@@ -0,0 +1,13 @@
package com.matrix.codeGeneration.model;



import java.util.List;



/**

 * 代码文件模型

 * 
 * @author Matrix-J

 *

 */

public interface CodeModel {

    public List<CodeFile> buildCodeFile(OutDataSource dataSource);

 }


 src/main/java/com/matrix/codeGeneration/model/CommonData.java

New file
@@ -0,0 +1,19 @@
package com.matrix.codeGeneration.model;



import java.util.Date;



import com.matrix.codeGeneration.plugin.DateUtils;



public class CommonData {

    @SuppressWarnings("unused")

    private String now;



    public String getNow() {

        return DateUtils.dateFormatStr(new Date(), "yyyy-MM-dd HH:mm");

    }



    public void setNow(String now) {

        this.now = now;

    }



}


 src/main/java/com/matrix/codeGeneration/model/Constant.java

New file
@@ -0,0 +1,68 @@
package com.matrix.codeGeneration.model;



/**

 * 文件类型

 * 
 * @author Matrix-J

 *

 */

public class Constant {

	
    /**

     * javabean类型模型

     */

    public static String MYSQL_SQL = "MYSQL_SQL";

	
	
    /**

     * javabean类型模型

     */

    public static String JAVA_BEAN = "JAVA_BEAN";



    /**

     * mybatis dao模型文件

     */

    public static String MYBATIS_DAO_IMPL = "MYBATIS_DAO_IMPL";



    /**

     * mybatis dao模型文件

     */

    public static String MYBATIS_DAO = "MYBATIS_DAO";



    /**

     * SERVICE接口 模型文件

     */

    public static String SERVICE = "SERVICE";



    /**

     * SERVICE 实现类模型文件

     */

    public static String SERVICE_IMPL = "SERVICE_IMPL";



    /**

     * ACTION 类模型文件

     */

    public static String ACTION = "ACTION";



    /**

     * LIST VIEW 视图模型文件

     */

    public static String LIST = "LIST";

    /**

     * FORM VIEW 视图模型文件

     */

    public static String FORM = "FORM";



    /**

     * MABATIS 的配置文件

     */

    public static String MABATIS_CONFIG = "MABATIS_CONFIG";

    /**

     * MYSQL数据库类型

     */

    public static String DB_MYSQL = "DB_MYSQL";

    /**

     * oracle数据库类型

     */

    public static String DB_ORACLE = "DB_ORACLE";

}


 src/main/java/com/matrix/codeGeneration/model/ModelType.java

New file
@@ -0,0 +1,78 @@
package com.matrix.codeGeneration.model;



/**

 * 文件类型

 * 
 * @author Matrix-J

 *

 */

public enum ModelType {

    /**

     * javabean类型模型

     */

    JAVA_BEAN,



    /**

     * mybatis dao模型文件

     */

    MYBATIS_DAO_IMPL,



    /**

     * mybatis dao模型文件

     */

    MYBATIS_DAO,



    /**

     * SERVICE接口 模型文件

     */

    SERVICE,



    /**

     * SERVICE 实现类模型文件

     */

    SERVICE_IMPL,



    /**

     * ACTION 类模型文件

     */

    ACTION,



    /**

     * LIST VIEW 视图模型文件

     */

    LIST,

    /**

     * FORM VIEW 视图模型文件

     */

    FORM,



    /**

     * MABATIS 的配置文件

     */

    MABATIS_CONFIG,;



    public static ModelType get(String source) {



        if (source.equals(JAVA_BEAN.toString())) {

            return JAVA_BEAN;

        } else if (source.equals(MYBATIS_DAO_IMPL.toString())) {

            return MYBATIS_DAO_IMPL;

        } else if (source.equals(MYBATIS_DAO.toString())) {

            return MYBATIS_DAO;

        } else if (source.equals(SERVICE.toString())) {

            return SERVICE;

        } else if (source.equals(SERVICE_IMPL.toString())) {

            return SERVICE_IMPL;

        } else if (source.equals(ACTION.toString())) {

            return ACTION;

        } else if (source.equals(LIST.toString())) {

            return LIST;

        }else if (source.equals(FORM.toString())) {

            return FORM;

        } else if (source.equals(MABATIS_CONFIG.toString())) {

            return MABATIS_CONFIG;

        }

        return null;

    }



}


 src/main/java/com/matrix/codeGeneration/model/OutDataSource.java

New file
@@ -0,0 +1,89 @@
package com.matrix.codeGeneration.model;



import java.util.List;

import java.util.Map;



import com.matrix.codeGeneration.convert.DefaultNameConvert;

import com.matrix.codeGeneration.convert.NameConvert;



public abstract class OutDataSource {



    private String targetPath;



    private NameConvert nameConvert = new DefaultNameConvert();

    /**

     * 根据客户的选择生成表与类的对应

     */

    private List<TableClassModel> tableClassModels;



    /**

     * 根据客户的选择生成模型文件

     */

    private Map<String, CodeModel> codeModels;



    /**

     * 是否要生成文件 的包名

     */

    private List<String> modelPackages;



    /**

     * 用户模板根目录

     */

    private String userTempLataHome;



    public abstract List<TableClassModel> convertToTableModel();



    public String getTargetPath() {

        return targetPath;

    }



    public void setTargetPath(String targetPath) {

        this.targetPath = targetPath;

    }



    public List<TableClassModel> getTableClassModels() {

        return tableClassModels;

    }



    public void setTableClassModels(List<TableClassModel> tableClassModels) {

        this.tableClassModels = tableClassModels;

    }



    public Map<String, CodeModel> getCodeModels() {

        return codeModels;

    }



    public void setCodeModels(Map<String, CodeModel> codeModels) {

        this.codeModels = codeModels;

    }



    public List<String> getModelPackages() {

        return modelPackages;

    }



    public void setModelPackages(List<String> modelPackages) {

        this.modelPackages = modelPackages;

    }



    public String getUserTempLataHome() {

        return userTempLataHome;

    }



    // 这里支持classpath

    public void setUserTempLataHome(String userTempLataHome) {

        String cuttentPath = ClassLoader.getSystemResource("").toString().substring(5);

        cuttentPath = cuttentPath + userTempLataHome;

        this.userTempLataHome = cuttentPath;

    }



    public NameConvert getNameConvert() {

        return nameConvert;

    }



    public void setNameConvert(NameConvert nameConvert) {

        this.nameConvert = nameConvert;

    }



	 


}


 src/main/java/com/matrix/codeGeneration/model/PropertyColumn.java

New file
@@ -0,0 +1,218 @@
package com.matrix.codeGeneration.model;



/**

 * 属性名称和字段名称的对应bean

 * 
 * @author Matrix-j

 *

 */

public class PropertyColumn {

    /**

     * 属性名称

     */

    private String property;

    /**

     * 字段名称

     */

    private String column;

    /**

     * 类型名称

     */

    private String classType;



    /**

     * JDBC名称

     */

    private String jdbcType;

	
    /**

     * JDBC名称 加长度

     */

    private String fullJdbcType;

	
	
    /**

     * 是否为主键

     * 
     */

    private Boolean isPrimaryKey;

	
    /**

     * 是否在界面显示

     * 在数据库用[显示字段]备注表示在界面显示

     */

    private Boolean isVisible;

	
    /**

     * 是否必填

     * 在数据库用[显示字段*]备注表示必填项

     */

    private Boolean isNecessary;

	
    /**

     * 是否可为空

     */

    private String isAllowNull;

    /**

     * 显示在界面的名称

     */

    private String showName;

	
    /**

     * 是否为外键

     */

    private Boolean isForeignKey;



    /**

     * 外键表名

     */

    private String foreignTableName;



    /**

     * 备注

     */

    private String memo;



    /**

     * 字段最大长度

     */

    private String columnLength;



    /**

     * 方法名称

     */

    private String methodName;



    /**

     * 索引名称

     */

    private String indexName;



    public String getMethodName() {

        return methodName;

    }



    public void setMethodName(String methodName) {

        this.methodName = methodName;

    }



    public String getMemo() {

        return memo;

    }



    public void setMemo(String memo) {

        this.memo = memo;

    }



    public String getForeignTableName() {

        return foreignTableName;

    }



    public void setForeignTableName(String foreignTableName) {

        this.foreignTableName = foreignTableName;

    }



    public String getProperty() {

        return property;

    }



    public void setProperty(String property) {

        this.property = property;

    }



    public String getColumn() {

        return column;

    }



    public void setColumn(String column) {

        this.column = column;

    }



    public String getClassType() {

        return classType;

    }



    public void setClassType(String classType) {

        this.classType = classType;

    }



	
    public Boolean getIsVisible() {

        return isVisible;

    }



    public void setIsVisible(Boolean isVisible) {

        this.isVisible = isVisible;

    }



    public Boolean getIsNecessary() {

        return isNecessary;

    }



    public void setIsNecessary(Boolean isNecessary) {

        this.isNecessary = isNecessary;

    }



    public String getJdbcType() {

        return jdbcType;

    }



    public void setJdbcType(String jdbcType) {

        this.jdbcType = jdbcType;

    }



    public Boolean getIsPrimaryKey() {

        return isPrimaryKey;

    }



    public void setIsPrimaryKey(Boolean isPrimaryKey) {

        this.isPrimaryKey = isPrimaryKey;

    }



    public Boolean getIsForeignKey() {

        return isForeignKey;

    }



    public void setIsForeignKey(Boolean isForeignKey) {

        this.isForeignKey = isForeignKey;

    }



    public String getColumnLength() {

        return columnLength;

    }



    public void setColumnLength(String columnLength) {

        this.columnLength = columnLength;

    }



    public String getShowName() {

        return showName;

    }



    public void setShowName(String showName) {

        this.showName = showName;

    }



    public String getFullJdbcType() {

        return fullJdbcType;

    }



    public void setFullJdbcType(String fullJdbcType) {

        this.fullJdbcType = fullJdbcType;

    }

    public String getIsAllowNull() {

        return isAllowNull;

    }



    public void setIsAllowNull(String isAllowNull) {

        this.isAllowNull = isAllowNull;

    }



    public String getIndexName() {

        return indexName;

    }



    public void setIndexName(String indexName) {

        this.indexName = indexName;

    }

}


 src/main/java/com/matrix/codeGeneration/model/TableClassModel.java

New file
@@ -0,0 +1,150 @@
package com.matrix.codeGeneration.model;



import java.util.ArrayList;

import java.util.List;



/**

 * 数据表和java的对应模型

 * 
 * @author Matrix-J

 *

 */

public class TableClassModel {



    /**

     * 类的中文名称

     */

    private String tableMemo;



    /**

     * 类名

     */

    private String className;

	
    /**

     * bean的名称

     */

    private String beanClassName;

	
    private String fullClassName;

	
    private String qualifiedClassName;



    /**

     * 表名

     */

    private String tableName;



    /**

     * 类的变量名称

     */

    private String classVariableName;

    /**

     * 主键

     */

    private PropertyColumn primaryKey;



    private List<PropertyColumn> mapping = new ArrayList<PropertyColumn>();

	
    /**

     * 展示到页面的字段个数 addByzhangheng

     */

    private Integer showCount;



    public TableClassModel() {

    }

  


    public String getTableName() {

        return tableName;

    }



    public void setTableName(String tableName) {

        this.tableName = tableName;

    }



    public String getClassName() {

        return className;

    }



    public void setClassName(String className) {

        this.className = className;

    }



    public List<PropertyColumn> getMapping() {

        return mapping;

    }



    public void setMapping(List<PropertyColumn> mapping) {

        this.mapping = mapping;

    }



    public PropertyColumn getPrimaryKey() {

        return primaryKey;

    }



    public void setPrimaryKey(PropertyColumn primaryKey) {

        this.primaryKey = primaryKey;

    }

 


    public String getClassVariableName() {

        return classVariableName;

    }



    public void setClassVariableName(String classVariableName) {

        this.classVariableName = classVariableName;

    }



	 


    public String getTableMemo() {

        return tableMemo;

    }



    public void setTableMemo(String tableMemo) {

        this.tableMemo = tableMemo;

    }





    public String getBeanClassName() {

        return beanClassName;

    }





    public void setBeanClassName(String beanClassName) {

        this.beanClassName = beanClassName;

    }





    public String getFullClassName() {

        return fullClassName;

    }





    public void setFullClassName(String fullClassName) {

        this.fullClassName = fullClassName;

    }





    public String getQualifiedClassName() {

        return qualifiedClassName;

    }





    public void setQualifiedClassName(String qualifiedClassName) {

        this.qualifiedClassName = qualifiedClassName;

    }





    public Integer getShowCount() {

        return showCount;

    }





    public void setShowCount(Integer showCount) {

        this.showCount = showCount;

    }



	
}


 src/main/java/com/matrix/codeGeneration/model/TypeHandle.java

New file
@@ -0,0 +1,9 @@
package com.matrix.codeGeneration.model;

/**

 * 类型处理器

 * @author Matrix-j

 *

 */

public interface TypeHandle {



}


 src/main/java/com/matrix/codeGeneration/plugin/DateUtils.java

New file
@@ -0,0 +1,557 @@
package com.matrix.codeGeneration.plugin;



import java.sql.Timestamp;

import java.text.DateFormat;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Calendar;

import java.util.Date;

import java.util.List;



/**

 * 日期格式化，转换工具类

 * 
 * @author 姜友瑶

 * @createTime 2014.08.30

 */

public class DateUtils {





    public static final String DATE_FORMAT_SS = "yyyy-MM-dd HH:mm:ss";



    public static final String DATE_FORMAT_MONGO = "yyyy-MM-dd'T'HH:mm:ss.SSS";



    public static final String DATE_FORMAT_STS = "yyyy-MM-dd'T'HH:mm:ss";



    public static final String DATE_FORMAT_MM = "yyyy-MM-dd HH:mm";



    public static final String DATE_FORMAT_HH = "yyyy-MM-dd HH";



    public static final String DATE_FORMAT_DD = "yyyy-MM-dd";



    public static final String DATE_FORMAT_SPLITE_DD = "yyyy.MM.dd";



    public static final String DATE_FORMAT_NO_SPLITE_DD = "yyyyMMdd";



    public static final String DATE_FORMAT_MM_NO_DD = "yyyyMM";



    public static final String DATE_FORMAT_NO_SPLITE_MM = "yyyyMMddHHmm";



    public static final String DATE_FORMAT_NO_SPLITE_MM_HH = "yyyyMMddHH";



    public static final String YEAR = "yyyy";



    public static final String DATE_FORMAT_MMDD = "M月d日";



    public static final String DATE_FORMAT_WEEK = "星期";



    public static final String DATE_TIME_MORNING = "早上";



    public static final String DATE_TIME_AFTERNOON = "下午";



    public static final String DATE_TIME_NIGHT = "晚上";



    public static final String CENTRE_SCRIBING = "-";



    protected static final String EMPTY = "";



    protected static final String ZERO = "0";



    protected static final String SPLITE_CHAR = ":";



    protected static final String START_TIME = " 00:00:00";// 空格不能删除



    protected static final String END_TIME = " 23:59:59";// 空格不能删除



    protected static final int WEEK_DAYS = 7;



    public static String yyyy_MM_dd_HH_mm_ss = "yyyy-MM-dd HH:mm:ss";



    protected static final String[] weeks = { "一", "二", "三", "四", "五", "六", "日" };



    /**

     * 返回年份

     * 
     * @param date

     *            日期

     * @return 返回年份

     */

    public static int getYear(java.util.Date date) {



        try {

            java.util.Calendar c = java.util.Calendar.getInstance();

            c.setTime(date);

            return c.get(java.util.Calendar.YEAR);

        } catch (Exception e) {

        }



        return 0;

    }



    /**

     * 返回月份

     * 
     * @param date

     *            日期

     * @return 返回月份

     */

    public static int getMonth(java.util.Date date) {



        try {

            java.util.Calendar c = java.util.Calendar.getInstance();

            c.setTime(date);

            return c.get(java.util.Calendar.MONTH) + 1;

        } catch (Exception e) {

			
        }

        return 0;

    }



    /**

     * 日期转字符串

     * 
     * @param date

     * @param format

     * @return

     */

    public static String dateToString(Date date, String format) {



        if (date == null) {

            return EMPTY;

        }

        DateFormat fmt = new SimpleDateFormat(format);

        return fmt.format(date);

    }



    /**

     * 字符串转日期

     * 
     * @param dateStr

     * @param format

     * @return

     */

    public static Date stringToDate(String dateStr, String format) {



        DateFormat fmt = new SimpleDateFormat(format);

        try {

            return fmt.parse(dateStr);

        } catch (ParseException e) {

			
        }

        return null;

    }

 


    /**

     * 判断给定的日期是一周中的第几天，注意：按照中国的习惯，周日是第七天

     * 
     * @param date

     * @return

     */

    public static int dateToWeek(Date date) {



        if (date == null) {

            return 0;

        }



        Calendar cal = Calendar.getInstance();

        cal.setTime(date);

        if (cal.get(Calendar.DAY_OF_WEEK) == 1) {

            return 7;

        } else {

            return cal.get(Calendar.DAY_OF_WEEK) - 1;

        }

    }



    public static String dateOfWeek(Date date) {



        return DATE_FORMAT_WEEK + weeks[dateToWeek(date) - 1];

    }



    /**

     * 指定时间的下一天

     * 
     * @param date

     * @return

     */

    public static Date nextDate(Date date) {



        if (date == null) {

            return date;

        }



        Calendar cal = Calendar.getInstance();

        try {

            cal.setTime(date);

            cal.add(Calendar.DATE, 1);

            return cal.getTime();

        } catch (Exception e) {

			
        }



        return null;

    }



    /**

     * 指定时间的前一天

     * 
     * @param date

     * @return

     */

    public static Date previousDate(Date date) {



        if (date == null) {

            return date;

        }



        Calendar cal = Calendar.getInstance();

        try {

            cal.setTime(date);

            cal.add(Calendar.DATE, -1);

            return cal.getTime();

        } catch (Exception e) {

			
        }



        return null;

    }



    /**

     * 指定时间的下N天

     * 
     * @param date

     * @return

     */

    public static Date nextNDate(Date date, int nDay) {



        if (date == null) {

            return date;

        }



        Calendar cal = Calendar.getInstance();

        try {

            cal.setTime(date);

            cal.add(Calendar.DATE, nDay);

            return cal.getTime();

        } catch (Exception e) {

			
        }



        return null;

    }



    /**

     * 指定时间的前N天

     * 
     * @param date

     * @return

     */

    public static Date previousNDate(Date date, int nDay) {



        if (date == null) {

            return date;

        }



        Calendar cal = Calendar.getInstance();

        try {

            cal.setTime(date);

            cal.add(Calendar.DATE, -nDay);

            return cal.getTime();

        } catch (Exception e) {

			
        }



        return null;

    }



    /**

     * 获取一天的起始时间

     * 
     * @param date

     * @return

     */

    public static Date getStartDate(Date date) {



        if (date == null) {

            return date;

        }



        DateFormat fmt = new SimpleDateFormat(DATE_FORMAT_DD);

        String dateStr = fmt.format(date);

        dateStr = dateStr + START_TIME;

        fmt = new SimpleDateFormat(DATE_FORMAT_SS);

        try {

            return fmt.parse(dateStr);

        } catch (ParseException e) {

			
        }



        return date;

    }



    /**

     * 获取一天的结束时间

     * 
     * @param date

     * @return

     */

    public static Date getEndDate(Date date) {



        if (date == null) {

            return date;

        }



        DateFormat fmt = new SimpleDateFormat(DATE_FORMAT_DD);

        String dateStr = fmt.format(date);

        dateStr = dateStr + END_TIME;

        fmt = new SimpleDateFormat(DATE_FORMAT_SS);

        try {

            return fmt.parse(dateStr);

        } catch (ParseException e) {

			
        }



        return date;

    }



    /**

     * currentDat是否在referenceDate日期之前

     * 
     * @param referenceDate

     * @param currentDat

     * @return

     */

    public static boolean isBeforeDate(Date referenceDate, Date currentDate) {



        if (currentDate == null) {

            return false;

        }

        if (referenceDate == null) {

            return true;

        }

        return currentDate.before(referenceDate);

    }



    /**

     * currentDat是否在referenceDate日期之后

     * 
     * @param referenceDate

     * @param currentDat

     * @return

     */

    public static boolean isAffterDate(Date referenceDate, Date currentDate) {



        if (currentDate == null) {

            return false;

        }

        if (referenceDate == null) {

            return true;

        }

        return currentDate.after(referenceDate);

    }



    /**

     * 判断currentDate是否在startDate和endDate之间，不包括startDate和endDate

     * 
     * @param startDate

     * @param endDate

     * @param currentDate

     * @return

     */

    public static boolean isDuringDate(Date startDate, Date endDate, Date currentDate) {



        if (currentDate == null) {

            return false;

        }



        if (isAffterDate(startDate, currentDate) && isBeforeDate(endDate, currentDate)) {

            return true;

        }

        return false;

    }



	 


    /**

     * 获取startDate到endDate之间的星期day（中文星期）不包括startDate和endDate

     * 
     * @param startDate

     * @param endDate

     * @param day

     * @return

     */

    public static List<Date> findDayDuringDate(Date startDate, Date endDate, int day) {



        List<Date> listDate = new ArrayList<Date>();

        int startDay = dateToWeek(startDate);



        Date date = null;

        if (startDay == day) {

            date = nextNDate(startDate, WEEK_DAYS);

        } else {

            date = nextNDate(startDate, day - startDay);

        }

        while (isDuringDate(startDate, endDate, date)) {

            listDate.add(date);

            date = nextNDate(date, WEEK_DAYS);

        }



        return listDate;

    }



	 


    /**

     * date转换成Timestamp

     * 
     * @param date

     * @param format

     * @return

     */

    public static Timestamp dateToTimestamp(Date date, String format) {



        if (date == null) {

            return null;

        }



        format = DATE_FORMAT_SS;



        DateFormat fmt = new SimpleDateFormat(format);



        return Timestamp.valueOf(fmt.format(date));

    }



    /**

     * 获取早中晚

     * 
     * @param time

     * @return

     */

    public static String getDateTime(int time) {



        // 早上

        if (time == 1) {

            return DateUtils.DATE_TIME_MORNING;

        }

        // 下午

        else if (time == 2) {

            return DateUtils.DATE_TIME_AFTERNOON;

        }

        // 晚上

        else if (time == 3) {

            return DateUtils.DATE_TIME_NIGHT;

        }

        return null;

    }



    /**

     * 获取早中晚的开始时间

     * 
     * @param date

     * @param time

     * @return

     */

    public static Date getMeetTimeStart(String date, int time) {



        // 早上

        if (time == 1) {

            return DateUtils.stringToDate(date + " 06:00", DateUtils.DATE_FORMAT_MM);

        }

        // 下午

        else if (time == 2) {

            return DateUtils.stringToDate(date + " 13:00", DateUtils.DATE_FORMAT_MM);

        }

        // 晚上

        else if (time == 3) {

            return DateUtils.stringToDate(date + " 19:00", DateUtils.DATE_FORMAT_MM);

        }

        return null;

    }



    /**

     * 获取早中晚的结束时间

     * 
     * @param date

     * @param time

     * @return

     */



    public static Date getMeetTimeEnd(String date, int time) {

        // 早上

        if (time == 1) {

            return DateUtils.stringToDate(date + " 13:00", DateUtils.DATE_FORMAT_MM);

        }

        // 下午

        else if (time == 2) {

            return DateUtils.stringToDate(date + " 19:00", DateUtils.DATE_FORMAT_MM);

        }

        // 晚上

        else if (time == 3) {

            return DateUtils.stringToDate(date + " 23:00", DateUtils.DATE_FORMAT_MM);

        }

        return null;

    }



    /**

     * 得到几天前的时间

     * 
     * @param d

     * @param day

     * @return

     */

    public static Timestamp getDateBefore(Date d, int day) {

        Calendar now = Calendar.getInstance();

        now.setTime(d);

        now.set(Calendar.DATE, now.get(Calendar.DATE) - day);

        return new Timestamp(now.getTime().getTime());

    }



    /**

     * 得到几天后的时间

     * 
     * @param d

     * @param day

     * @return

     */

    public static Timestamp getDateAfter(Date d, int day) {

        Calendar now = Calendar.getInstance();

        now.setTime(d);

        now.set(Calendar.DATE, now.get(Calendar.DATE) + day);

        return new Timestamp(now.getTime().getTime());

    }



    /**

     * 将日期类型格式化成字符串

     * 
     * @param date

     * @return 格式化后日期字符串

     * @throws ParseException

     */

    public static String dateFormatStr(Date date, String dateStyle) {

        String dateStr = null;

        if (date != null) {

            SimpleDateFormat sdf = new SimpleDateFormat(dateStyle);

            dateStr = sdf.format(date);

        }

        return dateStr;

    }



    /**

     * 获取时间戳

     * 
     * @return

     */

    public static String getTimeMark() {

        Calendar c = Calendar.getInstance();

        int year = c.get(Calendar.YEAR);

        int mouth = c.get(Calendar.MONTH);

        int day = c.get(Calendar.DAY_OF_MONTH);

        int hour = c.get(Calendar.HOUR_OF_DAY);

        int minute = c.get(Calendar.MINUTE);

        int second = c.get(Calendar.SECOND);

        int haomiao = c.get(Calendar.MILLISECOND);

        return "" + year + mouth + day + hour + minute + second + haomiao;

    }



}


 src/main/java/com/matrix/codeGeneration/plugin/ExcelImport.java

New file
@@ -0,0 +1,326 @@
package com.matrix.codeGeneration.plugin;



import java.io.File;

import java.io.FileInputStream;

import java.io.IOException;

import java.text.DecimalFormat;

import java.text.SimpleDateFormat;

import java.util.HashMap;

import java.util.LinkedList;

import java.util.List;

import java.util.Map;



import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFDateUtil;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;



/**

 * excel导入（根据需求调用03/07版本方法导入）

 * 
 * @ClassName: ExcelImport

 * @Description: TODO

 * @author 肖崇高 xiaochonggao@zkingsoft.com

 * @date 2016年8月2日 上午10:39:04

 *

 */

public class ExcelImport {

    /**

     * 对外提供读取excel 的方法

     */

    public static List<List<Object>> readExcel(File file, String fileName, Integer rowNum, Integer cellNum)

            throws IOException {

        String extension = fileName.lastIndexOf(".") == -1 ? "" : fileName.substring(fileName.lastIndexOf(".") + 1);

        if ("xls".equals(extension)) {

            return read2003Excel(file, rowNum, cellNum);

        } else if ("xlsx".equals(extension)) {

            return read2007Excel(file, rowNum, cellNum);

        } else {

            throw new IOException("不支持的文件类型");

        }

    }



    /**

     * 
     * @Title: read2003Excel @Description: TODO @param @param file

     *         待读取的文件 @param @param rowNum 行数 @param @param cellNum

     *         列数 @param @return @param @throws IOException 设定文件 @return

     *         List<List<Object>> 返回类型 Object:单元格对象 List<Object>:行对象

     *         List<List<Object>>:整个excel对象 @throws

     */

    private static List<List<Object>> read2003Excel(File file, Integer rowNum, Integer cellNum) throws IOException {

        List<List<Object>> list = new LinkedList<List<Object>>();

        HSSFWorkbook hwb = new HSSFWorkbook(new FileInputStream(file));

        HSSFSheet sheet = hwb.getSheetAt(0);

        Object value = null;

        HSSFRow row = null;

        HSSFCell cell = null;

        Integer rowsNum = 0;// 读取的行数

        Integer cellsNum = 0;// 读取的列数

        if (rowNum != null) {

            rowsNum = rowNum;

        } else {

            rowsNum = sheet.getPhysicalNumberOfRows();

        }

        for (int i = sheet.getFirstRowNum(); i <= rowsNum; i++) {

            row = sheet.getRow(i);

            if (row == null) {

                continue;

            }

            if (row.getFirstCellNum() < 0) {

                continue;

            }

            List<Object> linked = new LinkedList<Object>();

            if (cellNum != null) {

                cellsNum = cellNum;

            } else {

                cellsNum = (int) row.getLastCellNum();

            }

            for (int j = 0; j <= cellsNum; j++) {// row.getFirstCellNum()

                cell = row.getCell(j);

                if (cell == null) {

                    value = null;

                } else {

                    DecimalFormat df = new DecimalFormat("0");// 格式化 number

                                                                // String

                    // 字符

                    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");// 格式化日期字符串

                    DecimalFormat nf = new DecimalFormat("0.00");// 格式化数字

                    switch (cell.getCellType()) {

                    case XSSFCell.CELL_TYPE_STRING:

                        value = cell.getStringCellValue();

                        break;

                    case XSSFCell.CELL_TYPE_NUMERIC:

                        if ("@".equals(cell.getCellStyle().getDataFormatString())) {

                            value = df.format(cell.getNumericCellValue());

                        } else if ("General".equals(cell.getCellStyle().getDataFormatString())) {

                            value = nf.format(cell.getNumericCellValue());

                        } else {

                            value = sdf.format(HSSFDateUtil.getJavaDate(cell.getNumericCellValue()));

                        }

                        break;

                    case XSSFCell.CELL_TYPE_BOOLEAN:

                        value = cell.getBooleanCellValue();

                        break;

                    case XSSFCell.CELL_TYPE_BLANK:

                        value = "";

                        break;

                    default:

                        value = cell.toString();

                    }

                }

                linked.add(value);

            }

            list.add(linked);

        }

        return list;

    }



    /**

     * 
     * @Title: read2007Excel @Description: TODO @param @param file

     *         待读取的文件 @param @param rowNum 行数 @param @param cellNum

     *         列数 @param @return @param @throws IOException 设定文件 @return

     *         List<List<Object>> 返回类型 Object:单元格对象 List<Object>:行对象

     *         List<List<Object>>:整个excel对象 @throws

     */

    private static List<List<Object>> read2007Excel(File file, Integer rowNum, Integer cellNum) throws IOException {

        List<List<Object>> list = new LinkedList<List<Object>>();

        // 构造 XSSFWorkbook 对象，strPath 传入文件路径

        XSSFWorkbook xwb = new XSSFWorkbook(new FileInputStream(file));

        // 读取第一章表格内容

        XSSFSheet sheet = xwb.getSheetAt(0);

        Object value = null;

        XSSFRow row = null;

        XSSFCell cell = null;

        Integer rowsNum = 0;// 读取的行数

        Integer cellsNum = 0;// 读取的列数

        if (rowNum != null) {

            rowsNum = rowNum;

        } else {

            rowsNum = sheet.getPhysicalNumberOfRows();

        }

        for (int i = sheet.getFirstRowNum(); i <= rowsNum; i++) {

            row = sheet.getRow(i);

            if (row == null) {

                continue;

            }

            if (row.getFirstCellNum() < 0) {

                continue;

            }

            if (cellNum != null) {

                cellsNum = cellNum;

            } else {

                cellsNum = (int) row.getLastCellNum();

            }

            List<Object> linked = new LinkedList<Object>();

            for (int j = 0; j <= cellsNum; j++) {

                cell = row.getCell(j);

                if (cell == null) {

                    value = null;

                } else {

                    DecimalFormat df = new DecimalFormat("0");// 格式化 number

                                                                // String

                    // 字符

                    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");// 格式化日期字符串

                    DecimalFormat nf = new DecimalFormat("0.00");// 格式化数字

                    switch (cell.getCellType()) {

                    case XSSFCell.CELL_TYPE_STRING:

                        value = cell.getStringCellValue();

                        break;

                    case XSSFCell.CELL_TYPE_NUMERIC:

                        if ("@".equals(cell.getCellStyle().getDataFormatString())) {

                            value = df.format(cell.getNumericCellValue());

                        } else if ("General".equals(cell.getCellStyle().getDataFormatString())) {

                            value = nf.format(cell.getNumericCellValue());

                        } else {

                            value = sdf.format(HSSFDateUtil.getJavaDate(cell.getNumericCellValue()));

                        }

                        break;

                    case XSSFCell.CELL_TYPE_BOOLEAN:

                        value = cell.getBooleanCellValue();

                        break;

                    case XSSFCell.CELL_TYPE_BLANK:

                        value = "";

                        break;

                    default:

                        value = cell.toString();

                    }

                }

                linked.add(value);

            }

            list.add(linked);

        }

        return list;

    }



    /**

     * 
     * @Title: getCellValue @Description: TODO 获取某个单元格数据 @param @param

     *         cell @param @return @param @throws Exception 设定文件 @return Object

     *         返回类型 @throws

     */

    public static Object getCellValue(HSSFCell cell) throws Exception {

        Object value = null;

        if (cell != null) {

            DecimalFormat df = new DecimalFormat("0");// 格式化

            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");// 格式化日期字符串

            DecimalFormat nf = new DecimalFormat("0.00");// 格式化数字

            switch (cell.getCellType()) {

            case XSSFCell.CELL_TYPE_STRING:

                value = cell.getStringCellValue();

                break;

            case XSSFCell.CELL_TYPE_NUMERIC:

                if ("@".equals(cell.getCellStyle().getDataFormatString())) {

                    value = df.format(cell.getNumericCellValue());

                } else if ("General".equals(cell.getCellStyle().getDataFormatString())) {

                    value = nf.format(cell.getNumericCellValue());

                } else {

                    value = sdf.format(HSSFDateUtil.getJavaDate(cell.getNumericCellValue()));

                }

                break;

            case XSSFCell.CELL_TYPE_BOOLEAN:

                value = cell.getBooleanCellValue();

                break;

            case XSSFCell.CELL_TYPE_BLANK:

                value = "";

                break;

            default:

                value = cell.toString();

            }

        }

        return value;

    }



    /**

     * 
     * @Title: read2007Excel @Description: TODO @param @param file

     *         待读取的文件 @param @param rowNum 行数 @param @param cellNum

     *         列数 @param @return @param @throws IOException 设定文件 @return

     *         List<List<Object>> 返回类型 Object:单元格对象 List<Object>:行对象

     *         List<List<Object>>:整个excel对象 @throws

     */

    public static Map<String, List<List<Object>>> read2007ExcelAllShell(File file, Integer rowNum, Integer cellNum)

            throws IOException {



        Map<String, List<List<Object>>> resultSheet = new HashMap<String, List<List<Object>>>();



        // 构造 XSSFWorkbook 对象，strPath 传入文件路径

        XSSFWorkbook xwb = new XSSFWorkbook(new FileInputStream(file));

        for (int i = 0; i < xwb.getNumberOfSheets(); i++) {

            List<List<Object>> list = new LinkedList<List<Object>>();

            XSSFSheet sheet = xwb.getSheetAt(i);

            String sheetName = sheet.getSheetName();

            System.out.println("读取第" + i + "章表格内容->" + sheetName);//

            Object value = null;

            XSSFRow row = null;

            XSSFCell cell = null;

            Integer rowsNum = 0;// 读取的行数

            Integer cellsNum = 0;// 读取的列数

            if (rowNum != null) {

                rowsNum = rowNum;

            } else {

                rowsNum = sheet.getPhysicalNumberOfRows();

            }

            for (int j = sheet.getFirstRowNum(); j <= rowsNum; j++) {

                row = sheet.getRow(j);

                if (row == null) {

                    continue;

                }

                if (row.getFirstCellNum() < 0) {

                    continue;

                }

                if (cellNum != null) {

                    cellsNum = cellNum;

                } else {

                    cellsNum = (int) row.getLastCellNum();

                }

                List<Object> linked = new LinkedList<Object>();

                for (int k = 0; k <= cellsNum; k++) {

                    cell = row.getCell(k);

                    if (cell == null) {

                        value = null;

                    } else {

                        DecimalFormat df = new DecimalFormat("0");// 格式化 number

                                                                    // String

                        // 字符

                        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");// 格式化日期字符串

                        DecimalFormat nf = new DecimalFormat("0.00");// 格式化数字

                        switch (cell.getCellType()) {

                        case XSSFCell.CELL_TYPE_STRING:

                            value = cell.getStringCellValue();

                            break;

                        case XSSFCell.CELL_TYPE_NUMERIC:

                            if ("@".equals(cell.getCellStyle().getDataFormatString())) {

                                value = df.format(cell.getNumericCellValue());

                            } else if ("General".equals(cell.getCellStyle().getDataFormatString())) {

                                value = nf.format(cell.getNumericCellValue());

                            } else {

                                value = sdf.format(HSSFDateUtil.getJavaDate(cell.getNumericCellValue()));

                            }

                            break;

                        case XSSFCell.CELL_TYPE_BOOLEAN:

                            value = cell.getBooleanCellValue();

                            break;

                        case XSSFCell.CELL_TYPE_BLANK:

                            value = "";

                            break;

                        default:

                            value = cell.toString();

                        }

                    }

                    linked.add(value);

                }

                list.add(linked);

            }

            resultSheet.put(sheetName, list);

        }



        return resultSheet;

    }

}


 src/main/resources/config/code-generation.xml

New file
@@ -0,0 +1,157 @@
<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

       xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"

       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

       xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd

    http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd 
    http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd">



    <!-- 根据需要调整注入的outDataSource -->



    <!-- EXCEL 构建代码 -->

    <bean id="outDataSource" class="com.matrix.codeGeneration.ext.ExcelDataSource">

        <property name="author" value="yourName"></property>

        <!-- excel所在目录 -->

        <property name="sourcePath" value="E:\生成代码" />

        <!-- 数据库类型 -->

        <property name="dbType" value="mysql" />

        <!-- 目标代码位置 -->

        <property name="targetPath" value="E:\生成代码" />

        <!-- 模板文件位置 -->

        <property name="userTempLataHome" value="template/excelTemplateForBoot" />

        <!-- <property name="userTempLataHome" value="template/excelTemplate" /> -->

        <property name="nameConvert">

            <bean class="com.matrix.codeGeneration.ext.OracleStyleNameConvert"></bean>

        </property>

        <!-- 配置需要生成的文件 -->

        <property name="codeModels">

            <map>

                <entry key="JAVA_BEAN" value-ref="javaBean" />

                <entry key="MYSQL_SQL" value-ref="mysqlModel" />

                <entry key="MYBATIS_DAO" value-ref="mybatisDao" />

                <entry key="MYBATIS_DAO_IMPL" value-ref="mybatisDaoImpl" />

                <!-- <entry key="SERVICE" value-ref="service" /> -->

                <!-- <entry key="SERVICE_IMPL" value-ref="serviceImpl" /> -->

                <entry key="ACTION" value-ref="action" />

                <entry key="LIST" value-ref="list" />

                <entry key="FORM" value-ref="form" />

            </map>

        </property>

    </bean>

    <!-- 生成文件模型相关配置 -->

    <bean id="mysqlModel" class="com.matrix.codeGeneration.ext.Matrix4Models">

        <!-- javaBean类型 -->

        <property name="modelName" value="MYSQL_SQL" />

        <!-- 包名 -->

        <property name="packageName" value="sql" />

        <!-- 文件后缀名称 -->

        <property name="fileExtName" value=".sql" />

        <!-- 对应的framwork模板文件名称 -->

        <property name="templateName" value="sqlFile.ftl" />

    </bean>

    <!-- 生成文件模型相关配置 -->

    <bean id="javaBean" class="com.matrix.codeGeneration.ext.Matrix4Models">

        <!-- javaBean类型 -->

        <property name="modelName" value="JAVA_BEAN" />

        <!-- 包名 -->

        <property name="packageName" value="com.xincheng.biz2.bean" />

        <!-- 文件后缀名称 -->

        <property name="fileExtName" value=".java" />

        <!-- 对应的framwork模板文件名称 -->

        <property name="templateName" value="javaBean.ftl" />



    </bean>



    <bean id="mybatisDao" class="com.matrix.codeGeneration.ext.Matrix4Models">

        <!-- dao接口类型 -->

        <property name="modelName" value="MYBATIS_DAO" />

        <!-- 包名 -->

        <property name="packageName" value="com.xincheng.biz2.dao" />

        <!-- 文件后缀名称 -->

        <property name="fileExtName" value=".java" />

        <!-- 对应的framwork模板文件名称 -->

        <property name="templateName" value="dao.ftl" />

        <!-- 类名称后缀 -->

        <property name="suffixName" value="Dao" />

    </bean>



    <bean id="mybatisDaoImpl" class="com.matrix.codeGeneration.ext.Matrix4Models">

        <!-- dao接口类型 -->

        <property name="modelName" value="MYBATIS_DAO_IMPL" />

        <!-- 包名 -->

        <property name="packageName" value="com.xincheng.biz2.dao" />

        <!-- 文件后缀名称 -->

        <property name="fileExtName" value=".xml" />

        <!-- 对应的framwork模板文件名称 -->

        <property name="templateName" value="daoImpl.ftl" />

        <!-- 类名称后缀 -->

        <property name="suffixName" value="Dao" />

    </bean>



    <bean id="service" class="com.matrix.codeGeneration.ext.Matrix4Models">

        <!-- dao接口类型 -->

        <property name="modelName" value="SERVICE" />

        <!-- 包名 -->

        <property name="packageName" value="com.xincheng.biz2.service" />

        <!-- 文件后缀名称 -->

        <property name="fileExtName" value=".java" />

        <!-- 对应的framwork模板文件名称 -->

        <property name="templateName" value="service.ftl" />

        <!-- 类名称后缀 -->

        <property name="suffixName" value="Service" />

    </bean>



    <bean id="serviceImpl" class="com.matrix.codeGeneration.ext.Matrix4Models">

        <!-- dao接口类型 -->

        <property name="modelName" value="SERVICE_IMPL" />

        <!-- 包名 -->

        <property name="packageName" value="com.xincheng.biz2.service.impl" />

        <!-- 文件后缀名称 -->

        <property name="fileExtName" value=".java" />

        <!-- 对应的framwork模板文件名称 -->

        <property name="templateName" value="serviceImpl.ftl" />

        <!-- 类名称后缀 -->

        <property name="suffixName" value="ServiceImpl" />

    </bean>



    <bean id="action" class="com.matrix.codeGeneration.ext.Matrix4Models">

        <!-- dao接口类型 -->

        <property name="modelName" value="ACTION" />

        <!-- 包名 -->

        <property name="packageName" value="com.xincheng.biz2.action" />

        <!-- 文件后缀名称 -->

        <property name="fileExtName" value=".java" />

        <!-- 对应的framwork模板文件名称 -->

        <property name="templateName" value="action.ftl" />

        <!-- 类名称后缀 -->

        <property name="suffixName" value="Action" />



    </bean>

    <bean id="list" class="com.matrix.codeGeneration.ext.Matrix4Models">

        <!-- dao接口类型 -->

        <property name="modelName" value="LIST" />

        <!-- 包名 -->

        <property name="packageName" value="com.xincheng.biz2.html" />

        <!-- 文件后缀名称 -->

        <property name="fileExtName" value=".html" />

        <!-- 对应的framwork模板文件名称 -->

        <property name="templateName" value="list.ftl" />

        <!-- 类名称后缀 -->

        <property name="suffixName" value="-list" />



    </bean>

    <bean id="form" class="com.matrix.codeGeneration.ext.Matrix4Models">

        <!-- dao接口类型 -->

        <property name="modelName" value="FORM" />

        <!-- 包名 -->

        <property name="packageName" value="com.xincheng.biz2.html" />

        <!-- 文件后缀名称 -->

        <property name="fileExtName" value=".html" />

        <!-- 对应的framwork模板文件名称 -->

        <property name="templateName" value="form.ftl" />

        <!-- 类名称后缀 -->

        <property name="suffixName" value="-form" />



    </bean>



</beans>

 src/main/resources/template/excelTempLateCopy/action.ftl

New file
@@ -0,0 +1,122 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>	


/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

@Controller

@RequestMapping(value = "admin/${tableClassModel.classVariableName}")

public class ${ClassName} {



    @Autowired

    private ${tableClassModel.className}Dao ${tableClassModel.classVariableName}Dao;

	
    //记录编辑前的值Before_Edit_Value

    public static final String BEV="${tableClassModel.className}_BEV";

	
	
    /**

     * 列表显示

     */

    @RequestMapping(value =  "/showList")

    public @ResponseBody AjaxResult showList(${tableClassModel.className} ${tableClassModel.classVariableName}, PaginationVO pageVo) {

        if (pageVo == null) {

            pageVo = new PaginationVO();

        }

        List<${tableClassModel.className}> dataList = ${tableClassModel.classVariableName}Dao.selectInPage(${tableClassModel.classVariableName}, pageVo);

        AjaxResult result = new AjaxResult(AjaxResult.STATUS_SUCCESS, dataList,

                ${tableClassModel.classVariableName}Dao.selectTotalRecord(${tableClassModel.classVariableName}));

        return result;

    }

   	
    /**

     * 新增

     */   
    @RemoveRequestToken	
       @RequestMapping(value =  "/add${tableClassModel.className}")

    public @ResponseBody AjaxResult add${tableClassModel.className}(${tableClassModel.className} ${tableClassModel.classVariableName}) {

        SysUsers user = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY);

        ${tableClassModel.classVariableName}.set${tableClassModel.primaryKey.property?cap_first}(UUIDUtil.getRandomID());

        ${tableClassModel.classVariableName}.setCreateBy(user.getSuName());

        ${tableClassModel.classVariableName}.setUpdateBy(user.getSuName());

         int i=${tableClassModel.classVariableName}Dao.insert(${tableClassModel.classVariableName});

         if(i > 0){

             return new AjaxResult(AjaxResult.STATUS_SUCCESS, SystemMessageCode.ADD_SUCCES, "${tableClassModel.tableMemo}");

         }else {

            throw new GlobleException(SystemErrorCode.DATA_ADD_FAIL);

        }

    }

	
	
	
	
	
    /**

     * 修改

     */   
    @RemoveRequestToken	
       @RequestMapping(value =  "/modify${tableClassModel.className}")

    public @ResponseBody AjaxResult modify${tableClassModel.className}(${tableClassModel.className} new${tableClassModel.className}) {

           ${tableClassModel.className} old${tableClassModel.className} = WebUtil.getSessionAttribute(BEV);

        int i = 0;

        Map<String, Object> modifyMap = null;

        try {

            if (!ModelUtils.isModified(old${tableClassModel.className}, new${tableClassModel.className})) {

                i = MatrixConstance.DML_SUCCESSS;

            }

            modifyMap = ModelUtils.comparePojo2Map(old${tableClassModel.className}, new${tableClassModel.className});

        } catch (Exception e) {

            throw new GlobleException(SystemErrorCode.DATA_UPDATE_FAIL, e, new${tableClassModel.className});

        }

        if (modifyMap.size() > 0) {

            modifyMap.put("${tableClassModel.primaryKey.property}", old${tableClassModel.className}.get${tableClassModel.primaryKey.property?cap_first}());

            ${tableClassModel.classVariableName}Dao.updateByMap(modifyMap);

        }

        i = MatrixConstance.DML_SUCCESSS;

        WebUtil.removeSessionAttribute(BEV);

        if (i > 0) {

            return new AjaxResult(AjaxResult.STATUS_SUCCESS, SystemMessageCode.UPDATE_SUCCES, "${tableClassModel.tableMemo}");

        } else {

            throw new GlobleException(SystemErrorCode.DATA_UPDATE_FAIL);

        }

    }

	
	
	
	
       /**

     * 进入修改界面

     */   
    @SaveRequestToken

       @RequestMapping(value =  "/editForm")

    public String editForm(${tableClassModel.primaryKey.classType} id) {

        ${tableClassModel.className} ${tableClassModel.classVariableName};

        if (id != null) {

            ${tableClassModel.classVariableName} = ${tableClassModel.classVariableName}Dao.selectById(id);

            WebUtil.getRequest().setAttribute("obj", ${tableClassModel.classVariableName});

            WebUtil.setSessionAttribute(BEV, ${tableClassModel.classVariableName});

        }

        return "admin/${tableClassModel.className}-form";

    }

   	
   	
       /**

     * 删除

     */  
     @RequestMapping(value = "/del")

    public @ResponseBody AjaxResult del(String keys) {

        List<String> ids = StringUtils.strToCollToString(keys, ",");

        int i =  ${tableClassModel.classVariableName}Dao.deleteByIds(ids);

        if (i > 0) {

            return new AjaxResult(AjaxResult.STATUS_SUCCESS, SystemMessageCode.DELETE_SUCCES, i);

        } else {

            throw new GlobleException(SystemErrorCode.DATA_DELETE_FAIL);

        }

    }

  
}

 src/main/resources/template/excelTempLateCopy/dao.ftl

New file
@@ -0,0 +1,38 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>	


/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

public interface ${ClassName}{



    public int insert(@Param("item") ${tableClassModel.className} ${tableClassModel.classVariableName});

   	
       public int batchInsert(@Param("list") List<${tableClassModel.className}> ${tableClassModel.classVariableName}List);

   	
    public int updateByMap(Map<String, Object> modifyMap);

	
    public int updateByModel(@Param("record")${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public int deleteByIds(@Param("list") List<${tableClassModel.primaryKey.classType}> list);

	
    public int deleteById(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property});



    public int deleteByModel(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public List<${tableClassModel.className}> selectInPage(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName}, @Param("pageVo") PaginationVO pageVo);



    public List<${tableClassModel.className}> selectByModel(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public int selectTotalRecord(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public ${tableClassModel.className}  selectById(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property});

	
    public ${tableClassModel.className}  selectForUpdate(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property});

	
}

 src/main/resources/template/excelTempLateCopy/daoImpl.ftl

New file
@@ -0,0 +1,226 @@
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">



<mapper namespace="${tableClassModel.qualifiedClassName}">

    <!-- 定义${tableClassModel.className} 的复杂关联map -->

    <resultMap type="${beanQualifiedClassName}" id="${tableClassModel.className}Map">

        <id property="${tableClassModel.primaryKey.property}" column="${tableClassModel.primaryKey.column}" />

        <result property="createBy" column="create_by" />

        <result property="createTime" column="create_time" />

        <result property="updateBy" column="update_by" />

        <result property="updateTime" column="update_time" />

        <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <result property="${item.property}" column="${item.column}" />

            </#if>

        </#list>	
    </resultMap>

	
	
    <!-- 定义${tableClassModel.className} 的简单map  ，本map不添加其他的关联属性 -->

    <resultMap type="${beanQualifiedClassName}" id="${tableClassModel.className}SimpleMap">

        <id property="${tableClassModel.primaryKey.property}" column="${tableClassModel.primaryKey.column}" />

        <result property="createBy" column="create_by" />

        <result property="createTime" column="create_time" />

        <result property="updateBy" column="update_by" />

        <result property="updateTime" column="update_time" />

        <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <result property="${item.property}" column="${item.column}" />

            </#if>

        </#list>	
    </resultMap>

	
    <!-- 字段sql -->

    <sql id="columns">

        create_by,

        create_time,

        update_by,

        update_time,

        <#list tableClassModel.mapping as item> 
            <#if item_has_next>

            ${item.column},

            <#else>

            ${item.column}

            </#if>

        </#list>

    </sql>

	
    <!-- 属性sql -->

    <sql id="propertys">

        ${'#'}{item.createBy},

        now(),

        ${'#'}{item.updateBy},

        now(),

        <#list tableClassModel.mapping as propertyitem>

        <#if propertyitem_has_next>

            ${'#'}{item.${propertyitem.property}},

            <#else>

            ${'#'}{item.${propertyitem.property}}

            </#if>

        </#list>	
    </sql>

	
    <!-- where sql -->

    <sql id="where_sql">

		 
         <if test="record!=null">

            <#list tableClassModel.mapping as item> 
            <if test="(record.${item.property}!=null and record.${item.property}!='') or  (record.${item.property}!='' and record.${item.property}==0)  ">

                and ${item.column}  = ${'#'}{record.${item.property}} 
            </if>

            </#list>	
        </if>

		 
    </sql>

	
    <!--  插入方法   -->

    <insert id="insert" parameterType="${beanQualifiedClassName}"

        useGeneratedKeys="true" keyProperty="item.${tableClassModel.primaryKey.property}">

        INSERT INTO ${tableClassModel.tableName} (

             <include refid="columns"></include>

        )

    VALUES (

         <include refid="propertys"></include>

    )

    </insert>

	
	
	
    <!--  批量插入   -->

    <insert id="batchInsert" parameterType="java.util.List">

        INSERT INTO ${tableClassModel.tableName} (

        <include refid="columns"></include>	
        )

    VALUES 
    <foreach collection="list" item="item" index="index" separator=",">(

        <include refid="propertys"></include>	
    )</foreach>

    </insert>

	
	
	
	
	
    <!--  根据Map更新 部分更新   -->

    <update id="updateByMap" parameterType="java.util.HashMap" >

        UPDATE ${tableClassModel.tableName}

        <set>

            <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <if test="_parameter.containsKey('${item.property}')">

                    ${item.column} = ${'#'}{${item.property}},

                </if>		
            </#if>

            </#list>

        </set>

        WHERE ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.property}} 
    </update> 
	
	
    <!--  根据对象更新 部分更新   -->

    <update id="updateByModel" parameterType="${tableClassModel.primaryKey.classType}">

        UPDATE ${tableClassModel.tableName}

        <set>

            <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <#if item.classType = "String">

            <if test="record.${item.property} != null and record.${item.property} != '' ">

                ${item.column}  = ${'#'}{record.${item.property}}, 
            </if>

            <#else>

            <if test="record.${item.property} != null ">

                ${item.column}  = ${'#'}{record.${item.property}}, 
            </if>

            </#if>	
            </#if>

            </#list>

        </set>

        WHERE ${tableClassModel.primaryKey.column}=${'#'}{record.${tableClassModel.primaryKey.property}} 
    </update>

	
    <!-- 批量删除 -->

    <delete id="deleteByIds" parameterType="java.util.List">

        delete from ${tableClassModel.tableName} where  ${tableClassModel.primaryKey.column} in

        <foreach collection="list" index="index" item="item" open="("

            separator="," close=")">

            ${'#'}{item}

        </foreach>

    </delete>

		
    <!-- 根据id删除-->

    <delete id="deleteById" parameterType="${tableClassModel.primaryKey.classType}">

        DELETE FROM ${tableClassModel.tableName}

        where  ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.property}} 
    </delete>

	
    <!-- 根据对象删除-->

    <delete id="deleteByModel" parameterType="${beanQualifiedClassName}">

        DELETE FROM ${tableClassModel.tableName}

        <where>

        <include refid="where_sql" ></include>

        </where>

    </delete>

	
	
	
    <!-- 分页查询 -->

    <select id="selectInPage" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        <where>

          <include refid="where_sql"></include>

         </where>

        <if test="pageVo !=null"><!-- 判断pageVo对象是否为空 -->

            <if test="pageVo.sort !=null  and pageVo.order !=null">

                order by

                ${'$'}{pageVo.sort} ${'$'}{pageVo.order}

            </if>

            <if test="pageVo.offset >=0  and pageVo.limit >0">

                limit

                ${'#'}{pageVo.offset},${'#'}{pageVo.limit}

            </if>

        </if>

    </select>

	
    <!-- 查询总条数 -->

    <select id="selectTotalRecord" parameterType="long"   resultType="java.lang.Integer">

    select count(*)

    from ${tableClassModel.tableName}

        <where>

           <include refid="where_sql"></include>

        </where>

    </select>



    <!-- 根据id查询-->

    <select id="selectById" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        where  ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.property}} 
    </select>	
	
	
    <!-- 根据id 锁表查询-->

    <select id="selectForUpdate" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        where  ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.column}} 
        for update

    </select>	
	
	
	
    <!-- 根据对象查询-->

    <select id="selectByModel" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        <where>

          <include refid="where_sql"></include>

         </where>

    </select>

</mapper>

 src/main/resources/template/excelTempLateCopy/form.ftl

New file
@@ -0,0 +1,82 @@
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<%@ taglib uri="http://java.sun.com/jstl/core_rt" prefix="c"%>

<c:set var="path" value="${'$'}{pageContext.request.contextPath }" />

<!DOCTYPE HTML>

<html>

<head>

<meta charset="utf-8">

<META HTTP-EQUIV="Pragma" CONTENT="no-cache">

<meta name="renderer" content="webkit|ie-comp|ie-stand">

<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">

<meta name="viewport"

    content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />

<meta http-equiv="Cache-Control" content="no-siteapp" />

<!-- 本框架基本脚本和样式 -->

<script type="text/javascript"

    src="${'$'}{path }/resource/js/plugin/jquery-2.1.4.min.js"></script>

<script type="text/javascript"

    src="${'$'}{path }/resource/js/systools/MBase.js"></script>

</head>

<body>

<div class="ibox-content">

        <form class="form-horizontal" id="dataform" onsubmit="javascripr:return false;">

            <input type="hidden" name="tokenUrl" value="${'$'}{tokenUrl}">	 
            <input type="hidden" name="token" value="${'$'}{token}">

        <c:if test="${'$'}{obj ne null }">

            <input type="hidden" name="${tableClassModel.primaryKey.property}" value="${'$'}{obj.${tableClassModel.primaryKey.property} }">

        </c:if>

        <#assign x = 1>

        <#assign nodelSize = tableClassModel.mapping?size >

        <#list tableClassModel.mapping as being>

            <#if being.isVisible>

            <#assign x = x + 1>

            <#if x%2 = 0 || x = nodelSize>

        <div class="form-group">

            </#if>

            <label class="col-sm-2 control-label">${being.showName}

            <#if being.isNecessary>

            <span class="text-danger">*</span>

            </#if>

            </label>

            <div class="col-sm-4">

                <input type="text" class="form-control" name="${being.property}" 
                    <#if being.columnLength??>

                        maxLength="${being.columnLength}" dataType="s1-${being.columnLength}"

                    </#if>

                    <#if !being.isNecessary>

                    ignore="ignore"

                    </#if>

                    value="<c:out value="${'$'}{obj.${being.property} }"></c:out>" nullmsg="${being.showName}不能为空">

            </div>

            <#if x%2 = 1 || x = nodelSize>

        </div>

            </#if>

            </#if>

        </#list>	
        <div class="form-group ">

            <div class="col-sm-12 text-center">

                <a href="javascript:;" onclick="myForm.submit()"

                    class="btn btn-success radius"><i class="fa fa-check"></i>  保存</a>&nbsp;&nbsp;&nbsp;&nbsp; <a

                     class="btn btn-danger radius" href="javascript:;" onclick="MTools.closeForm()" ><i class="fa fa-close"></i> 关闭</a>

            </div>

        </div>

    </form>

    </div>

</body>

<script type="text/javascript" src="${'$'}{path }/resource/js/systools/MJsBase.js"></script>

<script type="text/javascript">

    MTools.autoFullSelect();

    $(".select2").select2();

    var invokeUrl="${'$'}{path}/do/admin/${tableClassModel.classVariableName}/add${tableClassModel.className}";

    <c:if test="${'$'}{obj ne null }">

    invokeUrl = "${'$'}{path}/do/admin/${tableClassModel.classVariableName}/modify${tableClassModel.className}";

    </c:if>

    var myForm=MForm.initForm({

        invokeUrl:invokeUrl,

        afterSubmit:function(){

            parent.myGrid.serchData();

        },

    });

</script>

</body>

</html>

 src/main/resources/template/excelTempLateCopy/javaBean.ftl

New file
@@ -0,0 +1,41 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>	


/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

public class ${tableClassModel.className}  extends EntityDTO{

    @Extend

    private static final long serialVersionUID = 1L; 


<#list tableClassModel.mapping as being>

	
    <#if being.memo!="">

    /**

     * ${being.memo}

     */

    </#if>

    private ${being.classType}  ${being.property};

			
</#list>	
	
<#list tableClassModel.mapping as being>



    public ${being.classType} get${being.methodName}() {

        return ${being.property};

    }

   	
       public void set${being.methodName}(${being.classType} ${being.property}) {

        this.${being.property}=${being.property};

    }

   	
</#list>	




  
}

 src/main/resources/template/excelTempLateCopy/list.ftl

New file
@@ -0,0 +1,132 @@
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<%@ taglib uri="http://java.sun.com/jstl/core_rt" prefix="c"%>

<%@ taglib uri="http://www.zkingsoft.com" prefix="matrix"%>

<c:set var="path" value="${'$'}{pageContext.request.contextPath }" />

<!DOCTYPE HTML>

<html>

<head>

<meta charset="utf-8">

<META HTTP-EQUIV="Pragma" CONTENT="no-cache">

<meta name="renderer" content="webkit|ie-comp|ie-stand">

<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">

<meta name="viewport"

    content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />

<meta http-equiv="Cache-Control" content="no-siteapp" />

<!-- 本框架基本脚本和样式 -->

<script type="text/javascript"

    src="${'$'}{path }/resource/js/plugin/jquery-2.1.4.min.js"></script>

<script type="text/javascript"

    src="${'$'}{path }/resource/js/systools/MBase.js"></script>

</head>

<body class="gray-bg">

<div class="wrapper wrapper-content animated fadeInRight">

        <!-- 搜索框部分start -->

        <matrix:btn value="${tableClassModel.className}:search">

<div class="row" >

        <div class="col-sm-12" > 
            <form class="form-inline" id="serchform">

                <div class="form-group mr-20">

                    <input placeholder="请输入关键词" name="" type="text" class="form-control">

                </div>

                <button onclick="myGrid.serchData()" type="button"

                    class="btn btn-info btn-sm">

                    <i class="fa fa-search "></i> 搜索

                </button>

                <button onclick="MForm.reset('#serchform');" type="button" class="btn btn-info btn-sm">

                    <i class="fa fa-refresh "></i> 重置

                </button>

            </form>

            </div>

    </div>

        </matrix:btn> 
        <!-- 搜索框部分en -->

        <div class="ibox-content radius-5 mt-5 mpanel">

		
    <div class="row" >

        <div class="col-sm-12" >

        <div class="option-bar">

            <matrix:btn value="${tableClassModel.className}:dels"> 
                <button onclick="myGrid.delItems('${tableClassModel.primaryKey.property}')" type="button"

                    class="btn btn-danger btn-sm">

                    <i class="fa fa-trash"></i>批量删除

                </button>

            </matrix:btn>

            <matrix:btn value="${tableClassModel.className}:add"> 
                <button onclick="openAdd()" type="button"

                    class="btn btn-success btn-sm">

                    <i class="fa fa-plus"></i> 新增

                </button>

            </matrix:btn>

        </div>

        <table id="mgrid">

            <thead>

                <tr>

                    <th data-checkbox="true"></th>

                    <th data-formatter="MGrid.indexfn" data-align="center"  data-width="30px" >序号</th>

                    <#list tableClassModel.mapping as being>

                        <#if being.isVisible>

                    <th data-field="${being.property}" >${being.showName}</th>

                        </#if>

                    </#list>	
                    <th data-align="center"  data-width="195px" data-field="${tableClassModel.primaryKey.property}" data-formatter="buidOperate">操作</th>

                </tr>

            </thead>

        </table>

    </div>

</div>

</div>

</div>

<script type="text/javascript"

    src="${'$'}{path }/resource/js/systools/MJsBase.js"></script>

    <script type="text/javascript">

         var myGrid;

        $(function(){

            var delUrl="";

            <matrix:btn value="${tableClassModel.className}:del"> 
            delUrl="${'$'}{path}/do/admin/${tableClassModel.classVariableName}/del" ;

            </matrix:btn>

            myGrid=MGrid.initGrid({

                 url:"${'$'}{path}/do/admin/${tableClassModel.classVariableName}/showList",

                 delUrl:delUrl,

             });

			
        });

		
         function buidOperate(value, row, index){

            var html = [];

            <matrix:btn value="${tableClassModel.className}:edit"> 
            html[0] = '<a  onClick="openEdit(\''+value+'\')"  title="编辑" class="fa fa-edit option"></a>'

            </matrix:btn>

            <matrix:btn value="${tableClassModel.className}:del"> 
            html[1] = '<a onClick="myGrid.delItem(\''+value+'\')" title="删除" class="fa fa-close option text-danger"></a>';

            </matrix:btn>

            return html.join(""); 
        } 
        //打开添加界面

        <matrix:btn value="${tableClassModel.className}:add"> 
        function openAdd() {

            layer.open({

                type : 2,

                title : "添加${tableClassModel.tableMemo}",

                area : [ MUI.SIZE_L, '400px' ],

                maxmin : true,

                content : [ '${'$'}{path}/do/admin/${tableClassModel.classVariableName}/editForm']

            }); 
        }

        </matrix:btn>

		
        //打开编辑界面

        <matrix:btn value="${tableClassModel.className}:edit"> 
        function openEdit(id) {

            layer.open({

                type : 2,

                title : "编辑${tableClassModel.tableMemo}",

                area : [ MUI.SIZE_L, '400px' ],

                maxmin : true,

                content : [ '${'$'}{path}/do/admin/${tableClassModel.classVariableName}/editForm?id=' + id]

            });

        }

        </matrix:btn>

    </script>

</body>

</html>


 src/main/resources/template/excelTempLateCopy/mybatis-config.ftl

New file
@@ -0,0 +1,33 @@
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration  PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">



<configuration>

    <settings>

        <setting name="cacheEnabled" value="false" />

           <setting name="lazyLoadingEnabled" value="false" />

           <setting name="multipleResultSetsEnabled" value="true" />

           <setting name="useColumnLabel" value="true" />

           <setting name="useGeneratedKeys" value="false" />

           <setting name="defaultExecutorType" value="SIMPLE" />

           <setting name="defaultStatementTimeout" value="25000" />

    </settings>

	
	


	
    <typeAliases>



    <#list alias as item> 
    ${item}

    </#list>	


    </typeAliases>

	
    <mappers>

	
        <#list mappers as item> 
        ${item}

        </#list>	
		
    </mappers>

</configuration>

 src/main/resources/template/excelTempLateCopy/sqlFile.ftl

New file
@@ -0,0 +1,29 @@


/**

 * ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

 CREATE TABLE ${tableClassModel.tableName}(

  create_by varchar(100) NOT NULL COMMENT '创建人',

  create_time datetime NOT NULL COMMENT '创建时间',

  update_by varchar(100) NOT NULL COMMENT '更新人',

  update_time datetime NOT NULL COMMENT '更新时间',

<#list tableClassModel.mapping as being>

  ${being.column} ${being.fullJdbcType}  ${being.isAllowNull}  COMMENT '${being.memo}',

</#list>	
PRIMARY KEY(${tableClassModel.primaryKey.column})

)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='${tableClassModel.tableMemo}';



/**

 *

 *生成菜单的sql 默认在权限管理目录下

 */

INSERT INTO `sys_function` 
VALUES 
      ('开发者', now(), 
      '开发者', now(), 
      replace(uuid(), '-', ''), 
      '', 'admin/${tableClassModel.className}-list', '否', '2', 
      '05fb2915b39b4021a51d406473f0ee91', 
      '${tableClassModel.tableMemo}', '4', '${tableClassModel.className}', '123', '是', null);


 src/main/resources/template/excelTempLateCopy/数据字典表(模板).xlsx

Binary files differ

 src/main/resources/template/excelTemplate/action.ftl

New file
@@ -0,0 +1,88 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>	


/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

@Controller

@RequestMapping(value = "admin/${tableClassModel.classVariableName}")

public class ${ClassName} extends BaseAction{



    @Autowired

    private ${tableClassModel.className}Service ${tableClassModel.classVariableName}Service;

	
    //记录编辑前的值Before_Edit_Value

    public static final String BEV="${tableClassModel.className}_BEV";

	
	
    /**

     * 列表显示

     */

    @RequestMapping(value =  SAFEPATH+"/showList")

    public @ResponseBody AjaxResult showList(${tableClassModel.className} ${tableClassModel.classVariableName}, PaginationVO pageVo) {

        return showList(${tableClassModel.classVariableName}Service, ${tableClassModel.classVariableName}, pageVo);

    }

   	
    /**

     * 新增

     */   
    @RemoveRequestToken	
       @RequestMapping(value =  SAFEPATH+"/add${tableClassModel.className}")

    public @ResponseBody AjaxResult add${tableClassModel.className}(${tableClassModel.className} ${tableClassModel.classVariableName}) {

         int i=${tableClassModel.classVariableName}Service.add(${tableClassModel.classVariableName});

         if(i > 0){

             return new AjaxResult(AjaxResult.STATUS_SUCCESS, SystemMessageCode.ADD_SUCCES, "${tableClassModel.tableMemo}");

         }else {

            throw new GlobleException(SystemErrorCode.DATA_ADD_FAIL);

        }

    }

	
	
	
	
	
    /**

     * 修改

     */   
    @RemoveRequestToken	
       @RequestMapping(value =  SAFEPATH+"/modify${tableClassModel.className}")

    public @ResponseBody AjaxResult modify${tableClassModel.className}(${tableClassModel.className} ${tableClassModel.classVariableName}) {

               ${tableClassModel.classVariableName}.set${tableClassModel.primaryKey.methodName}(((${tableClassModel.className})WebUtil.getSessionAttribute(BEV)).get${tableClassModel.primaryKey.methodName}());

               AjaxResult result=modify(${tableClassModel.classVariableName}Service, WebUtil.getSessionAttribute(BEV), ${tableClassModel.classVariableName}, "${tableClassModel.tableMemo}");

            WebUtil.removeSessionAttribute(BEV);

            return  result;

    }

	
	
	
	
       /**

     * 进入修改界面

     */   
    @SaveRequestToken

       @RequestMapping(value =  SAFEPATH+"/editForm")

    public String editForm(${tableClassModel.primaryKey.classType} id) {

        ${tableClassModel.className} ${tableClassModel.classVariableName};

        if (id != null) {

            ${tableClassModel.classVariableName} = ${tableClassModel.classVariableName}Service.findById(id);

            WebUtil.getRequest().setAttribute("obj", ${tableClassModel.classVariableName});

            WebUtil.setSessionAttribute(BEV, ${tableClassModel.classVariableName});

        }

        return "admin/${tableClassModel.className}-form";

    }

   	
   	
       /**

     * 删除

     */  
     @RequestMapping(value = SAFEPATH+"/del")

    public @ResponseBody AjaxResult del(String keys) {

        return remove(${tableClassModel.classVariableName}Service, keys);

    }

  
}

 src/main/resources/template/excelTemplate/dao.ftl

New file
@@ -0,0 +1,38 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>	


/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

public interface ${ClassName}{



    public int insert(@Param("item") ${tableClassModel.className} ${tableClassModel.classVariableName});

   	
       public int batchInsert(@Param("list") List<${tableClassModel.className}> ${tableClassModel.classVariableName}List);

   	
    public int updateByMap(Map<String, Object> modifyMap);

	
    public int updateByModel(@Param("record")${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public int deleteByIds(@Param("list") List<${tableClassModel.primaryKey.classType}> list);

	
    public int deleteById(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property});



    public int deleteByModel(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public List<${tableClassModel.className}> selectInPage(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName}, @Param("pageVo") PaginationVO pageVo);



    public List<${tableClassModel.className}> selectByModel(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public int selectTotalRecord(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public ${tableClassModel.className}  selectById(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property});

	
    public ${tableClassModel.className}  selectForUpdate(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property});

	
}

 src/main/resources/template/excelTemplate/daoImpl.ftl

New file
@@ -0,0 +1,226 @@
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">



<mapper namespace="${tableClassModel.qualifiedClassName}">

    <!-- 定义${tableClassModel.className} 的复杂关联map -->

    <resultMap type="${beanQualifiedClassName}" id="${tableClassModel.className}Map">

        <id property="${tableClassModel.primaryKey.property}" column="${tableClassModel.primaryKey.column}" />

        <result property="createBy" column="create_by" />

        <result property="createTime" column="create_time" />

        <result property="updateBy" column="update_by" />

        <result property="updateTime" column="update_time" />

        <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <result property="${item.property}" column="${item.column}" />

            </#if>

        </#list>	
    </resultMap>

	
	
    <!-- 定义${tableClassModel.className} 的简单map  ，本map不添加其他的关联属性 -->

    <resultMap type="${beanQualifiedClassName}" id="${tableClassModel.className}SimpleMap">

        <id property="${tableClassModel.primaryKey.property}" column="${tableClassModel.primaryKey.column}" />

        <result property="createBy" column="create_by" />

        <result property="createTime" column="create_time" />

        <result property="updateBy" column="update_by" />

        <result property="updateTime" column="update_time" />

        <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <result property="${item.property}" column="${item.column}" />

            </#if>

        </#list>	
    </resultMap>

	
    <!-- 字段sql -->

    <sql id="columns">

        create_by,

        create_time,

        update_by,

        update_time,

        <#list tableClassModel.mapping as item> 
            <#if item_has_next>

            ${item.column},

            <#else>

            ${item.column}

            </#if>

        </#list>

    </sql>

	
    <!-- 属性sql -->

    <sql id="propertys">

        ${'#'}{item.createBy},

        now(),

        ${'#'}{item.updateBy},

        now(),

        <#list tableClassModel.mapping as propertyitem>

        <#if propertyitem_has_next>

            ${'#'}{item.${propertyitem.property}},

            <#else>

            ${'#'}{item.${propertyitem.property}}

            </#if>

        </#list>	
    </sql>

	
    <!-- where sql -->

    <sql id="where_sql">

		 
         <if test="record!=null">

            <#list tableClassModel.mapping as item> 
            <if test="(record.${item.property}!=null and record.${item.property}!='') or  (record.${item.property}!='' and record.${item.property}==0)  ">

                and ${item.column}  = ${'#'}{record.${item.property}} 
            </if>

            </#list>	
        </if>

		 
    </sql>

	
    <!--  插入方法   -->

    <insert id="insert" parameterType="${beanQualifiedClassName}"

        useGeneratedKeys="true" keyProperty="item.${tableClassModel.primaryKey.property}">

        INSERT INTO ${tableClassModel.tableName} (

             <include refid="columns"></include>

        )

    VALUES (

         <include refid="propertys"></include>

    )

    </insert>

	
	
	
    <!--  批量插入   -->

    <insert id="batchInsert" parameterType="java.util.List">

        INSERT INTO ${tableClassModel.tableName} (

        <include refid="columns"></include>	
        )

    VALUES 
    <foreach collection="list" item="item" index="index" separator=",">(

        <include refid="propertys"></include>	
    )</foreach>

    </insert>

	
	
	
	
	
    <!--  根据Map更新 部分更新   -->

    <update id="updateByMap" parameterType="java.util.HashMap" >

        UPDATE ${tableClassModel.tableName}

        <set>

            <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <if test="_parameter.containsKey('${item.property}')">

                    ${item.column} = ${'#'}{${item.property}},

                </if>		
            </#if>

            </#list>

        </set>

        WHERE ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.property}} 
    </update> 
	
	
    <!--  根据对象更新 部分更新   -->

    <update id="updateByModel" parameterType="${tableClassModel.primaryKey.classType}">

        UPDATE ${tableClassModel.tableName}

        <set>

            <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <#if item.classType = "String">

            <if test="record.${item.property} != null and record.${item.property} != '' ">

                ${item.column}  = ${'#'}{record.${item.property}}, 
            </if>

            <#else>

            <if test="record.${item.property} != null ">

                ${item.column}  = ${'#'}{record.${item.property}}, 
            </if>

            </#if>	
            </#if>

            </#list>

        </set>

        WHERE ${tableClassModel.primaryKey.column}=${'#'}{record.${tableClassModel.primaryKey.property}} 
    </update>

	
    <!-- 批量删除 -->

    <delete id="deleteByIds" parameterType="java.util.List">

        delete from ${tableClassModel.tableName} where  ${tableClassModel.primaryKey.column} in

        <foreach collection="list" index="index" item="item" open="("

            separator="," close=")">

            ${'#'}{item}

        </foreach>

    </delete>

		
    <!-- 根据id删除-->

    <delete id="deleteById" parameterType="${tableClassModel.primaryKey.classType}">

        DELETE FROM ${tableClassModel.tableName}

        where  ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.property}} 
    </delete>

	
    <!-- 根据对象删除-->

    <delete id="deleteByModel" parameterType="${beanQualifiedClassName}">

        DELETE FROM ${tableClassModel.tableName}

        <where>

        <include refid="where_sql" ></include>

        </where>

    </delete>

	
	
	
    <!-- 分页查询 -->

    <select id="selectInPage" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        <where>

          <include refid="where_sql"></include>

         </where>

        <if test="pageVo !=null"><!-- 判断pageVo对象是否为空 -->

            <if test="pageVo.sort !=null  and pageVo.order !=null">

                order by

                ${'$'}{pageVo.sort} ${'$'}{pageVo.order}

            </if>

            <if test="pageVo.offset >=0  and pageVo.limit >0">

                limit

                ${'#'}{pageVo.offset},${'#'}{pageVo.limit}

            </if>

        </if>

    </select>

	
    <!-- 查询总条数 -->

    <select id="selectTotalRecord" parameterType="long"   resultType="java.lang.Integer">

    select count(*)

    from ${tableClassModel.tableName}

        <where>

           <include refid="where_sql"></include>

        </where>

    </select>



    <!-- 根据id查询-->

    <select id="selectById" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        where  ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.property}} 
    </select>	
	
	
    <!-- 根据id 锁表查询-->

    <select id="selectForUpdate" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        where  ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.column}} 
        for update

    </select>	
	
	
	
    <!-- 根据对象查询-->

    <select id="selectByModel" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        <where>

          <include refid="where_sql"></include>

         </where>

    </select>

</mapper>

 src/main/resources/template/excelTemplate/form.ftl

New file
@@ -0,0 +1,82 @@
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<%@ taglib uri="http://java.sun.com/jstl/core_rt" prefix="c"%>

<c:set var="path" value="${'$'}{pageContext.request.contextPath }" />

<!DOCTYPE HTML>

<html>

<head>

<meta charset="utf-8">

<META HTTP-EQUIV="Pragma" CONTENT="no-cache">

<meta name="renderer" content="webkit|ie-comp|ie-stand">

<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">

<meta name="viewport"

    content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />

<meta http-equiv="Cache-Control" content="no-siteapp" />

<!-- 本框架基本脚本和样式 -->

<script type="text/javascript"

    src="${'$'}{path }/resource/js/plugin/jquery-2.1.4.min.js"></script>

<script type="text/javascript"

    src="${'$'}{path }/resource/js/systools/MBase.js"></script>

</head>

<body>

<div class="ibox-content">

        <form class="form-horizontal" id="dataform" onsubmit="javascripr:return false;">

            <input type="hidden" name="tokenUrl" value="${'$'}{tokenUrl}">	 
            <input type="hidden" name="token" value="${'$'}{token}">

        <c:if test="${'$'}{obj ne null }">

            <input type="hidden" name="${tableClassModel.primaryKey.property}" value="${'$'}{obj.${tableClassModel.primaryKey.property} }">

        </c:if>

        <#assign x = 1>

        <#assign nodelSize = tableClassModel.mapping?size >

        <#list tableClassModel.mapping as being>

            <#if being.isVisible>

            <#assign x = x + 1>

            <#if x%2 = 0 || x = nodelSize>

        <div class="form-group">

            </#if>

            <label class="col-sm-2 control-label">${being.showName}

            <#if being.isNecessary>

            <span class="text-danger">*</span>

            </#if>

            </label>

            <div class="col-sm-4">

                <input type="text" class="form-control" name="${being.property}" 
                    <#if being.columnLength??>

                        maxLength="${being.columnLength}" dataType="s1-${being.columnLength}"

                    </#if>

                    <#if !being.isNecessary>

                    ignore="ignore"

                    </#if>

                    value="<c:out value="${'$'}{obj.${being.property} }"></c:out>" nullmsg="${being.showName}不能为空">

            </div>

            <#if x%2 = 1 || x = nodelSize>

        </div>

            </#if>

            </#if>

        </#list>	
        <div class="form-group ">

            <div class="col-sm-12 text-center">

                <a href="javascript:;" onclick="myForm.submit()"

                    class="btn btn-success radius"><i class="fa fa-check"></i>  保存</a>&nbsp;&nbsp;&nbsp;&nbsp; <a

                     class="btn btn-danger radius" href="javascript:;" onclick="MTools.closeForm()" ><i class="fa fa-close"></i> 关闭</a>

            </div>

        </div>

    </form>

    </div>

</body>

<script type="text/javascript" src="${'$'}{path }/resource/js/systools/MJsBase.js"></script>

<script type="text/javascript">

    MTools.autoFullSelect();

    $(".select2").select2();

    var invokeUrl="${'$'}{path}/do/admin/${tableClassModel.classVariableName}/add${tableClassModel.className}";

    <c:if test="${'$'}{obj ne null }">

    invokeUrl = "${'$'}{path}/do/admin/${tableClassModel.classVariableName}/modify${tableClassModel.className}";

    </c:if>

    var myForm=MForm.initForm({

        invokeUrl:invokeUrl,

        afterSubmit:function(){

            parent.myGrid.serchData();

        },

    });

</script>

</body>

</html>

 src/main/resources/template/excelTemplate/javaBean.ftl

New file
@@ -0,0 +1,41 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>	


/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

public class ${tableClassModel.className}  extends EntityDTO{

    @Extend

    private static final long serialVersionUID = 1L; 


<#list tableClassModel.mapping as being>

	
    <#if being.memo!="">

    /**

     * ${being.memo}

     */

    </#if>

    private ${being.classType}  ${being.property};

			
</#list>	
	
<#list tableClassModel.mapping as being>



    public ${being.classType} get${being.methodName}() {

        return ${being.property};

    }

   	
       public void set${being.methodName}(${being.classType} ${being.property}) {

        this.${being.property}=${being.property};

    }

   	
</#list>	




  
}

 src/main/resources/template/excelTemplate/list.ftl

New file
@@ -0,0 +1,132 @@
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<%@ taglib uri="http://java.sun.com/jstl/core_rt" prefix="c"%>

<%@ taglib uri="http://www.zkingsoft.com" prefix="matrix"%>

<c:set var="path" value="${'$'}{pageContext.request.contextPath }" />

<!DOCTYPE HTML>

<html>

<head>

<meta charset="utf-8">

<META HTTP-EQUIV="Pragma" CONTENT="no-cache">

<meta name="renderer" content="webkit|ie-comp|ie-stand">

<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">

<meta name="viewport"

    content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />

<meta http-equiv="Cache-Control" content="no-siteapp" />

<!-- 本框架基本脚本和样式 -->

<script type="text/javascript"

    src="${'$'}{path }/resource/js/plugin/jquery-2.1.4.min.js"></script>

<script type="text/javascript"

    src="${'$'}{path }/resource/js/systools/MBase.js"></script>

</head>

<body class="gray-bg">

<div class="wrapper wrapper-content animated fadeInRight">

        <!-- 搜索框部分start -->

        <matrix:btn value="${tableClassModel.className}:search">

<div class="row" >

        <div class="col-sm-12" > 
            <form class="form-inline" id="serchform">

                <div class="form-group mr-20">

                    <input placeholder="请输入关键词" name="" type="text" class="form-control">

                </div>

                <button onclick="myGrid.serchData()" type="button"

                    class="btn btn-info btn-sm">

                    <i class="fa fa-search "></i> 搜索

                </button>

                <button onclick="MForm.reset('#serchform');" type="button" class="btn btn-info btn-sm">

                    <i class="fa fa-refresh "></i> 重置

                </button>

            </form>

            </div>

    </div>

        </matrix:btn> 
        <!-- 搜索框部分en -->

        <div class="ibox-content radius-5 mt-5 mpanel">

		
    <div class="row" >

        <div class="col-sm-12" >

        <div class="option-bar">

            <matrix:btn value="${tableClassModel.className}:dels"> 
                <button onclick="myGrid.delItems('${tableClassModel.primaryKey.property}')" type="button"

                    class="btn btn-danger btn-sm">

                    <i class="fa fa-trash"></i>批量删除

                </button>

            </matrix:btn>

            <matrix:btn value="${tableClassModel.className}:add"> 
                <button onclick="openAdd()" type="button"

                    class="btn btn-success btn-sm">

                    <i class="fa fa-plus"></i> 新增

                </button>

            </matrix:btn>

        </div>

        <table id="mgrid">

            <thead>

                <tr>

                    <th data-checkbox="true"></th>

                    <th data-formatter="MGrid.indexfn" data-align="center"  data-width="30px" >序号</th>

                    <#list tableClassModel.mapping as being>

                        <#if being.isVisible>

                    <th data-field="${being.property}" >${being.showName}</th>

                        </#if>

                    </#list>	
                    <th data-align="center"  data-width="195px" data-field="${tableClassModel.primaryKey.property}" data-formatter="buidOperate">操作</th>

                </tr>

            </thead>

        </table>

    </div>

</div>

</div>

</div>

<script type="text/javascript"

    src="${'$'}{path }/resource/js/systools/MJsBase.js"></script>

    <script type="text/javascript">

         var myGrid;

        $(function(){

            var delUrl="";

            <matrix:btn value="${tableClassModel.className}:del"> 
            delUrl="${'$'}{path}/do/admin/${tableClassModel.classVariableName}/del" ;

            </matrix:btn>

            myGrid=MGrid.initGrid({

                 url:"${'$'}{path}/do/admin/${tableClassModel.classVariableName}/showList",

                 delUrl:delUrl,

             });

			
        });

		
         function buidOperate(value, row, index){

            var html = [];

            <matrix:btn value="${tableClassModel.className}:edit"> 
            html[0] = '<a  onClick="openEdit(\''+value+'\')"  title="编辑" class="fa fa-edit option"></a>'

            </matrix:btn>

            <matrix:btn value="${tableClassModel.className}:del"> 
            html[1] = '<a onClick="myGrid.delItem(\''+value+'\')" title="删除" class="fa fa-close option text-danger"></a>';

            </matrix:btn>

            return html.join(""); 
        } 
        //打开添加界面

        <matrix:btn value="${tableClassModel.className}:add"> 
        function openAdd() {

            layer.open({

                type : 2,

                title : "添加${tableClassModel.tableMemo}",

                area : [ MUI.SIZE_L, '400px' ],

                maxmin : true,

                content : [ '${'$'}{path}/do/admin/${tableClassModel.classVariableName}/editForm']

            }); 
        }

        </matrix:btn>

		
        //打开编辑界面

        <matrix:btn value="${tableClassModel.className}:edit"> 
        function openEdit(id) {

            layer.open({

                type : 2,

                title : "编辑${tableClassModel.tableMemo}",

                area : [ MUI.SIZE_L, '400px' ],

                maxmin : true,

                content : [ '${'$'}{path}/do/admin/${tableClassModel.classVariableName}/editForm?id=' + id]

            });

        }

        </matrix:btn>

    </script>

</body>

</html>


 src/main/resources/template/excelTemplate/mybatis-config.ftl

New file
@@ -0,0 +1,33 @@
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration  PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">



<configuration>

    <settings>

        <setting name="cacheEnabled" value="false" />

           <setting name="lazyLoadingEnabled" value="false" />

           <setting name="multipleResultSetsEnabled" value="true" />

           <setting name="useColumnLabel" value="true" />

           <setting name="useGeneratedKeys" value="false" />

           <setting name="defaultExecutorType" value="SIMPLE" />

           <setting name="defaultStatementTimeout" value="25000" />

    </settings>

	
	


	
    <typeAliases>



    <#list alias as item> 
    ${item}

    </#list>	


    </typeAliases>

	
    <mappers>

	
        <#list mappers as item> 
        ${item}

        </#list>	
		
    </mappers>

</configuration>

 src/main/resources/template/excelTemplate/service.ftl

New file
@@ -0,0 +1,72 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>	


/**

 * @description  service接口类 ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

public interface ${ClassName}  extends BaseServices<${tableClassModel.className}>{

	
    /**

     * 新增

     */

    public int add(${tableClassModel.className} ${tableClassModel.classVariableName});

   	
       /**

     * 批量新增

     */

    public int batchAdd(List<${tableClassModel.className}>  ${tableClassModel.classVariableName}List);

   	
       /**

     * 根据map键值对 更新

     */

    public int modifyByMap(${tableClassModel.className} old${tableClassModel.className} ,${tableClassModel.className} new${tableClassModel.className});

	
    /**

     * 根据对象 更新

     */

    public int modifyByModel(${tableClassModel.className} ${tableClassModel.classVariableName});

	
    /**

     * 批量删除

     */

    public int remove(List<${tableClassModel.primaryKey.classType}> list);



    /**

     * 根据id删除

     */

    public int removeById(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property});

	
    /**

     * 根据对象删除

     */

    public int removeByModel(${tableClassModel.className} ${tableClassModel.classVariableName});

	
    /**

     * 分页查询

     */

    public List<${tableClassModel.className}> findInPage(${tableClassModel.className} ${tableClassModel.classVariableName}, PaginationVO pageVo);



    /**

     * 根据对象查询

     */

    public List<${tableClassModel.className}> findByModel(${tableClassModel.className} ${tableClassModel.classVariableName});

	
    /**

     * 统计记录数

     */

    public int  findTotal(${tableClassModel.className} ${tableClassModel.classVariableName});

	
    /**

     * 根据id查询

     */

    public ${tableClassModel.className}  findById(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property});



   	


  
}

 src/main/resources/template/excelTemplate/serviceImpl.ftl

New file
@@ -0,0 +1,132 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>	


/**

 * @description service接口实现类${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

@Service

public class  ${ClassName} implements  ${serviceInterface}{



	
    @Autowired

    private ${daoClassName} ${daoVariableName};

	
	
    @Override

    public int add(${tableClassModel.className} ${tableClassModel.classVariableName}){

        // 设置基本字段信息

        SysUsers loginUser = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY);

        ${tableClassModel.classVariableName}.setCreateBy(loginUser.getSuName());

        ${tableClassModel.classVariableName}.setUpdateBy(loginUser.getSuName());

        ${tableClassModel.classVariableName}.set${tableClassModel.primaryKey.methodName}(UUIDUtil.getRandomID());

        return ${daoVariableName}.insert(${tableClassModel.classVariableName});

		
    }

	
    @Override

    public int batchAdd(List<${tableClassModel.className}>  ${tableClassModel.classVariableName}List) {

        //这里没有做基本字段的设置，如有需要请自己实现	
        int num = 0;

        int c = 10000;

        int size = ${tableClassModel.classVariableName}List.size()/c + 1;

        for(int i=0; i<size; i++) {

            int begin = i*c;

            int end = (i+1)*c;

            end = end >= ${tableClassModel.classVariableName}List.size() ? ${tableClassModel.classVariableName}List.size() : end;

            List<${tableClassModel.className}> insertList = ${tableClassModel.classVariableName}List.subList(begin, end);

            num += ${daoVariableName}.batchInsert(insertList);

        }

        return num;

		
    }

	
	
   	
    @Override

    public int modifyByMap(${tableClassModel.className} old${tableClassModel.className}

    ,${tableClassModel.className} new${tableClassModel.className}){

	
        Map<String, Object> modifyMap = null;

        try {

            if (!ModelUtils.isModified(old${tableClassModel.className}, new${tableClassModel.className})) {

                return MatrixConstance.DML_SUCCESSS;

            }

            modifyMap = ModelUtils.comparePojo2Map(old${tableClassModel.className}, new${tableClassModel.className});

        } catch (Exception e) {

            throw new GlobleException(SystemErrorCode.DATA_UPDATE_FAIL, e, new${tableClassModel.className});

        }

        if (modifyMap.size() > 0) {

            modifyMap.put("${tableClassModel.primaryKey.property}", old${tableClassModel.className}.get${tableClassModel.primaryKey.methodName}());

            ${daoVariableName}.updateByMap(modifyMap);

        }

        return MatrixConstance.DML_SUCCESSS;

    }

	
    @Override

    public int modifyByModel(${tableClassModel.className} ${tableClassModel.classVariableName}){

	
        return ${daoVariableName}.updateByModel(${tableClassModel.classVariableName});

	
    }

	
	
	
    @Override

    public int remove(List<${tableClassModel.primaryKey.classType}> list){

	
        return ${daoVariableName}.deleteByIds(list);

	
    }



    @Override

    public int removeById(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property}){

	
        return ${daoVariableName}.deleteById(${tableClassModel.primaryKey.property});

	
    }

	
    @Override

    public int removeByModel(${tableClassModel.className} ${tableClassModel.classVariableName}){

	
        return ${daoVariableName}.deleteByModel(${tableClassModel.classVariableName});

	
    }

	
	
    @Override

    public List<${tableClassModel.className}> findInPage(${tableClassModel.className} ${tableClassModel.classVariableName},  PaginationVO pageVo){

	
        return ${daoVariableName}.selectInPage(${tableClassModel.classVariableName} , pageVo);

	
    }

	
    @Override

    public List<${tableClassModel.className}> findByModel(${tableClassModel.className} ${tableClassModel.classVariableName}){

	
        return ${daoVariableName}.selectByModel(${tableClassModel.classVariableName});

	
    }

	
    @Override

    public int  findTotal(${tableClassModel.className} ${tableClassModel.classVariableName}){

	
        return ${daoVariableName}.selectTotalRecord(${tableClassModel.classVariableName});

	
    }

	
    @Override

    public ${tableClassModel.className}  findById(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property}){

	
        return ${daoVariableName}.selectById(${tableClassModel.primaryKey.property});

	
    }



   	
	
	
}

 src/main/resources/template/excelTemplate/sqlFile.ftl

New file
@@ -0,0 +1,16 @@


/**

 * ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

 CREATE TABLE ${tableClassModel.tableName}(

  create_by varchar(100) NOT NULL COMMENT '创建人',

  create_time datetime NOT NULL COMMENT '创建时间',

  update_by varchar(100) NOT NULL COMMENT '更新人',

  update_time datetime NOT NULL COMMENT '更新时间',

<#list tableClassModel.mapping as being>

  ${being.column} ${being.fullJdbcType}  ${being.isAllowNull}  COMMENT '${being.memo}',

</#list>	
PRIMARY KEY(${tableClassModel.primaryKey.column})

)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='${tableClassModel.tableMemo}';

 src/main/resources/template/excelTemplateForBoot/action.ftl

New file
@@ -0,0 +1,122 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>	


/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

@Controller

@RequestMapping(value = "admin/${tableClassModel.classVariableName}")

public class ${ClassName} {



    @Autowired

    private ${tableClassModel.className}Dao ${tableClassModel.classVariableName}Dao;

	
    //记录编辑前的值Before_Edit_Value

    public static final String BEV="${tableClassModel.className}_BEV";

	
	
    /**

     * 列表显示

     */

    @RequestMapping(value =  "/showList")

    public @ResponseBody AjaxResult showList(${tableClassModel.className} ${tableClassModel.classVariableName}, PaginationVO pageVo) {

        if (pageVo == null) {

            pageVo = new PaginationVO();

        }

        List<${tableClassModel.className}> dataList = ${tableClassModel.classVariableName}Dao.selectInPage(${tableClassModel.classVariableName}, pageVo);

        AjaxResult result = new AjaxResult(AjaxResult.STATUS_SUCCESS, dataList,

                ${tableClassModel.classVariableName}Dao.selectTotalRecord(${tableClassModel.classVariableName}));

        return result;

    }

   	
    /**

     * 新增

     */   
    @RemoveRequestToken	
       @RequestMapping(value =  "/add${tableClassModel.className}")

    public @ResponseBody AjaxResult add${tableClassModel.className}(${tableClassModel.className} ${tableClassModel.classVariableName}) {

        SysUsers user = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY);

        ${tableClassModel.classVariableName}.setCreateBy(user.getSuName());

        ${tableClassModel.classVariableName}.setUpdateBy(user.getSuName());

         int i=${tableClassModel.classVariableName}Dao.insert(${tableClassModel.classVariableName});

         if(i > 0){

             return new AjaxResult(AjaxResult.STATUS_SUCCESS, SystemMessageCode.ADD_SUCCES, "${tableClassModel.tableMemo}");

         }else {

            throw new GlobleException(SystemErrorCode.DATA_ADD_FAIL);

        }

    }

	
	
	
	
	
    /**

     * 修改

     */   
    @RemoveRequestToken	
       @RequestMapping(value =  "/modify${tableClassModel.className}")

    public @ResponseBody AjaxResult modify${tableClassModel.className}(${tableClassModel.className} new${tableClassModel.className}) {

           ${tableClassModel.className} old${tableClassModel.className} = WebUtil.getSessionAttribute(BEV);

        int i = 0;

        Map<String, Object> modifyMap = null;

        try {

            if (!ModelUtils.isModified(old${tableClassModel.className}, new${tableClassModel.className})) {

                i = MatrixConstance.DML_SUCCESSS;

            }

            modifyMap = ModelUtils.comparePojo2Map(old${tableClassModel.className}, new${tableClassModel.className});

        } catch (Exception e) {

            throw new GlobleException(SystemErrorCode.DATA_UPDATE_FAIL, e, new${tableClassModel.className});

        }

        if (modifyMap.size() > 0) {

            modifyMap.put("${tableClassModel.primaryKey.property}", old${tableClassModel.className}.get${tableClassModel.primaryKey.property?cap_first}());

            ${tableClassModel.classVariableName}Dao.updateByMap(modifyMap);

        }

        i = MatrixConstance.DML_SUCCESSS;

        WebUtil.removeSessionAttribute(BEV);

        if (i > 0) {

            return new AjaxResult(AjaxResult.STATUS_SUCCESS, SystemMessageCode.UPDATE_SUCCES, "${tableClassModel.tableMemo}");

        } else {

            throw new GlobleException(SystemErrorCode.DATA_UPDATE_FAIL);

        }

    }

	
	
	
	
       /**

     * 进入修改界面

     */   
    @SaveRequestToken

       @RequestMapping(value =  "/editForm")

    public ModelAndView editForm(${tableClassModel.primaryKey.classType} id) {

        ${tableClassModel.className} ${tableClassModel.classVariableName} = new ${tableClassModel.className}();

        ModelAndView modelAndView = new ModelAndView("admin/${tableClassModel.className?uncap_first}-form");

        if (id != null) {

            ${tableClassModel.classVariableName} = ${tableClassModel.classVariableName}Dao.selectById(id);

            WebUtil.setSessionAttribute(BEV, ${tableClassModel.classVariableName});

        }

        modelAndView.addObject("obj",${tableClassModel.classVariableName});

        return modelAndView;

    }

   	
   	
       /**

     * 删除

     */  
     @RequestMapping(value = "/del")

    public @ResponseBody AjaxResult del(String keys) {

        List<String> ids = StringUtils.strToCollToString(keys, ",");

        int i =  ${tableClassModel.classVariableName}Dao.deleteByIds(ids);

        if (i > 0) {

            return new AjaxResult(AjaxResult.STATUS_SUCCESS, SystemMessageCode.DELETE_SUCCES, i);

        } else {

            throw new GlobleException(SystemErrorCode.DATA_DELETE_FAIL);

        }

    }

  
}

 src/main/resources/template/excelTemplateForBoot/dao.ftl

New file
@@ -0,0 +1,38 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>	


/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

public interface ${ClassName}{



    public int insert(@Param("item") ${tableClassModel.className} ${tableClassModel.classVariableName});

   	
       public int batchInsert(@Param("list") List<${tableClassModel.className}> ${tableClassModel.classVariableName}List);

   	
    public int updateByMap(Map<String, Object> modifyMap);

	
    public int updateByModel(@Param("record")${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public int deleteByIds(@Param("list") List<String> list);

	
    public int deleteById(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property});



    public int deleteByModel(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public List<${tableClassModel.className}> selectInPage(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName}, @Param("pageVo") PaginationVO pageVo);



    public List<${tableClassModel.className}> selectByModel(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public int selectTotalRecord(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public ${tableClassModel.className}  selectById(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property});

	
    public ${tableClassModel.className}  selectForUpdate(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property});

	
}

 src/main/resources/template/excelTemplateForBoot/daoImpl.ftl

New file
@@ -0,0 +1,226 @@
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">



<mapper namespace="${tableClassModel.qualifiedClassName}">

    <!-- 定义${tableClassModel.className} 的复杂关联map -->

    <resultMap type="${beanQualifiedClassName}" id="${tableClassModel.className}Map">

        <id property="${tableClassModel.primaryKey.property}" column="${tableClassModel.primaryKey.column}" />

        <result property="createBy" column="create_by" />

        <result property="createTime" column="create_time" />

        <result property="updateBy" column="update_by" />

        <result property="updateTime" column="update_time" />

        <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <result property="${item.property}" column="${item.column}" />

            </#if>

        </#list>	
    </resultMap>

	
	
    <!-- 定义${tableClassModel.className} 的简单map  ，本map不添加其他的关联属性 -->

    <resultMap type="${beanQualifiedClassName}" id="${tableClassModel.className}SimpleMap">

        <id property="${tableClassModel.primaryKey.property}" column="${tableClassModel.primaryKey.column}" />

        <result property="createBy" column="create_by" />

        <result property="createTime" column="create_time" />

        <result property="updateBy" column="update_by" />

        <result property="updateTime" column="update_time" />

        <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <result property="${item.property}" column="${item.column}" />

            </#if>

        </#list>	
    </resultMap>

	
    <!-- 字段sql -->

    <sql id="columns">

        create_by,

        create_time,

        update_by,

        update_time,

        <#list tableClassModel.mapping as item> 
            <#if item_has_next>

            ${item.column},

            <#else>

            ${item.column}

            </#if>

        </#list>

    </sql>

	
    <!-- 属性sql -->

    <sql id="propertys">

        ${'#'}{item.createBy},

        now(),

        ${'#'}{item.updateBy},

        now(),

        <#list tableClassModel.mapping as propertyitem>

        <#if propertyitem_has_next>

            ${'#'}{item.${propertyitem.property}},

            <#else>

            ${'#'}{item.${propertyitem.property}}

            </#if>

        </#list>	
    </sql>

	
    <!-- where sql -->

    <sql id="where_sql">

		 
         <if test="record!=null">

            <#list tableClassModel.mapping as item> 
            <if test="(record.${item.property}!=null and record.${item.property}!='') or  (record.${item.property}!='' and record.${item.property}==0)  ">

                and ${item.column}  = ${'#'}{record.${item.property}} 
            </if>

            </#list>	
        </if>

		 
    </sql>

	
    <!--  插入方法   -->

    <insert id="insert" parameterType="${beanQualifiedClassName}"

        useGeneratedKeys="true" keyProperty="item.${tableClassModel.primaryKey.property}">

        INSERT INTO ${tableClassModel.tableName} (

             <include refid="columns"></include>

        )

    VALUES (

         <include refid="propertys"></include>

    )

    </insert>

	
	
	
    <!--  批量插入   -->

    <insert id="batchInsert" parameterType="java.util.List">

        INSERT INTO ${tableClassModel.tableName} (

        <include refid="columns"></include>	
        )

    VALUES 
    <foreach collection="list" item="item" index="index" separator=",">(

        <include refid="propertys"></include>	
    )</foreach>

    </insert>

	
	
	
	
	
    <!--  根据Map更新 部分更新   -->

    <update id="updateByMap" parameterType="java.util.HashMap" >

        UPDATE ${tableClassModel.tableName}

        <set>

            <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <if test="_parameter.containsKey('${item.property}')">

                    ${item.column} = ${'#'}{${item.property}},

                </if>		
            </#if>

            </#list>

        </set>

        WHERE ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.property}} 
    </update> 
	
	
    <!--  根据对象更新 部分更新   -->

    <update id="updateByModel" parameterType="${tableClassModel.primaryKey.classType}">

        UPDATE ${tableClassModel.tableName}

        <set>

            <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <#if item.classType = "String">

            <if test="record.${item.property} != null and record.${item.property} != '' ">

                ${item.column}  = ${'#'}{record.${item.property}}, 
            </if>

            <#else>

            <if test="record.${item.property} != null ">

                ${item.column}  = ${'#'}{record.${item.property}}, 
            </if>

            </#if>	
            </#if>

            </#list>

        </set>

        WHERE ${tableClassModel.primaryKey.column}=${'#'}{record.${tableClassModel.primaryKey.property}} 
    </update>

	
    <!-- 批量删除 -->

    <delete id="deleteByIds" parameterType="java.util.List">

        delete from ${tableClassModel.tableName} where  ${tableClassModel.primaryKey.column} in

        <foreach collection="list" index="index" item="item" open="("

            separator="," close=")">

            ${'#'}{item}

        </foreach>

    </delete>

		
    <!-- 根据id删除-->

    <delete id="deleteById" parameterType="${tableClassModel.primaryKey.classType}">

        DELETE FROM ${tableClassModel.tableName}

        where  ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.property}} 
    </delete>

	
    <!-- 根据对象删除-->

    <delete id="deleteByModel" parameterType="${beanQualifiedClassName}">

        DELETE FROM ${tableClassModel.tableName}

        <where>

        <include refid="where_sql" ></include>

        </where>

    </delete>

	
	
	
    <!-- 分页查询 -->

    <select id="selectInPage" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        <where>

          <include refid="where_sql"></include>

         </where>

        <if test="pageVo !=null"><!-- 判断pageVo对象是否为空 -->

            <if test="pageVo.sort !=null  and pageVo.order !=null">

                order by

                ${'$'}{pageVo.sort} ${'$'}{pageVo.order}

            </if>

            <if test="pageVo.offset >=0  and pageVo.limit >0">

                limit

                ${'#'}{pageVo.offset},${'#'}{pageVo.limit}

            </if>

        </if>

    </select>

	
    <!-- 查询总条数 -->

    <select id="selectTotalRecord" parameterType="long"   resultType="java.lang.Integer">

    select count(*)

    from ${tableClassModel.tableName}

        <where>

           <include refid="where_sql"></include>

        </where>

    </select>



    <!-- 根据id查询-->

    <select id="selectById" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        where  ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.property}} 
    </select>	
	
	
    <!-- 根据id 锁表查询-->

    <select id="selectForUpdate" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        where  ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.column}} 
        for update

    </select>	
	
	
	
    <!-- 根据对象查询-->

    <select id="selectByModel" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        <where>

          <include refid="where_sql"></include>

         </where>

    </select>

</mapper>

 src/main/resources/template/excelTemplateForBoot/form.ftl

New file
@@ -0,0 +1,82 @@
<!DOCTYPE HTML>

<html xmlns:th="http://www.thymeleaf.org">

<head>

<meta charset="utf-8">

<META HTTP-EQUIV="Pragma" CONTENT="no-cache">

<meta name="renderer" content="webkit|ie-comp|ie-stand">

<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">

<meta name="viewport"

    content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />

<meta http-equiv="Cache-Control" content="no-siteapp" />

<!-- 本框架基本脚本和样式 -->

<script type="text/javascript"

    th:src="@{/js/plugin/jquery-2.1.4.min.js}"></script>

<script type="text/javascript"

    th:src="@{/js/systools/MBase.js}"></script>

</head>

<body>

<div class="ibox-content">

        <form class="form-horizontal" id="dataform" onsubmit="javascript:return false;">

            <input type="hidden" name="tokenUrl" th:value="${'$'}{tokenUrl}">	 
            <input type="hidden" name="token" th:value="${'$'}{token}">

            <input type="hidden" name="${tableClassModel.primaryKey.property}" th:value="${'$'}{obj.${tableClassModel.primaryKey.property}}">

        <#assign x = 1>

        <#assign nodelSize = tableClassModel.showCount+1 >

        <#list tableClassModel.mapping as being>

            <#if being.isVisible>

            <#assign x = x + 1>

            <#if x%2 = 0 >

        <div class="form-group">

            </#if>

            <label class="col-sm-2 control-label">${being.showName}

            <#if being.isNecessary>

            <span class="text-danger">*</span>

            </#if>

            </label>

            <div class="col-sm-4">

                <input type="text" class="form-control" name="${being.property}" 
                    <#if being.columnLength??>

                        maxLength="${being.columnLength}" dataType="s1-${being.columnLength}"

                    </#if>

                    <#if !being.isNecessary>

                    ignore="ignore"

                    </#if>

                    th:value="${'$'}{obj.${being.property}}"nullmsg="${being.showName}不能为空">

            </div>

            <#if x%2 = 1 || x = nodelSize>

        </div>

            </#if>

            </#if>

        </#list>	
        <div class="form-group ">

            <div class="col-sm-12 text-center">

                <a href="javascript:;" onclick="myForm.submit()"

                    class="btn btn-success radius"><i class="fa fa-check"></i>  保存</a>&nbsp;&nbsp;&nbsp;&nbsp; <a

                     class="btn btn-danger radius" href="javascript:;" onclick="MTools.closeForm()" ><i class="fa fa-close"></i> 关闭</a>

            </div>

        </div>

    </form>

    </div>

</body>

<script type="text/javascript" th:src="@{/js/systools/MJsBase.js}"></script>

<script th:inline="javascript">

    MTools.autoFullSelect();

    $(".select2").select2();

	
    /*<![CDATA[*/

    var obj=/*[[${'$'}{obj}]]*/

    /*]]>*/

	
    var invokeUrl=basePath+"/admin/${tableClassModel.classVariableName}/add${tableClassModel.className}";

    if(obj.${tableClassModel.primaryKey.property}!=null){

       invokeUrl = basePath+"/admin/${tableClassModel.classVariableName}/modify${tableClassModel.className}";

    }

    var myForm=MForm.initForm({

        invokeUrl:invokeUrl,

        afterSubmit:function(){

            parent.myGrid.serchData();

        },

    });

</script>

</body>

</html>

 src/main/resources/template/excelTemplateForBoot/javaBean.ftl

New file
@@ -0,0 +1,42 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>	


/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

public class ${tableClassModel.className}  extends EntityDTO{

    @Extend

    private static final long serialVersionUID = 1L; 


<#list tableClassModel.mapping as being>

	
    <#if being.memo!="">

    /**

     * ${being.memo}

     */

    </#if>

    private ${being.classType}  ${being.property};

			
</#list>	
	
<#list tableClassModel.mapping as being>



    public ${being.classType} get${being.methodName}() {

        return ${being.property};

    }

   	
       public ${tableClassModel.className} set${being.methodName}(${being.classType} ${being.property}) {

        this.${being.property}=${being.property};

        return this;

    }

   	
</#list>	




  
}

 src/main/resources/template/excelTemplateForBoot/list.ftl

New file
@@ -0,0 +1,161 @@
<!DOCTYPE HTML>

<html xmlns:th="http://www.thymeleaf.org" xmlns:matrix="http://www.w3.org/1999/xhtml">

<html xmlns:th="http://www.thymeleaf.org">

<head>

    <meta charset="utf-8">

    <META HTTP-EQUIV="Pragma" CONTENT="no-cache">

    <meta name="renderer" content="webkit|ie-comp|ie-stand">

    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">

    <meta name="viewport"

          content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no"/>

    <meta http-equiv="Cache-Control" content="no-siteapp"/>

    <!-- 本框架基本脚本和样式 -->

    <script type="text/javascript"

            th:src="@{/js/plugin/jquery-2.1.4.min.js}"></script>

    <script type="text/javascript"

            th:src="@{/js/systools/MBase.js}"></script>

</head>

<body class=" container-fluid">



<div class="pd-10">



    <!-- 搜索框部分start -->

    <div class="row form-head">

        <div class="col-md-4 col-xs-12">

            <button onclick="myGrid.delItems('${tableClassModel.primaryKey.property}')" type="button"   matrix:btn="${tableClassModel.className?uncap_first}-dels"

                    class="btn btn-danger btn-sm">

                <i class="fa fa-trash"></i>批量删除

            </button>

            <button onclick="openAdd()" type="button" matrix:btn="${tableClassModel.className?uncap_first}-add"

                    class="btn btn-success btn-sm">

                <i class="fa fa-plus"></i> 新增

            </button>

        </div>

        <div class="col-md-8 col-xs-12">

            <div class="row">

                <div class="col-md-11 col-xs-12" style="text-align: right">

                    <form class="form-inline" id="serchform"  matrix:btn="${tableClassModel.className?uncap_first}-search" >

                        <div class="input-group">

                            <div class="btn-group search-list " data-for="search-text">

                                <button type="button"

                                        class="btn btn-default dropdown-toggle searchlist"

                                        data-toggle="dropdown">

                                    用户姓名 <span class="caret "></span>

                                </button>

                                <ul class="dropdown-menu" role="menu">

                                    <li data-field="suName"><a>用户姓名</a></li>

                                    <li data-field="suAccount"><a>账号 </a></li>

                                </ul>

                            </div>

                            <div class="form-group mr-20 ml-20">

                                <input id="search-text" name="suName" placeholder="输入查询关键词"

                                       type="text" class="form-control">

                            </div>

                            <div class="form-group">

                                <button onclick="myGrid.serchData(1)" type="button"

                                        class="btn btn-info">

                                    <i class="fa fa-search "></i> 搜索

                                </button>

                                <button type="reset" class="btn btn-info ">

                                    <i class="fa fa-refresh "></i> 重置

                                </button>

                            </div>

                        </div>

                        <!-- 高级搜索

                        <div class="senior-content">

                            <div class="serch-headline">高级搜索</div>

                            <div>

                                <span class="serch-title">电话：</span> <input type="text" name="suTel"

                                    class="form-control">

                            </div>

                            <div class="button">

                                <button type="button" class="btn btn-info" onclick="myGrid.serchData()">确认</button>

                                <button type="button" class="btn btn-warning serch-close">取消</button>

                            </div>

                        </div> -->

                    </form>

                </div>

                <!--    <div class="col-md-1 text-r layui-anim" data-anim="layui-anim-up">

                        <a class="senior-serch">高级搜索</a>

                    </div>-->

            </div>

        </div>

    </div>



    <div class="row">

        <table id="mgrid">

            <thead>

            <tr>

                <th data-checkbox="true"></th>

                <th data-formatter="MGrid.indexfn" data-align="center" data-width="30px">序号</th>

                <#list tableClassModel.mapping as being>

                    <#if being.isVisible>

                        <th data-field="${being.property}">${being.showName}</th>

                    </#if>

                </#list>

                <th data-align="center" data-width="195px" data-field="${tableClassModel.primaryKey.property}"

                    data-formatter="buidOperate">操作

                </th>

            </tr>

            </thead>

        </table>

    </div>

</div>

<script type="text/javascript"

        th:src="@{/js/systools/MJsBase.js}"></script>

<script type="text/javascript">

    var myGrid;

    $(function () {

        var delUrl = "";

        delUrl = basePath + "/admin/${tableClassModel.classVariableName}/del";

        myGrid = MGrid.initGrid({

            url: basePath + "/admin/${tableClassModel.classVariableName}/showList",

            delUrl: delUrl,

        });



    });



    function buidOperate(value, row, index) {

        var html = "";

        html += '<div class="btn-group">'

            + '<button type="button" class="btn btn-info dropdown-toggle" data-toggle="dropdown">'

            + '操作 <span class="caret"></span>' + '</button>'

            + '<ul class="dropdown-menu" role="menu">'

            + '<li><a href="javascript:void(0)" style="display:'

            + value

            + '"  onClick="openEdit(\''

            + value

            + '\')" title="编辑">编辑</a></li>'

            + '<li><a href="javascript:void(0)" style="display:'

            + value

            + '" onClick="myGrid.delItem(\''

            + value

            + '\')" title="删除">删除</a></li>' + '</ul>' + '</div>';

        html += '';

        return html;

    }



    //打开添加界面

    function openAdd() {

        layer.open({

            type: 2,

            title: "添加${tableClassModel.tableMemo}",

            area: [MUI.SIZE_L, '400px'],

            maxmin: true,

            content: [basePath + '/admin/${tableClassModel.classVariableName}/editForm']

        });

    }



    //打开编辑界面

    function openEdit(id) {

        layer.open({

            type: 2,

            title: "编辑${tableClassModel.tableMemo}",

            area: [MUI.SIZE_L, '400px'],

            maxmin: true,

            content: [basePath + '/admin/${tableClassModel.classVariableName}/editForm?id=' + id]

        });

    }

</script>

</body>

</html>


 src/main/resources/template/excelTemplateForBoot/mybatis-config.ftl

New file
@@ -0,0 +1,33 @@
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration  PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">



<configuration>

    <settings>

        <setting name="cacheEnabled" value="false" />

           <setting name="lazyLoadingEnabled" value="false" />

           <setting name="multipleResultSetsEnabled" value="true" />

           <setting name="useColumnLabel" value="true" />

           <setting name="useGeneratedKeys" value="false" />

           <setting name="defaultExecutorType" value="SIMPLE" />

           <setting name="defaultStatementTimeout" value="25000" />

    </settings>

	
	


	
    <typeAliases>



    <#list alias as item> 
    ${item}

    </#list>	


    </typeAliases>

	
    <mappers>

	
        <#list mappers as item> 
        ${item}

        </#list>	
		
    </mappers>

</configuration>

 src/main/resources/template/excelTemplateForBoot/sqlFile.ftl

New file
@@ -0,0 +1,46 @@


/**

 * ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

 CREATE TABLE ${tableClassModel.tableName}(

  create_by varchar(100) NOT NULL COMMENT '创建人',

  create_time datetime NOT NULL COMMENT '创建时间',

  update_by varchar(100) NOT NULL COMMENT '更新人',

  update_time datetime NOT NULL COMMENT '更新时间',

<#list tableClassModel.mapping as being>

<#if being.column = tableClassModel.primaryKey.column && being.fullJdbcType = "int">

 ${being.column} ${being.fullJdbcType}  ${being.isAllowNull} AUTO_INCREMENT  COMMENT '${being.memo}',

 <#else>

 ${being.column} ${being.fullJdbcType}  ${being.isAllowNull}  COMMENT '${being.memo}',

</#if>

 
</#list>	
PRIMARY KEY(${tableClassModel.primaryKey.column})

)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='${tableClassModel.tableMemo}';



/**

 *

 *生成菜单的sql 默认在权限管理目录下 根据不同的主键类型生成不同的菜单SQL

 */

 <#if  tableClassModel.primaryKey.fullJdbcType = "int">

INSERT INTO `sys_function` 
VALUES 
      ('开发者', now(), 
      '开发者', now(), 
      null, 
      '', 'biz/${tableClassModel.className?uncap_first}-list', '否', '2', 
      1, 
      '${tableClassModel.tableMemo}', '4', '${tableClassModel.className?uncap_first}', '123', '是', null);

 <#else>

INSERT INTO `sys_function` 
VALUES 
      ('开发者', now(), 
      '开发者', now(), 
      replace(uuid(), '-', ''), 
      '', 'biz/${tableClassModel.className?uncap_first}-list', '否', '2', 
      '05fb2915b39b4021a51d406473f0ee91', 
      '${tableClassModel.tableMemo}', '4', '${tableClassModel.className?uncap_first}', '123', '是', null);

</#if>




 src/main/resources/template/excelTemplateForBoot/数据字典表(模板).xlsx

Binary files differ

 src/main/resources/template/excelTemplateForCloud/action.ftl

New file
@@ -0,0 +1,81 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>	


/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

@Controller

@RequestMapping(value = "admin/${tableClassModel.classVariableName}")

public class ${ClassName} {



    @Autowired

    private ${tableClassModel.className}Dao ${tableClassModel.classVariableName}Dao;

    @Autowired

    RedisUserLoginUtils redisUserLoginUtils;

	
    /**

     * 列表显示

     */

    @RequestMapping(value =  "/showList")

    public @ResponseBody AjaxResult showList(${tableClassModel.className} ${tableClassModel.classVariableName}) {

        List<${tableClassModel.className}> dataList = ${tableClassModel.classVariableName}Dao.selectInPage(${tableClassModel.classVariableName});

        AjaxResult result = new AjaxResult(AjaxResult.STATUS_SUCCESS, dataList,

                ${tableClassModel.classVariableName}Dao.selectTotalRecord(${tableClassModel.classVariableName}));

        return result;

    }

   	
    /**

     * 新增

     */   
    @RemoveRequestToken	
       @RequestMapping(value =  "/add${tableClassModel.className}")

    public @ResponseBody AjaxResult add${tableClassModel.className}(${tableClassModel.className} ${tableClassModel.classVariableName}) {

        SysUsers user = redisUserLoginUtils.getLoginUser(SysUsers.class);

        ${tableClassModel.classVariableName}.setCreateBy(user.getSuName());

        ${tableClassModel.classVariableName}.setUpdateBy(user.getSuName());

         int i=${tableClassModel.classVariableName}Dao.insert(${tableClassModel.classVariableName});

         if(i > 0){

             return new AjaxResult(AjaxResult.STATUS_SUCCESS, SystemMessageCode.ADD_SUCCES, "${tableClassModel.tableMemo}");

         }else {

            throw new GlobleException(SystemErrorCode.DATA_ADD_FAIL);

        }

    }



	
    /**

     * 修改

     */   
    @RemoveRequestToken	
       @RequestMapping(value =  "/modify${tableClassModel.className}")

    public @ResponseBody AjaxResult modify${tableClassModel.className}(${tableClassModel.className} new${tableClassModel.className}) {

        int i = ${tableClassModel.classVariableName}Dao.updateByModel(new${tableClassModel.className});

        if (i > 0) {

            return new AjaxResult(AjaxResult.STATUS_SUCCESS, SystemMessageCode.UPDATE_SUCCES, "${tableClassModel.tableMemo}");

        } else {

            throw new GlobleException(SystemErrorCode.DATA_UPDATE_FAIL);

        }

    }



   	
       /**

     * 删除

     */  
     @RequestMapping(value = "/del")

    public @ResponseBody AjaxResult del(String keys) {

        SysUsers user = redisUserLoginUtils.getLoginUser(SysUsers.class);

        Long companyId = user.getCompanyId();

        List<String> ids = StringUtils.strToCollToString(keys, ",");

        int i =  ${tableClassModel.classVariableName}Dao.deleteByIds(ids,companyId);

        if (i > 0) {

            return new AjaxResult(AjaxResult.STATUS_SUCCESS, SystemMessageCode.DELETE_SUCCES, i);

        } else {

            throw new GlobleException(SystemErrorCode.DATA_DELETE_FAIL);

        }

    }

  
}

 src/main/resources/template/excelTemplateForCloud/dao.ftl

New file
@@ -0,0 +1,40 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>	


/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

public interface ${ClassName}{



    public int insert(@Param("item") ${tableClassModel.className} ${tableClassModel.classVariableName});

   	
       public int batchInsert(@Param("list") List<${tableClassModel.className}> ${tableClassModel.classVariableName}List);

   	
    public int updateByMap(Map<String, Object> modifyMap);



    public int compelUpdateByModel(@Param("record")${tableClassModel.className} ${tableClassModel.classVariableName});



    public int updateByModel(@Param("record")${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public int deleteByIds(@Param("list") List<String> list , @Param("companyId") Long companyId);

	
    public int deleteById(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property}, Long companyId);



    public int deleteByModel(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public List<${tableClassModel.className}> selectInPage(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});



    public List<${tableClassModel.className}> selectByModel(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public int selectTotalRecord(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});

	
    public ${tableClassModel.className}  selectById(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property});

	
    public ${tableClassModel.className}  selectForUpdate(${tableClassModel.primaryKey.classType} ${tableClassModel.primaryKey.property});

	
}

 src/main/resources/template/excelTemplateForCloud/daoImpl.ftl

New file
@@ -0,0 +1,252 @@
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">



<mapper namespace="${tableClassModel.qualifiedClassName}">

    <!-- 定义${tableClassModel.className} 的复杂关联map -->

    <resultMap type="${beanQualifiedClassName}" id="${tableClassModel.className}Map">

        <id property="${tableClassModel.primaryKey.property}" column="${tableClassModel.primaryKey.column}" />

        <result property="createBy" column="create_by" />

        <result property="createTime" column="create_time" />

        <result property="updateBy" column="update_by" />

        <result property="updateTime" column="update_time" />

        <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <result property="${item.property}" column="${item.column}" />

            </#if>

        </#list>	
    </resultMap>

	
	
    <!-- 定义${tableClassModel.className} 的简单map  ，本map不添加其他的关联属性 -->

    <resultMap type="${beanQualifiedClassName}" id="${tableClassModel.className}SimpleMap">

        <id property="${tableClassModel.primaryKey.property}" column="${tableClassModel.primaryKey.column}" />

        <result property="createBy" column="create_by" />

        <result property="createTime" column="create_time" />

        <result property="updateBy" column="update_by" />

        <result property="updateTime" column="update_time" />

        <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <result property="${item.property}" column="${item.column}" />

            </#if>

        </#list>	
    </resultMap>

	
    <!-- 字段sql -->

    <sql id="columns">

        create_by,

        create_time,

        update_by,

        update_time,

        <#list tableClassModel.mapping as item> 
            <#if item_has_next>

            ${item.column},

            <#else>

            ${item.column}

            </#if>

        </#list>

    </sql>

	
    <!-- 属性sql -->

    <sql id="propertys">

        ${'#'}{item.createBy},

        now(),

        ${'#'}{item.updateBy},

        now(),

        <#list tableClassModel.mapping as propertyitem>

        <#if propertyitem_has_next>

            ${'#'}{item.${propertyitem.property}},

            <#else>

            ${'#'}{item.${propertyitem.property}}

            </#if>

        </#list>	
    </sql>

	
    <!-- where sql -->

    <sql id="where_sql">

		 
         <if test="record!=null">

            <#list tableClassModel.mapping as item> 
            <if test="(record.${item.property}!=null and record.${item.property}!='') or  (record.${item.property}!='' and record.${item.property}==0)  ">

                and ${item.column}  = ${'#'}{record.${item.property}} 
            </if>

            </#list>	
        </if>

		 
    </sql>

	
    <!--  插入方法   -->

    <insert id="insert" parameterType="${beanQualifiedClassName}"

        useGeneratedKeys="true" keyProperty="item.${tableClassModel.primaryKey.property}">

        INSERT INTO ${tableClassModel.tableName} (

             <include refid="columns"></include>

        )

    VALUES (

         <include refid="propertys"></include>

    )

    </insert>

	
	
	
    <!--  批量插入   -->

    <insert id="batchInsert" parameterType="java.util.List">

        INSERT INTO ${tableClassModel.tableName} (

        <include refid="columns"></include>	
        )

    VALUES 
    <foreach collection="list" item="item" index="index" separator=",">(

        <include refid="propertys"></include>	
    )</foreach>

    </insert>

	
	
	
	
	
    <!--  根据Map更新 部分更新   -->

    <update id="updateByMap" parameterType="java.util.HashMap" >

        UPDATE ${tableClassModel.tableName}

        <set>

            update_time = now(),

            <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <if test="_parameter.containsKey('${item.property}')">

                    ${item.column} = ${'#'}{${item.property}},

                </if>		
            </#if>

            </#list>

        </set>

        WHERE ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.property}} 
    </update> 
	
	
    <!--  根据对象更新 部分更新   -->

    <update id="updateByModel" parameterType="${tableClassModel.primaryKey.classType}">

        UPDATE ${tableClassModel.tableName}

        <set>

            update_time = now(),

            <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

            <#if item.classType = "String">

            <if test="record.${item.property} != null and record.${item.property} != '' ">

                ${item.column}  = ${'#'}{record.${item.property}}, 
            </if>

            <#else>

            <if test="record.${item.property} != null ">

                ${item.column}  = ${'#'}{record.${item.property}}, 
            </if>

            </#if>	
            </#if>

            </#list>

        </set>

        WHERE ${tableClassModel.primaryKey.column}=${'#'}{record.${tableClassModel.primaryKey.property}} 
    </update>



    <!--  根据对象更新 部分更新(Integer和String类型为空时也会更新)   -->

    <update id="compelUpdateByModel" parameterType="${tableClassModel.primaryKey.classType}">

        UPDATE ${tableClassModel.tableName}

        <set>

            update_time = now(),

            <#list tableClassModel.mapping as item>

                <#if !item.isPrimaryKey>

                    <#if item.classType = "String">

                        <if test="record.${item.property} != null">

                            ${item.column}  = ${'#'}{record.${item.property}},

                        </if>

                    <#else>

                        <if test="record.${item.property} != '' ">

                            ${item.column}  = ${'#'}{record.${item.property}},

                        </if>

                    </#if>

                </#if>

            </#list>

        </set>

        WHERE ${tableClassModel.primaryKey.column}=${'#'}{record.${tableClassModel.primaryKey.property}}

    </update>

	
    <!-- 批量删除 -->

    <delete id="deleteByIds" parameterType="java.util.List">

        delete from ${tableClassModel.tableName} where  ${tableClassModel.primaryKey.column} in

        <foreach collection="list" index="index" item="item" open="("

            separator="," close=")">

            ${'#'}{item}

        </foreach>

        and company_id = ${'#'}{companyId}

    </delete>

		
    <!-- 根据id删除-->

    <delete id="deleteById" parameterType="${tableClassModel.primaryKey.classType}">

        DELETE FROM ${tableClassModel.tableName}

        where  ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.property}}

               and company_id = ${'#'}{companyId}

    </delete>

	
    <!-- 根据对象删除-->

    <delete id="deleteByModel" parameterType="${beanQualifiedClassName}">

        DELETE FROM ${tableClassModel.tableName}

        <where>

        <include refid="where_sql" ></include>

        </where>

    </delete>

	
	
	
    <!-- 分页查询 -->

    <select id="selectInPage" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        <where>

          <include refid="where_sql"></include>

         </where>

        <if test="record !=null"><!-- 判断pageVo对象是否为空 -->

            <if test="record.sort !=null  and record.order !=null">

                order by

                ${'$'}{record.sort} ${'$'}{record.order}

            </if>

            <if test="record.offset >=0  and record.limit >0">

                limit

                ${'#'}{record.offset},${'#'}{record.limit}

            </if>

        </if>

    </select>

	
    <!-- 查询总条数 -->

    <select id="selectTotalRecord" parameterType="long"   resultType="java.lang.Integer">

    select count(*)

    from ${tableClassModel.tableName}

        <where>

           <include refid="where_sql"></include>

        </where>

    </select>



    <!-- 根据id查询-->

    <select id="selectById" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        where  ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.property}} 
    </select>	
	
	
    <!-- 根据id 锁表查询-->

    <select id="selectForUpdate" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        where  ${tableClassModel.primaryKey.column}=${'#'}{${tableClassModel.primaryKey.column}} 
        for update

    </select>	
	
	
	
    <!-- 根据对象查询-->

    <select id="selectByModel" resultMap="${tableClassModel.className}Map">

        select 
        <include refid="columns" ></include>

        from ${tableClassModel.tableName}

        <where>

          <include refid="where_sql"></include>

         </where>

    </select>

</mapper>

 src/main/resources/template/excelTemplateForCloud/form.ftl

New file
@@ -0,0 +1,82 @@
<!DOCTYPE HTML>

<html xmlns:th="http://www.thymeleaf.org">

<head>

<meta charset="utf-8">

<META HTTP-EQUIV="Pragma" CONTENT="no-cache">

<meta name="renderer" content="webkit|ie-comp|ie-stand">

<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">

<meta name="viewport"

    content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />

<meta http-equiv="Cache-Control" content="no-siteapp" />

<!-- 本框架基本脚本和样式 -->

<script type="text/javascript"

    th:src="@{/js/plugin/jquery-2.1.4.min.js}"></script>

<script type="text/javascript"

    th:src="@{/js/systools/MBase.js}"></script>

</head>

<body>

<div class="ibox-content">

        <form class="form-horizontal" id="dataform" onsubmit="javascript:return false;">

            <input type="hidden" name="tokenUrl" th:value="${'$'}{tokenUrl}">	 
            <input type="hidden" name="token" th:value="${'$'}{token}">

            <input type="hidden" name="${tableClassModel.primaryKey.property}" th:value="${'$'}{obj.${tableClassModel.primaryKey.property}}">

        <#assign x = 1>

        <#assign nodelSize = tableClassModel.showCount+1 >

        <#list tableClassModel.mapping as being>

            <#if being.isVisible>

            <#assign x = x + 1>

            <#if x%2 = 0 >

        <div class="form-group">

            </#if>

            <label class="col-sm-2 control-label">${being.showName}

            <#if being.isNecessary>

            <span class="text-danger">*</span>

            </#if>

            </label>

            <div class="col-sm-4">

                <input type="text" class="form-control" name="${being.property}" 
                    <#if being.columnLength??>

                        maxLength="${being.columnLength}" dataType="s1-${being.columnLength}"

                    </#if>

                    <#if !being.isNecessary>

                    ignore="ignore"

                    </#if>

                    th:value="${'$'}{obj.${being.property}}"nullmsg="${being.showName}不能为空">

            </div>

            <#if x%2 = 1 || x = nodelSize>

        </div>

            </#if>

            </#if>

        </#list>	
        <div class="form-group ">

            <div class="col-sm-12 text-center">

                <a href="javascript:;" onclick="myForm.submit()"

                    class="btn btn-success radius"><i class="fa fa-check"></i>  保存</a>&nbsp;&nbsp;&nbsp;&nbsp; <a

                     class="btn btn-danger radius" href="javascript:;" onclick="MTools.closeForm()" ><i class="fa fa-close"></i> 关闭</a>

            </div>

        </div>

    </form>

    </div>

</body>

<script type="text/javascript" th:src="@{/js/systools/MJsBase.js}"></script>

<script th:inline="javascript">

    MTools.autoFullSelect();

    $(".select2").select2();

	
    /*<![CDATA[*/

    var obj=/*[[${'$'}{obj}]]*/

    /*]]>*/

	
    var invokeUrl=basePath+"/admin/${tableClassModel.classVariableName}/add${tableClassModel.className}";

    if(obj.${tableClassModel.primaryKey.property}!=null){

       invokeUrl = basePath+"/admin/${tableClassModel.classVariableName}/modify${tableClassModel.className}";

    }

    var myForm=MForm.initForm({

        invokeUrl:invokeUrl,

        afterSubmit:function(){

            parent.myGrid.serchData();

        },

    });

</script>

</body>

</html>

 src/main/resources/template/excelTemplateForCloud/javaBean.ftl

New file
@@ -0,0 +1,42 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>	


/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

public class ${tableClassModel.className}  extends EntityDTOExt{

    @Extend

    private static final long serialVersionUID = 1L; 


<#list tableClassModel.mapping as being>

	
    <#if being.memo!="">

    /**

     * ${being.memo}

     */

    </#if>

    private ${being.classType}  ${being.property};

			
</#list>	
	
<#list tableClassModel.mapping as being>



    public ${being.classType} get${being.methodName}() {

        return ${being.property};

    }

   	
       public ${tableClassModel.className} set${being.methodName}(${being.classType} ${being.property}) {

        this.${being.property}=${being.property};

        return this;

    }

   	
</#list>	




  
}

 src/main/resources/template/excelTemplateForCloud/list.ftl

New file
@@ -0,0 +1,161 @@
<!DOCTYPE HTML>

<html xmlns:th="http://www.thymeleaf.org" xmlns:matrix="http://www.w3.org/1999/xhtml">

<html xmlns:th="http://www.thymeleaf.org">

<head>

    <meta charset="utf-8">

    <META HTTP-EQUIV="Pragma" CONTENT="no-cache">

    <meta name="renderer" content="webkit|ie-comp|ie-stand">

    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">

    <meta name="viewport"

          content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no"/>

    <meta http-equiv="Cache-Control" content="no-siteapp"/>

    <!-- 本框架基本脚本和样式 -->

    <script type="text/javascript"

            th:src="@{/js/plugin/jquery-2.1.4.min.js}"></script>

    <script type="text/javascript"

            th:src="@{/js/systools/MBase.js}"></script>

</head>

<body class=" container-fluid">



<div class="pd-10">



    <!-- 搜索框部分start -->

    <div class="row form-head">

        <div class="col-md-4 col-xs-12">

            <button onclick="myGrid.delItems('${tableClassModel.primaryKey.property}')" type="button"   matrix:btn="${tableClassModel.className?uncap_first}-dels"

                    class="btn btn-danger btn-sm">

                <i class="fa fa-trash"></i>批量删除

            </button>

            <button onclick="openAdd()" type="button" matrix:btn="${tableClassModel.className?uncap_first}-add"

                    class="btn btn-success btn-sm">

                <i class="fa fa-plus"></i> 新增

            </button>

        </div>

        <div class="col-md-8 col-xs-12">

            <div class="row">

                <div class="col-md-11 col-xs-12" style="text-align: right">

                    <form class="form-inline" id="serchform"  matrix:btn="${tableClassModel.className?uncap_first}-search" >

                        <div class="input-group">

                            <div class="btn-group search-list " data-for="search-text">

                                <button type="button"

                                        class="btn btn-default dropdown-toggle searchlist"

                                        data-toggle="dropdown">

                                    用户姓名 <span class="caret "></span>

                                </button>

                                <ul class="dropdown-menu" role="menu">

                                    <li data-field="suName"><a>用户姓名</a></li>

                                    <li data-field="suAccount"><a>账号 </a></li>

                                </ul>

                            </div>

                            <div class="form-group mr-20 ml-20">

                                <input id="search-text" name="suName" placeholder="输入查询关键词"

                                       type="text" class="form-control">

                            </div>

                            <div class="form-group">

                                <button onclick="myGrid.serchData(1)" type="button"

                                        class="btn btn-info">

                                    <i class="fa fa-search "></i> 搜索

                                </button>

                                <button type="reset" class="btn btn-info ">

                                    <i class="fa fa-refresh "></i> 重置

                                </button>

                            </div>

                        </div>

                        <!-- 高级搜索

                        <div class="senior-content">

                            <div class="serch-headline">高级搜索</div>

                            <div>

                                <span class="serch-title">电话：</span> <input type="text" name="suTel"

                                    class="form-control">

                            </div>

                            <div class="button">

                                <button type="button" class="btn btn-info" onclick="myGrid.serchData()">确认</button>

                                <button type="button" class="btn btn-warning serch-close">取消</button>

                            </div>

                        </div> -->

                    </form>

                </div>

                <!--    <div class="col-md-1 text-r layui-anim" data-anim="layui-anim-up">

                        <a class="senior-serch">高级搜索</a>

                    </div>-->

            </div>

        </div>

    </div>



    <div class="row">

        <table id="mgrid">

            <thead>

            <tr>

                <th data-checkbox="true"></th>

                <th data-formatter="MGrid.indexfn" data-align="center" data-width="30px">序号</th>

                <#list tableClassModel.mapping as being>

                    <#if being.isVisible>

                        <th data-field="${being.property}">${being.showName}</th>

                    </#if>

                </#list>

                <th data-align="center" data-width="195px" data-field="${tableClassModel.primaryKey.property}"

                    data-formatter="buidOperate">操作

                </th>

            </tr>

            </thead>

        </table>

    </div>

</div>

<script type="text/javascript"

        th:src="@{/js/systools/MJsBase.js}"></script>

<script type="text/javascript">

    var myGrid;

    $(function () {

        var delUrl = "";

        delUrl = basePath + "/admin/${tableClassModel.classVariableName}/del";

        myGrid = MGrid.initGrid({

            url: basePath + "/admin/${tableClassModel.classVariableName}/showList",

            delUrl: delUrl,

        });



    });



    function buidOperate(value, row, index) {

        var html = "";

        html += '<div class="btn-group">'

            + '<button type="button" class="btn btn-info dropdown-toggle" data-toggle="dropdown">'

            + '操作 <span class="caret"></span>' + '</button>'

            + '<ul class="dropdown-menu" role="menu">'

            + '<li><a href="javascript:void(0)" style="display:'

            + value

            + '"  onClick="openEdit(\''

            + value

            + '\')" title="编辑">编辑</a></li>'

            + '<li><a href="javascript:void(0)" style="display:'

            + value

            + '" onClick="myGrid.delItem(\''

            + value

            + '\')" title="删除">删除</a></li>' + '</ul>' + '</div>';

        html += '';

        return html;

    }



    //打开添加界面

    function openAdd() {

        layer.open({

            type: 2,

            title: "添加${tableClassModel.tableMemo}",

            area: [MUI.SIZE_L, '400px'],

            maxmin: true,

            content: [basePath + '/admin/${tableClassModel.classVariableName}/editForm']

        });

    }



    //打开编辑界面

    function openEdit(id) {

        layer.open({

            type: 2,

            title: "编辑${tableClassModel.tableMemo}",

            area: [MUI.SIZE_L, '400px'],

            maxmin: true,

            content: [basePath + '/admin/${tableClassModel.classVariableName}/editForm?id=' + id]

        });

    }

</script>

</body>

</html>


 src/main/resources/template/excelTemplateForCloud/mybatis-config.ftl

New file
@@ -0,0 +1,33 @@
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration  PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">



<configuration>

    <settings>

        <setting name="cacheEnabled" value="false" />

           <setting name="lazyLoadingEnabled" value="false" />

           <setting name="multipleResultSetsEnabled" value="true" />

           <setting name="useColumnLabel" value="true" />

           <setting name="useGeneratedKeys" value="false" />

           <setting name="defaultExecutorType" value="SIMPLE" />

           <setting name="defaultStatementTimeout" value="25000" />

    </settings>

	
	


	
    <typeAliases>



    <#list alias as item> 
    ${item}

    </#list>	


    </typeAliases>

	
    <mappers>

	
        <#list mappers as item> 
        ${item}

        </#list>	
		
    </mappers>

</configuration>

 src/main/resources/template/excelTemplateForCloud/sqlFile.ftl

New file
@@ -0,0 +1,54 @@


/**

 * ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

 CREATE TABLE ${tableClassModel.tableName}(

  create_by varchar(100) NOT NULL COMMENT '创建人',

  create_time datetime NOT NULL COMMENT '创建时间',

  update_by varchar(100) NOT NULL COMMENT '更新人',

  update_time datetime NOT NULL COMMENT '更新时间',

<#list tableClassModel.mapping as being>

<#if being.column = tableClassModel.primaryKey.column && being.jdbcType = "int">

 ${being.column} ${being.fullJdbcType}  ${being.isAllowNull} AUTO_INCREMENT  COMMENT '${being.memo}',

 <#else>

 ${being.column} ${being.fullJdbcType}  ${being.isAllowNull}  COMMENT '${being.memo}',

</#if>

 
</#list>	
PRIMARY KEY(${tableClassModel.primaryKey.column})

)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='${tableClassModel.tableMemo}';



<#list tableClassModel.mapping as being>

<#if (being.indexName)??>

  ALTER TABLE ${tableClassModel.tableName}

  ADD INDEX ${being.indexName} (${being.column}) USING BTREE ;

</#if>

</#list>





/**

 *

 *生成菜单的sql 默认在权限管理目录下 根据不同的主键类型生成不同的菜单SQL

 */

 <#if  tableClassModel.primaryKey.fullJdbcType = "int">

INSERT INTO `sys_function` 
VALUES 
      ('开发者', now(), 
      '开发者', now(), 
      null, 
      '', 'biz/${tableClassModel.className?uncap_first}-list', '否', '2', 
      1, 
      '${tableClassModel.tableMemo}', '4', '${tableClassModel.className?uncap_first}', '123', '是', null);

 <#else>

INSERT INTO `sys_function` 
VALUES 
      ('开发者', now(), 
      '开发者', now(), 
      replace(uuid(), '-', ''), 
      '', 'biz/${tableClassModel.className?uncap_first}-list', '否', '2', 
      '05fb2915b39b4021a51d406473f0ee91', 
      '${tableClassModel.tableMemo}', '4', '${tableClassModel.className?uncap_first}', '123', '是', null);

</#if>




 src/main/resources/template/excelTemplateForCloud/数据字典表(模板).xlsx

Binary files differ

 src/main/resources/template/excelTemplateForHis/action.ftl

New file
@@ -0,0 +1,71 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>

import com.matrix.core.pojo.AjaxResult;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.web.bind.annotation.*;

import io.swagger.annotations.Api;

import io.swagger.annotations.ApiOperation;

/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

@Api(value=" ${tableClassModel.tableMemo}",tags={" ${tableClassModel.tableMemo}接口"})

@RestController

@RequestMapping(value = "/${tableClassModel.classVariableName}")

public class ${ClassName} {



    @Autowired

    private ${tableClassModel.className}Service ${tableClassModel.classVariableName}Service;



    /**

     * 列表显示

     */

    @ApiOperation("列表显示")

    @PostMapping(value =  "/showList")

    public  AjaxResult showList(@RequestBody ${tableClassModel.className} ${tableClassModel.classVariableName}) {



        return    ${tableClassModel.classVariableName}Service.showList(${tableClassModel.classVariableName});

    }

   	
    /**

     * 新增

     */

    @ApiOperation("新增")

       @PostMapping(value =  "/su/add")

    public  AjaxResult add${tableClassModel.className}(@RequestBody ${tableClassModel.className} ${tableClassModel.classVariableName}) {

        return    ${tableClassModel.classVariableName}Service.add(${tableClassModel.classVariableName});

    }



	
    /**

     * 修改

     */

    @ApiOperation("修改")

       @PostMapping(value =  "/su/modify")

    public  AjaxResult modify(@RequestBody ${tableClassModel.className} ${tableClassModel.classVariableName}) {

        return    ${tableClassModel.classVariableName}Service.modify(${tableClassModel.classVariableName});

    }



   	
       /**

     * 批量删除

     */

    @ApiOperation("批量删除")

    @PostMapping(value = "/su/deleteIds")

    public  AjaxResult del(String ids) {

        return    ${tableClassModel.classVariableName}Service.del(ids);

    }

    /**

    * 删除

    */

    @ApiOperation("删除")

    @PostMapping(value = "/su/delete")

    public  AjaxResult deleteByPrimaryKey(Integer id) {

    return    ${tableClassModel.classVariableName}Service.deleteByPrimaryKey(id);

    }

  
}

 src/main/resources/template/excelTemplateForHis/dao.ftl

New file
@@ -0,0 +1,15 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>

import com.xincheng.common.dao.BaseMapper;

/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

public interface ${ClassName} extends BaseMapper<${tableClassModel.className}>{

  List<${tableClassModel.className}> selectByKeyword(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});

  Integer selectCountByKeyword(@Param("record") ${tableClassModel.className} ${tableClassModel.classVariableName});

}

 src/main/resources/template/excelTemplateForHis/daoImpl.ftl

New file
@@ -0,0 +1,104 @@
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">



<mapper namespace="${tableClassModel.qualifiedClassName}">

    <!-- 定义${tableClassModel.className} 的复杂关联map -->

    <resultMap type="${beanQualifiedClassName}" id="${tableClassModel.className}Map">

        <id property="${tableClassModel.primaryKey.property}" column="${tableClassModel.primaryKey.column}" />

        <result property="createBy" column="create_by" />

        <result property="createTime" column="create_time" />

        <result property="updateBy" column="update_by" />

        <result property="updateTime" column="update_time" />

        <result property="createDeptId" column="create_dept_id" />

        <result property="createStoreId" column="create_store_id" />

        <result property="companyId" column="company_id" />

        <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

        <result property="${item.property}" column="${item.column}" />

            </#if>

        </#list>

    </resultMap>

	
	
    <!-- 定义${tableClassModel.className} 的简单map  ，本map不添加其他的关联属性 -->

    <resultMap type="${beanQualifiedClassName}" id="${tableClassModel.className}SimpleMap">

        <result property="createBy" column="create_by" />

        <result property="createTime" column="create_time" />

        <result property="updateBy" column="update_by" />

        <result property="updateTime" column="update_time" />

        <result property="createDeptId" column="create_dept_id" />

        <result property="createStoreId" column="create_store_id" />

        <result property="companyId" column="company_id" />

        <#list tableClassModel.mapping as item>

            <#if !item.isPrimaryKey>

        <result property="${item.property}" column="${item.column}" />

            </#if>

        </#list>

    </resultMap>



    <sql id="columns">

        ${r'${alias}'}.create_by ${r'${columnPrefix}'}create_by,

        ${r'${alias}'}.create_time ${r'${columnPrefix}'}create_time,

        ${r'${alias}'}.update_by ${r'${columnPrefix}'}update_by,

        ${r'${alias}'}.update_time ${r'${columnPrefix}'}update_time,

        ${r'${alias}'}.create_dept_id ${r'${columnPrefix}'}create_dept_id,

        ${r'${alias}'}.create_store_id ${r'${columnPrefix}'}create_store_id,

        ${r'${alias}'}.company_id ${r'${columnPrefix}'}company_id,

        <#list tableClassModel.mapping as item>

            <#if item_has_next>

        ${r'${alias}'}.${item.column}  ${r'${columnPrefix}'}${item.column},

            <#else>

        ${r'${alias}'}.${item.column} ${r'${columnPrefix}'}${item.column}

            </#if>

        </#list>

    </sql>

    <!-- where sql -->

    <sql id="keyword_where_sql">



        <if test="record!=null">

            <if test="(record.companyId!=null and record.companyId!='')">

                and ${r'${alias}'}.company_id  =  ${'#'}{record.companyId}

            </if>

            <if test="(record.createStoreId!=null and record.createStoreId!='')">

                and ${r'${alias}'}.create_store_id  =  ${'#'}{record.createStoreId}

            </if>

            <if test="(record.createDeptId!=null and record.createDeptId!='')">

                and ${r'${alias}'}.create_dept_id  =  ${'#'}{record.createDeptId}

            </if>

            <#list tableClassModel.mapping as item>

                <#if item.classType=="String">

                    <if test="(record.${item.property}!=null and record.${item.property}!='')">

                        and ${r'${alias}'}.${item.column}  = ${'#'}{record.${item.property}}

                    </if>

                <#else>

                <if test="(record.${item.property}!=null)">

                    and ${r'${alias}'}.${item.column}  = ${'#'}{record.${item.property}}

                </if>

                </#if>

            </#list>

        </if>



    </sql>

    <!-- 分页查询 -->

    <select id="selectByKeyword" resultMap="${tableClassModel.className}Map">

        select

        <include refid="columns" >

            <property name="alias" value="a"/>

            <property name="columnPrefix" value=""/>

        </include>

        from ${tableClassModel.tableName} a

        <where>

            <include refid="keyword_where_sql"><property name="alias" value="a"/></include>

        </where>

    </select>



    <!-- 查询总条数 -->

    <select id="selectCountByKeyword" parameterType="long"   resultType="java.lang.Integer">

        select count(a.id)

        from ${tableClassModel.tableName} a

        <where>

            <include refid="keyword_where_sql"><property name="alias" value="a"/></include>

        </where>

    </select>

</mapper>

 src/main/resources/template/excelTemplateForHis/javaBean.ftl

New file
@@ -0,0 +1,49 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>

import lombok.AllArgsConstructor;

import lombok.Builder;

import lombok.Data;

import lombok.NoArgsConstructor;

import javax.persistence.Column;

import javax.persistence.GeneratedValue;

import javax.persistence.Id;

import javax.persistence.Table;

import javax.persistence.Transient;

import com.xincheng.common.bean.EntityShoptTkDTO;

import io.swagger.annotations.ApiModel;

import io.swagger.annotations.ApiModelProperty;

/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

@Data

@Table(name = "${tableClassModel.tableName}")

@AllArgsConstructor

@NoArgsConstructor

@Builder

@ApiModel(value="${tableClassModel.tableMemo}",description="${tableClassModel.tableMemo}")

public class ${tableClassModel.className}  extends EntityShoptTkDTO{

    @Transient

    private static final long serialVersionUID = 1L; 


<#list tableClassModel.mapping as being>

    <#if being.column = tableClassModel.primaryKey.column && being.jdbcType = "int">

    @Id

    @GeneratedValue(generator = "JDBC")

    private ${being.classType}  ${being.property};

    <#else>

    <#if being.memo!="">

    /**

    * ${being.memo}

    */

    @ApiModelProperty(value="${being.memo}",name="${being.memo}",example="")

    </#if>

    @Column(name = "${being.column}")

    private ${being.classType}  ${being.property};

    </#if>

</#list>

}

 src/main/resources/template/excelTemplateForHis/mybatis-config.ftl

New file
@@ -0,0 +1,33 @@
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration  PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">



<configuration>

    <settings>

        <setting name="cacheEnabled" value="false" />

           <setting name="lazyLoadingEnabled" value="false" />

           <setting name="multipleResultSetsEnabled" value="true" />

           <setting name="useColumnLabel" value="true" />

           <setting name="useGeneratedKeys" value="false" />

           <setting name="defaultExecutorType" value="SIMPLE" />

           <setting name="defaultStatementTimeout" value="25000" />

    </settings>

	
	


	
    <typeAliases>



    <#list alias as item> 
    ${item}

    </#list>	


    </typeAliases>

	
    <mappers>

	
        <#list mappers as item> 
        ${item}

        </#list>	
		
    </mappers>

</configuration>

 src/main/resources/template/excelTemplateForHis/service.ftl

New file
@@ -0,0 +1,92 @@
package ${codeModel.packageName};



<#list importList?keys as key>

import ${importList[key]};

</#list>

import com.github.pagehelper.PageHelper;

import com.github.pagehelper.PageInfo;

import com.matrix.core.constance.SystemErrorCode;

import com.matrix.core.constance.SystemMessageCode;

import com.matrix.core.exception.GlobleException;

import com.matrix.core.pojo.AjaxResult;

import com.matrix.core.tools.StringUtils;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import org.springframework.transaction.annotation.Transactional;

import java.util.List;

import java.util.stream.Collectors;

/**

 * @description ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

@Service

public class ${ClassName} {



    @Autowired

    private ${tableClassModel.className}Dao ${tableClassModel.classVariableName}Dao;



    /**

     * 列表显示

     */

    public  AjaxResult showList(${tableClassModel.className} ${tableClassModel.classVariableName}) {

        if (${tableClassModel.classVariableName}.getLimit() != null && ${tableClassModel.classVariableName}.getOffset() != null&&${tableClassModel.classVariableName}.getLimit() !=0) {

            PageHelper.startPage((${tableClassModel.classVariableName}.getOffset()/${tableClassModel.classVariableName}.getLimit())+1,${tableClassModel.classVariableName}.getLimit(),

            ${tableClassModel.classVariableName}.getSort()+" "+${tableClassModel.classVariableName}.getOrder());

        }

        List<${tableClassModel.className}> dataList = ${tableClassModel.classVariableName}Dao.select(${tableClassModel.classVariableName});

        PageInfo pageInfo = new PageInfo(dataList);

        AjaxResult result = new AjaxResult(AjaxResult.STATUS_SUCCESS, pageInfo.getList(),

        ${tableClassModel.classVariableName}Dao.selectCount(${tableClassModel.classVariableName}));

        return result;

    }

   	
    /**

     * 新增

     */

    @Transactional

    public  AjaxResult add(${tableClassModel.className} ${tableClassModel.classVariableName}) {

        ${tableClassModel.classVariableName}Dao.insert(${tableClassModel.classVariableName});

        return AjaxResult.buildSuccessInstance("添加成功");

    }



	
    /**

     * 修改

     */

    @Transactional

    public  AjaxResult modify(${tableClassModel.className} ${tableClassModel.classVariableName}) {

        ${tableClassModel.classVariableName}Dao.updateByPrimaryKeySelective(${tableClassModel.classVariableName});

        return AjaxResult.buildSuccessInstance("修改成功");

    }



    /**

    * 删除

    */

    @Transactional

    public  AjaxResult deleteByPrimaryKey(Integer id) {



        int i =  ${tableClassModel.classVariableName}Dao.deleteByPrimaryKey(id);

        if (i > 0) {

        return AjaxResult.buildSuccessInstance("删除成功");

        } else {

        throw new GlobleException(SystemErrorCode.DATA_DELETE_FAIL);

        }

    }

       /**

     * 删除

     */

    @Transactional

    public  AjaxResult del(String keys) {

        List<String> ids = StringUtils.strToCollToString(keys, ",");

        List<Integer> ${tableClassModel.classVariableName}s = ids.stream().map(a ->

        Integer.parseInt(a)).collect(Collectors.toList());

        int i =  ${tableClassModel.classVariableName}Dao.deleteByIdList(${tableClassModel.classVariableName}s);

        if (i > 0) {

        return AjaxResult.buildSuccessInstance("删除成功");

        } else {

        throw new GlobleException(SystemErrorCode.DATA_DELETE_FAIL);

        }

    }

  
}

 src/main/resources/template/excelTemplateForHis/sqlFile.ftl

New file
@@ -0,0 +1,34 @@


/**

 * ${tableClassModel.tableMemo}

 * @author ${dataSource.author}

 * @date ${time}

 */

 CREATE TABLE ${tableClassModel.tableName}(

  create_by varchar(100) NOT NULL COMMENT '创建人',

  create_time datetime NOT NULL COMMENT '创建时间',

  update_by varchar(100) NOT NULL COMMENT '更新人',

  update_time datetime NOT NULL COMMENT '更新时间',

  create_dept_id int(11) COMMENT '创建部门',

  create_store_id int(11) COMMENT '创建门店',

  company_id int(11) COMMENT '创建公司',

<#list tableClassModel.mapping as being>

<#if being.column = tableClassModel.primaryKey.column && being.jdbcType = "int">

 ${being.column} ${being.fullJdbcType}  ${being.isAllowNull} AUTO_INCREMENT  COMMENT '${being.memo}',

 <#else>

 ${being.column} ${being.fullJdbcType}  ${being.isAllowNull}  COMMENT '${being.memo}',

</#if>

</#list>	
PRIMARY KEY(${tableClassModel.primaryKey.column})

)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='${tableClassModel.tableMemo}';



<#list tableClassModel.mapping as being>

<#if (being.indexName)??>

  ALTER TABLE ${tableClassModel.tableName}

  ADD INDEX ${being.indexName} (${being.column}) USING BTREE ;

</#if>

</#list>