編集履歴

質問編集履歴

検索ボタンを押した後の画面

2020/08/22 22:46

投稿

スコア15

test CHANGED Viewed

	@@ -1 +1 @@
1	- 背景赤い部分の高さを変えたい
1	+ 検索結果後の画面表示の背景赤い部分の高さを変えたい

test CHANGED Viewed

File without changes

javaでなくjspでした

2020/08/22 22:46

投稿

kaibasira

スコア15

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -112,204 +112,182 @@
-スタイルシートを使っているjava
-```
-package movie;
-import java.sql.Connection;
-import java.sql.PreparedStatement;
-import java.sql.ResultSet;
-import java.util.ArrayList;
-public class Model {
-	private String q;
-	private String c;
-	private ArrayList<TitleListResult> results;
-	public void execute() {
-		System.out.println("Hello");
-		try {
-			Connection conn = ConnectUtilMy.connectDatabase();
-			// 住所の検索
-			String sql = "SELECT title_name,years_publication,performance_income,production_cost,public_evaluation,screening_time,genre_name,original_name,cast_name,directed_name "
-					+ "FROM movie "
-					+ "inner join original_list on movie.original_number=original_list.original_number "
-					+ "inner join genre_list on movie.genre_number=genre_list.genre_number "
-					+ "inner join directed_list on movie.directed_number=directed_list.directed_number "
-					+ "inner join cast_list on movie.cast_number=cast_list.cast_number ";
-			PreparedStatement pstmt;
-			if (c.equals("全て")) {
-				sql += " where title_name like ? or directed_name like ? or cast_name like ?";
-				pstmt = conn.prepareStatement(sql);
-				pstmt.setString(1, q + "%");
-				pstmt.setString(2, q + "%");
-				pstmt.setString(3, q + "%");
-			} else if (c.equals("タイトル名")) {
-				sql += " where title_name like ?";
-				pstmt = conn.prepareStatement(sql);
-				pstmt.setString(1, q + "%");
-			} else if (c.equals("監督名")) {
-				sql += " where directed_name like ?";
-				pstmt = conn.prepareStatement(sql);
-				pstmt.setString(1, q + "%");
-			} else if (c.equals("主演名")) {
-				sql += " where cast_name like ?";
-				pstmt = conn.prepareStatement(sql);
-				pstmt.setString(1, q + "%");
-			} else {
-				throw new RuntimeException("選択が不正です");
-			}
-			pstmt.setMaxRows(50);
-			ResultSet rs = pstmt.executeQuery();
-			// 検索結果の取得
-			results = new ArrayList<TitleListResult>();
+スタイルシートを使っているjsp
+```
+<%@page import="movie.TitleListResult"%>
+<%@page contentType="text/html" pageEncoding="windows-31j"%>
+<%@page import="java.util.*"%>
+<!DOCTYPE html>
+<html xmlns="http://www.w3.org/1999/xhtml">
+<head>
+<meta name="keywords" content="映画　洋画　邦画">
+<meta http-equiv="content-language" content="ja">
+<meta http-equiv="content-type" content="text/html:charset=Shift_JIS">
+<meta http-equiv="content-style-type" content="text/css">
+<link href="./style.css" rel="stylesheet" type="text/css">
+<title>映画データベース</title>
+<meta name="keywords" content="映画">
+</head>
+<body background="img/kuro.jpg">
+	<h1 class="title">映画データベース</h1>
+	<form method="POST" action="Controller">
+		<input type="text" name="keyword" size="55"
+			placeholder="　キーワードを入力してください"> <input type="submit"
+			value="search"> <input type="search" name="category"
+			list="data1">
+		<datalist id="data1">
+			<option value="全て"></option>
+			<option value="タイトル名"></option>
+			<option value="監督名"></option>
+			<option value="主演名"></option>
+		</datalist>
+	</form>
+	<%
+		// サーブレットから渡された検索結果を取得する
+		ArrayList<TitleListResult> results = (ArrayList<TitleListResult>)request.getAttribute("results");
+	%>
+	<% if (results != null) { %>
+	<h2 class="naka">検索結果</h2>
+	<div id="kensaku">
+		<ul class="horizontal-list">
+		<% for (TitleListResult result : results) { %>
+			<li class="item">
+			<dl>
+				<dt>監督名</dt>
+				<dd><%= result.Get_directed_name() %></dd>
-			while (rs.next()) {
-				TitleListResult result = new TitleListResult();
-				result.Set_movie_name(rs.getString("title_name"));
-				result.Set_years_publication(rs.getString("years_publication"));
-				result.Set_performance_income(rs.getDouble("performance_income"));
-				result.Set_Production_cost(rs.getDouble("production_cost"));
-				result.Set_Public_evaluation(rs.getDouble("public_evaluation"));
-				result.Set_Screening_time(rs.getString("screening_time"));
-				result.Set_Genre_name(rs.getString("genre_name"));
-				result.Set_original_name(rs.getString("original_name"));
-				result.Set_cast_name(rs.getString("cast_name"));
-				result.Set_directed_name(rs.getString("directed_name"));
-				results.add(result);
-			}
-			// 切断
-			rs.close();
-			pstmt.close();
-			conn.close();
-		} catch (Exception ex) {
-			ex.printStackTrace();
-		}
-	}
-	public ArrayList<TitleListResult> getResults() {
-		return results;
-	}
-	public void setQ(String q) {
-		this.q = q;
-	}
-	public void setC(String c) {
-		this.c = c;
-	}
-}
-```
+				<dt>タイトル名</dt>
+				<dd><%= result.Get_movie_name() %></dd>
+				<dt>ジャンル</dt>
+				<dd><%= result.Get_Genre_name() %></dd>
+				<dt>原作</dt>
+				<dd><%= result.Get_original_name() %></dd>
+				<dt>主演</dt>
+				<dd><%= result.Get_cast_name() %></dd>
+				<dt>公開年</dt>
+				<dd><%= result.Get_years_publication() %></dd>
+				<dt>上映時間</dt>
+				<dd><%= result.Get_Screening_time() %></dd>
+				<dt>興行収入</dt>
+				<dd><%= result.Get_performance_income() %></dd>
+				<dt>制作費</dt>
+				<dd><%= result.Get_Production_cost() %></dd>
+				<dt>評価</dt>
+				<dd><%= result.Get_Public_evaluation() %></dd>
+			</dl>
+			</li>
+		<% } %>
+		</ul>
+	</div>
+	<% } %>
+</body>
+</htmt>
+```