質問編集履歴

コードの修正

2020/09/18 08:11

投稿

Y.Mamoru

スコア47

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -586,6 +586,14 @@
 				String sql = "SELECT * FROM Information WHERE NO ="+No+"AND (NAME LIKE '"+Name+"%' OR NAME LIKE '%"+Name+"')";
+				～中略～
+		}else if(No != "" && Name == "") {
+			try {
+				String sql = "SELECT * FROM Information WHERE NO ="+No;
 				conn = DBManager.getConnection();
 				smt = conn.createStatement();
@@ -594,13 +602,19 @@
 				List list = new ArrayList();
+				DataBase db = new DataBase();
 					//画面表示させるためにLISTに格納
 					while(rs.next()) {
 						～中略～
-						db.setName(Name);
+						db.setName(rs.getString("name"));
@@ -608,6 +622,8 @@
 						list.add(db);
 					}
 					if(list.isEmpty()) {
@@ -616,20 +632,26 @@
 					}
-				request.setAttribute("list", list);
+					request.setAttribute("list", list);
+					request.getRequestDispatcher("/jsp/Search.jsp").forward(request, response);//◆◆◆
+					return;
+			}catch(SQLException e) {
-				request.getRequestDispatcher("/jsp/Search.jsp").forward(request, response);
+				request.getRequestDispatcher("/jsp/result.jsp").forward(request, response);
 				return;
-			}catch(SQLException e) {
-				request.getRequestDispatcher("/jsp/result.jsp").forward(request, response);
-				return;
 			}finally {
@@ -650,163 +672,7 @@
-		}else if(No != "" && Name == "") {
-			try {
-				String sql = "SELECT * FROM Information WHERE NO ="+No;
-				conn = DBManager.getConnection();
-				smt = conn.createStatement();
-				ResultSet rs = smt.executeQuery(sql);
-				List list = new ArrayList();
-				DataBase db = new DataBase();
-					//画面表示させるためにLISTに格納
-					while(rs.next()) {
-						～中略～
+　　　　　　～中略～
-						db.setName(rs.getString("name"));
-						list.add(db);
-					}
-					if(list.isEmpty()) {
-						throw new SQLException();
-					}
-					request.setAttribute("list", list);
-					request.getRequestDispatcher("/jsp/Search.jsp").forward(request, response);
-					return;
-			}catch(SQLException e) {
-				request.getRequestDispatcher("/jsp/result.jsp").forward(request, response);//◆◆◆
-				return;
-			}finally {
-				if(smt != null) {
-					try {smt.close();}catch(SQLException ignore) {}
-				}
-				if(conn != null) {
-					try {conn.close();}catch(SQLException ignore) {}
-				}
-			}
-		}else if(No == "" && Name != "") {
-			//名前だけの検索
-			try {
-				String sql = "SELECT * FROM Information WHERE NAME LIKE '"+Name+"%' OR NAME LIKE '%"+Name+"'";
-				conn = DBManager.getConnection();
-				smt = conn.createStatement();
-				ResultSet rs = smt.executeQuery(sql);
-				List list = new ArrayList();
-					//画面表示させるためにLISTに格納
-					while(rs.next()) {
-						～中略～
-						list.add(db);
-					}
-					if(list.isEmpty()) {
-						throw new SQLException();
-					}
-				request.setAttribute("list", list);
-				request.getRequestDispatcher("/jsp/Search.jsp").forward(request, response);
-				return;
-			}catch(SQLException e) {
-				request.getRequestDispatcher("/jsp/result.jsp").forward(request, response);
-				return;
-			}finally {
-				if(smt != null) {
-					try {smt.close();}catch(SQLException ignore) {}
-				}
-				if(conn != null) {
-					try {conn.close();}catch(SQLException ignore) {}
-				}
-			}

コード追加

2020/09/18 08:11

投稿

Y.Mamoru

スコア47

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -513,3 +513,319 @@
 </html>
 ```
+追加です。エラーが出た文をまったく同じように書き直すことによって最初に出ていた箇所のエラーは無くなりました。しかし進んだ別の箇所で同じエラーが出ます。エラーが出ているのはSerchServlet.javaの115行目（◆マーク）です。
+```servlet
+package Look;
+import java.io.IOException;
+import java.sql.Connection;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
+import java.util.ArrayList;
+import java.util.List;
+import javax.servlet.ServletException;
+import javax.servlet.http.HttpServlet;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+public class SearchServlet extends HttpServlet {
+	private static final long serialVersionUID = 1L;
+	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
+		request.setCharacterEncoding("utf-8");
+		//受け取ったデータ
+		String No = request.getParameter("No");
+		String Name = request.getParameter("Name");
+		//接続準備
+		Connection conn = null;
+		Statement smt = null;
+		//接続開始
+		//NOとNAME両方で検索
+		if(No != "" && Name != "") {
+			try {
+				String sql = "SELECT * FROM Information WHERE NO ="+No+"AND (NAME LIKE '"+Name+"%' OR NAME LIKE '%"+Name+"')";
+				conn = DBManager.getConnection();
+				smt = conn.createStatement();
+				ResultSet rs = smt.executeQuery(sql);
+				List list = new ArrayList();
+					//画面表示させるためにLISTに格納
+					while(rs.next()) {
+						～中略～
+						db.setName(Name);
+						list.add(db);
+					}
+					if(list.isEmpty()) {
+						throw new SQLException();
+					}
+				request.setAttribute("list", list);
+				request.getRequestDispatcher("/jsp/Search.jsp").forward(request, response);
+				return;
+			}catch(SQLException e) {
+				request.getRequestDispatcher("/jsp/result.jsp").forward(request, response);
+				return;
+			}finally {
+				if(smt != null) {
+					try {smt.close();}catch(SQLException ignore) {}
+				}
+				if(conn != null) {
+					try {conn.close();}catch(SQLException ignore) {}
+				}
+			}
+		}else if(No != "" && Name == "") {
+			try {
+				String sql = "SELECT * FROM Information WHERE NO ="+No;
+				conn = DBManager.getConnection();
+				smt = conn.createStatement();
+				ResultSet rs = smt.executeQuery(sql);
+				List list = new ArrayList();
+				DataBase db = new DataBase();
+					//画面表示させるためにLISTに格納
+					while(rs.next()) {
+						～中略～
+						db.setName(rs.getString("name"));
+						list.add(db);
+					}
+					if(list.isEmpty()) {
+						throw new SQLException();
+					}
+					request.setAttribute("list", list);
+					request.getRequestDispatcher("/jsp/Search.jsp").forward(request, response);
+					return;
+			}catch(SQLException e) {
+				request.getRequestDispatcher("/jsp/result.jsp").forward(request, response);//◆◆◆
+				return;
+			}finally {
+				if(smt != null) {
+					try {smt.close();}catch(SQLException ignore) {}
+				}
+				if(conn != null) {
+					try {conn.close();}catch(SQLException ignore) {}
+				}
+			}
+		}else if(No == "" && Name != "") {
+			//名前だけの検索
+			try {
+				String sql = "SELECT * FROM Information WHERE NAME LIKE '"+Name+"%' OR NAME LIKE '%"+Name+"'";
+				conn = DBManager.getConnection();
+				smt = conn.createStatement();
+				ResultSet rs = smt.executeQuery(sql);
+				List list = new ArrayList();
+					//画面表示させるためにLISTに格納
+					while(rs.next()) {
+						～中略～
+						list.add(db);
+					}
+					if(list.isEmpty()) {
+						throw new SQLException();
+					}
+				request.setAttribute("list", list);
+				request.getRequestDispatcher("/jsp/Search.jsp").forward(request, response);
+				return;
+			}catch(SQLException e) {
+				request.getRequestDispatcher("/jsp/result.jsp").forward(request, response);
+				return;
+			}finally {
+				if(smt != null) {
+					try {smt.close();}catch(SQLException ignore) {}
+				}
+				if(conn != null) {
+					try {conn.close();}catch(SQLException ignore) {}
+				}
+			}
+		}else {
+			//該当がない場合
+			request.getRequestDispatcher("/jsp/result.jsp").forward(request, response);
+			return;
+		}
+	}
+}
+```

コードの追加

2020/09/18 08:08

投稿

Y.Mamoru

スコア47

test CHANGED Viewed

	@@ -1 +1 @@
1	- 書いていないはずのメソッドでエラーが出たときの対処が知りたいです。
1	+ kod-書いていないはずのメソッドでエラーが出たときの対処が知りたいです。

test CHANGED Viewed

@@ -395,3 +395,121 @@
 }
 ```
+```jsp
+<%@ page language="java" contentType="text/html;" pageEncoding="UTF-8"%>
+<%@ page import="java.util.List,Look.DataBase"%>
+<!DOCTYPE html>
+<html>
+<head>
+<meta charset="UTF-8">
+<title>アンケートNo入力画面</title>
+<link rel="stylesheet"  href="CSS/Look.css">
+</head>
+<body>
+	<h1>アンケート一覧</h1>
+	<form method="post" action="/Look/SearchServlet">
+		<div id="div1">
+			<p>アンケートNO:<input type="text" name="No"></p>
+			<p>氏名：<input type="text" name="Name"></p>
+		</div>
+		<input type="submit" name="search" value="検索">
+	</form>
+	<div id="div2">
+	<form >
+		<input type="button" name="new" value="新規" onClick="">
+	</form>
+	</div>
+	<form method="POST" action="/Look/UpdateServlet">
+		<table>
+		<tr>
+			<th>アンケートNO</th>
+			<th>氏名</th>
+			<th></th>
+			<th></th>
+		</tr>
+		<%
+			List list = (List)request.getAttribute("list");
+			for(int i=0 ; i<list.size() ; i++){
+			DataBase db = (DataBase)list.get(i);
+		%>
+		<tr>
+			<td><%= db.getNo() %></td>
+			<td><%= db.getName() %></td>
+				<td>
+				<input type="submit" name="update" value="変更" >
+				<input type="hidden" name="flag" value="1">
+				<input type="hidden" name="hiddenNO" value="<%= db.getNo() %>">
+				</td>
+				<td>
+				</td>
+		</tr>
+		<% } %>
+		</table>
+	</form>
+</body>
+</html>
+```