| | |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.springframework.web.bind.annotation.ResponseBody; |
| | | |
| | | import java.sql.Timestamp; |
| | | import java.util.List; |
| | | |
| | | /** |
| | |
| | | @ResponseBody |
| | | public interface OperateMapper { |
| | | /** |
| | | * 根据表名查询记录数 |
| | | * |
| | | * @param userid 登录人ID |
| | | * @return 记录数 |
| | | * 查询记录数 |
| | | * @param uname |
| | | * @param type |
| | | * @param start |
| | | * @param end |
| | | * @return |
| | | */ |
| | | public Integer selectCount(String userid); |
| | | public Integer selectCount(String uname, Integer type, Timestamp start, Timestamp end); |
| | | |
| | | /** |
| | | * 根据表名分页查询 |
| | | * |
| | | * @param userid 表名 |
| | | * @param limit 记录表 |
| | | * @param offset 偏移量 |
| | | * @return 列表 |
| | | * 分页查询 |
| | | * @param uname |
| | | * @param type |
| | | * @param start |
| | | * @param end |
| | | * @param limit |
| | | * @param offset |
| | | * @return |
| | | */ |
| | | public List<OperateEntity> selectByPage(String userid, Integer limit, Integer offset); |
| | | public List<OperateEntity> selectByPage(String uname, Integer type, Timestamp start, Timestamp end, Integer limit, Integer offset); |
| | | |
| | | /** |
| | | * 添加数据 |
| | | * 插入一条 |
| | | * |
| | | * @param operateEntity |
| | | * @return |
| | |
| | | public Integer insertOperate(OperateEntity operateEntity); |
| | | |
| | | /** |
| | | * 批量添加 |
| | | * 插入多条 |
| | | * |
| | | * @param operateEntity |
| | | * @param list |
| | | * @return |
| | | */ |
| | | public Integer insertOperates(List<OperateEntity> operateEntity); |
| | | public Integer insertOperates(List<OperateEntity> list); |
| | | |
| | | /** |
| | | * 刪除数据 |
| | | * 删除一条 |
| | | * |
| | | * @param id |
| | | * @return |
| | |
| | | public Integer deleteOperate(int id); |
| | | |
| | | /** |
| | | * 批量删除 |
| | | * 删除多条 |
| | | * |
| | | * @param ids |
| | | * @return |
| | |
| | | public Integer deleteOperates(List<Integer> ids); |
| | | |
| | | /** |
| | | * 修改数据 |
| | | * 更新一条 |
| | | * |
| | | * @param operateEntity |
| | | * @return |
| | |
| | | public OperateEntity selectOperate(int id); |
| | | |
| | | /** |
| | | * 查询全部数据 |
| | | * 查询所有 |
| | | * |
| | | * @return |
| | | */ |