spring-jquery-datatable

This project is an extension of the Spring project to ease its use with jQuery plugin DataTables with server-side processing enabled.

This will allow you to handle the Ajax requests sent by DataTables for each draw of the information on the page (i.e. when paging, ordering, searching, etc.) from Spring @Controller.

Example:

On the server-side

@Controller
@RequestMapping(value = "/pc")
public class PCController {

    @Autowired
    private PCActionService pcActionService;

    @RequestMapping(value = "/get_pc_tea_api_action")
    @ResponseBody
    public DatatablesResponse<PCTeaAPIAction> findPCTeaAPIActionsWithDatatablesCriterias(HttpServletRequest request) {
        DatatablesCriterias criterias = DatatablesCriterias.getFromRequest(request);
        DataSet<PCTeaAPIAction> actions = pcActionService.findPCTeaAPIActionsWithDatatablesCriterias(criterias);
        return DatatablesResponse.build(actions, criterias);
    }
}

@Service
public class PCActionServiceImpl implements PCActionService {
    @PersistenceContext
    private EntityManager entityManager;

    @Override
    public DataSet<PCTeaAPIAction> findPCTeaAPIActionsWithDatatablesCriterias(DatatablesCriterias criterias) {
        TableQuery query = new TableQuery(entityManager, PCTeaAPIAction.class, criterias);
        return query.getResultDataSet();
    }

}

On the client-side

On the client-side, you can now define your table loading data dynamically :

$(document).ready(function() {
    var table = $('#teaPCApiActionTable').DataTable({
        processing: true,
        serverSide: true,
        columns: [
            {"data": "time"},
            {"data": "uid"},
            {"data": "api_name"},
            {"data": "request_type"},
            {"data": "parameters"},
            {"data": "response_idx"}
        ],
        ajax: {
            url: '/pc/get_pc_tea_api_action',
            type: 'GET'
        }
    });
}

Maven dependency

<dependency>
    <groupId>com.github.lwfwind.web</groupId>
    <artifactId>spring-jquery-datatable</artifactId>
    <version>3.2</version>
</dependency>