web应用技术第七次作业

---

一、准备

1、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;
}

2、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));
    }
}

2.service层

service接口

public interface PeotService {
 
    public List<Peot> findAll();
 
    public int deletePeot(Integer id);
 
    public Peot peotById(Integer id);
}

PeotService.java

public interface PeotService {
 
    public List<Peot> findAll();
 
    public int deletePeot(Integer id);
 
    public Peot peotById(Integer id);
}

3、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);
}

---

三、修改功能

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));
    }
 
    @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("添加失败");
        }
    }
 
    @RequestMapping("/updatePoet")
    public Result updatePeot(@RequestBody Peot peot){
        boolean r = peotService.updatePeot(peot);
 
        if(r) {
            // 成功  code==1
            return Result.success();
        } else {
            // 失败  code==0
            return Result.erro("更新失败");
        }
    }
}

2.service层

service接口

public interface PeotService {
 
    List<Peot> findAll();
 
    int deletePeot(Integer id);
 
    Peot peotById(Integer id);
 
    boolean insertPeot(Peot peot);
 
    boolean updatePeot(Peot peot);
}

PeotService.java

@Service
public class PeotServiceImpl implements PeotService {
    @Autowired
    private PeotMapper peotMapper;
 
    @Override
    public List<Peot> findAll() {
        return peotMapper.findAll();
    }
 
    @Override
    public int deletePeot(Integer id) {
        return peotMapper.deletePeot(id);
    }
    @Override
    public Peot peotById(Integer id) {
        return peotMapper.peotById(id);
    }
 
    @Override
    public boolean insertPeot(Peot peot) {
        int result =  peotMapper.insertPeot(peot);
        return result == 1;
    }
 
    @Override
    public boolean updatePeot(Peot peot) {
        return peotMapper.updatePeot(peot);
    }
}

3、Dao层

@Mapper
public interface PeotMapper {
   @Select("select * from peom")
    List<Peot> findAll();
 
    @Delete("delete from peom where id=#{id}")
    int deletePeot(Integer id);
 
    @Select("select * from peom where id=#{id}")
    Peot peotById(Integer id);
 
    @Insert("insert into peom(author, gender, dynasty, title, style) values (#{author}, #{gender}, #{dynasty}, #{title}, #{style})")
    int insertPeot(Peot peot);
 
    @Update("update peom set author=#{author},gender=#{gender},dynasty=#{dynasty},title=#{title} ,style=#{style} where id=#{id} ")
    boolean updatePeot(Peot peot);
 
}

---

四、新增功能

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));
    }
 
    @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("添加失败");
 
        }
    }
}

2.service层

service接口

public interface PeotService {
 
    public List<Peot> findAll();
 
 
    boolean insertPeot(Peot peot);
}

PeotService.java

@Service
public class PeotServiceImpl implements PeotService {
    @Autowired
    private PeotMapper peotMapper;
 
    @Override
    public List<Peot> findAll() {
        return peotMapper.findAll();
    }
 
    @Override
    public boolean insertPeot(Peot peot) {
        int result =  peotMapper.insertPeot(peot);
        return result == 1;
    }
}

3、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);
 
}

---

五、运行结果