springboot的增删改查

package com.example.springbootdemo.controller;

import com.example.springbootdemo.mapper.UserMapper;
import com.example.springbootdemo.pojo.User;
import com.example.springbootdemo.pojo.UserExample;
import org.springframework.lang.UsesSunHttpServer;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import java.util.List;

/**
 * @description:
 * @author: Anniebing
 * @date: 2021/5/6 15:57
 */

/**
 * @Controller 定义一个 Controller 控制器
 * @ResponseBody 默认返回页面，加上返回一个字符串
 * @RestController注解相当于@ResponseBody ＋ @Controller合在一起的作用。
 */

@RestController
@RequestMapping("/test")
/**
 * 使用 @RequestMapping 来映射 Request 请求与处理器
 */
public class Test {

    //自动装配，最上面
    @Resource
    private UserMapper userMapper;

    @RequestMapping("/test")
    public String test() {
        return "hello springboot";
    }

    //注册
    @RequestMapping("/register")
    public String register() {

        User user = new User();
        user.setUserName("sss");
        user.setUserPassword("12111");
        System.out.println(user.getUserName() + " " + user.getUserPassword());
        userMapper.insert(user);
        return "success";
    }

    //真正删，通过主键
    @RequestMapping("/delete")
    public String delete() {
        //通过主键来删
        userMapper.deleteByPrimaryKey((long) 1000);
        //通过条件来删
        UserExample userExample = new UserExample();
        //给userExample对象设置条件
        userExample.createCriteria().andUserNameEqualTo("sss").andUserPasswordEqualTo("sss");

        userMapper.deleteByExample(userExample);
        return "success";
    }

    @RequestMapping("/select")
    public String select() {
        UserExample userExample = new UserExample();
        userExample.createCriteria().andUserNameEqualTo("sss").andUserPasswordEqualTo("sss");
        //使用链表接受查询数据
        List<User> userList = userMapper.selectByExample(userExample);
        if(userList.size()==1){
            System.out.println("ok");
        }else{
            System.out.println("no");
        }
        System.out.println(userList.size());
        return "success";
    }

    @RequestMapping("/update")
    public String upDate() {
        User user = new User();

        user.setId((long)1);
        user.setUserName("lzy");
        user.setUserPassword("dsz");

        //只更新你修改的字段
        userMapper.updateByPrimaryKeySelective(user);

        //全部更新
//        userMapper.updateByPrimaryKey(user);

        return "success";
    }
}