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

完成对诗人表的增删改查的操作。

查询所有诗人信息:

见第六次课后作业~

根据id删除某行诗人信息:

按钮:

mapper编写sql语句对数据库进行根据id的删除操作:

@Delete("DELETE FROM writer where id=#{id}")
    public int delete(Integer id);

service中方添加deleteById删除方法,实现类中调用writerMapper对象方法实现传值,注意方法传参数:

public int delete(Integer id);
    @Override
    public int delete(Integer id){
        return writerMapper.delete(id);
    }

controller包中编写delete方法并调用writerService对象的方法传值,地址为/deleteById:

    @RequestMapping("/deleteById")
    public void delete(Integer id){
        writerService.delete(id);
    }

最后html页面,在按钮中添加@click链接到deleteById方法,使得点击按钮后执行删除操作,在js中编写方法selectAll和deleteById方法,以及编写created()获取id参数的值,用按钮执行删除不需要跳转页面:

<script>
  new Vue({
    el: "#app",
    data() {
      return {
        tableData: []
      }
    },
    methods: {
      selectAll:function (){
        var _this = this;
        axios.post('/selectAll',{
        })
          .then(function (response){
            _this.tableData = response.data.data;
          })
          .catch(function (error){
            console.log(error);
          })
      },

      deleteById:function (id){
        var _this = this;
        if(window.confirm("确定要删除该条数据吗?")){
          axios.post('/deleteById?id='+id)
            .then(function (response){
              alert("删除成功!")
              _this.selectAll();
            })
            .catch(function (error){
              console.log(error);
            });
        }
      }
    },
    created(){
      //获取参数id的值
      this.id = location.href.split("?id=")[1]
      this.selectAll();
    }
  });
</script>

运行结果:

链接:

添加超链接地址点击跳转到页面WriterDelete.html,创建WriterDelete.html并编写js方法(因为WriterDelete页面不用展示数据只需确定删除,body中可以不写):

<body>

</body>
<style>
    .el-table .warning-row {
        background: oldlace;
    }
    .el-table .success-row {
        background: #f0f9eb;
    }
</style>

<script>
    new Vue({
        el: "#app",
        data() {
            return {
                tableData: []
            }
        },
        methods: {
            selectAll:function (){
                var _this = this;
                axios.post('/selectAll',{
                })
                    .then(function (response){
                        _this.tableData = response.data.data;
                    })
                    .catch(function (error){
                        console.log(error);
                    })
            },

            deleteById:function (id){
                var _this = this;
                var url = `deleteById/${this.id}`
                if(window.confirm("确定要删除该条数据吗?")){
                    axios.post(url)
                        .then(function (response){
                            alert("删除成功!")
                            _this.selectAll();
                            location.href = 'WriterShow.html'
                        })
                        .catch(function (error){
                            console.log(error);
                        });
                }
            }
        },
        created(){
            //获取参数id的值
            this.id = location.href.split("?id=")[1]
            this.deleteById();
        }
    });
</script>

controller中路径添加/{id}传参并添加注解@PathVariable进行了参数传递:

     @RequestMapping("/deleteById/{id}")
    public void delete(@PathVariable Integer id){
        writerService.delete(id);
    }

运行页面:

根据id修改某行诗人信息:

在修改某行诗人信息之前 要先有方法来根据id查找到诗人的信息:

mapper:

//根据id查询数据
    @Select("SELECT * FROM writer WHERE id = #{id}")
    public Writer selectById(Integer id);

service:

public Writer selectById(Integer id);

service实现类:

    @Override
    public Writer selectById(Integer id){
        return writerMapper.selectById(id);
    }

controller:(注意地址后添加参数/{id})

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

然后再编写更新操作:

在mapper中编写sql语句:(id是自动编号就不修改id的值)

//根据id修改数据
    @Update("update writer set author=#{author},gender=#{gender},dynasty=#{dynasty},title=#{title} ,style=#{style} where id=#{id}")
    public boolean update(Writer writer);

在service中编写抽象方法并在实现类调用mapper方法实现:

public boolean update(Writer writer);//返回值为布尔值
    @Override
    public boolean update(Writer writer){
        return writerMapper.update(writer);
    }

在controller中编写:

@RequestMapping("/updateById")
    public  Result update(@RequestBody Writer writer){
        boolean r = writerService.update(writer);
        if(r) {
            // 成功  code==1
            return Result.success();
        } else {
            // 失败  code==0
            return Result.erro("更新失败");
        }
    }

编写WriterUpdate.html页面:(前面点击修改后跳转到该页面时先根据js中的selectById方法获取到相应的值到表单中,然后再进行修改,点击更新按钮后执行js中的updateById方法返回数据,并回到首页表格)

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

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

    </tr>
  </table>
</div>
</body>

<script>
  new Vue({
    el:'#app',
    data:{
      id:'',
      writer:{},
    },
    methods:{
      selectById(){
        var url = `selectById/${this.id}`
        axios.get(url)
          .then(response =>{
            var baseResult = response.data
            if(baseResult.code == 1){
              this.writer = baseResult.data
            }
          })
            .catch(error => {})
      },
      updateById(){
        var url = `updateById`//与controller中的路径要要一致,没有/符号
        axios.put(url,this.writer)
          .then(res => {
            var baseResult = res.data
            if(baseResult.code == 1){
              //成功
              location.href = 'WriterShow.html'
            }else {
              //失败
              alert(baseResult.message)
            }
          })
        .catch(err => {
          console.error(err);
        })
      }
    },
    created(){
      //获得参数值id
      this.id = location.href.split("?id=")[1]
      //通过id查询详情
      this.selectById();
    }
  })
</script>

(${this.id}这个刚开始手打的一直不对啊复制过来才成功了)

运行:(更新第一条的内容)

添加诗人信息:

mapper中添加sql语句和方法:

    //新增数据
    @Insert("INSERT INTO writer(author, gender, dynasty, title, style) values (#{author},#{gender},#{dynasty},#{title},#{style})")
    public int insert(Writer writer);

在service中编写抽象方法并在实现类调用mapper方法实现:

public boolean insert(Writer writer);
     @Override
    public boolean insert(Writer writer) {
        int result = writerMapper.insert(writer);
        return result == 1;
    }

在controller中编写:

    @RequestMapping("/insert")
    public Result insert(@RequestBody Writer writer){
        boolean result =writerService.insert(writer);
        if(result) {
            // 成功  code==1
            return Result.success();
        } else {
            // 失败  code==0
            return Result.erro("添加失败");

        }

编写网页WriterInsert.html:

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

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

</div>
</body>
<script>
  new Vue({
    el: '#app',
    data: {
      writer: {
        "author":"",
        "gender":"",
        "dynasty":"",
        "title":"",
        "style":""
      }      

    },
    methods: {

      insert() {
        var url = 'insert'//和controller中相同
        axios.post(url,this.writer)
                .then(res => {
                  var baseResult = res.data
                  if(baseResult.code == 1) {
                    // 成功后跳转回首页
                    location.href = 'WriterShow.html'
                  } else {
                    // 失败后提示失败信息
                    alert(baseResult.message)
                  }
                })
                .catch(err => {
                  console.error(err);
                })
      }
    },

  })
</script>

运行结果:

整体代码:

WriterMapper:
 

@Mapper
public interface WriterMapper {
    //查询所有数据
    @Select("SELECT * FROM writer")
    public List<Writer> list();

    //根据id查询数据
    @Select("SELECT * FROM writer WHERE id = #{id}")
    public Writer selectById(Integer id);

    //根据id删除数据
    @Delete("DELETE FROM writer where id=#{id}")
    public int delete(Integer id);

    //根据id修改数据
    @Update("update writer set author=#{author},gender=#{gender},dynasty=#{dynasty},title=#{title} ,style=#{style} where id=#{id}")
    public boolean update(Writer writer);

    //新增数据
    @Insert("INSERT INTO writer(author, gender, dynasty, title, style) values (#{author},#{gender},#{dynasty},#{title},#{style})")
    public int insert(Writer writer);
}

WriterService:

 @Service
    public interface WriterService {
        public List<Writer> list();
        public int delete(Integer id);
        public boolean update(Writer writer);
        public Writer selectById(Integer id);
        public boolean insert(Writer writer);
}

WriterServiceImpl:

@Service
public class WriterServiceImpl implements WriterService {
    @Autowired
    private WriterMapper writerMapper;

    @Override
    public List<Writer> list(){
        return writerMapper.list();
    }

    @Override
    public Writer selectById(Integer id){
        return writerMapper.selectById(id);
    }

    @Override
    public boolean insert(Writer writer) {
        int result = writerMapper.insert(writer);
        return result == 1;
    }

    @Override
    public int delete(Integer id){
        return writerMapper.delete(id);
    }

    @Override
    public boolean update(Writer writer){
        return writerMapper.update(writer);
    }
}

WriterController:

@RestController
public class WriterController {

    @Autowired
    private WriterService writerService;

    @RequestMapping("/selectAll")
    public Result list(){
        return Result.success(writerService.list());
    }

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

    @RequestMapping("/deleteById/{id}")
    public void delete(@PathVariable("id") Integer id){
        writerService.delete(id);
    }

    @RequestMapping("/updateById")
    public  Result update(@RequestBody Writer writer){
        boolean r = writerService.update(writer);
        if(r) {
            // 成功  code==1
            return Result.success();
        } else {
            // 失败  code==0
            return Result.erro("更新失败");
        }
    }

    @RequestMapping("/insert")
    public Result insert(@RequestBody Writer writer){
        boolean result =writerService.insert(writer);
        if(result) {
            // 成功  code==1
            return Result.success();
        } else {
            // 失败  code==0
            return Result.erro("添加失败");
        }
    }
}

WriterShow.html:展示表格

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>诗人信息</title>
</head>

<link rel="stylesheet" href="element-ui/index.css">
<script src="./js/vue.js"></script>
<script src="./element-ui/index.js"></script>
<script src="./js/axios-0.18.0.js"></script>

<body>
  <h1 align="center">诗人信息列表展示</h1>
  <a href="WriterInsert.html" align="center">新增</a>
  <div id="app">
    <table border="1" cellspacing="0" width="100%">
      <tr align="center" >
        <td>编号</td>
        <td>姓名</td>
        <td>性别</td>
        <td>朝代</td>
        <td>头衔</td>
        <td>风格</td>
        <td>操作</td>
      </tr>
      <tr v-for="(writer,index) in tableData" align="center">
        <td>{{index+1}}</td>
        <td>{{writer.author}}</td>
        <td>{{writer.gender}}</td>
        <td>{{writer.dynasty}}</td>
        <td>{{writer.title}}</td>
        <td>{{writer.style}}</td>
        <td><input type="button"value="删除" @click="deleteById(writer.id)">
          <a :href="'WriterDelete.html?id='+writer.id">删除</a>
          <a :href="'WriterUpdate.html?id='+writer.id">修改</a></td>
      </tr>
    </table>
  </div>
</body>
<style>
  .el-table .warning-row {
    background: oldlace;
  }
  .el-table .success-row {
    background: #f0f9eb;
  }
</style>

<script>
  new Vue({
    el: "#app",
    data() {
      return {
        tableData: []
      }
    },
    mounted(){//vue的钩子方法发起异步请求请求数据
      axios.get('/selectAll').then(result =>{
        if(result.data.code){//回调函数中判断返回code的值
          this.tableData = result.data.data;
        }
      });
    },
    methods: {
      selectAll:function (){
        var _this = this;
        axios.post('/selectAll',{
        })
          .then(function (response){
            _this.tableData = response.data.data;
          })
          .catch(function (error){
            console.log(error);
          })
      },

      deleteById:function (id){
        var _this = this;
        if(window.confirm("确定要删除该条数据吗?")){
          axios.post('/deleteById?id='+id)
            .then(function (response){
              alert("删除成功!")
              _this.selectAll();
            })
            .catch(function (error){
              console.log(error);
            });
        }
      }
    },
  });
</script>
</html>

WriterDelete.html:(链接删除)

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>

<link rel="stylesheet" href="element-ui/index.css">
<script src="./js/vue.js"></script>
<script src="./element-ui/index.js"></script>
<script src="./js/axios-0.18.0.js"></script>

<body>

</body>
<style>
    .el-table .warning-row {
        background: oldlace;
    }
    .el-table .success-row {
        background: #f0f9eb;
    }
</style>

<script>
    new Vue({
        el: "#app",
        data() {
            return {
                tableData: []
            }
        },
        methods: {
            selectAll:function (){
                var _this = this;
                axios.post('/selectAll',{
                })
                    .then(function (response){
                        _this.tableData = response.data.data;
                    })
                    .catch(function (error){
                        console.log(error);
                    })
            },

            deleteById:function (id){
                var _this = this;
                var url = `deleteById/${this.id}`
                if(window.confirm("确定要删除该条数据吗?")){
                    axios.post(url)
                        .then(function (response){
                            alert("删除成功!")
                            _this.selectAll();
                            location.href = 'WriterShow.html'
                        })
                        .catch(function (error){
                            console.log(error);
                        });
                }
            }
        },
        created(){
            //获取参数id的值
            this.id = location.href.split("?id=")[1]
            this.deleteById();
        }
    });
</script>
</html>

WriterInsert.html:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>

<link rel="stylesheet" href="element-ui/index.css">
<script src="./js/vue.js"></script>
<script src="./element-ui/index.js"></script>
<script src="./js/axios-0.18.0.js"></script>

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

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

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

    </tr>
  </table>

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

    },
    methods: {

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

  })
</script>
</html>

WriterUpdate.html:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>

<link rel="stylesheet" href="element-ui/index.css">
<script src="./js/vue.js"></script>
<script src="./element-ui/index.js"></script>
<script src="./js/axios-0.18.0.js"></script>

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

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

    </tr>
  </table>
</div>
</body>

<script>
  new Vue({
    el:'#app',
    data:{
      id:'',
      writer:{},
    },
    methods:{
      selectById(){
        var url = `selectById/${this.id}`
        axios.get(url)
          .then(response =>{
            var baseResult = response.data
            if(baseResult.code == 1){
              this.writer = baseResult.data
            }
          })
            .catch(error => {})
      },
      updateById(){
        var url = `updateById`
        axios.put(url,this.writer)
          .then(res => {
            var baseResult = res.data
            if(baseResult.code == 1){
              //成功
              location.href = 'WriterShow.html'
            }else {
              //失败
              alert(baseResult.message)
            }
          })
        .catch(err => {
          console.error(err);
        })
      }
    },
    created(){
      //获得参数值id
      this.id = location.href.split("?id=")[1]
      //通过id查询详情
      this.selectById();
    }
  })
</script>
</html>

Result和Writer省略~ 

  • 33
    点赞
  • 16
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值