Created
December 21, 2016 14:21
-
-
Save dario61081/4483a97f2613a2efd027505d32802e41 to your computer and use it in GitHub Desktop.
Mybatis interface descriptor
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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