4.15团队和个人第三次冲刺

团队博客

整个项目预期的任务量：30h 已用8h

任务看板照片

 

 

 

团队照片

 

 

 

燃尽图

 

4.产品状态

昨天进行了登录和注册代码的编写，今天进行个人信息简历的修改，删除，查看

个人博客

首先写对应的sql语句，代码如下

 @Select("select * from v_resume where rid=#{rid}")
    List<Resume> selectresumebyid(int rid);
    @Update("update v_resume set name=#{name},age=#{age},study=#{study},school=#{school},year=#{year} where rid=#{rid}")
    void updateresumebyid(Resume resume);
    @Delete("delete from v_resume where rid=#{rid}")
    void deletebyid(int rid);

对应的servlet代码

package com.itheima.web;

import com.alibaba.fastjson.JSON;
import com.itheima.pojo.Resume;
import com.itheima.pojo.User;
import com.itheima.service.UserService;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.BufferedReader;
import java.io.IOException;

@WebServlet("/UpdateResumeServlet")
public class UpdateResumeServlet extends HttpServlet {
    UserService userService = new UserService();
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //1. 接收品牌数据
        HttpSession session = request.getSession();
        User user = (User)session.getAttribute("user");
        BufferedReader br = request.getReader();
        String params = br.readLine();//json字符串
        //转为Brand对象
        Resume resume= JSON.parseObject(params, Resume.class);
        resume.setRid(user.getUid());
        userService.updateresumebyid(resume);
        //3. 响应成功的标识
        response.getWriter().write("success");
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doGet(request, response);
    }
}
package com.itheima.web;

import com.alibaba.fastjson.JSON;
import com.itheima.pojo.Resume;
import com.itheima.pojo.User;
import com.itheima.service.UserService;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.BufferedReader;
import java.io.IOException;

@WebServlet("/DeleteResumeServlet")
public class DeleteResumeServlet extends HttpServlet {
    UserService userService = new UserService();
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //1. 接收品牌数据
        HttpSession session = request.getSession();
        User user = (User)session.getAttribute("user");
        userService.deletebyid(user.getUid());
        //3. 响应成功的标识
        response.getWriter().write("success");
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doGet(request, response);
    }
}
package com.itheima.web;

import com.alibaba.fastjson.JSON;
import com.itheima.pojo.Resume;
import com.itheima.pojo.User;
import com.itheima.service.UserService;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
import java.util.List;

@WebServlet("/SelectResumeServlet")
public class SelectResumeServlet extends HttpServlet {
    UserService userService = new UserService();
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        HttpSession session = request.getSession();
        User user = (User)session.getAttribute("user");
        //1. 调用service查询
        List<Resume> resumes = userService.selectresumebyid(user.getUid());
        //2. 转为JSON
        String jsonString = JSON.toJSONString(resumes);
        //3. 写数据
        response.setContentType("text/json;charset=utf-8");
        response.getWriter().write(jsonString);
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doGet(request, response);
    }
}

个人的javaweb水平有限，增删改查不太熟练，磕磕绊绊，不太理解其中的逻辑