12
完成对peom表的增删改查的操作
poet类
package com.itccc.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Peot {
private Integer id;
private String author;
private String gender;
private String dynasty;
private String title;
private String style;
}
result类
package com.itccc.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Result {
private Integer code;//响应码,1 代表成功; 0 代表失败
private String msg; //响应信息 描述字符串
private Object data; //返回的数据
public static Result success() {
return new Result(1, "success", null);
}
public static Result seccess(Object data) {
return new Result(1, "success", data);
}
public static Result erro(String str) {
return new Result(1, str, null);
}
}
1,删除操作
controller层
@RestController
public class PeotController {
@Autowired
private PeotService peotService;
@RequestMapping("/findAllJson")
public Result findAllJson(){
return Result.seccess(peotService.findAll()) ;
}
@RequestMapping("/deletePeot")
public void deletePeot(Integer id){
peotService.deletePeot(id);
}
//允许前端通过 GET 请求来获取特定诗人的信息
@RequestMapping("/peotById/{id}")
public Result peotfindById(@PathVariable("id") Integer id) {
return Result.seccess(peotService.peotById(id));
}
}
service层
public interface PeotService {
public List<Peot> findAll();
public int deletePeot(Integer id);
public Peot peotById(Integer id);
}
dao层
@Mapper
public interface PeotMapper {
@Select("select * from peom")
public List<Peot> findAll();
@Delete("delete from peom where id=#{id}")
public int deletePeot(Integer id);
@Select("select * from peom where id=#{id}")
public Peot peotById(Integer id);
}
2,增加操作
controller层
@RestController
public class PeotController {
@Autowired
private PeotService peotService;
@RequestMapping("/findAllJson")
public Result findAllJson(){
return Result.seccess(peotService.findAll()) ;
}
@RequestMapping("/deletePeot")
public void deletePeot(Integer id){
peotService.deletePeot(id);
}
//允许前端通过 GET 请求来获取特定诗人的信息
@RequestMapping("/peotById/{id}")
public Result peotfindById(@PathVariable("id") Integer id) {
return Result.seccess(peotService.peotById(id));
}
@RequestMapping("/insertPoet")
public Result insertUser(@RequestBody Peot peot){
boolean result =peotService.insertPeot(peot);
if(result) {
// 成功 code==1
return Result.success();
} else {
// 失败 code==0
return Result.erro("添加失败");
}
}
}
service层
public interface PeotService {
public List<Peot> findAll();
boolean insertPeot(Peot peot);
}
dao层
@Mapper
public interface PeotMapper {
@Select("select * from peom")
public List<Peot> findAll();
@Delete("delete from peom where id=#{id}")
public int deletePeot(Integer id);
@Select("select * from peom where id=#{id}")
public Peot peotById(Integer id);
@Insert("insert into peom(author, gender, dynasty, title, style) values (#{author}, #{gender}, #{dynasty}, #{title}, #{style})")
int insertPeot(Peot peot);
}