Skip to content

Instantly share code, notes, and snippets.

@dario61081
Created December 21, 2016 14:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dario61081/4483a97f2613a2efd027505d32802e41 to your computer and use it in GitHub Desktop.
Save dario61081/4483a97f2613a2efd027505d32802e41 to your computer and use it in GitHub Desktop.
Mybatis interface descriptor
public interface DeliverUserMapper{
@Results(id = "DeliverUserResults", value = {
@Result(property = "usuario", column = "DLRY_USUARIO", id = true),
@Result(property = "fecha", column = "DLRY_FECHA"),
@Result(property = "estado", column = "DLRY_ESTADO"),
@Result(property = "dispositivo", column = "DLRY_DISPOSITIVO"),
@Result(property = "observacion", column = "DLRY_OBSERVACION")
})
@Select("select * from FARMA.DELIVERY_STATS")
public List<DeliverUser> getDeliversStatus();
/**
*
* @param usuario
* @param estado
*/
@Update("UPDATE FARMA.DELIVERY_STATS SET DLRY_ESTADO=#{estado}, DLRY_FECHA=CURRENT_TIMESTAMP WHERE DLRY_USUARIO=#{usuario}")
public void setDeliverStatus(@Param("usuario") String usuario,@Param("estado") String estado);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment