《Weby应用技术》第七次课后作业

完成对peom表的增删改查的操作

目录结构

PoetController.java

package com.example.webstudent.Controller;

import com.example.webstudent.Pojo.Poet;
import com.example.webstudent.Pojo.Result;
import com.example.webstudent.Service.PoetService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
public class PoetController {
    @Autowired
    private PoetService poetService;

    @RequestMapping("/poetselect")
    public Result select() {
        return Result.success(poetService.select());
    }

    @RequestMapping("/poetdelete")
    public void delete( Integer id){
        poetService.delete(id);
    }


    @RequestMapping("/peotinsert")
    public Result insert(@RequestBody Poet poet){
        boolean result =poetService.insert(poet);
        if(result) {
            // 成功  code==1
            return Result.success();
        } else {
            // 失败  code==0
            return Result.error("添加失败");

        }

    }
    @RequestMapping("/peotupdate")
    public  Result updatePeot(@RequestBody Poet poet){
        boolean r = poetService.update(poet);

        if(r) {
            // 成功  code==1
            return Result.success();
        } else {
            // 失败  code==0
            return Result.error("更新失败");
        }
    }

    @RequestMapping("/peotfindById/{id}")
    public Result peotfindById(@PathVariable("id") Integer id) {
        return  Result.success(poetService.peotfindById(id));
    }
    
}

PoetService

package com.example.webstudent.Service;

import com.example.webstudent.Pojo.Poet;

import java.util.List;

public interface PoetService {
    public List<Poet> select();
    public void delete(Integer id);
    public boolean insert(Poet poet);
    public boolean update(Poet poet);
    public Poet peotfindById(Integer id);
}

PoetService2.java

package com.example.webstudent.Service;

import com.example.webstudent.Mapper.PoetMapper;
import com.example.webstudent.Pojo.Poet;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class PoetService2 implements PoetService{
    @Autowired
    private PoetMapper poetMapper;

    @Override
    public List<Poet> select() {
        return poetMapper.select();
    }

    @Override
    public void delete(Integer id) {
        poetMapper.delete(id);
    }

    @Override
    public boolean insert(Poet poet) {
        int result =  poetMapper.insert(poet);
        return result == 1;
    }

    @Override
    public boolean update(Poet poet) {
        return poetMapper.update(poet);
    }

    @Override
    public Poet peotfindById(Integer id) {
        return poetMapper.peotfindById(id);
    }
}

PoetMapper

package com.example.webstudent.Mapper;

import com.example.webstudent.Pojo.Poet;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface PoetMapper {
    @Select("select * from information")
    public List<Poet> select();

    @Delete("delete  from information where id=#{id}")
    public void delete(Integer id);

    @Insert("insert into information(name, gender, dynasty, title, style) values (#{name}, #{gender}, #{dynasty}, #{title}, #{style})")
    public int insert(Poet poet);

    @Update("update information set name=#{name},gender=#{gender},dynasty=#{dynasty},title=#{title} ,style=#{style} where id=#{id} ")
    public  boolean update(Poet poet);

    @Select("select * from information where id=#{id}")
    public Poet peotfindById(Integer id);


}

peot_list.html

package com.example.webstudent.Mapper;

import com.example.webstudent.Pojo.Poet;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface PoetMapper {
    @Select("select * from information")
    public List<Poet> select();

    @Delete("delete  from information where id=#{id}")
    public void delete(Integer id);

    @Insert("insert into information(name, gender, dynasty, title, style) values (#{name}, #{gender}, #{dynasty}, #{title}, #{style})")
    public int insert(Poet poet);

    @Update("update information set name=#{name},gender=#{gender},dynasty=#{dynasty},title=#{title} ,style=#{style} where id=#{id} ")
    public  boolean update(Poet poet);

    @Select("select * from information where id=#{id}")
    public Poet peotfindById(Integer id);
    
}

poet_insert.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <script src="./js/vue.js"></script>
    <script src="./js/axios-0.18.0.js"></script>

</head>
<body>
<div id="app">
    <table border="1">

        <tr>
            <td>姓名</td>
            <td><input type="text" v-model="peot.name"> </td>
        </tr>
        <tr>
            <td>性别</td>
            <td>
                <input type="radio" name="gender" v-model="peot.gender" value="1"> 男
                <input type="radio" name="gender" v-model="peot.gender" value="0"> 女
            </td>
        </tr>
        <tr>
            <td>朝代</td>
            <td><input type="text" v-model="peot.dynasty"> </td>
        </tr>
        <tr>
            <td>头衔</td>
            <td><input type="text" v-model="peot.title"> </td>
        </tr>
        <tr>
            <td>风格</td>
            <td><input type="text" v-model="peot.style"> </td>
        </tr>

        <tr>
            <td></td>
            <td><input type="button" @click="addPeot" value="增加"> </td>

        </tr>
    </table>

</div>
</body>
<script>
    new Vue({
        el: '#app',
        data: {
            peot: {
                "name":"",
                "gender":"",
                "dynasty":"",
                "title":"",
                "style":""
            }        //详情

        },
        methods: {

            addPeot() {
                var url = 'peotinsert'
                axios.post(url,this.peot)
                    .then(res => {
                        var baseResult = res.data
                        if(baseResult.code == 1) {
                            // 成功
                            location.href = 'peot_list.html'
                        } else {
                            // 失败
                            alert(baseResult.message)
                        }
                    })
                    .catch(err => {
                        console.error(err);
                    })
            }
        },

    })
</script>

</html>

poet_update.html

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>Title</title>
  <script src="./js/vue.js"></script>
  <script src="./js/axios-0.18.0.js"></script>

</head>
<body>
<div id="app">
  <table border="1">
    <tr>
      <td>编号</td>
      <td><input type="text" v-model="this.id"> </td>
    </tr>
    <tr>
      <td>姓名</td>
      <td><input type="text" v-model="peot.name"> </td>
    </tr>
    <tr>
      <td>性别</td>
      <td>
        <input type="radio" name="gender" v-model="peot.gender" value="1"> 男
        <input type="radio" name="gender" v-model="peot.gender" value="0"> 女
      </td>
    </tr>
    <tr>
      <td>朝代</td>
      <td><input type="text" v-model="peot.dynasty"> </td>
    </tr>
    <tr>
      <td>头衔</td>
      <td><input type="text" v-model="peot.title"> </td>
    </tr>
    <tr>
      <td>风格</td>
      <td><input type="text" v-model="peot.style"> </td>
    </tr>

    <tr>
      <td></td>
      <td><input type="button" @click="updatePeot" value="更新"> </td>

    </tr>
  </table>
  {{peot}}
</div>


</body>
<script>
  new Vue({
    el: '#app',
    data: {
      id: '',
      peot: {},        //详情
    },
    methods: {
      selectById() {
        //${this.id}
        var url = `peotfindById/${this.id}`  //注意这里是反引号
        //反引号（backticks，也称为模板字符串或模板字面量）是ES6（ECMAScript 2015）中引入的一种新字符串字面量功能，
        // 它允许您在字符串中嵌入表达式。反引号用`（键盘上通常位于Tab键上方）来界定字符串的开始和结束。
        axios.get(url)
                .then(response => {
                  var baseResult = response.data
                  if(baseResult.code == 1) {
                    this.peot = baseResult.data
                  }
                })
                .catch( error => {})
      },
      updatePeot() {
        var url = 'peotupdate'
        axios.put(url,this.peot)
                .then(res => {
                  var baseResult = res.data
                  if(baseResult.code == 1) {
                    // 成功
                    location.href = 'peot' +
                            '' +
                            '_list.html'
                  } else {
                    // 失败
                    alert(baseResult.message)
                  }
                })
                .catch(err => {
                  console.error(err);
                })
      },


    },
    created() {
      // 获得参数id值
      this.id = location.href.split("?id=")[1]
      // 通过id查询详情
      this.selectById()
    },

  })



</script>

</html>

运行，效果如下：