html과 mysql 을 연동하려고 하는데 오류가 납니다.

Question

지금 데이터 베이스와 html을 연동하려고 하고 있는데 계속 500에러가 나와서 이걸 어떻게 해야할 지 모르겠어요 ㅜㅜ 이상하게 어디서 문제인지를 모르겠어요 ... 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: 서버 버전 이름: Apache Tomcat/9.0.35 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: Server 빌드 시각: May 5 2020 20:36:20 UTC 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: Server 버전 번호: 9.0.35.0 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: 운영체제 이름: Windows 10 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: 운영체제 버전: 10.0 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: 아키텍처: amd64 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: 자바 홈: C:\Program Files\Java\jre1.8.0_251 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: JVM 버전: 1.8.0_251-b08 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: JVM 벤더: Oracle Corporation 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: CATALINA_BASE: C:\Users\user\Documents\workspace-spring-tool-suite-4-4.6.1.RELEASE\.metadata\.plugins\org.eclipse.wst.server.core mp1 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: CATALINA_HOME: C:\Users\user\Downloads\apache-tomcat-9.0.35\apache-tomcat-9.0.35 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: 명령 행 아규먼트: -Dcatalina.base=C:\Users\user\Documents\workspace-spring-tool-suite-4-4.6.1.RELEASE\.metadata\.plugins\org.eclipse.wst.server.core mp1 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: 명령 행 아규먼트: -Dcatalina.home=C:\Users\user\Downloads\apache-tomcat-9.0.35\apache-tomcat-9.0.35 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: 명령 행 아규먼트: -Dwtp.deploy=C:\Users\user\Documents\workspace-spring-tool-suite-4-4.6.1.RELEASE\.metadata\.plugins\org.eclipse.wst.server.core mp1\wtpwebapps 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: 명령 행 아규먼트: -Djava.endorsed.dirs=C:\Users\user\Downloads\apache-tomcat-9.0.35\apache-tomcat-9.0.35\endorsed 6월 12, 2020 8:26:49 오후 org.apache.catalina.startup.VersionLoggerListener log 정보: 명령 행 아규먼트: -Dfile.encoding=MS949 6월 12, 2020 8:26:49 오후 org.apache.catalina.core.AprLifecycleListener lifecycleEvent 정보: 프로덕션 환경들에서 최적의 성능을 제공하는, APR 기반 Apache Tomcat Native 라이브러리가, 다음 java.library.path에서 발견되지 않습니다: [C:\Program Files\Java\jre1.8.0_251\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre1.8.0_251/bin/server;C:/Program Files/Java/jre1.8.0_251/bin;C:/Program Files/Java/jre1.8.0_251/lib/amd64;C:\Program Files (x86)\NAT Service;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\;C:\Program Files\Java\jdk1.8.0_251\bin;C:\Users\user\anaconda3;C:\Users\user\anaconda3\Scripts;C:\Users\user\anaconda3\condabin;C:\Users\user\anaconda3\Library\bin;C:\Users\user\.dnx\bin;C:\Program Files\Microsoft DNX\Dnvm\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Users\user\Downloads\apache-maven-3.6.3-bin\apache-maven-3.6.3;C:\Users\user\Downloads\apache-maven-3.6.3-bin\apache-maven-3.6.3\bin;C:\xampp\mysql\bin;C:\python37\Scripts\;C:\python37\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\;C:\Users\user\AppData\Local\Microsoft\WindowsApps:C:\Program Files\MySQL\MySQL Server 5.7\bin;C:\Program Files\MySQL\MySQL Server 5.7\bin;C:\Users\user\AppData\Local\atom\bin;C:\Program Files (x86)\ESTsoft\ALSee\x64;C:\Users\user\Downloads\sts-4.6.1.RELEASE;;.] 6월 12, 2020 8:26:49 오후 org.apache.coyote.AbstractProtocol init 정보: 프로토콜 핸들러 ["http-nio-8080"]을(를) 초기화합니다. 6월 12, 2020 8:26:50 오후 org.apache.catalina.startup.Catalina load 정보: [1,548] 밀리초 내에 서버가 초기화되었습니다. 6월 12, 2020 8:26:50 오후 org.apache.catalina.core.StandardService startInternal 정보: 서비스 [Catalina]을(를) 시작합니다. 6월 12, 2020 8:26:50 오후 org.apache.catalina.core.StandardEngine startInternal 정보: 서버 엔진을 시작합니다: [Apache Tomcat/9.0.35] 6월 12, 2020 8:26:51 오후 org.apache.jasper.servlet.TldScanner scanJars 정보: 적어도 하나의 JAR가 TLD들을 찾기 위해 스캔되었으나 아무 것도 찾지 못했습니다. 스캔했으나 TLD가 없는 JAR들의 전체 목록을 보시려면, 로그 레벨을 디버그 레벨로 설정하십시오. 스캔 과정에서 불필요한 JAR들을 건너뛰면, 시스템 시작 시간과 JSP 컴파일 시간을 단축시킬 수 있습니다. 6월 12, 2020 8:26:51 오후 org.apache.coyote.AbstractProtocol start 정보: 프로토콜 핸들러 ["http-nio-8080"]을(를) 시작합니다. 6월 12, 2020 8:26:51 오후 org.apache.catalina.startup.Catalina start 정보: 서버가 [951] 밀리초 내에 시작되었습니다. 6월 12, 2020 8:27:38 오후 org.apache.catalina.core.StandardWrapperValve invoke 심각: 경로 [/project2]의 컨텍스트 내의 서블릿 [jsp]을(를) 위한 Servlet.service() 호출이, 근본 원인(root cause)과 함께, 예외 [타입이 [reservation.Reservation]인 bean의 프로퍼티 [Rdate]에 대한 정보를 찾을 수 없습니다.]을(를) 발생시켰습니다. org.apache.jasper.JasperException: 타입이 [reservation.Reservation]인 bean의 프로퍼티 [Rdate]에 대한 정보를 찾을 수 없습니다. at org.apache.jasper.runtime.JspRuntimeLibrary.introspecthelper(JspRuntimeLibrary.java:362) at org.apache.jsp.reservationAction_jsp._jspService(reservationAction_jsp.java:137) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) 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:690) 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:373) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="reservation.ReservationDAO" %> <%@ page import="reservation.Reservation" %> <%@ page import="java.io.PrintWriter" %> <% request.setCharacterEncoding("UTF-8"); %> Insert title here <% if(reservation.getRdate() == null || reservation.getRtime() == null){ PrintWriter script = response.getWriter(); script.println(""); }else { ReservationDAO reservationDAO = new ReservationDAO(); int result = reservationDAO.write(reservation.getRdate(), reservation.getRtime(), reservation.getRPnum(), reservation.getRoomnumber()); if(result == -1){ PrintWriter script = response.getWriter(); script.println(""); }else{ PrintWriter script = response.getWriter(); script.println(""); } } %> <%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="UTF-8"%> 보드게임카페 예약

보드게임 좌석예약

package reservation; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; public class ReservationDAO { private Connection conn; private ResultSet rs; public ReservationDAO() { try { String dbURL = "jdbc:mysql://localhost:3306/BBS"; String dbID = "root"; String dbPassword = "1234"; Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection(dbURL,dbID,dbPassword); } catch (Exception e) { e.printStackTrace(); } } public int getNext() { String SQL = "SELECT Rnum FROM reservation ORDER BY Rnum DESC"; try { PreparedStatement pstmt = conn.prepareStatement(SQL); rs = pstmt.executeQuery(); if (rs.next()) { return rs.getInt(1) +1; } }catch (Exception e) { e.printStackTrace(); } return -1; } public int write(String Rdate, String Rtime, int RPnum, int Roomnumber) { String SQL = "INSERT INTO reservation VALUES(?,?,?,?,?,?)"; try { PreparedStatement pstmt = conn.prepareStatement(SQL); pstmt.setInt(1, getNext()); pstmt.setString(2, Rdate); pstmt.setString(3, Rtime); pstmt.setInt(4, RPnum); pstmt.setInt(5, Roomnumber); pstmt.setInt(6, 1); return pstmt.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } return -1; } public ArrayList getList(int pageNumber) { String SQL = "SELECT * FROM reservation WHERE Rnum < ? AND RAvailable = 1 ORDER BY Rnum DESC LIMIT 10"; ArrayList list = new ArrayList(); try { PreparedStatement pstmt = conn.prepareStatement(SQL); pstmt.setInt(1,getNext() - (pageNumber -1)*10); rs = pstmt.executeQuery(); while(rs.next()) { Reservation reser = new Reservation(); reser.setRnum(rs.getInt(1)); reser.setRdate(rs.getString(2)); reser.setRtime(rs.getString(3)); reser.setRPnum(rs.getInt(4)); reser.setRoomnumber(rs.getInt(5)); reser.setRAvailable(rs.getInt(6)); list.add(reser); } }catch (Exception e) { e.printStackTrace(); } return list; } } package reservation; public class Reservation { private int Rnum; public int getRnum() { return Rnum; } public void setRnum(int rnum) { Rnum = rnum; } private String Rdate; public String getRdate() { return Rdate; } public void setRdate(String rdate) { Rdate = rdate; } private String Rtime; public String getRtime() { return Rtime; } public void setRtime(String rtime) { Rtime = rtime; } private int RPnum; public int getRPnum() { return RPnum; } public void setRPnum(int rPnum) { RPnum = rPnum; } private int Roomnumber; public int getRoomnumber() { return Roomnumber; } public void setRoomnumber(int roomnumber) { Roomnumber = roomnumber; } private int RAvailable; public int getRAvailable() { return RAvailable; } public void setRAvailable(int rAvailable) { RAvailable = rAvailable; } }

html과 mysql 을 연동하려고 하는데 오류가 납니다.

0개의 답변

#500 목록