前端学习-servlet编写数据接口JSON文件形式后续-跨域操作+layui table分页

1、下载两个包

可以在maven仓库下载，也可以去这个公众号（小L来讲吧），发送【servlet跨域jar】下载
2、配置web.xml

<filter>
        <filter-name>CORS</filter-name>
        <filter-class>com.thetransactioncompany.cors.CORSFilter</filter-class>
        <init-param>
            <param-name>cors.allowOrigin</param-name>
            <param-value>*</param-value>
        </init-param>
        <init-param>
            <param-name>cors.supportedMethods</param-name>
            <param-value>GET, POST, HEAD, PUT, DELETE</param-value>
        </init-param>
        <init-param>
            <param-name>cors.supportedHeaders</param-name>
            <param-value>Accept, Origin, X-Requested-With, Content-Type, Last-Modified</param-value>
        </init-param>
        <init-param>
            <param-name>cors.exposedHeaders</param-name>
            <param-value>Set-Cookie</param-value>
        </init-param>
        <init-param>
            <param-name>cors.supportsCredentials</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>CORS</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

3、配置servlet
resp.setHeader(“Access-Control-Allow-Origin”, “*”);

跨域成功！！

layui table分页

查看layui官方文档，https://www.layui.com/doc/modules/table.html#options
首先要了解了layui中table的数据调用模式，limit和page
String sql=“select * from user LIMIT “+((page-1))*limit+”,”+limit;

protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        int page=Integer.parseInt(req.getParameter("page"));
        int limit=Integer.parseInt(req.getParameter("limit"));
        req.setAttribute("page",page);
        req.setAttribute("limit",limit);
        System.out.println(page+","+limit);
        UserDAO dao=new UserDAO();
        //String sql=" select * from user limit ((page - 1)*limit),limit";select * from user  LIMIT 0,8;
        String sql="select * from user  LIMIT "+((page-1))*limit+","+limit;
        try {
            List<Object> list=dao.getUserAll(sql,page,limit);
            //设置json数据中文不为乱码
            Object code="200";
            JSONObject jsonObject = new JSONObject();
            jsonObject.put("code", 0);
            jsonObject.put("msg", "成功");
            jsonObject.put("count", 1000);
            jsonObject.put("page",page);
            jsonObject.put("limit",limit);
            jsonObject.put("data",list);
            resp.setContentType("application/json;charset=utf-8");
            resp.getWriter().write(String.valueOf(jsonObject));
            // 解决跨域问题
            resp.setHeader("Access-Control-Allow-Origin", "*");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }