From ea6a41b505a753d10bb1aa103eb7f7c67958e502 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期一, 27 三月 2023 15:23:52 +0800 Subject: [PATCH] 删除Msg --- /dev/null | 74 ------------------------------------- 1 files changed, 0 insertions(+), 74 deletions(-) diff --git a/src/main/java/com/lf/server/entity/sys/MsgEntity.java b/src/main/java/com/lf/server/entity/sys/MsgEntity.java deleted file mode 100644 index e04e032..0000000 --- a/src/main/java/com/lf/server/entity/sys/MsgEntity.java +++ /dev/null @@ -1,95 +0,0 @@ -package com.lf.server.entity.sys; - -import java.io.Serializable; -import java.sql.Timestamp; - -/** - * 娑堟伅閫氱煡 - * @author WWW - */ -public class MsgEntity implements Serializable { - private static final long serialVersionUID = -188183034857820256L; - - private int id; - - private String title; - - private String msg; - - private String guid; - - private int createUser; - - private Timestamp createTime; - - private int updateUser; - - private Timestamp updateTime; - - public MsgEntity() { - } - - public int getId() { - return id; - } - - public void setId(int id) { - this.id = id; - } - - public String getTitle() { - return title; - } - - public void setTitle(String title) { - this.title = title; - } - - public String getMsg() { - return msg; - } - - public void setMsg(String msg) { - this.msg = msg; - } - - public String getGuid() { - return guid; - } - - public void setGuid(String guid) { - this.guid = guid; - } - - public int getCreateUser() { - return createUser; - } - - public void setCreateUser(int createUser) { - this.createUser = createUser; - } - - public Timestamp getCreateTime() { - return createTime; - } - - public void setCreateTime(Timestamp createTime) { - this.createTime = createTime; - } - - public int getUpdateUser() { - return updateUser; - } - - public void setUpdateUser(int updateUser) { - this.updateUser = updateUser; - } - - public Timestamp getUpdateTime() { - return updateTime; - } - - public void setUpdateTime(Timestamp updateTime) { - this.updateTime = updateTime; - } -} diff --git a/src/main/java/com/lf/server/mapper/sys/MsgMapper.java b/src/main/java/com/lf/server/mapper/sys/MsgMapper.java deleted file mode 100644 index d52e63b..0000000 --- a/src/main/java/com/lf/server/mapper/sys/MsgMapper.java +++ /dev/null @@ -1,96 +0,0 @@ -package com.lf.server.mapper.sys; - -import com.lf.server.entity.sys.MsgEntity; -import org.apache.ibatis.annotations.Mapper; -import org.springframework.stereotype.Repository; - -import java.util.List; - -/** - * 娑堟伅閫氱煡 - * @author WWW - */ -@Mapper -@Repository -public interface MsgMapper { - /** - * 鏌ヨ璁板綍鏁� - * - * @param title 鏍囬 - * @return 璁板綍鏁� - */ - public Integer selectCount(String title); - - /** - * 鍒嗛〉鏌ヨ - * - * @param title 鏍囬 - * @param limit 璁板綍鏁� - * @param offset 鍋忕Щ閲� - * @return 鍒楄〃 - */ - public List<MsgEntity> selectByPage(String title, Integer limit, Integer offset); - - /** - * 鏌ヨ鎵�鏈� - * - * @return - */ - public List<MsgEntity> selectAll(); - - /** - * 鏍规嵁ID鏌ヨ - * - * @param id - * @return - */ - public MsgEntity selectById(int id); - - /** - * 鎻掑叆涓�鏉� - * - * @param entity - * @return - */ - public Integer insert(MsgEntity entity); - - /** - * 鎻掑叆澶氭潯 - * - * @param list - * @return - */ - public Integer inserts(List<MsgEntity> list); - - /** - * 鍒犻櫎涓�鏉� - * - * @param id - * @return - */ - public Integer delete(int id); - - /** - * 鍒犻櫎澶氭潯 - * - * @param ids - * @return - */ - public Integer deletes(List<Integer> ids); - - /** - * 鏇存柊涓�鏉� - * - * @param entity - * @return - */ - public Integer update(MsgEntity entity); - - /** - * 鏇存柊澶氭潯 - * - * @param list - * @return - */ - public Integer updates(List<MsgEntity> list); -} diff --git a/src/main/java/com/lf/server/service/sys/MsgService.java b/src/main/java/com/lf/server/service/sys/MsgService.java deleted file mode 100644 index 19c7d87..0000000 --- a/src/main/java/com/lf/server/service/sys/MsgService.java +++ /dev/null @@ -1,73 +0,0 @@ -package com.lf.server.service.sys; - -import com.lf.server.entity.sys.MsgEntity; -import com.lf.server.helper.StringHelper; -import com.lf.server.mapper.sys.MsgMapper; -import org.springframework.beans.factory.annotation.Autowired; -import org.springframework.stereotype.Service; - -import java.util.List; - -/** - * 娑堟伅閫氱煡 - * @author WWW - */ -@Service -public class MsgService implements MsgMapper { - @Autowired - MsgMapper msgMapper; - - @Override - public Integer selectCount(String title) { - title = StringHelper.getLikeUpperStr(title); - - return msgMapper.selectCount(title); - } - - @Override - public List<MsgEntity> selectByPage(String title, Integer limit, Integer offset) { - title = StringHelper.getLikeUpperStr(title); - - return msgMapper.selectByPage(title, limit, offset); - } - - @Override - public List<MsgEntity> selectAll() { - return msgMapper.selectAll(); - } - - @Override - public MsgEntity selectById(int id) { - return msgMapper.selectById(id); - } - - @Override - public Integer insert(MsgEntity entity) { - return msgMapper.insert(entity); - } - - @Override - public Integer inserts(List<MsgEntity> list) { - return msgMapper.inserts(list); - } - - @Override - public Integer delete(int id) { - return msgMapper.delete(id); - } - - @Override - public Integer deletes(List<Integer> ids) { - return msgMapper.deletes(ids); - } - - @Override - public Integer update(MsgEntity entity) { - return msgMapper.update(entity); - } - - @Override - public Integer updates(List<MsgEntity> list) { - return msgMapper.updates(list); - } -} diff --git a/src/main/resources/mapper/sys/MsgMapper.xml b/src/main/resources/mapper/sys/MsgMapper.xml deleted file mode 100644 index 96a47fa..0000000 --- a/src/main/resources/mapper/sys/MsgMapper.xml +++ /dev/null @@ -1,74 +0,0 @@ -<?xml version="1.0" encoding="UTF-8" ?> -<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> -<mapper namespace="com.lf.server.mapper.sys.MsgMapper"> - <select id="selectCount" resultType="java.lang.Integer" parameterType="java.lang.String"> - select count(*) from lf.sys_msg - <where> - <if test="title != null"> - upper(title) like #{title} - </if> - </where> - </select> - - <select id="selectByPage" resultType="com.lf.server.entity.sys.MsgEntity"> - select * from lf.sys_msg - <where> - <if test="title != null"> - upper(title) like #{title} - </if> - </where> - order by id desc - limit #{limit} offset #{offset} - </select> - - <select id="selectAll" resultType="com.lf.server.entity.sys.MsgEntity"> - select * from lf.sys_msg order by id desc; - </select> - - <select id="selectById" resultType="com.lf.server.entity.sys.MsgEntity"> - select * from lf.sys_msg where id = #{id} - </select> - - <insert id="insert" parameterType="com.lf.server.entity.sys.MsgEntity"> - insert into lf.sys_msg - (title,msg,guid,create_user,create_time) - values - (#{title},#{msg},#{guid},#{createUser},now()) - </insert> - - <insert id="inserts"> - insert into lf.sys_msg - (title,msg,guid,create_user,create_time) - values - <foreach collection="list" item="item" index="index" separator=","> - (#{item.title},#{item.msg},#{item.guid},#{item.createUser},now()) - </foreach> - </insert> - - <delete id="delete"> - delete from lf.sys_msg where id = #{id} - </delete> - - <delete id="deletes"> - delete from lf.sys_msg where id in - <foreach item="id" collection="ids" index="index" open="(" separator="," close=")"> - #{id} - </foreach> - </delete> - - <update id="update"> - update lf.sys_msg - set title=#{title},msg=#{msg},guid=#{guid},update_user=#{updateUser},update_time=now() - where id=#{id} - </update> - - <update id="updates"> - <foreach collection="list" item="item" index="index" separator=";"> - update lf.sys_msg - <set> - title=#{item.title},msg=#{item.msg},guid=#{item.guid},update_user=#{item.updateUser},update_time=now() - </set> - where id = #{item.id} - </foreach> - </update> -</mapper> \ No newline at end of file -- Gitblit v1.9.3