| | |
|---|
| | | |
|---|
| | | @Mapper |
|---|
| | | public interface AlarmMapper { |
|---|
| | | @Select("SELECT * FROM alarmmg") |
|---|
| | | @Select("SELECT * FROM alarmmg where endTime is not null and to_days(timeon)=to_days(now())") |
|---|
| | | List<alarmmg> selectAll(); |
|---|
| | | |
|---|
| | | @Select("SELECT count(*) FROM alarmmg where endTime is null and content=#{content}") |
|---|
| | |
|---|
| | | |
|---|
| | | @Insert("UPDATE `canadames`.`alarmmg` set endTime= now() where endTime is null and content=#{content}") |
|---|
| | | void updatealarm(String content); |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM alarmmg where timeon between #{sj1} and #{sj2}") |
|---|
| | | List<alarmmg> selecttime(String sj1, String sj2); |
|---|
| | | } |
|---|
