編集履歴

質問編集履歴

CheckからhiddenでFinishにformの内容を送れるように。Mapperにメソッドを作りました。

2019/10/27 07:32

投稿

mimi_129

スコア63

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -108,6 +108,12 @@
 <%
+request.setCharacterEncoding("UTF-8");
 PostMaster pm = new PostMaster();
@@ -116,6 +122,8 @@
 pm.setHonbun(request.getParameter("honbun"));
 %>
 <!DOCTYPE html>
@@ -128,7 +136,7 @@
     <link rel="stylesheet" href="../../css/stylesheet.css" type="text/css">
-    <title>タイトル</title>
+    <title>投稿確認｜ペット移動トリミングサイト</title>
 </head>
@@ -152,9 +160,141 @@
         <div id="content">
+				<ul>
+					<li>【タイトル】</li>
+					<li>
+						<%
+							out.println(pm.getTitle());
+						%>
+					</li>
+					<li>【本文】</li>
+					<li>
+						<%
+							out.println(pm.getHonbun());
+						%>
+					</li>
+				</ul>
 			<form method="POST" action="post_finish.jsp">
+				<input type="hidden" name="title" value="<% pm.getTitle(); %>">
+				<input type="hidden" name="honbun" value="<% pm.getHonbun(); %>">
+				<input type="submit" value="送信">
+			</form>
+		</div>
+        <div id="side"></div>
+        <div id="footer">
+    </div>
+</div>
+</body>
+</html>
+```
+POST_FINISH
+```Java
+<%@ page language="java" contentType="text/html; charset=UTF-8"
+    pageEncoding="UTF-8"%>
+<%@ page import="model.PostMaster" %>
+<%@ page import="model.PostMasterMapper" %>
+<%
+request.setCharacterEncoding("UTF-8");
+PostMaster pm = new PostMaster();
+pm.setTitle(request.getParameter("title"));
+pm.setHonbun(request.getParameter("honbun"));
+PostMasterMapper pmm = new PostMasterMapper();
+pmm.addSQL();
+%>
+<!DOCTYPE html>
+<html lang="en">
+<head>
+    <meta charset="UTF-8">
+    <link rel="stylesheet" href="../../css/stylesheet.css" type="text/css">
+    <title>投稿完了｜ペット移動トリミングサイト</title>
+</head>
+<body>
+    <div id="main">
+        <div id="header">
+            <p><a href="../index.jsp">ロゴ</a>
-				<ul>
+            <ul>
+                <li>投稿画面へ</li>
+                <li>業者検索</li>
+            </ul>
+        </div>
+        <div id="content">
+        	<p>投稿が完了しました</p>
+        		<ul>
 					<li>【タイトル】</li>
@@ -182,11 +322,9 @@
 				</ul>
-				<input type="submit" value="送信">
+        	<p><a href="../index.jsp">TOPに戻る</a></p>
-			</form>
-		</div>
+        </div>
         <div id="side"></div>
@@ -204,87 +342,69 @@
-POST_FINISH
+POST_MASTER
 ```Java
-<%@ page language="java" contentType="text/html; charset=UTF-8"
-    pageEncoding="UTF-8"%>
-<%@ page import="model.PostMaster" %>
-<%@ page import="model.PostMasterMapper" %>
-<%
-PostMasterMapper pmm = new PostMasterMapper();
-%>
-<!DOCTYPE html>
-<html lang="en">
-<head>
-    <meta charset="UTF-8">
-    <link rel="stylesheet" href="../../css/stylesheet.css" type="text/css">
-    <title>タイトル</title>
-</head>
-<body>
-    <div id="main">
-        <div id="header">
-            <p><a href="../index.jsp">ロゴ</a>
-            <ul>
-                <li>投稿</li>
-                <li>検索</li>
-            </ul>
-        </div>
-        <div id="content">
-        	<p>投稿が完了しました</p>
-        	<p><a href="../index.jsp">TOPに戻る</a></p>
-        </div>
-        <div id="side"></div>
-        <div id="footer">
-    </div>
-</div>
-</body>
-</html>
-```
-POST_MASTER
+package model;
+public class PostMaster {
+	// フィールド
+	private String title;
+	private String honbun;
+	// アクセサー
+	public String getTitle() {
+		return title;
+	}
+	public void setTitle(String title) {
+		this.title = title;
+	}
+	public String getHonbun() {
+		return honbun;
+	}
+	public void setHonbun(String honbun) {
+		this.honbun = honbun;
+	}
+}
+```
+POST_MASTERMAPPER
 ```Java
@@ -292,75 +412,13 @@
-public class PostMaster {
-	// フィールド
-	private String title;
-	private String honbun;
-	// アクセサー
-	public String getTitle() {
-		return title;
-	}
-	public void setTitle(String title) {
-		this.title = title;
-	}
-	public String getHonbun() {
-		return honbun;
-	}
-	public void setHonbun(String honbun) {
-		this.honbun = honbun;
-	}
-}
-```
-POST_MASTERMAPPER
-```Java
-package model;
 import java.sql.Connection;
 import java.sql.DriverManager;
 import java.sql.PreparedStatement;
-import java.sql.Statement;
+import java.sql.SQLException;
@@ -368,57 +426,107 @@
-	public static void main(String[] args) {
+	public int addSQL() throws SQLException {
 		try {
+			//変数定義
+	        Connection conn = null;
+	        PreparedStatement ps = null;
-            new PostMasterMapper().execute();
+	        PostMaster pm = new PostMaster();
+			final String URL = "jdbc:mysql://localhost:8880/petidotriming";
+			final String USERNAME = "root";
+			final String PASSWORD = "kimitunagi5emu";
+			String sql = "INSERT INTO postmaster values(?, ?)";
+            //JDBCドライバをロードする
+            Class.forName("oracle.jdbc.driver.OracleDriver");
+            //DBへのコネクションを作成する
+            conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
+            conn.setAutoCommit(false);  //オートコミットはオフ
+            //実行するSQL文とパラメータを指定する
+            ps = conn.prepareStatement(sql);
+            ps.setString(1, "タイトルです");
+            ps.setString(2, "本文です");
+            //INSERT文を実行する
+            int i = ps.executeUpdate();
+            //処理件数を表示する
+            System.out.println("結果：" + i);
+            //コミット
+            conn.commit();
+            //クローズ処理
+            if (ps != null) ps.close();
+            if (conn != null) conn.close();
+            return i;
-        }catch(Exception e) {
+        } catch (Exception ex) {
+            //例外発生時の処理
-            e.printStackTrace();
+            ex.printStackTrace();  //エラー内容をコンソールに出力する
+            return 2;
+        } finally {
         }
-	}
-	public void execute() throws Exception {
-	PostMaster pm = new PostMaster();
-	final String URL = "jdbc:mysql://localhost:8880/XXX";
-	final String USERNAME = "XXX";
-	final String PASSWORD = "XXX";
-	Connection conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
-	Statement statement = conn.createStatement();
-	String sql = "INSERT INTO postmaster (title, honbun) VALUES (?, ?)";
-	PreparedStatement pstmt = conn.prepareStatement(sql);
-	pstmt.setString(1, pm.getTitle());
-	pstmt.setString(2, pm.getHonbun());
-	int num = pstmt.executeUpdate();
@@ -426,4 +534,6 @@
-```
+```

修正

2019/10/27 07:32

投稿

mimi_129

スコア63

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -128,7 +128,7 @@
     <link rel="stylesheet" href="../../css/stylesheet.css" type="text/css">
-    <title>投稿確認｜ペット移動トリミングサイト</title>
+    <title>タイトル</title>
 </head>