br.com.anteros.springWeb.controller

Class AbstractSQLRestController<T,ID extends Serializable>

java.lang.Object

br.com.anteros.springWeb.controller.AbstractSQLRestController<T,ID>

Type Parameters:

T - Tipo

ID - ID

@Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=true)
public abstract class AbstractSQLRestController<T,ID extends Serializable>
extends Object

Classe base para uso de serviços REST de persistência usando Anteros.

Author:

Edson Martins edsonmartins2005@gmail.com

Field Summary

Fields

Modifier and Type	Field and Description
protected static br.com.anteros.core.log.Logger	log

Constructor Summary

Constructors

Constructor and Description
AbstractSQLRestController()

Method Summary

Modifier and Type	Method and Description
long	count()
List<T>	find(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, String sql)
br.com.anteros.persistence.session.repository.Page<T>	find(String sql, int page, int size)
br.com.anteros.persistence.session.repository.Page<T>	find(String sql, int page, int size, Object... parameters)
List<T>	find(String sql, Object... parameters)
List<T>	findAll() Retorna todos os objetos do banco de dados via método GET.
br.com.anteros.persistence.session.repository.Page<T>	findAll(int page, int size) Retorna todos os objetos do banco de dados com paginação via método GET.
List<T>	findByNamedQuery(String queryName)
br.com.anteros.persistence.session.repository.Page<T>	findByNamedQuery(String queryName, int page, int size)
br.com.anteros.persistence.session.repository.Page<T>	findByNamedQuery(String queryName, int page, int size, Object... parameters)
List<T>	findByNamedQuery(String queryName, Object... parameters)
T	findOne(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, String id) Retorna objeto do banco de dados via método GET.
abstract br.com.anteros.persistence.session.service.SQLService<T,ID>	getService() Método abstrato que irá fornecer a classe de serviço para ser usada no controller.
void	remove(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, T object) Remove objeto no banco de dados via método DELETE.
T	removeById(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, String id) Remove objeto por ID no banco de dados via método DELETE.
T	save(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, T object) Insere ou atualiza objeto no banco de dados via método POST ou PUT

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

log

protected static br.com.anteros.core.log.Logger log

Constructor Detail

AbstractSQLRestController

public AbstractSQLRestController()

Method Detail

save

@RequestMapping(value="/",
                method={POST,PUT})
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=false)
public T save(javax.servlet.http.HttpServletRequest request,
                                                                                                                                                                                                                                                 javax.servlet.http.HttpServletResponse response,
                                                                                                                                                                                                                                                 @RequestBody
                                                                                                                                                                                                                                                 T object)
                                                                                                                                                                                                                                          throws Exception

Insere ou atualiza objeto no banco de dados via método POST ou PUT.;

Parameters:

id -

Returns:

Throws:

Exception

removeById

@RequestMapping(value="/{id}",
                method=DELETE)
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=false)
public T removeById(javax.servlet.http.HttpServletRequest request,
                                                                                                                                                                                                                                                       javax.servlet.http.HttpServletResponse response,
                                                                                                                                                                                                                                                       @PathVariable(value="id")
                                                                                                                                                                                                                                                       String id)
                                                                                                                                                                                                                                                throws Exception

Remove objeto por ID no banco de dados via método DELETE.

Parameters:

id -

Returns:

Throws:

Exception

remove

@RequestMapping(value="/",
                method=DELETE)
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=false)
public void remove(javax.servlet.http.HttpServletRequest request,
                                                                                                                                                                                                                                                  javax.servlet.http.HttpServletResponse response,
                                                                                                                                                                                                                                                  @RequestBody
                                                                                                                                                                                                                                                  T object)
                                                                                                                                                                                                                                           throws Exception

Remove objeto no banco de dados via método DELETE.

Parameters:

id -

Throws:

Exception

findOne

@RequestMapping(value="/{id}",
                method=GET)
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=true)
public T findOne(javax.servlet.http.HttpServletRequest request,
                                                                                                                                                                                                                                                javax.servlet.http.HttpServletResponse response,
                                                                                                                                                                                                                                                @PathVariable(value="id")
                                                                                                                                                                                                                                                String id)
                                                                                                                                                                                                                                         throws Exception

Retorna objeto do banco de dados via método GET.

Parameters:

id -

Returns:

Throws:

Exception

findAll

@RequestMapping(value={"/findAll","/"},
                method=GET)
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=true)
public List<T> findAll()

Retorna todos os objetos do banco de dados via método GET.

Returns:

findAll

@RequestMapping(method=GET,
                value="/findAllWithPage",
                params={"page","size"})
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=true)
public br.com.anteros.persistence.session.repository.Page<T> findAll(@RequestParam(value="page")
                                                                                                                                                                                                                                                                                                                                                       int page,
                                                                                                                                                                                                                                                                                                                                                       @RequestParam(value="size")
                                                                                                                                                                                                                                                                                                                                                       int size)

Retorna todos os objetos do banco de dados com paginação via método GET.

Parameters:

page -

size -

Returns:

find

@RequestMapping(value="/find/{sql}",
                method=GET)
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=true)
public List<T> find(javax.servlet.http.HttpServletRequest request,
                                                                                                                                                                                                                                                         javax.servlet.http.HttpServletResponse response,
                                                                                                                                                                                                                                                         @PathVariable(value="sql")
                                                                                                                                                                                                                                                         String sql)
                                                                                                                                                                                                                                                  throws Exception

Throws:

Exception

find

@RequestMapping(value="/findWithPage/{sql}",
                params={"page","size"},
                method=GET)
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=true)
public br.com.anteros.persistence.session.repository.Page<T> find(@PathVariable(value="sql")
                                                                                                                                                                                                                                                                                                                                                       String sql,
                                                                                                                                                                                                                                                                                                                                                       @RequestParam(value="page",required=true)
                                                                                                                                                                                                                                                                                                                                                       int page,
                                                                                                                                                                                                                                                                                                                                                       @RequestParam(value="size",required=true)
                                                                                                                                                                                                                                                                                                                                                       int size)

find

@RequestMapping(method=GET,
                value="/findWithParameters/{sql}",
                params="parameters")
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=true)
public List<T> find(@PathVariable
                                                                                                                                                                                                                                                                                                            String sql,
                                                                                                                                                                                                                                                                                                            @RequestParam(value="parameters",required=true)
                                                                                                                                                                                                                                                                                                            Object... parameters)

find

@RequestMapping(method=GET,
                value="/findWithParametersAndPage/{sql}",
                params={"page","size","parameters"})
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=true)
public br.com.anteros.persistence.session.repository.Page<T> find(@PathVariable(value="sql")
                                                                                                                                                                                                                                                                                                                                                                                 String sql,
                                                                                                                                                                                                                                                                                                                                                                                 @RequestParam(value="page",required=true)
                                                                                                                                                                                                                                                                                                                                                                                 int page,
                                                                                                                                                                                                                                                                                                                                                                                 @RequestParam(value="size",required=true)
                                                                                                                                                                                                                                                                                                                                                                                 int size,
                                                                                                                                                                                                                                                                                                                                                                                 @RequestParam(value="parameters",required=true)
                                                                                                                                                                                                                                                                                                                                                                                 Object... parameters)

findByNamedQuery

@RequestMapping(value="/findByNamedQuery/{queryName}",
                method=GET)
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=true)
public List<T> findByNamedQuery(@PathVariable(value="queryName")
                                                                                                                                                                                                                                                                                       String queryName)

findByNamedQuery

@RequestMapping(value="/findByNamedQueryWithPage/{queryName}",
                params={"page","size"},
                method=GET)
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=true)
public br.com.anteros.persistence.session.repository.Page<T> findByNamedQuery(@PathVariable(value="queryName")
                                                                                                                                                                                                                                                                                                                                                                                     String queryName,
                                                                                                                                                                                                                                                                                                                                                                                     @RequestParam(value="page",required=true)
                                                                                                                                                                                                                                                                                                                                                                                     int page,
                                                                                                                                                                                                                                                                                                                                                                                     @RequestParam(value="size",required=true)
                                                                                                                                                                                                                                                                                                                                                                                     int size)

findByNamedQuery

@RequestMapping(value="/findByNamedQueryWithParameters/{queryName}",
                params="parameters",
                method=GET)
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=true)
public List<T> findByNamedQuery(@PathVariable(value="queryName")
                                                                                                                                                                                                                                                                                                                                          String queryName,
                                                                                                                                                                                                                                                                                                                                          @RequestParam(value="parameters",required=true)
                                                                                                                                                                                                                                                                                                                                          Object... parameters)

findByNamedQuery

@RequestMapping(value="/findByNamedQueryWithParamsAndPage/{queryName}",
                params={"page","size","parameters"},
                method=GET)
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=true)
public br.com.anteros.persistence.session.repository.Page<T> findByNamedQuery(@PathVariable(value="queryName")
                                                                                                                                                                                                                                                                                                                                                                                                           String queryName,
                                                                                                                                                                                                                                                                                                                                                                                                           @RequestParam(value="page",required=true)
                                                                                                                                                                                                                                                                                                                                                                                                           int page,
                                                                                                                                                                                                                                                                                                                                                                                                           @RequestParam(value="size",required=true)
                                                                                                                                                                                                                                                                                                                                                                                                           int size,
                                                                                                                                                                                                                                                                                                                                                                                                           @RequestParam(value="parameters",required=true)
                                                                                                                                                                                                                                                                                                                                                                                                           Object... parameters)

count

@RequestMapping(value="/count",
                method=GET)
 @ResponseStatus(value=OK)
 @ResponseBody
 @Transactional(rollbackFor=java.lang.Throwable.class,
               propagation=REQUIRED,
               readOnly=true)
public long count()

getService

public abstract br.com.anteros.persistence.session.service.SQLService<T,ID> getService()

Método abstrato que irá fornecer a classe de serviço para ser usada no controller.

Returns: