実現したいこと
フォームで入力した内容をデータベースに反映させたい
前提
IntelliJ IDEAで課題を管理するためにタイトル 内容 対応期限 重要度を入力して、一覧表示させたりする簡単なアプリを作っています。
発生している問題・エラーメッセージ
フォームに情報を入力しても、sequel proに反映されません。
2023-03-16 14:58:51.661 INFO 19412 --- [ main] i.techcamp.issueapp.IssueappApplication : Starting IssueappApplication using Java 19.0.1 on abehiroshinosukenoMacBook-Air.local with PID 19412 (/Users/absn/java_projects/issueapp/build/classes/java/main started by absn in /Users/absn/java_projects/issueapp) 2023-03-16 14:58:51.662 INFO 19412 --- [ main] i.techcamp.issueapp.IssueappApplication : No active profile set, falling back to 1 default profile: "default" 2023-03-16 14:58:52.128 INFO 19412 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http) 2023-03-16 14:58:52.133 INFO 19412 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2023-03-16 14:58:52.134 INFO 19412 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.71] 2023-03-16 14:58:52.176 INFO 19412 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2023-03-16 14:58:52.176 INFO 19412 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 494 ms 2023-03-16 14:58:52.221 INFO 19412 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2023-03-16 14:58:52.367 INFO 19412 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2023-03-16 14:58:52.496 INFO 19412 --- [ main] o.s.b.a.w.s.WelcomePageHandlerMapping : Adding welcome page template: index 2023-03-16 14:58:52.585 INFO 19412 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8080 (http) with context path '' 2023-03-16 14:58:52.591 INFO 19412 --- [ main] i.techcamp.issueapp.IssueappApplication : Started IssueappApplication in 1.087 seconds (JVM running for 1.238) 2023-03-16 14:59:16.997 INFO 19412 --- [nio-8080-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet' 2023-03-16 14:59:16.997 INFO 19412 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet' 2023-03-16 14:59:16.998 INFO 19412 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 1 ms 2023-03-16 14:59:17.021 WARN 19412 --- [nio-8080-exec-1] .w.s.m.s.DefaultHandlerExceptionResolver : Resolved [org.springframework.validation.BindException: org.springframework.validation.BeanPropertyBindingResult: 1 errors<EOL>Field error in object 'issueForm' on field 'importance': rejected value [�a]; codes [typeMismatch.issueForm.importance,typeMismatch.importance,typeMismatch.char,typeMismatch]; arguments [org.springframework.context.support.DefaultMessageSourceResolvable: codes [issueForm.importance,importance]; arguments []; default message [importance]]; default message [Failed to convert property value of type 'java.lang.String' to required type 'char' for property 'importance'; nested exception is java.lang.IllegalArgumentException: String [�a] with length 2 cannot be converted to char type: neither Unicode nor single character]]
該当のソースコード
issueController
1package in.techcamp.issueapp; 2 3import lombok.AllArgsConstructor; 4import org.springframework.boot.Banner; 5import org.springframework.stereotype.Controller; 6import org.springframework.ui.Model; 7import org.springframework.web.bind.annotation.GetMapping; 8import org.springframework.web.bind.annotation.ModelAttribute; 9import org.springframework.web.bind.annotation.PostMapping; 10 11@Controller 12@AllArgsConstructor 13public class IssueController { 14 15 private final IssueRepository issueRepository; 16 17 @GetMapping("/issueForm") 18 public String showIssueForm(@ModelAttribute("issueForm") IssueForm form){ 19 return "issueForm"; 20 } 21 22 @PostMapping("/issues") 23 public String createIssue(IssueForm issueForm){ 24 issueRepository.insert(issueForm.getTitle(), issueForm.getContent(), issueForm.getPeriod(), issueForm.getImportance()); 25 return "redirect:/"; 26 } 27 28 @GetMapping 29 public String showIssues(Model model){ 30 var issueList = issueRepository.findAll(); 31 model.addAttribute("issueList", issueList); 32 return "index"; 33 } 34}
IssueEntity
1import lombok.AllArgsConstructor; 2import lombok.Data; 3 4@AllArgsConstructor 5@Data 6public class IssueEntity { 7 private long id; 8 private String title; 9 private String content; 10 private String period; 11 private char importance; 12}
IssueForm
1package in.techcamp.issueapp; 2 3import lombok.Data; 4 5@Data 6public class IssueForm { 7 private String title; 8 private String content; 9 private String period; 10 private char importance; 11}
IssueRepository
1package in.techcamp.issueapp; 2 3import org.apache.ibatis.annotations.Insert; 4import org.apache.ibatis.annotations.Mapper; 5import org.apache.ibatis.annotations.Select; 6 7import java.util.List; 8 9@Mapper 10public interface IssueRepository { 11 @Insert("insert into issues (title, content, period, importance) values (#{title}, #{content}, #{period}, #{importance})") 12 void insert(String title, String content, String period, char importance); 13 14 @Select("select * from issues") 15 List<IssueEntity> findAll(); 16} 17
試したこと
検索しても対処法が分からず、1から作り直しましたが変わりませんでした。
補足情報(FW/ツールのバージョンなど)
spring bootのバージョン情報
IntelliJ IDEA 2022.3.1 (Community Edition)
Build #IC-223.8214.52, built on December 20, 2022
Runtime version: 17.0.5+1-b653.23 aarch64
VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o.
macOS 13.2.1
GC: G1 Young Generation, G1 Old Generation
Memory: 1024M
Cores: 8
Metal Rendering is ON
Non-Bundled Plugins:
com.intellij.ja (223.228)
Kotlin: 223-1.7.21-release-272-IJ8214.52
初めて質問するので至らない点など教えていただけたら幸いです。
超初歩的な内容だと思うのですが、よろしくお願いします。