Spring 3 JSON and datatables

Don’t you just love JQuery. I’ve been using it with and .

I played about with some of this stuff (datatables) last year and was impressed with what I’d achieved – fetching tens of thousands of rows of data in a single JSON query – that datatables renders to the screen, makes it fully searchable. Great.

When I originally did this, I used the older style of configuring your Jackson mappers into the view resolver so that you could serve up json out of the request.

After reading about the inbuilt support for JSON in Spring 3, I simplified my spring context. But this meant the data being served back to datatables (which expects your JSON data to be in set format) wasn’t correct. I’ve read a number of blogs and the solution I came up with is a bit of a highbrid.

I don’t have time to outline all this in detail, so I will just post the relevant bits for reference.

Spring Context

Controller:

@Controller@RequestMapping(value="/useradm")public class UserAdminController {              ....         /**    * Fetch a the user list from the service, and package up into a Map that is     * compatible with datatables.net    */         @RequestMapping(method={RequestMethod.POST,RequestMethod.GET} ,value="/fetchtableall")    public @ResponseBody Map
    
      findAllForTableView(){        try{            Collection
     
       users = iamService.listUsers();              if (users == null) {                throw new UserAdminException("Unable to fetch all users - ");            }            return Collections.singletonMap("aaData", getJSONForUser(users));                 }catch(ServiceException se){            throw new UserAdminException("Unable to fetch all users  ");        }    }         /**    * I only want certain user info..    */    public Object[] getJSONForUser(Collection
      
        users){        Object[] rdArray = new Object[users.size()];        int i = 0;        for(UserBean u:users){            // [ name, id,arn,groups ]            Object[] us = new String[]{u.getUser().getUserName(),u.getUser().getArn(),groupList(u.getGroups()),u.getUser().getUserId()};             rdArray[i] = us;            i++;                    }        return rdArray;    }

The key bit in this controller is the @ResponseBody Map – it allows Spring to do it’s JSON magic. In the older world of wiring up your Jackson Mappers in the spring context, you could happily return a ModelAndView :

returnnewModelAndView("fetchall","aaData", getJSONForUser(users));

JSP

<%@ page session="false" %><%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%><%@ taglib uri="http://www.springframework.org/tags/form" prefix="form"%>

转载于:https://my.oschina.net/lgscofield/blog/388134

你可能感兴趣的文章