質問編集履歴
1
追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -142,7 +142,7 @@
|
|
|
142
142
|
|
|
143
143
|
|
|
144
144
|
|
|
145
|
-
###JSP
|
|
145
|
+
###JSP（追記）
|
|
146
146
|
|
|
147
147
|
```
|
|
148
148
|
|
|
@@ -162,7 +162,7 @@
|
|
|
162
162
|
|
|
163
163
|
<sql:query var="rs" dataSource="${db}">
|
|
164
164
|
|
|
165
|
-
SELECT book.book_no,book.book_name,book.note,genre.genre_name,
|
|
165
|
+
SELECT book.book_no,book.book_name,IF(book.note="" OR book.note IS NULL,"-", book.note),genre.genre_name,
|
|
166
166
|
|
|
167
167
|
lend.lend_date,book.state FROM book LEFT JOIN lend ON book.book_no = lend.book_no LEFT JOIN
|
|
168
168
|
|
|
@@ -246,7 +246,7 @@
|
|
|
246
246
|
|
|
247
247
|
|
|
248
248
|
|
|
249
|
-
sql = "SELECT
|
|
249
|
+
sql = "SELECT * FROM book where book.delete_flg = 0";
|
|
250
250
|
|
|
251
251
|
|
|
252
252
|
|
|
@@ -400,21 +400,7 @@
|
|
|
400
400
|
|
|
401
401
|
</form></td>
|
|
402
402
|
|
|
403
|
-
<td>
|
|
404
|
-
|
|
405
|
-
<%
|
|
406
|
-
|
|
407
|
-
String memo = gs.getString("note");
|
|
408
|
-
|
|
409
|
-
if (memo == null || memo.equals("")) {
|
|
410
|
-
|
|
411
|
-
memo = "-";
|
|
412
|
-
|
|
413
|
-
}
|
|
414
|
-
|
|
415
|
-
%><%=memo%>
|
|
416
|
-
|
|
417
|
-
</td>
|
|
403
|
+
<td>${row.note}</td>
|
|
418
404
|
|
|
419
405
|
</tr>
|
|
420
406
|
|
|
@@ -495,5 +481,3 @@
|
|
|
495
481
|
</html>
|
|
496
482
|
|
|
497
483
|
/
|
|
498
|
-
|
|
499
|
-
```
|