JSP 회원가입 페이지에서 DB접속 불가능한 상황인데... 어디를 수정해야할까요

Question

이게 데이터베이스로 연결시키는 java파일입니다package com.project.DB; import java.sql.*; import com.mysql.jdbc.exceptions.MySQLDataException; public class DBUtil { public static Connection getMySQLConnection(){ Connection conn = null; try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/z1437023"; String user = "z1437037"; String password = "ycdc"; conn = DriverManager.getConnection(url, user, password); } catch(ClassNotFoundException e) { System.out.println("MySQL 드라이버가 없습니다.
"); } catch(MySQLDataException e) { System.out.println("데이터베이스가 없습니다.
"); } catch(SQLException e){ System.out.println("사용자 계정 또는 비밀번호가 일치하지 않습니다.
"); } return conn; } public static void close(Connection conn){ try{if(conn != null){conn.close();} }catch(Exception e){e.printStackTrace();} } public static void close(Statement stmt){ try{if(stmt != null){stmt.close();} }catch(Exception e){e.printStackTrace();} } public static void close(PreparedStatement pstmt){ try{if(pstmt != null){pstmt.close();} }catch(Exception e){e.printStackTrace();} } public static void close(ResultSet rs){ try{if(rs != null){rs.close();} }catch(Exception e){e.printStackTrace();} } } 이건 회원가입 성공했다는 코드고요...ㅠ<%@page import="com.project.DB.DBUtil"%> <%@page import="java.sql.Connection"%> <%@page import="java.sql.PreparedStatement"%> <%@page import="java.sql.*" %> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> 회원가입 <% request.setCharacterEncoding("UTF-8"); String id = request.getParameter("id"); String password = request.getParameter("password"); String name = request.getParameter("name"); int age = Integer.parseInt(request.getParameter("age")); Connection conn = DBUtil.getMySQLConnection(); //DB 연결 String sql = "INSERT INTO member(id, password, name, age)"+"values(?, ?, ?, ?)"; PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, id); pstmt.setString(2, password); pstmt.setString(3, name); pstmt.setInt(4,age); pstmt.executeUpdate(); DBUtil.close(pstmt); DBUtil.close(conn); %> 이 페이지로 접속했을때 나오는 에러가 HTTP Status 500 – Internal Server Error Type Exception Report Message An exception occurred processing JSP page [/joinOK.jsp] at line [24] Description The server encountered an unexpected condition that prevented it from fulfilling the request. Exception org.apache.jasper.JasperException: An exception occurred processing JSP page [/joinOK.jsp] at line [24] 21: Connection conn = DBUtil.getMySQLConnection(); //DB 연결 22: 23: String sql = "INSERT INTO member(id, password, name, age)"+"values(?, ?, ?, ?)"; 24: PreparedStatement pstmt = conn.prepareStatement(sql); 25: 26: pstmt.setString(1, id); 27: pstmt.setString(2, password); Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:584) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:481) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) Root Cause java.lang.NullPointerException org.apache.jsp.joinOK_jsp._jspService(joinOK_jsp.java:141) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) Note The full stack trace of the root cause is available in the server logs. 회원가입 뿐만 아니라 로그인 페이지도 같이 만들고 있는데 24: PreparedStatement pstmt = conn.prepareStatement(sql);이 에러는 공통적으로 뜨네요.... 조언부탁드립니다..ㅠ

dev_is_art · Answer

int rn &#61; pstmt.excuteUpdate(); 해줘야하는거 아닌가요?

서월 · Answer

에러가 난 부분에 말씀하시는건가요?

siva6 · Answer

System.out 에 찍히는 것은 없나요?

땡후이 · Answer

sql을 로그 찍어 보고 그 쿼리 실행 해보시는게.

더미 · Answer

싱글톤이라든지생성자라든지static 이라든지찾아보세요

JSP 회원가입 페이지에서 DB접속 불가능한 상황인데... 어디를 수정해야할까요

5개의 답변

#500error 목록