이클립스 서블릿 값 넘기기 도와주세요ㅠ

Question

index.jsp 에서 입력 받은 값을 폼으로 SignupServlet.java 로 넘기려고하는데 값들이 자꾸 null 로 바뀌어서 넘어가집니다. 도와주세요// index.jsp<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%>Weekly Project-20230825

회원 가입 페이지

ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ//SignupServlet.javapackage org.comstudy.weeklyapp;import java.io.IOException;import java.sql.SQLException;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;@WebServlet("/index")public class SignupServlet extends HttpServlet {protected void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {String username = request.getParameter("username");String password = request.getParameter("password");String email = request.getParameter("email");String photopath = request.getParameter("photopath");System.out.println("index 에서 값을 가져옴: " + username + "," +password+ "," +email+ "," +photopath);try {DBManager dbManager = new DBManager();dbManager.insertMember(username, password, email, photopath);// 데이터베이스 연결 완료 메시지 출력response.setContentType("text/html; charset=UTF-8");response.getWriter().println("

데이터베이스 연결이 완료되었습니다.

");// 가입 후 페이지 이동response.sendRedirect("index.jsp");} catch (SQLException e) {e.printStackTrace();// 데이터베이스 연결 오류 메시지 출력response.setContentType("text/html; charset=UTF-8");response.getWriter().println("

데이터베이스 연결 오류가 발생했습니다.

");}}}ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ오류 메세지:index 에서 값을 가져옴: null,null,null,nullorg.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: NULL not allowed for column "USERNAME"; SQL statement:INSERT INTO MEMBERS (username, password, email, photopath) VALUES (?, ?, ?, ?) [23502-222]at org.h2.message.DbException.getJdbcSQLException(DbException.java:520)at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)at org.h2.message.DbException.get(DbException.java:223)at org.h2.message.DbException.get(DbException.java:199)at org.h2.table.Column.validateConvertUpdateSequence(Column.java:365)at org.h2.table.Table.convertInsertRow(Table.java:936)at org.h2.command.dml.Insert.insertRows(Insert.java:167)at org.h2.command.dml.Insert.update(Insert.java:135)at org.h2.command.dml.DataChangeStatement.update(DataChangeStatement.java:74)at org.h2.command.CommandContainer.update(CommandContainer.java:169)at org.h2.command.Command.executeUpdate(Command.java:256)at org.h2.server.TcpServerThread.process(TcpServerThread.java:413)at org.h2.server.TcpServerThread.run(TcpServerThread.java:191)at java.base/java.lang.Thread.run(Thread.java:834)at org.h2.message.DbException.getJdbcSQLException(DbException.java:520)at org.h2.engine.SessionRemote.readException(SessionRemote.java:650)at org.h2.engine.SessionRemote.done(SessionRemote.java:619)at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:237)at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:216)at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:174)at org.comstudy.weeklyapp.DBManager.insertMember(DBManager.java:38)at org.comstudy.weeklyapp.SignupServlet.doPost(SignupServlet.java:26)at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:673)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:390)at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1790)at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)at java.base/java.lang.Thread.run(Thread.java:834)

이클립스 서블릿 값 넘기기 도와주세요ㅠ

0개의 답변

Q&A 목록