springboot增删改查（持续更新中）

一：数据的增加
1，controller层

package com.example.demo3.controller;


import com.example.demo3.mapper.ResMapper;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;


@RestController
public class ResController {
    @Resource
    ResMapper resMapper;

    @RequestMapping(path = "/res",method = RequestMethod.GET)
    public String res(String username,String password){
        int result =  resMapper.resuser(username,password);
        if (result==1){
            return "[{code:200;mess:注册成功;}]";
        }

       return "[{code:401;mess:注册失败;}]";
    }
}

2，mapper层

package com.example.demo3.mapper;


import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;



public interface ResMapper {

    @Insert("insert into login (username,password) values(#{username},#{password})")
    int resuser(@Param("username") String username, @Param("password") String password);

}

二：数据的删除
1,controller层

package com.example.demo3.controller;

import com.example.demo3.mapper.DelMapper;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

@RestController
public class delController {
    @Resource
    private DelMapper delMapper;

    @RequestMapping(path = "/del",method = RequestMethod.GET )
    public String del(Long id){
        delMapper.del(id);
        return "[{code:200,mess:删除成功}]";

    }
}

2，mapper层

package com.example.demo3.mapper;

import org.apache.ibatis.annotations.Delete;

public interface DelMapper {

    @Delete("DELETE FROM login WHERE id= #{id}")
    void del(Long id);
}