EclipseによるSpringBoot⑤MyBatis insert

package com.example.demo.controller;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
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.AddressListForm;
import com.example.demo.form.InputForm;
import com.example.demo.service.AddressService;

@RestController
public class AddressController {
  @Autowired
  private AddressService addressService;
  
  @RequestMapping("/list")
  ModelAndView getList(ModelAndView model) {
    
    List list = addressService.getAddress();
    
    List formList = new ArrayList();
    for(AddressDto li:list) {
      AddressListForm form = new AddressListForm();
      form.setNo(li.getId());
      form.setAddress(li.getAddress());
      form.setName(li.getName());
      form.setTel(li.getTel());
      form.setMail(li.getMail());
      form.setJob(li.getJob());
      form.setGender(li.getGender());
      formList.add(form);
    }
    
    //Thymeleafにリスト情報を設定
    model.addObject("list",formList);
    //Thymeleaf名を設定
    model.setViewName("list");
    
    return model;
  }

  //新規作成ボタン押下時の処理
  @RequestMapping("/input")
  public ModelAndView input(ModelAndView model) {
    
    InputForm inputForm = new InputForm();
    
    Map genderMap = new HashMap<>();
    genderMap.put("0", "男");
    genderMap.put("1", "女");
    inputForm.setGenderItem(genderMap);
    model.addObject("inputForm",inputForm);
    //Thymeleaf名を設定
    model.setViewName("input");
    
    return model;
  }

  //確認画面
  @RequestMapping("/confirm")
  public ModelAndView confirm(@Validated @ModelAttribute InputForm inputForm,
      BindingResult result, ModelAndView model,@RequestParam("id")String id) {
    //リダイレクトして一覧画面に戻る
    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("input");
     return model;
    }
    //確認画面に遷移
    model.setViewName("Confirm");
    return   model;
  }

  //登録ボタン押下時
  @RequestMapping("/register")
  public ModelAndView register(ModelAndView model ,
      @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("Input");
      return model;
    }
      
    //ID最大値取得
    long idMax = addressService.getIdMax();
      
    AddressDto dto = new AddressDto();
      
    //アドレス情報の設定
    dto.setId(idMax+1);
    dto.setName(name);
    dto.setAddress(address);
    dto.setMail(mail);
    dto.setTel(tel);
    dto.setJob(job);
    dto.setGender(gender);
      
    //アドレス情報の登録
    addressService.registerAddress(dto);
    //完了画面に遷移
    model.setViewName("Complete");
    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);
  
}

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);
  }

}

<?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>
</mapper>