| | |
| | | @Select("SELECT * FROM queue where glassid=#{glassid}") |
| | | List<Queue> selectQueues(@Param("glassid") int glassid); |
| | | |
| | | @Select("SELECT * FROM queue order by time asc limit 1") |
| | | @Select("SELECT * FROM queue order by time desc limit 1") |
| | | Queue selectLastQueue(); |
| | | |
| | | @Select("SELECT * FROM queue where state<=0") |
| | |
| | | "values (null,null,null,null,null,null,#{glasswidthmm},#{glassheightmm},null,#{state},NOW())") |
| | | void insertMatchFailure(@Param("glasswidthmm") double glasswidthmm, @Param("glassheightmm") double glassheightmm,@Param("state") int state); |
| | | |
| | | @Delete("delete from queue where state<=0") |
| | | void DeleteErrorQueue(); |
| | | |
| | | } |