JSP 회원가입 textfield에서 마지막 입력 값을 못 받습니다.

Question

안녕하세요 Struts2를 이용해서 간단하게 회원가입 연습을 하고 있는 초보 웹개발자입니다. 회원가입 페이지의 input field에 이름을 분명하게 입력하였음에도 불구하고 다음과 같은 SQLServerException이 발생합니다.(참고로, 1~6열과 맨 마지막 두 열은 디버깅하기 위하여 입력한 System.out.println 코드들이 출력된 것입니다.) 제가 보기에는 JSP파일 쪽의 문제인 것 같습니다. 제가 해당 예제를 참고하였는데, 아무리 봐도 어디가 문제인지 모르겠네요.. ㅠㅠ 고수님들 조언 부탁드립니다. 보시면 아시겠지만, input field가 4개가 있는데, 그중 3곳에 대하여는 값이 출력이 되지만, 마지막 m.getFullName()이 null로 출력됩니다.exec1 Driver version: 2.0.1803.100 m.getId(): duhan m.getEmail(): duhan@yain.com m.getPassword(): 1234 m.getFullName(): null exception com.microsoft.sqlserver.jdbc.SQLServerException: 테이블 'test1.dbo.member', 열 'full_name'에 NULL 값을 삽입할 수 없습니다. 열에는 NULL을 사용할 수 없습니다. INSERT이(가) 실패했습니다. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306) at tom.st2.dao.RegisterDao.save(RegisterDao.java:35) at tom.st2.model.Member.execute(Member.java:48) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:567) at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441) at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243) at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252) at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488) at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77) at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1598) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:830) exec2. value of int i is: 0 exec:error join.jsp입니다.디버깅을 위하여 제이쿼리로 코드를 좀 넣어봤습니다. <%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="utf-8"%> <%@ taglib uri="/struts-tags" prefix="s" %> 회원가입 회원가입 분명히 값을 입력하였음에도 불구하고, alert로 값을 받아서 출력해 보면 아무것도 나오지 않습니다. 다른 field에 입력된 값은 전부 제대로 나옵니다. 추가로 기타 설정파일 코드 첨부합니다. web.xml

struts2

org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter

struts2

/*

RegisterDao.java package tom.st2.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import tom.st2.model.Member; public class RegisterDao { public static int save(Member m) { int status = 0; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //String url ="jdbc:sqlserver://localhost;database=test1;integratedSecurity=true"; String url ="jdbc:sqlserver://localhost;database=test1;"; Connection con = DriverManager.getConnection(url, "id","password"); java.sql.DatabaseMetaData metaData = con.getMetaData(); System.out.println("Driver version: "+ metaData.getDriverVersion()); String sql = "insert into member(id,email,password,full_name) values(?,?,?,?)"; //String sql = "insert into member(id,email,password,full_name) values(?,?,?,'두한')"; PreparedStatement ps = con.prepareStatement(sql); System.out.println("m.getId(): "+m.getId()); ps.setString(1, m.getId()); System.out.println("m.getEmail(): "+m.getEmail()); ps.setString(2, m.getEmail()); System.out.println("m.getPassword(): "+m.getPassword()); ps.setString(3, m.getPassword());//암호화 1도 안됨. 어쨌든 값은 가지고 온다. System.out.println("m.getFullName(): "+m.getFullName()); //왜 null이냐 ps.setString(4, m.getFullName()); status = ps.executeUpdate(); System.out.println(12); }catch(Exception e) { System.out.println("exception"); e.printStackTrace(); } return status; } } Member.java package tom.st2.model; import tom.st2.dao.RegisterDao; public class Member { private String id; private String email; private String password; private String fullName; public Member() {} public Member(String id, String email, String password, String fullName) { this.id = id; this.email = email; this.password = password; this.fullName = fullName; } public String getId() { return id; } public void setId(String id) { this.id = id; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getFullName() { return fullName; } public void setFullName(String fullName) { this.fullName = fullName; } public String execute() { System.out.println("exec1"); int i = RegisterDao.save(this); System.out.println("exec2. value of int i is: "+i); if(i>0) {System.out.println("exec:success"); return "success";} else {System.out.println("exec:error"); return "error";} } } struts.xml join-success.jsp join-error.jsp

스트라 · Answer

음..스트럿츠는 모르지만 일단Member.java 에 fullName과 jsp 폼 내의 name&#61;&#34;fullname&#34; 대소문자가 달라서 발생하지 않을까 예상해봅니다 그리고 alert 찍으실때alert('입력된 이름 : ' &#43; $(&#34;fullname&#34;).val())요로케 하세여 콤마뒤는 무시됩니다.

사딸라 · Answer

스트라님 말씀 듣고Member,java안에서변수명 fullName을 fullname으로 변경하고,getter,setter도 각각 getFullname, setFullname으로 변경했습니다.join.jsp에서도 fullname으로 바꿨어요.그런데도 안되네요 ㅠㅠ

스트라 · Answer

음..login.jsp 꼭대기에 contentType&#61;&#34;text/html; charset&#61;EUC-KR&#34; 요게 문제일까요..다른거는 다 utf-8인데 저것만 EUC-KR로 되어있어서 신경이 쓰이긴해요 fullname에 영어로 했을 때 제대로 된다면 아마 저거 문제일수도..

사딸라 · Answer

말씀대로 alert('입력된 이름 : ' &#43; $(&#34;fullname&#34;).val()) 으로 변경해보았습니다.그랬더니 아래와 같은 메시지가 나옵니다.이제 m.getFullname()은 값을 가져오네요.다만 SQLServerException에서, 제가 기존에 삭제한 column인 'member_index'에 null 값을 삽입할 수 없다고 나오네요. SQL Server의 DB에서 테이블을 다시 조회해보니, 새로 만든 테이블이 반영이 되어있지 않아서, 새로고침을 했더니 해당 문제는 해결되었습니다.그러나 이제는 com.microsoft.sqlserver.jdbc.SQLServerException: 문자열이나 이진 데이터는 잘립니다. 라는 오류가 뜨네요.. 테이블을 만들 때 데이터 길이에 관련된 값을 안 넣어서 문제가 생긴 것으로 보여서, varchar에 길이 값을 추가했더니 이제는 됩니다.도와주셔서 감사합니다 ㅎㅎ

사딸라 · Answer

그리고 fullname을 한글로 넣었는데도 회원가입이 잘 이루어지며, 글자가 깨지지 않습니다 ㅎㅎ

JSP 회원가입 textfield에서 마지막 입력 값을 못 받습니다.

5개의 답변

#struts2 목록