update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
package com.fgkj.mapper.impl;
 
import com.fgkj.dto.Announce;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
 
import java.util.List;
 
public interface AnnounceMapper{
 
    //发布公告
    @Insert("insert into web_site.tb_announce(usr_id,announce_time,message,note)" +
            " values(#{usr_id},#{announce_time},#{message},#{note}) ")
    public int add(Announce a);
    //更新修改公告
    @Update("update web_site.tb_announce set "+
            "usr_id=#{usr_id},announce_time=#{announce_time},message=#{message},note=#{note} where num=#{num} ")
    public int update(Announce a);
 
    //删除公告
    @Delete("delete from web_site.tb_announce where num=#{num}")
    public int del(Announce a);
 
    //0.6公告信息显示(未分页)
    @Select("select num,usr_id,announce_time,message,note from web_site.tb_announce order by announce_time desc")
    public List<Announce> searchAll();
   
     //根据条件查询公告信息
    public List<Announce> serchByCondition(Announce obj);
 
     //0.6公告信息显示(分页)
    public List serchByInfo(Object obj);
 
}