JspでMySQLのデータを表示させたいのですがこのようなエラーが出てしまいます。
lang
1HTTPステータス 500 - An exception occurred processing JSP page /Select_Task.jsp at line 11 2 3 4type 例外レポート 5 6メッセージ An exception occurred processing JSP page /Select_Task.jsp at line 11 7 8説明 The server encountered an internal error that prevented it from fulfilling this request. 9 10例外 11org.apache.jasper.JasperException: An exception occurred processing JSP page /Select_Task.jsp at line 11 12 138: </head> 149: <body> 1510: <% 1611: Class.forName("com.mysql.jdbc.Driver"); 1712: Connection conn = DriverManager 1813: .getConnection("jdbc:mysql://XXXXXXXXXX" 1914: + "user=XXXXX&password=XXXXXX&useUnicode=true&characterEncoding=Windows-31J"); 20 21 22Stacktrace: 23 org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568) 24 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455) 25 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) 26 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) 27 javax.servlet.http.HttpServlet.service(HttpServlet.java:727) 28 org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) 29 30 31 32原因 33javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver 34 org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:916) 35 org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845) 36 org.apache.jsp.Task_005fManage_jsp._jspService(Task_005fManage_jsp.java:150) 37 org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) 38 javax.servlet.http.HttpServlet.service(HttpServlet.java:727) 39 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) 40 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) 41 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) 42 javax.servlet.http.HttpServlet.service(HttpServlet.java:727) 43 org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) 44 45 46 47原因 48java.lang.ClassNotFoundException: com.mysql.jdbc.Driver 49 org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720) 50 org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571) 51 org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:126) 52 org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63) 53 java.lang.Class.forName0(Native Method) 54 java.lang.Class.forName(Class.java:191) 55 org.apache.jsp.Task_005fManage_jsp._jspService(Task_005fManage_jsp.java:109) 56 org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) 57 javax.servlet.http.HttpServlet.service(HttpServlet.java:727) 58 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) 59 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) 60 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) 61 javax.servlet.http.HttpServlet.service(HttpServlet.java:727) 62 org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) 63 64
ソースはこれです。
lang
1<%@ page language="java" contentType="text/html; charset=Windows-31J" 2 pageEncoding="Windows-31J" import="java.sql.*"%> 3<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 4<html> 5<head> 6<meta http-equiv="Content-Type" content="text/html; charset=Windows-31J"> 7<title>Insert title here</title> 8</head> 9<body> 10 <div> 11 <h1>タスク管理</h1> 12 <div> 13 <input type="radio" name="ModelSel" id="ModelSel1"> <label 14 for="ModelSel1">参照</label> <input type="radio" name="ModelSel" 15 id="ModelSel2"> <label for="ModelSel2">変更</label> <input 16 type="radio" name="ModelSel" id="ModelSel3"> <label 17 for="ModelSel3">削除</label> 18 <button type="button">新規追加</button> 19 </div> 20 21 <table> 22 <thead> 23 <tr> 24 <th>タスクID</th> 25 <th>タスク概要</th> 26 <th>担当者</th> 27 <th>作業期間</th> 28 <th>状態</th> 29 </tr> 30 <%@include file="Select_Task.jsp"%> 31 </thead> 32 </table> 33 </div> 34 <!-- /.wrap --> 35</body> 36</html>
lang
1<%@ page language="java" contentType="text/html; charset=Windows-31J" 2 pageEncoding="Windows-31J" import="java.sql.*"%> 3<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 4<html> 5<head> 6<meta http-equiv="Content-Type" content="text/html; charset=Windows-31J"> 7<title>Insert title here</title> 8</head> 9<body> 10 <% 11 Class.forName("com.mysql.jdbc.Driver"); 12 Connection conn = DriverManager 13 .getConnection("jdbc:mysql://XXXXXXXX" 14 + "user=XXX&password=1kb5c2&useUnicode=true&characterEncoding=Windows-31J"); 15 Statement st = conn.createStatement(); 16 ResultSet res = st.executeQuery("select * XXX"); 17 18 while (res.next()) { 19 out.println("<tr>"); 20 out.println("<td>" + res.getString("TASK_ID") + "</td>"); 21 out.println("<td>" + res.getString("TASK_OVERVIEW") + "</td>"); 22 out.println("<td>" + res.getString("TASK_DETAIL") + "</td>"); 23 out.println("<td>" + res.getString("WORK_DT_FROM") + "</td>"); 24 out.println("<td>" + res.getString("WORK_DT_TO ") + "</td>"); 25 out.println("<td>" + res.getString("STATUS_F") + "</td>"); 26 out.println("</tr>"); 27 } 28 st.close(); 29 conn.close(); 30 %> 31</body> 32</html>
です。よろしくお願いします。
回答3件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2015/04/22 06:59
2015/04/22 07:43