###前提・実現したいこと
JSPから値を入力しDB(SQLSERVER)から該当する値を取してJSPで表示させたいです。
流れとしてはJSP→サーブレット→DB→サーブレット→JSP
###発生している問題・エラーメッセージ
DBから値を取得はできているのですが、JSPで表示できません。
■画面(下記しか表示されていません)
Web サイトはページを表示できません
HTTP500
■コンソール
重大: サーブレット [ichiro.Control] のServlet.service()が例外を投げました
■Javaスタック・トレース・コンソール
out.println("</body>");
out.println("</html>");
java
1<%@ page language="java" contentType="text/html; charset=UTF-8" 2 pageEncoding="UTF-8"%> 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=UTF-8"> 7<title>Insert title here</title> 8</head> 9<body> 10 11<form action = "/Ichiro/Control" method = "post"> 12 名前:<input type="text" name="name"> 13 ID:<input type="text" name="id"> 14 <input type="submit" value="POSTで送信"> 15</form> 16</body> 17</html>
java
1package ichiro; 2 3import java.io.IOException; 4 5import javax.servlet.RequestDispatcher; 6import javax.servlet.ServletException; 7import javax.servlet.annotation.WebServlet; 8import javax.servlet.http.HttpServlet; 9import javax.servlet.http.HttpServletRequest; 10import javax.servlet.http.HttpServletResponse; 11import javax.servlet.http.HttpSession; 12 13/** 14 * Servlet implementation class Control 15 */ 16@WebServlet("/Control") 17public class Control extends HttpServlet { 18 private static final long serialVersionUID = 1L; 19 20 /** 21 * @see HttpServlet#HttpServlet() 22 */ 23 public Control() { 24 super(); 25 // TODO Auto-generated constructor stub 26 } 27 28 /** 29 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) 30 */ 31 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 32 33 RequestDispatcher dispatcher = request.getRequestDispatcher("/WEB-INF/jsp/InData.jsp"); 34 dispatcher.forward(request, response); 35 36 37 response.getWriter().append("Served at: ").append(request.getContextPath()); 38 39 } 40 41 /** 42 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) 43 */ 44 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 45 // TODO Auto-generated method stub 46 doGet(request, response); 47 48 String name = request.getParameter("name"); 49 String id = request.getParameter("id"); 50 51 Man m = new Man(); 52 m.setName(name); 53 m.setId(id); 54 55 DB db = new DB(); 56 db.data(m); 57 58 HttpSession session = request.getSession(); 59 session.setAttribute("m", m); 60 61 RequestDispatcher dispatcher = request.getRequestDispatcher("/WEB-INF/jsp/ReturnData.jsp"); 62 dispatcher.forward(request, response); 63 64 } 65 66} 67
java
1package ichiro; 2 3import java.io.Serializable; 4 5public class Man implements Serializable { 6 String name; 7 8 String id; 9 10 public String getName() { 11 return name; 12 } 13 14 public void setName(String name) { 15 this.name = name; 16 } 17 18 public String getId() { 19 return id; 20 } 21 22 public void setId(String id) { 23 this.id = id; 24 } 25 26 27} 28
java
1package ichiro; 2 3import java.sql.Connection; 4import java.sql.Driver; 5import java.sql.ResultSet; 6import java.sql.Statement; 7import java.util.Properties; 8 9public class DB { 10 11 public void data(Man man){ 12 try { 13 Driver d = (Driver) Class.forName( 14 "com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance(); 15 String connUrl = 16 "jdbc:sqlserver://localhost:1433;databaseName=KINMU;" 17 + "integratedSecurity=false;user=hosaka;password=Ichiroichiro16"; 18 Connection con = d.connect(connUrl, new Properties()); 19 20 String SQL = "SELECT * from M_SHAIN where SHAIN_ID ='" + man.getId() +"'"; 21 Statement stmt = con.createStatement(); 22 ResultSet rs = stmt.executeQuery(SQL); 23 24 while(rs.next()){ 25 String name = rs.getString("SHAIN_MEI"); 26 String id = rs.getString("SHAIN_ID"); 27 man.setName(name); 28 man.setId(id); 29 30 31 } 32 33 rs.close(); 34 stmt.close(); 35 } 36 catch (Exception e) { 37 e.printStackTrace(); 38 } 39 40 } 41} 42
java
1<%@ page language="java" contentType="text/html; charset=UTF-8" 2 pageEncoding="UTF-8"%> 3<%@ page import = "ichiro.Man" %> 4 5<%Man m = (Man) session.getAttribute("m"); %> 6<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 7<html> 8<head> 9<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 10<title>Insert title here</title> 11</head> 12<body> 13<p> 14名前:<%= m.getName() %> <br> 15 ID:<%= m.getId() %> <br> 16</p> 17</body> 18</html>
どうか回答をよろしくお願いします。