EclipseによるSpringBoot⑥MyBatis update

package com.example.demo.controller;

import java.util.HashMap;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.validation.BindingResult;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.ModelAndView;

import com.example.demo.dto.AddressDto;
import com.example.demo.form.InputForm;
import com.example.demo.service.AddressService;

@RestController
public class AddressModifyController {
  @Autowired
  private AddressService addressService;

  @RequestMapping("/modify")
  public ModelAndView modify(ModelAndView model, @RequestParam("modifyId")long modifyId) {
    
    AddressDto addressDto = addressService.getAddressById(modifyId);
    
    InputForm inputForm = new InputForm();
    if(addressDto.getName() != null) {
      inputForm.setName(addressDto.getName().trim());
    }
    if(addressDto.getAddress().trim() != null) {
      inputForm.setAddress(addressDto.getAddress().trim());
    }
    if(addressDto.getTel() != null) {
      inputForm.setTel(addressDto.getTel().trim());
    }
    if(addressDto.getMail() != null) {
      inputForm.setMail(addressDto.getMail().trim());
    }
    if(addressDto.getJob() != null) {
      inputForm.setJob(addressDto.getJob().trim());
    }
    if(addressDto.getGender() != null) {
      inputForm.setGender(addressDto.getGender().trim());
    }
    Map genderMap = new HashMap<>();
    genderMap.put("0", "男");
    genderMap.put("1", "女");
    inputForm.setGenderItem(genderMap);
    
    //Thymeleafに住所編集情報を設定
    model.addObject("inputForm",inputForm);
    model.addObject("modifyId",modifyId);
    //Thymeleaf名を設定
    model.setViewName("Modify");
    
    return model;
  }

  //編集確認画面
  @RequestMapping("/modify/confirm")
  public ModelAndView modifyConfirm(@Validated @ModelAttribute InputForm inputForm,
      BindingResult result, ModelAndView model,
      @RequestParam("id")String id,
      @RequestParam("modifyId")long modifyId) {
    //リダイレクトにより一覧画面に戻る
    if(id.equals("back")) {
      model.setViewName("redirect:/List");
      return model;
    }
    //エラーチェック
    if(result.hasErrors()) {
      model.addObject("validationError", "不正な値が入力されました。");
      
      Map genderMap = new HashMap<>();
      genderMap.put("0", "男");
      genderMap.put("1", "女");
      inputForm.setGenderItem(genderMap);
      model.addObject("inputForm",inputForm);
      model.setViewName("Modify");
     return model;
    }
    model.addObject("modifyId",modifyId);
    model.setViewName("ModifyConfirm");
    return model;
  }
  //更新ボタン押下時
  @RequestMapping("/update")
  public ModelAndView update(ModelAndView model,
      @RequestParam("modifyId")long modifyId,
      @RequestParam("name")String name,
      @RequestParam("address")String address,
      @RequestParam("mail")String mail,
      @RequestParam("tel")String tel,
      @RequestParam("job")String job,
      @RequestParam("gender")String gender,
      @RequestParam("id")String id) {
      
    //戻るボタン押下時
    if(id.equals("back")) {
      InputForm inputForm = new InputForm();
      inputForm.setName(name);
      inputForm.setAddress(address);
      inputForm.setMail(mail);
      inputForm.setTel(tel);
      inputForm.setJob(job);
      inputForm.setGender(gender);
      Map genderMap = new HashMap<>();
      genderMap.put("0", "男");
      genderMap.put("1", "女");
      inputForm.setGenderItem(genderMap);
      model.addObject("inputForm",inputForm);
      model.setViewName("Modify");
      return model;
    }
          
    AddressDto addressDto = new AddressDto();
      
    //アドレス情報の設定
    addressDto.setId(modifyId);
    addressDto.setName(name);
    addressDto.setAddress(address);
    addressDto.setMail(mail);
    addressDto.setTel(tel);
    addressDto.setJob(job);
    addressDto.setGender(gender);
      
    //アドレス情報の更新
    addressService.updateAddressById(addressDto);
    //編集完了画面に遷移
    model.setViewName("ModifyComplete");
    return model;
  }
}

package com.example.demo.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.example.demo.dto.AddressDto;

@Mapper
public interface AddressMapper {
  public List selectAddress();

  public long selectIdMax();

  public void insertAddress(AddressDto addressDto);
  
  public AddressDto selectAddressById(long id);
  
  public void updateAddressById(AddressDto addressDto);

}

package com.example.demo.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.example.demo.dto.AddressDto;
import com.example.demo.mapper.AddressMapper;

@Service
public class AddressService {
  @Autowired
  private AddressMapper addressMapper;
  
  //住所一覧取得
  public List getAddress(){
    return addressMapper.selectAddress();
  }
  
  //ID最大値取得
  public long getIdMax() {
    return addressMapper.selectIdMax();
  }
  
  //住所登録
  public void registerAddress(AddressDto addressDto) {
    addressMapper.insertAddress(addressDto);
  }

  //IDをキーとして住所取得
  public AddressDto getAddressById(long id) {
    return addressMapper.selectAddressById(id);
  }

  //住所更新
  public void updateAddressById(AddressDto addressDto) {
    addressMapper.updateAddressById(addressDto);
  }
  
}

<?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.example.demo.mapper.AddressMapper">
  <select id="selectAddress" resultType="com.example.demo.dto.AddressDto">
    select
      *
    from
      ADDRESS
    order by id
  </select>

  <select id="selectIdMax" resultType="long">
    select
      max(id)
    from
      Address
  </select>
  
  <insert id="insertAddress" parameterType="com.example.demo.dto.AddressDto">
    insert into Address
      (id, address, tel, name, mail, job, gender)
    values(#{id}, #{address}, #{tel}, #{name}, #{mail}, #{job}, #{gender})
  </insert>

  <select id="selectAddressById" parameterType="long" resultType="com.example.demo.dto.AddressDto">
    select
      *
    from
      Address
    where
  id = #{id}
  </select>

  <update id="updateAddressById" parameterType="com.example.demo.dto.AddressDto">
    update
      Address
    set
      name = #{name},
      address = #{address},
      tel = #{tel},
      mail = #{mail},
      job = #{job},
      gender = #{gender}
    where
      id = #{id}
  </update>

</mapper>

/**
* 編集リンク押下時
*/
function postAction(id, action){
  
  var f=document.addressListForm;
  f.method="post";
  f.action=action;
  f.modifyId.value=id;
  f.submit();
}

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>アドレス一覧画面</title>
<script th:src="@{/js/PostAction.js}"></script>
</head>
<body>
  <form id="addressListForm" name="addressListForm" action="#" th:action="@{/input}" method="post">
    <table>
      <tr>
        <th>No</th>
        <th>名前</th>
        <th>住所</th>
        <th>電話番号</th>
        <th>メールアドレス</th>
        <th>職業</th>
        <th>性別</th>
        <th>編集</th>
      </tr>
      <th:block th:each="li:${list}">
        <tr>
          <td th:text="${li.no}"></td>
          <td th:text="${li.name}"></td>
          <td th:text="${li.address}"></td>
          <td th:text="${li.tel}"></td>
          <td th:text="${li.mail}"></td>
          <td th:text="${li.job}"></td>
          <td>
            <span th:if="${li.gender != null}">
              <span th:if="${li.gender == '0'}">男</span>
              <span th:if="${li.gender == '1'}">女</span>
            </span>
          </td>  
          <td>
            <a href="#"
              th:attr="onclick='postAction(\'' +${li.no} + '\',\'' + @{/modify} + '\');'">
              <span th:text="${li.name}"></span>
            </a>
          </td>
        </tr>
      </th:block>
    </table>
    <button type="submit" name="id" th:value="new">新規作成</button>
     <input type="hidden" name="modifyId" >
  </form >
</body>
</html>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>編集画面</title>
</head>
<body>
  <p th:if="${validationError}" th:text="${validationError}">validation error</p>

  <form action="#" th:action="@{/modify/confirm}" th:object="${inputForm}" method="post">
    <div>
      <span th:if="${#fields.hasErrors('name')}" th:errors="*{name}" >error!</span>
      <p>名前*</p>
      <p><input type="text" id="name" th:field="*{name}"></p>

      <span th:if="${#fields.hasErrors('address')}" th:errors="*{address}" >error!</span>
      <p>住所*</p>
      <p><input type="text" id="address" th:field="*{address}"></p>

      <span th:if="${#fields.hasErrors('tel')}" th:errors="*{tel}" >error!</span>
      <p>電話番号*</p>
      <p><input type="text" id="tel" th:field="*{tel}"></p>

      <span th:if="${#fields.hasErrors('mail')}" th:errors="*{mail}" >error!</span>
      <p>メールアドレス</p>
      <p><input type="text" id="mail" th:field="*{mail}"></p>

      <span th:if="${#fields.hasErrors('job')}" th:errors="*{job}" >error!</span>
      <p>職業</p>
      <p><input type="text" id="job" th:field="*{job}"></p>

      <p>性別</p>
      <p>
        <div th:each="item:*{genderItem}">
          <input type="radio" th:value="${item.key}" th:text="${item.value}" th:field="*{gender}"/>
        </div>
       </p>
      <button type="submit" name="id" th:value="back">戻る</button>
      <button type="submit" name="id" th:value="next">次へ</button>
    </div>
    <input type="hidden" name="modifyId" th:value="${modifyId}" >
  </form>
</body>
</html>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>編集確認画面</title>
</head>
<body>
  <form action="#" th:action="@{/update}" th:object="${inputForm}" method="post">
    <table>
    <tr>
      <th>名前</th>
      <th>住所</th>
      <th>電話番号</th>
      <th>メールアドレス</th>
      <th>職業</th>
      <th>性別</th>
    </tr>
    <tr>
      <td th:text="*{name}"></td>
      <td th:text="*{address}"></td>
      <td th:text="*{tel}"></td>
      <td th:text="*{mail}"></td>
      <td th:text="*{job}"></td>
      <td>
        <span th:if="*{gender == '0'}">男</span>
        <span th:if="*{gender == '1'}">女</span>
      </td>
    </tr>

    </table>
    <button type="submit" name="id" th:value="back">戻る</button>
    <button type="submit" name="id" th:value="modify">更新</button>

    <input type="hidden" name="name" th:value="*{name}">
    <input type="hidden" name="address" th:value="*{address}">
    <input type="hidden" name="tel" th:value="*{tel}">
    <input type="hidden" name="mail" th:value="*{mail}">
    <input type="hidden" name="job" th:value="*{job}">
    <input type="hidden" name="gender" th:value="*{gender}">
    <input type="hidden" name="modifyId" th:value="${modifyId}" >
  </form>
</body>
</html>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>更新完了画面</title>
</head>
<body>
  <form action="#" th:action="@{/list}" method="post">
    <div>
      <p>更新が完了しました。</p>
      <button type="submit" name="id" th:value="next">一覧へ</button>
    </div>
  </form>
</body>
</html>