Spring 500번 에러 부적합한 열 유형 1111이 계속 나오네용ㅠㅠ

Question

Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='member_id', mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #1 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: 부적합한 열 유형: 1111으로 500 에러가 계속 뜨네요ㅠㅠ 8시간동안 보고 있는데 진짜...답이 안나와요ㅠㅠㅠㅠㅠㅠ도와주시면 진심으로 감사하겠습니다...!!! MainController 부분package com.ja.rubatoex.main.controller; import javax.servlet.http.HttpSession; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import com.ja.rubatoex.member.service.MemberService; import com.ja.rubatoex.vo.MemberVo; @Controller @RequestMapping("/main/*") public class MainController { @Autowired private MemberService memberService; public String mainPage() { System.out.println("시스템 로그] 메인 페이지 실행 "); return "main/mainPage"; } @RequestMapping("joinMemberPage") public String joinMemberPage() { System.out.println("시스템 로그] 회원가입 페이지 실행 "); return "main/joinMemberPage"; } @RequestMapping("findMemberIdPwPage") public String findMemberIdPwPage() { System.out.println("시스템 로그] 아이디/비밀번호 찾기 페이지 실행"); return "main/findMemberIdPwPage"; } @RequestMapping("joinMemberProcess") System.out.println("시스템 로그] 회원가입 프로세스 실행"); memberService.joinMember(param); return "main/joinMemberCompletePage"; } @RequestMapping("loginProcess") public String loginProcess(MemberVo param, HttpSession session){ System.out.println("시스템 로그] 로그인 프로세스 실행..."); System.out.println("시스템 로그] url로 입력받아 넘어온 파라미터 값 id : " + param.getMember_id()); System.out.println("시스템 로그] url로 입력받아 넘어온 파라미터 값 pw : " + param.getMember_pw()); MemberVo sessionUser = memberService.login(param); if(sessionUser != null) { // 로그인 성공 session.setAttribute("sessionUser", sessionUser); return "main/loginMainPage"; } else { // 인증 실패 return "main/loginFail"; } } } MainService 부분package com.ja.rubatoex.member.service; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.ja.rubatoex.member.mapper.MemberSQLMapper; import com.ja.rubatoex.vo.MemberVo; @Service public class MemberService { @Autowired private MemberSQLMapper memberSQLMapper; public void joinMember(MemberVo vo) { memberSQLMapper.joinMember(vo); } public MemberVo login(MemberVo vo) { MemberVo memberInfo = memberSQLMapper.getMemberByIdAndPw(vo); return memberInfo; } } MemberSQLMapper.java 부분package com.ja.rubatoex.member.mapper; import com.ja.rubatoex.vo.MemberVo; public interface MemberSQLMapper { public void joinMember(MemberVo vo); public MemberVo getMemberByIdAndPw(MemberVo abc); } MemberSQLMapper.xml 부분 INSERT INTO RU_Member VALUES( FP_Member_seq.nextval, #{member_id}, #{member_pw}, #{member_nick}, #{member_gender}, #{member_birth}, #{member_phone}, #{member_email}, SYSDATE ) MemberVo 부분package com.ja.rubatoex.vo; import java.util.Date; import org.springframework.format.annotation.DateTimeFormat; public class MemberVo { // DB 속성 그대로 필드 생성 private int member_no; private String member_id; private String member_pw; private String member_nick; private String member_gender; @DateTimeFormat(pattern = "yyyy-MM-dd") // 왼쪽 패턴에 해당하는 형식으로 문자를 수용하게 한다. private Date member_birth; // Date 타입 스타일은 java.util 형식으로!! => 2021/01/01 (o), 2021-01-01 (x) private String member_phone; private String member_email; private Date member_joindate; public MemberVo() { super(); } public MemberVo(int member_no, String member_id, String member_pw, String member_nick, String member_gender, Date member_birth, String member_phone, String member_email, Date member_joindate) { super(); this.member_no = member_no; this.member_id = member_id; this.member_pw = member_pw; this.member_nick = member_nick; this.member_gender = member_gender; this.member_birth = member_birth; this.member_phone = member_phone; this.member_email = member_email; this.member_joindate = member_joindate; } public int getMember_no() { return member_no; } public void setMember_no(int member_no) { this.member_no = member_no; } public String getMember_id() { return member_id; } public void setMember_id(String member_id) { this.member_id = member_id; } public String getMember_pw() { return member_pw; } public void setMember_pw(String member_pw) { this.member_pw = member_pw; } public String getMember_nick() { return member_nick; } public void setMember_nick(String member_nick) { this.member_nick = member_nick; } public String getMember_gender() { return member_gender; } public void setMember_gender(String member_gender) { this.member_gender = member_gender; } public Date getMember_birth() { return member_birth; } public void setMember_birth(Date member_birth) { this.member_birth = member_birth; } public String getMember_phone() { return member_phone; } public void setMember_phone(String member_phone) { this.member_phone = member_phone; } public String getMember_email() { return member_email; } public void setMember_email(String member_email) { this.member_email = member_email; } public Date getMember_joindate() { return member_joindate; } public void setMember_joindate(Date member_joindate) { this.member_joindate = member_joindate; } } mainPage.jsp 부분 (loginProcess action 부분만 추출) DB에 등록되어 있는 id와 pw로 로그인했을 시, MainController 클래스 콘솔창에 아래와 같이 null이라고 뜹니다ㅠㅠ 뭐가 잘 못된 걸까요...?ㅜㅜ 비전공자이고 이제 막 스프링 두번째 해보는건데 너무 속상해요........도와주시면 감사하겠습니다...!!ㅠㅠ

titi00 · Accepted Answer

https://developer.mozilla.org/ko/docs/Web/HTML/Element/Input 여기나오는 DEMO 보고 공부하세요

Spring 500번 에러 부적합한 열 유형 1111이 계속 나오네용ㅠㅠ

1개의 답변

#1111 목록