为了与老系统隔离，从而做到无需重启应用也能维护EZ的相关列表，表单，EZ 使用数据库来管理表单列表。

下载初始化SQL:

init.sql

启动应用并访问 /topezadmin/dev.html。

SQL转列表表单

现在，让我们使用SQL生成一个用户列表，包含用户ID与用户名称

进入/topezadmin/dev.html ,点击SQL生成列表

列表编码填入：

             userlist
             
        

表达式填入：

             SELECT ID ID,NAME 名称 from T_USER WHERE 1=1
             
        

点击发布之后，代表列表已经进入生产环境，点击预览，即查看对应的 userlist

点击源码编辑，可参考文档，对前端源码进行修改

不是springboot?

参照：EzClientServletFilter，自定义filter，初始化EzClientBootstrap即可：

         package top.ezadmin.web.filters;
import top.ezadmin.common.utils.JSONUtils;
import top.ezadmin.common.utils.StringUtils;
import top.ezadmin.common.utils.Utils;
import top.ezadmin.EzClientBootstrap;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.slf4j.MDC;

import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
import java.io.IOException;
import java.util.HashMap;
import java.util.Map;
public class EzClientServletFilter implements Filter {
private static final Logger LOGGE = LoggerFactory.getLogger(EzClientServletFilter.class);


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


EzClientBootstrap ezBootstrap;

public void setEzBootstrap(EzClientBootstrap bootstrap) {
    if(ezBootstrap==null){
        ezBootstrap = bootstrap;
    }
}

@Override
public void init(FilterConfig filterConfig) throws ServletException {
    LOGGE.info("start init EzAdminFilter" + filterConfig.getInitParameterNames());
    if (ezBootstrap == null) {
        ezBootstrap = EzClientBootstrap.instance();
        String configJson=filterConfig.getInitParameter("configJson");
        Map<String, Object> configMap=JSONUtils.parseObjectMap(configJson);
        ezBootstrap.setConfig(configMap);

        ezBootstrap.setAppName(filterConfig.getInitParameter("appName"));
        ezBootstrap.setSqlCache(StringUtils.toBoolean(filterConfig.getInitParameter("cacheFlag")));
        if(StringUtils.isNotBlank(filterConfig.getInitParameter("uploadUrl"))){
            ezBootstrap.setUploadUrl(filterConfig.getInitParameter("uploadUrl"));
        }
        if(StringUtils.isNotBlank(filterConfig.getInitParameter("downloadUrl"))){
            ezBootstrap.setDownloadUrl(filterConfig.getInitParameter("downloadUrl"));
        }
        ezBootstrap.setLogType(filterConfig.getInitParameter("logType"));
        ezBootstrap.setRegionUrl(filterConfig.getInitParameter("regionUrl"));
        ezBootstrap.setCategoryUrl(filterConfig.getInitParameter("categoryUrl"));
        ezBootstrap.setOrgUrl(filterConfig.getInitParameter("orgUrl"));
        ezBootstrap.setSystemName(filterConfig.getInitParameter("systemName"));
        ezBootstrap.setNavUrl(filterConfig.getInitParameter("navUrl"));
        ezBootstrap.setLogoUrl(filterConfig.getInitParameter("logoUrl"));
        ezBootstrap.setSearchUrl(filterConfig.getInitParameter("searchUrl"));
        ezBootstrap.setAppendJs(filterConfig.getInitParameter("appendJs"));
        ezBootstrap.setIndexUrl(filterConfig.getInitParameter("indexUrl"));
        ezBootstrap.setSignoutUrl(filterConfig.getInitParameter("signoutUrl"));
        ezBootstrap.setMessageUrl(filterConfig.getInitParameter("messageUrl"));
        ezBootstrap.setChatUrl(filterConfig.getInitParameter("chatUrl"));
        ezBootstrap.setAdminStyle(filterConfig.getInitParameter("adminStyle"));
        for (Map.Entry<String, DataSource> entry:appDatasource.entrySet()){
            ezBootstrap.addBizDataSource(entry.getKey(), entry.getValue());
        }
        try {
            ezBootstrap.init();
        } catch (Exception throwables) {
            throw new ServletException(throwables);
        }
    }
}

@Override
public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
    HttpServletRequest httpServletRequest = (HttpServletRequest) servletRequest;
    HttpServletResponse httpServletResponse = (HttpServletResponse) servletResponse;
    try {
        ezBootstrap.doFilter(httpServletRequest, httpServletResponse,filterChain);
    } catch (Exception e) {
        LOGGE.error("", e);
        httpServletResponse.getWriter().println(e.getMessage());
    } finally {
        Utils.clearLog();
    }
}

@Override
public void destroy() {

}


public void addAppDatasource(String key, DataSource appDatasource) {
    this.appDatasource.put(key, appDatasource);
}


}

         
    

无数据库模式

如果不希望执行EZ数据库脚本，EZ同样支持， 在classpath目录新建文件，重新启动应用，访问 /topezadmin/list/list-helloworld 即可

classpath:/topezadmin/config/layui/list/helloword.html