From 8fb4d22f55ea6bcc7dd24d53027145959575ce61 Mon Sep 17 00:00:00 2001 From: xiangpei <xiangpei@timesnew.cn> Date: 星期四, 16 五月 2024 11:20:16 +0800 Subject: [PATCH] 在线学习基本代码 --- src/main/java/com/mindskip/xzs/controller/admin/OnlineStudyController.java | 44 ++++++++ src/main/java/com/mindskip/xzs/service/OnlineStudyService.java | 25 +++++ src/main/java/com/mindskip/xzs/domain/vo/OnlineStudyVO.java | 41 ++++++++ src/main/java/com/mindskip/xzs/repository/OnlineStudyMapper.java | 25 +++++ src/main/java/com/mindskip/xzs/domain/OnlineStudy.java | 39 +++++++ src/main/resources/mapper/OnlineStudyMapper.xml | 50 ++++++++++ src/main/java/com/mindskip/xzs/service/impl/OnlineStudySeerviceImpl.java | 47 +++++++++ 7 files changed, 271 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/mindskip/xzs/controller/admin/OnlineStudyController.java b/src/main/java/com/mindskip/xzs/controller/admin/OnlineStudyController.java new file mode 100644 index 0000000..b589dbc --- /dev/null +++ b/src/main/java/com/mindskip/xzs/controller/admin/OnlineStudyController.java @@ -0,0 +1,44 @@ +package com.mindskip.xzs.controller.admin; + +import com.mindskip.xzs.base.RestResponse; +import com.mindskip.xzs.domain.vo.OnlineStudyVO; +import com.mindskip.xzs.service.OnlineStudyService; +import lombok.RequiredArgsConstructor; +import org.springframework.validation.annotation.Validated; +import org.springframework.web.bind.annotation.*; + +import javax.validation.constraints.NotEmpty; +import java.util.List; + +/** + * @author锛歺p + * @date锛�2024/5/16 10:58 + */ +@RestController +@RequiredArgsConstructor +@RequestMapping(value = "/api/admin/online/study") +public class OnlineStudyController { + + private final OnlineStudyService service; + + @PostMapping + public RestResponse add(@RequestBody @Validated OnlineStudyVO form) { + return service.add(form); + } + + @PostMapping("/edit") + public RestResponse edit(@RequestBody @Validated OnlineStudyVO form) { + return service.update(form); + } + + @PostMapping("/remove") + public RestResponse remove(@RequestBody @NotEmpty(message = "璇烽�夋嫨瑕佸垹闄ょ殑鏁版嵁") List<Integer> ids) { + return service.remove(ids); + } + + @GetMapping("/page") + public RestResponse page(OnlineStudyVO query) { + return service.page(query); + } + +} diff --git a/src/main/java/com/mindskip/xzs/domain/OnlineStudy.java b/src/main/java/com/mindskip/xzs/domain/OnlineStudy.java new file mode 100644 index 0000000..b29cb1a --- /dev/null +++ b/src/main/java/com/mindskip/xzs/domain/OnlineStudy.java @@ -0,0 +1,39 @@ +package com.mindskip.xzs.domain; + +import lombok.Data; + +import java.util.Date; + +/** + * 鍦ㄧ嚎瀛︿範 + * + * @author锛歺p + * @date锛�2024/5/16 10:42 + */ +@Data +public class OnlineStudy { + + private Integer id; + + /** 鏂囦欢绫诲瀷 */ + private String contentType; + + /** 鏂囦欢鍦板潃 */ + private String contentUrl; + + /** 鎵�灞炲垎绫� */ + private String belongType; + + /** 涓婚 */ + private String subject; + + /** 闄勪欢 */ + private String attachment; + + private Date createTime; + + private Date updateTime; + + private Integer deleted; + +} diff --git a/src/main/java/com/mindskip/xzs/domain/vo/OnlineStudyVO.java b/src/main/java/com/mindskip/xzs/domain/vo/OnlineStudyVO.java new file mode 100644 index 0000000..ebbb906 --- /dev/null +++ b/src/main/java/com/mindskip/xzs/domain/vo/OnlineStudyVO.java @@ -0,0 +1,41 @@ +package com.mindskip.xzs.domain.vo; + +import lombok.Data; + +import javax.validation.constraints.NotBlank; +import java.util.Date; + +/** + * @author锛歺p + * @date锛�2024/5/16 10:45 + */ +@Data +public class OnlineStudyVO { + + private Integer pageSize = 10; + + private Integer pageNum = 1; + + private Integer id; + + /** 鏂囦欢绫诲瀷 */ + @NotBlank(message = "璇烽�夋嫨鏂囦欢绫诲瀷") + private String contentType; + + /** 鏂囦欢鍦板潃 */ + @NotBlank(message = "璇蜂笂浼犳枃浠�") + private String contentUrl; + + /** 鎵�灞炲垎绫� */ + @NotBlank(message = "璇烽�夋嫨鍒嗙被") + private String belongType; + + /** 涓婚 */ + @NotBlank(message = "璇疯緭鍏ヤ富棰�") + private String subject; + + private Date createTime; + + private Date updateTime; + +} diff --git a/src/main/java/com/mindskip/xzs/repository/OnlineStudyMapper.java b/src/main/java/com/mindskip/xzs/repository/OnlineStudyMapper.java new file mode 100644 index 0000000..a4ee989 --- /dev/null +++ b/src/main/java/com/mindskip/xzs/repository/OnlineStudyMapper.java @@ -0,0 +1,25 @@ +package com.mindskip.xzs.repository; + +import com.mindskip.xzs.domain.OnlineStudy; +import com.mindskip.xzs.domain.vo.OnlineStudyVO; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; + +import java.util.List; + +/** + * @author锛歺p + * @date锛�2024/5/16 10:49 + */ +@Mapper +public interface OnlineStudyMapper { + + void add(@Param("form") OnlineStudyVO form); + + void update(@Param("form") OnlineStudyVO form); + + void remove(@Param("ids") List<Integer> ids); + + List<OnlineStudyVO> page(@Param("query") OnlineStudyVO query); + +} diff --git a/src/main/java/com/mindskip/xzs/service/OnlineStudyService.java b/src/main/java/com/mindskip/xzs/service/OnlineStudyService.java new file mode 100644 index 0000000..2e59168 --- /dev/null +++ b/src/main/java/com/mindskip/xzs/service/OnlineStudyService.java @@ -0,0 +1,25 @@ +package com.mindskip.xzs.service; + +import com.mindskip.xzs.base.RestResponse; +import com.mindskip.xzs.domain.vo.OnlineStudyVO; + +import java.util.List; + +/** + * @author锛歺p + * @date锛�2024/5/16 10:52 + */ +public interface OnlineStudyService { + + RestResponse add(OnlineStudyVO form); + + + RestResponse update(OnlineStudyVO form); + + + RestResponse remove(List<Integer> ids); + + + RestResponse page(OnlineStudyVO query); + +} diff --git a/src/main/java/com/mindskip/xzs/service/impl/OnlineStudySeerviceImpl.java b/src/main/java/com/mindskip/xzs/service/impl/OnlineStudySeerviceImpl.java new file mode 100644 index 0000000..3af5f30 --- /dev/null +++ b/src/main/java/com/mindskip/xzs/service/impl/OnlineStudySeerviceImpl.java @@ -0,0 +1,47 @@ +package com.mindskip.xzs.service.impl; + +import com.github.pagehelper.PageHelper; +import com.mindskip.xzs.base.RestResponse; +import com.mindskip.xzs.domain.vo.OnlineStudyVO; +import com.mindskip.xzs.repository.OnlineStudyMapper; +import com.mindskip.xzs.service.OnlineStudyService; +import lombok.RequiredArgsConstructor; +import org.springframework.stereotype.Service; + +import java.util.List; + +/** + * @author锛歺p + * @date锛�2024/5/16 10:53 + */ +@Service +@RequiredArgsConstructor +public class OnlineStudySeerviceImpl implements OnlineStudyService { + + private final OnlineStudyMapper mapper; + + @Override + public RestResponse add(OnlineStudyVO form) { + mapper.add(form); + return RestResponse.ok("娣诲姞鎴愬姛"); + } + + @Override + public RestResponse update(OnlineStudyVO form) { + mapper.update(form); + return RestResponse.ok("淇敼鎴愬姛"); + } + + @Override + public RestResponse remove(List<Integer> ids) { + mapper.remove(ids); + return RestResponse.ok("鍒犻櫎鎴愬姛"); + } + + @Override + public RestResponse page(OnlineStudyVO query) { + PageHelper.startPage(query.getPageNum(), query.getPageSize()); + List<OnlineStudyVO> data = mapper.page(query); + return RestResponse.ok(data); + } +} diff --git a/src/main/resources/mapper/OnlineStudyMapper.xml b/src/main/resources/mapper/OnlineStudyMapper.xml new file mode 100644 index 0000000..4fdadf3 --- /dev/null +++ b/src/main/resources/mapper/OnlineStudyMapper.xml @@ -0,0 +1,50 @@ +<?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.mindskip.xzs.repository.OnlineStudyMapper"> + + <select id="page" resultType="com.mindskip.xzs.domain.vo.OnlineStudyVO"> + SELECT + id,content_type, content_url, belong_type, subject, create_time, update_time, attachment + FROM + t_online_study + <where> + AND deleted = 0 + <if test="query.subject != null and query.subject != ''"> + AND subject like concat('%', #{query.subject}, '%') + </if> + </where> + ORDER BY + create_time DESC + </select> + + <insert id="add" keyColumn="id" useGeneratedKeys="true" parameterType="com.mindskip.xzs.domain.OnlineStudy"> + INSERT INTO t_online_study(content_type, content_url, belong_type, subject, create_time, update_time, + attachment) + value (#{form.contentType}, #{form.contentUrl}, #{form.belongType}, #{form.subject}, #{form.createTime}, #{form.updateTime}, #{form.attachment}) + </insert> + + <update id="update" parameterType="com.mindskip.xzs.domain.vo.OnlineStudyVO"> + UPDATE + t_online_study + <set> + <if test="form.contentType != null and form.contentType != ''">content_type = #{form.contentType},</if> + <if test="form.contentUrl != null and form.contentUrl != ''">content_url = #{form.contentUrl},</if> + <if test="form.belong_type != null and form.belong_type != ''">belong_type = #{form.belongType},</if> + <if test="form.belongType != null and form.belongType != ''">belong_type = #{form.belongType},</if> + <if test="form.subject != null and form.subject != ''">subject = #{form.subject},</if> + <if test="form.updateTime != null">update_time = #{form.updateTime},</if> + <if test="form.attachment != null and form.attachment != ''">attachment = #{form.attachment},</if> + </set> + WHERE + id = #{vo.id} + </update> + + <update id="remove"> + UPDATE t_online_study SET deleted = 1 WHERE id IN + <foreach collection="ids" open="(" separator="," close=")" item="id">#{id}</foreach> + </update> + + +</mapper> -- Gitblit v1.8.0