質問編集履歴
1
追記
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -70,7 +70,7 @@
|
|
|
70
70
|
Apache Tomcat/8.0.20
|
|
71
71
|
```
|
|
72
72
|
|
|
73
|
-
###JSP
|
|
73
|
+
###JSP（追記）
|
|
74
74
|
```
|
|
75
75
|
<%@ page contentType="text/html; charset=UTF-8"
|
|
76
76
|
import="java.sql.*,javax.naming.*,javax.sql.*,java.text.*,java.util.Date,java.util.Calendar"%>
|
|
@@ -80,7 +80,7 @@
|
|
|
80
80
|
<sql:setDataSource var="db" driver="com.mysql.jdbc.Driver"
|
|
81
81
|
url="jdbc:mysql://localhost/Library" user="root" password="" />
|
|
82
82
|
<sql:query var="rs" dataSource="${db}">
|
|
83
|
-
SELECT book.book_no,book.book_name,book.note,genre.genre_name,
|
|
83
|
+
SELECT book.book_no,book.book_name,IF(book.note="" OR book.note IS NULL,"-", book.note),genre.genre_name,
|
|
84
84
|
lend.lend_date,book.state FROM book LEFT JOIN lend ON book.book_no = lend.book_no LEFT JOIN
|
|
85
85
|
user ON user.user_no = lend.user_no LEFT JOIN genre ON book.genre_no = genre.genre_no where book.delete_flg = 0
|
|
86
86
|
|
|
@@ -122,7 +122,7 @@
|
|
|
122
122
|
.lookup("java:comp/env/jdbc/Library");
|
|
123
123
|
con = ds.getConnection();
|
|
124
124
|
|
|
125
|
-
sql = "SELECT
|
|
125
|
+
sql = "SELECT * FROM book where book.delete_flg = 0";
|
|
126
126
|
|
|
127
127
|
ps = con.prepareStatement(sql);
|
|
128
128
|
|
|
@@ -199,14 +199,7 @@
|
|
|
199
199
|
<input type="hidden" name="user_edit" value=${row.book_no}>
|
|
200
200
|
<button class="button" type="submit">削除</button>
|
|
201
201
|
</form></td>
|
|
202
|
-
<td>
|
|
203
|
-
<%
|
|
204
|
-
String memo = gs.getString("note");
|
|
205
|
-
if (memo == null || memo.equals("")) {
|
|
206
|
-
memo = "-";
|
|
207
|
-
}
|
|
208
|
-
%><%=memo%>
|
|
209
|
-
</td>
|
|
202
|
+
<td>${row.note}</td>
|
|
210
203
|
</tr>
|
|
211
204
|
</c:forEach>
|
|
212
205
|
</table>
|
|
@@ -246,5 +239,4 @@
|
|
|
246
239
|
|
|
247
240
|
</body>
|
|
248
241
|
</html>
|
|
249
|
-
/
|
|
242
|
+
/
|
|
250
|
-
```
|