springboot 单表增删改查的代码部分

springboot 单表增删改查

基于springboot 的一个单表的增删改查

controller层

@Controller
public class CarController {
@Autowired
private CarService carService;
@RequestMapping("/getAll")
public @ResponseBody List getAll(){
return carService.getAll();
}

@PostMapping("/insert")
public @ResponseBody int insert(Car car){
    return carService.insert(car);
}
@RequestMapping("/update")
public @ResponseBody int update(Car car){
    return carService.update(car);
}

@RequestMapping("/delete")
public @ResponseBody int delete(Car id){
    return carService.delete(id);
}

}

1. dao层 ，
   
   @Mapper
   public interface CarDao {
   @Select(“select * from car”)
   List getAll();

   @Insert("insert into car(color,wheel_num) " +
   “values(#{color},#{wheelNum})”)
   int insert(Car car);
   @Update(“update car set color=#{color},wheel_num=#{wheelNum},pin_pai=#{pinPai},price=#{price} where id=#{id}”)
   int update(Car car);
   @Delete(“delete from car where id=#{id}”)
   int delete(Car id);
   }

entity层

public class Car {

public int id;
public String color;
public int wheelNum;
public String pinPai;
public int price;
}

service层

public interface CarService {

public List<Car> getAll();

public int insert(Car car);
public int update(Car car);
public int delete(Car id);

}

serviceImpl的实现类

@Service
public class CarServiceImpl implements CarService {
@Autowired
private CarDao carDao;
@Override
public List getAll() {
return carDao.getAll();
}

@Override
public int insert(Car car) {
    return carDao.insert(car);
}

@Override
public int update(Car car) {
    return carDao.update(car);
}

@Override
public int delete(Car id) {
    return carDao.delete(id);
}

}

yml文件 application.yml

spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&useOldAliasMetadataBehavior=true&autoReconnect=true&serverTimezone=UTC
username: root
password: root

调试工具测试