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

ly502294668

已于 2024-06-24 20:58:25 修改

阅读量212

点赞数 9

文章标签：前端 windows linux

于 2024-06-24 20:45:09 首次发布

本文链接：https://blog.csdn.net/ly502294668/article/details/139938037

版权

1.PeotController.java

package com.example.controller;
 
import com.example.pojo.Peot;
import com.example.pojo.Result;
import com.example.service.PeotService;
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 PeotController {
 
    @Autowired
    private PeotService peotService;
 
    @RequestMapping("/findAll")
    public List<Peot> findAll(){
     return   peotService.findAll();
    }
 
    @RequestMapping("/findAllJsoon")
    public Result findAllJson(){
        return  Result.seccess(peotService.findAll()) ;
    }
 @RequestMapping("/deletePeot")
    public void deletePeot(Integer id){
        peotService.deletePeot(id);
    }
@RequestMapping("/peotfindById/{id}")
public Result peotfindById(@PathVariable("id") Integer id) {
    return  Result.seccess(peotService.peotfindById(id));
}
 
@RequestMapping("/peotupdate")
public  Result updatePeot(@RequestBody Peot peot){
    boolean r = peotService.updatePeot(peot);
 
    if(r) {
        // 成功  code==1
        return Result.success();
    } else {
        // 失败  code==0
        return Result.erro("更新失败");
    }
}
 
    @RequestMapping("/peotinsert")
    public Result insertUser(@RequestBody Peot peot){
        boolean result =peotService.insertUser(peot);
        if(result) {
            // 成功  code==1
            return Result.success();
        } else {
            // 失败  code==0
            return Result.erro("添加失败");
 
        }
 
    }
 
 
}

2.PeotMapper.java

package com.example.mapper;
 
import com.example.pojo.Peot;
import com.example.pojo.Result;
import org.apache.ibatis.annotations.*;
 
import java.util.List;
 
@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 peotfindById(Integer ID);
 
    @Update("update peom set author=#{author},gender=#{gender},dynasty=#{dynasty},title=#{title} ,style=#{style} where id=#{id} ")
    public  boolean updatePeot(Peot peot);
 
    @Insert("insert into peom(author, gender, dynasty, title, style) values (#{author}, #{gender}, #{dynasty}, #{title}, #{style})")
    public int insert(Peot peot);
 
}

3.Peot.java

package com.example.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;
}

4.Result.java

package com.example.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);
    }
 
 
}

5.PeotService.java

package com.example.service;
 
import com.example.mapper.PeotMapper;
import com.example.pojo.Peot;
import org.springframework.beans.factory.annotation.Autowired;
 
import java.util.List;
 
public interface PeotService {
 
public List<Peot> findAll();
 
public int deletePeot(Integer id);
 
public Peot peotfindById(Integer id);
 
public boolean updatePeot(Peot peot);
 
    public   boolean  insertUser(Peot peot);
 
}

6.PeotServiceImpl.java

package com.example.service.impl;
 
import com.example.mapper.PeotMapper;
import com.example.pojo.Peot;
import com.example.service.PeotService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import java.util.List;
 
@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 peotfindById(Integer id) {
        return peotMapper.peotfindById(id);
    }
 
    @Override
    public boolean updatePeot(Peot peot) {
        return peotMapper.updatePeot(peot);
    }
 
    @Override
    public boolean  insertUser(Peot peot) {
        int result =  peotMapper.insert(peot);
        return result == 1;
    }
 
}

7.peot_findall.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>
<h1>诗人信息列表</h1>
<div id="app" align="center">
    <a href="peot_insert.html">新增</a>
<table  border="1">
    <tr>
    <th>id</th>
    <th>author</th>
    <th>gender</th>
    <th>dynasty</th>
    <th>title</th>
    <th>style</th>
    <th>操作</th>
    </tr>
    <tr v-for="peot in peotList">
        <td>{{peot.id}}</td>
        <td>{{peot.author}}</td>
        <td>{{peot.gender}}</td>
        <td>{{peot.dynasty}}</td>
        <td>{{peot.title}}</td>
        <td>{{peot.style}}</td>
        <td>
            <button type="button" @click="deleteId(peot.id)">删除</button>
            <a :href="'peot_edit.html?id='+peot.id">修改</a>
        </td>
    </tr>
 
</table>
</div>
 
</body>
 
<script>
    new Vue({
        el:"#app",
        data() {
            return {
                peotList:[]
            }
        },
        mounted(){
        axios.get('/findAllJsoon').then(res=>{
            if(res.data.code){
                this.peotList = res.data.data;
            }
            }
        )},
        methods:{
            findAll:function () {
                var _this = this;
                axios.post('/findAllJsoon', {
                })
                    .then(function (response) {
                        _this.peotList = response.data.data;//响应数据给tableData赋值
                    })
                    .catch(function (error) {
                        console.log(error);
                    });
            },
            deleteId:function (id) {
                var _thisd = this;
                if (window.confirm("确定要删除该条数据吗？？？")){
                    axios.post('/deletePeot?id='+id)
                        .then(function (response) {
                            alert("删除成功")
                            _thisd.findAll();
                        })
                        .catch(function (error) {
                            console.log(error);
                        });
                }
            }
 
        }
    })
 
 
</script>
 
</html>

8.peot_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.author"> </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: {
                "author":"",
                "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_findall.html'
                        } else {
                            // 失败
                            alert(baseResult.message)
                        }
                    })
                    .catch(err => {
                        console.error(err);
                    })
            }
        },
 
    })
</script>
 
</html>

9.peot_edit

<!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.author"> </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_findall.html'
                        } else {
                            // 失败
                            alert(baseResult.message)
                        }
                    })
                    .catch(err => {
                        console.error(err);
                    })
            },
 
 
        },
        created() {
            // 获得参数id值
            this.id = location.href.split("?id=")[1]
            // 通过id查询详情
            this.selectById()
        },
 
    })
 
 
 
</script>
 
</html>

10.application.properties

修改为自己的数据库，以及数据库连接的账号密码。