//
// Source code recreated from a .class file by IntelliJ IDEA
// (powered by FernFlower decompiler)
//
package com.lingnan.club.controller;
import com.lingnan.club.pojo.Sign;
import com.lingnan.club.service.impl.SignServiceImpl;
import com.lingnan.club.utils.Result;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
@Controller
@RequestMapping({"/sign"})
public class SignController {
@Autowired
private SignServiceImpl signService;
public SignController() {
}
@RequestMapping(
value = {"/lists"},
method = {RequestMethod.GET}
)
@ResponseBody
public List findAllSign() {
List signs = this.signService.findAll();
return signs;
}
@RequestMapping(
value = {"lists/{name}"},
method = {RequestMethod.GET}
)
@ResponseBody
public List searchSign(@PathVariable String name) {
List signs = this.signService.searchSign(name);
return signs;
}
@RequestMapping(
value = {"/addSign"},
method = {RequestMethod.POST}
)
@ResponseBody
public String addSign(@RequestBody Sign sign) {
boolean i = this.signService.publishSignActive(sign);
return i ? "{'module':'成功'}" : "{'module':'失败'}";
}
@RequestMapping(
value = {"/deleteSigns/{id}"},
method = {RequestMethod.DELETE}
)
@ResponseBody
public String deleteSign(@PathVariable Integer id) {
int i = this.signService.deleteSignById(id);
return i == 1 ? "{'module':'成功'}" : "{'module':'失败'}";
}
@RequestMapping(
value = {"/updateSigns"},
method = {RequestMethod.PUT}
)
@ResponseBody
public String updateSign(@RequestBody Sign sign) {
int i = this.signService.updateSignActive(sign);
return i == 1 ? "{'module':'成功'}" : "{'module':'失败'}";
}
@PostMapping({"/successSign"})
public Result successSign(@RequestParam Integer signFlag) {
return null;
}
}
二、Mybatis-plus
package userUI;
import com.lingnan.club.mapper.SignMapper;
import com.lingnan.club.pojo.Sign;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import java.util.List;
@SpringBootTest
public class SignMyBatisPlusTest {
@Autowired
private SignMapper signMapper;
@Test
public void testSelectList(){
//通过条件构造器查询一个List集合，若没有条件,则可以设置null为参数
List list = signMapper.selectList(null);
list.forEach(System.out::println);
}
@Test
public void testInsert(){
Sign sign = new Sign();
//sign.setId(9);
sign.setName("会议3");
int result = signMapper.insert(sign);
System.out.println(result);
}
@Test
public void testDelete(){
//1、通过id删除数据
int result = signMapper.deleteById(10);
System.out.println(result);
//2、根据map集合中所设置的条件来删除数据
// DELETE FROM club_sign WHERe name = ? AND begin_time = ?
// Map map = new HashMap<>();
// map.put("name",1);
// map.put("begin_time",1);
// int result = signMapper.deleteByMap(map);
// System.out.println(result);
//3、通过多个id实现批量删除
// ELETE FROM club_sign WHERe s_id IN ( ? , ? , ? , ? )
// List list = Arrays.asList(10, 11, 12, 13);
// int result = signMapper.deleteBatchIds(list);
// System.out.println(result);
}
@Test
public void testUpdate(){
//修改用户信息
//==> Preparing: UPDATE club_sign SET name=? WHERe s_id=?
Sign sign = new Sign();
sign.setId(8);
sign.setName("会议2");
int result = signMapper.updateById(sign);
System.out.println(result);
}
@Test
public void testSelect() {
//1、通过id查询用户信息
//SELECT s_id AS id,name,begin_time,end_time,sign_time,late_time FROM club_sign WHERe s_id=?
// Sign sign = signMapper.selectById(8);
// System.out.println(sign);
//2、根据多个id查询
//SELECT s_id AS id,name,begin_time,end_time,sign_time,late_time FROM club_sign WHERe s_id IN ( ? , ? , ? , ? )
// List list = Arrays.asList(6, 7, 8, 9);
// List signs= signMapper.selectBatchIds(list);
// signs.forEach(System.out::println);
//3、SELECT s_id AS id,name,begin_time,end_time,sign_time,late_time FROM club_sign WHERe name = ? AND begin_time = ?
// HashMap map = new HashMap<>();
// map.put("name","会议1");
// map.put("begin_time",7);
// List signs = signMapper.selectByMap(map);
// signs.forEach(System.out::println);
// 4、 通过条件构造器查询一个List集合，若没有条件,则可以设置null为参数
List list = signMapper.selectList(null);
list.forEach(System.out::println);
//5、自定义
// Map map = signMapper.selectMapById(12);
// System.out.println(map);
}
}
三、QueryWrapper
package userUI;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.lingnan.club.mapper.SignMapper;
import com.lingnan.club.pojo.Sign;
import com.lingnan.club.service.SignService;
import com.lingnan.club.service.impl.SignServiceImpl;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import java.util.List;
@SpringBootTest
public class SignWrapper {
@Autowired
private SignMapper signMapper;
@Test
public void test01(){
//查询用户名包含a. 且开始时间在20-23结束时间为30
QueryWrapper queryWrapper = new QueryWrapper();
queryWrapper.like("name","a")
.between("begin_time","20","23")
.eq("end_time",30);
List list = signMapper.selectList(queryWrapper);
list.forEach(System.out::println);
}
@Test
public void test02(){
SignService signService = new SignServiceImpl();
List list = signService.searchSign("会议");
list.forEach(System.out::println);
}
}
