假期作业10

daily评估表：
pojo:

点击查看代码

package com.vivy.pojo;


public class Daily {
    private Integer id;
    private Integer eatingScore;
    private Integer bathingScore;
    private Integer groomingScore;
    private Integer dressingScore;
    private Integer bowelControlScore;
    private Integer bladderControlScore;
    private Integer toiletingScore;
    private Integer movingScore;
    private Integer walkingScore;
    private Integer climbingScore;
    private Integer totalScore;
    private Integer activityLevel;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public Integer getEatingScore() {
        return eatingScore;
    }

    public void setEatingScore(Integer eatingScore) {
        this.eatingScore = eatingScore;
    }

    public Integer getBathingScore() {
        return bathingScore;
    }

    public void setBathingScore(Integer bathingScore) {
        this.bathingScore = bathingScore;
    }

    public Integer getGroomingScore() {
        return groomingScore;
    }

    public void setGroomingScore(Integer groomingScore) {
        this.groomingScore = groomingScore;
    }

    public Integer getDressingScore() {
        return dressingScore;
    }

    public void setDressingScore(Integer dressingScore) {
        this.dressingScore = dressingScore;
    }

    public Integer getBowelControlScore() {
        return bowelControlScore;
    }

    public void setBowelControlScore(Integer bowelControlScore) {
        this.bowelControlScore = bowelControlScore;
    }

    public Integer getBladderControlScore() {
        return bladderControlScore;
    }

    public void setBladderControlScore(Integer bladderControlScore) {
        this.bladderControlScore = bladderControlScore;
    }

    public Integer getToiletingScore() {
        return toiletingScore;
    }

    public void setToiletingScore(Integer toiletingScore) {
        this.toiletingScore = toiletingScore;
    }

    public Integer getMovingScore() {
        return movingScore;
    }

    public void setMovingScore(Integer movingScore) {
        this.movingScore = movingScore;
    }

    public Integer getWalkingScore() {
        return walkingScore;
    }

    public void setWalkingScore(Integer walkingScore) {
        this.walkingScore = walkingScore;
    }

    public Integer getClimbingScore() {
        return climbingScore;
    }

    public void setClimbingScore(Integer climbingScore) {
        this.climbingScore = climbingScore;
    }

    public Integer getTotalScore() {
        return totalScore;
    }

    public void setTotalScore(Integer totalScore) {
        this.totalScore = totalScore;
    }

    public Integer getActivityLevel() {
        return activityLevel;
    }

    public void setActivityLevel(Integer activityLevel) {
        this.activityLevel = activityLevel;
    }

    @Override
    public String toString() {
        return "Daily{" +
                "id=" + id +
                ", eatingScore=" + eatingScore +
                ", bathingScore=" + bathingScore +
                ", groomingScore=" + groomingScore +
                ", dressingScore=" + dressingScore +
                ", bowelControlScore=" + bowelControlScore +
                ", bladderControlScore=" + bladderControlScore +
                ", toiletingScore=" + toiletingScore +
                ", movingScore=" + movingScore +
                ", walkingScore=" + walkingScore +
                ", climbingScore=" + climbingScore +
                ", totalScore=" + totalScore +
                ", activityLevel=" + activityLevel +
                '}';
    }
}

mapper：

点击查看代码

package com.vivy.mapper;

import com.vivy.pojo.Daily;

public interface DailyMapper {

    void add(Daily daily);

}

mapper.xml

点击查看代码

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<!--接口全路径名-->
<mapper namespace="com.vivy.mapper.DailyMapper">

    <insert id="add" parameterType="com.vivy.pojo.Daily">
        INSERT INTO tb_daily (
            eatingScore,bathingScore,groomingScore,
            dressingScore,bowelControlScore,bladderControlScore,
            toiletingScore,movingScore,walkingScore,climbingScore,totalScore,activityLevel
        ) VALUES (
                     #{eatingScore}, #{bathingScore}, #{groomingScore}, #{dressingScore}, #{bowelControlScore},
                     #{bladderControlScore}, #{toiletingScore}, #{movingScore}, #{walkingScore},
                     #{climbingScore}, #{totalScore}, #{activityLevel}
                 )
    </insert>



</mapper>

Service：

点击查看代码

package com.vivy.service;

import com.vivy.mapper.BaseMapper;
import com.vivy.mapper.DailyMapper;
import com.vivy.pojo.Base;
import com.vivy.pojo.Daily;
import com.vivy.util.SqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

public class DailyService {
    SqlSessionFactory sqlSessionFactory = SqlSessionFactoryUtils.getSqlSessionFactory();

    public void add(Daily daily){

        SqlSession sqlSession = sqlSessionFactory.openSession();
        DailyMapper dailyMapper = sqlSession.getMapper(DailyMapper.class);

        dailyMapper.add(daily);

        sqlSession.commit();
        sqlSession.close();
    }
}

servlet：

点击查看代码

package com.vivy.web;

import com.vivy.pojo.Daily;
import com.vivy.service.DailyService;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

@WebServlet("/addDailyServlet")
public class addDailyServlet extends HttpServlet {
    private DailyService service = new DailyService();

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // 设置请求和响应的字符编码
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=UTF-8");

        // 获取表单数据
        int eatingScore = Integer.parseInt(request.getParameter("eatingScore"));
        int bathingScore = Integer.parseInt(request.getParameter("bathingScore"));
        int groomingScore = Integer.parseInt(request.getParameter("groomingScore"));
        int dressingScore = Integer.parseInt(request.getParameter("dressingScore"));
        int bowelControlScore = Integer.parseInt(request.getParameter("bowelControlScore"));
        int bladderControlScore = Integer.parseInt(request.getParameter("bladderControlScore"));
        int toiletingScore = Integer.parseInt(request.getParameter("toiletingScore"));
        int movingScore = Integer.parseInt(request.getParameter("movingScore"));
        int walkingScore = Integer.parseInt(request.getParameter("walkingScore"));
        int climbingScore = Integer.parseInt(request.getParameter("climbingScore"));

        // 计算总分
        int totalScore = eatingScore + bathingScore + groomingScore + dressingScore +
                bowelControlScore + bladderControlScore + toiletingScore +
                movingScore + walkingScore + climbingScore;

        // 计算分级
        int activityLevel;
        if (totalScore == 100) {
            activityLevel = 0;
        } else if (totalScore >= 65 && totalScore <= 95) {
            activityLevel = 1;
        } else if (totalScore >= 45 && totalScore <= 60) {
            activityLevel = 2;
        } else {
            activityLevel = 3;
        }

        Daily assessment = new Daily();
        assessment.setEatingScore(eatingScore);
        assessment.setBathingScore(bathingScore);
        assessment.setGroomingScore(groomingScore);
        assessment.setDressingScore(dressingScore);
        assessment.setBowelControlScore(bowelControlScore);
        assessment.setBladderControlScore(bladderControlScore);
        assessment.setToiletingScore(toiletingScore);
        assessment.setMovingScore(movingScore);
        assessment.setWalkingScore(walkingScore);
        assessment.setClimbingScore(climbingScore);
        assessment.setTotalScore(totalScore);
        assessment.setActivityLevel(activityLevel);

        service.add(assessment);

    }
}