編集履歴

質問編集履歴

変更

2016/06/20 02:13

投稿

スコア38

test CHANGED Viewed

	@@ -1 +1 @@
1	- ~~henkou~~ java.lang.NullPointerExceptio
1	+ java.lang.NullPointerExceptio

test CHANGED Viewed

File without changes

変更

2016/06/20 02:12

投稿

l_l_l_l_l_l_l_l

スコア38

test CHANGED Viewed

	@@ -1 +1 @@
1	- JSP~~画面でエラーメッセージが表示されない~~
1	+ henkou java.lang.NullPointerExceptio

test CHANGED Viewed

@@ -1,12 +1,8 @@
 ###前提・実現したいこと
-ユーザの新規登録の際、入力欄に一つでも未入力の箇所ある場合
-エラーメッセージを表示させたいのですがされません。
+エラーが出てしまう
+重大: Servlet.service() for servlet [servlet.book_lend] in context with path [/Library] threw exception [java.lang.NullPointerException] with root cause
 ###JSP
@@ -14,7 +10,7 @@
 <%@ page contentType="text/html; charset=UTF-8"
-	import="java.sql.*,javax.naming.*,javax.sql.*,java.text.*"%>
+import="java.sql.*,javax.naming.*,javax.sql.*,java.text.*,java.util.Date,java.util.Calendar"%>
 <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
@@ -22,69 +18,289 @@
+<html>
 <sql:setDataSource var="db" driver="com.mysql.jdbc.Driver"
 	url="jdbc:mysql://localhost/Library" user="root" password="" />
+<sql:query var="rs" dataSource="${db}">
+  SELECT book.book_no,book.book_name,book.state,genre.genre_no,genre.genre_name,user.user_no,user.user_id,
+  lend.lend_date,lend.return_date  FROM book  LEFT JOIN lend ON book.book_no = lend.book_no LEFT JOIN
+  user ON user.user_no = lend.user_no LEFT JOIN genre ON book.genre_no = genre.genre_no
+  <c:if test="${!empty param['genreNo']}">
+  	where book.genre_no = ?
+  	<sql:param value="${param['genreNo']}" />
+  	  ORDER BY book.book_no asc;
-<html>
+  </c:if>
+</sql:query>
+<sql:query var="rs1" dataSource="${db}">
+	select * from genre
+</sql:query>
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 <head>
-<link rel="stylesheet" type="text/css" href="css/Library.css">
 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<link rel="stylesheet" type="text/css" href="css/Lending.css">
-<title>新規ユーザ登録画面</title>
+<title>書籍貸出画面</title>
 </head>
 <body>
-	<h2>新規ユーザ登録画面</h2>
-	<form method="POST" action="newuser_tsuika">
-		<h3>新規ユーザ追加</h3>
-		名前（姓） <input type="text" name="first_name" size="30" >
-		名前（名） <input type="text" name="last_name" size="30"> <br>
-		カナ（姓） <input type="text" name="first_name_kana" size="30">
-		カナ（名） <input type="text" name="last_name_kana" size="30"> <br>
-		ID <input type="text" name="user_id" size="30">
-		パスワード <input type="password" name="password" size="30"> <br> <br>
-		<!-- <input name="admin" type="radio" value="0"></input> --> <input
-			style="color: white; background-color: D57200;" type="submit"
-			value="登録" />
+<h2>書籍貸出画面</h2>
+<br>
+<form method="POST" action="book_lend.jsp">
+  <p>
+		ジャンル
+		<select name="genreNo">
+			<option value="">全て</option>
+			<c:forEach var="row" items="${rs1.rows}">
+				<option value=${row.genre_no}>${row.genre_name}</option>
+			</c:forEach>
+		</select>
+	</p>
+<INPUT style="color:white;
+ 	background-color:D57200;" type="submit" value="絞り込む" />
+</form>
+<br>
+<table border="1">
+<tr>
+<th>ID</th>
+<th>書籍名</th>
+<th>ジャンル</th>
+<th>貸出日</th>
+<th>返却予定日</th>
+<th>状態</th>
+<th>貸出/返却</th>
+<th>貸りた人</th>
+</tr>
+<c:forEach var="row" items="${rs.rows}">
+<tr>
+<td>${row.book_no}</td>
+<td>${row.book_name}</td>
+<td>${row.genre_name}</td>
+<td>
+<c:if test="${empty row.lend_date}">-</c:if>
+	${row.lend_date }
+</td>
+<td>
+<c:if test="${empty row.lend_date}">-</c:if>
+	${row.return_date }
+</td>
+<td>
+	<c:if test="${row.state == 2}" >
+		<span class="fontRed">貸出不可</span>
+	</c:if>
+	<c:if test="${row.state == 1 }">
+		<c:if test="${empty row.lend_date}">
+			貸出可能
+		</c:if>
+		<c:if test="${!empty row.lend_date}">
+			<c:set var= "today" value="<%=new Date()%>"/>
+			<c:if test="${today > row.return_date}">
+				返却遅延
+			</c:if>
+			<c:if test="${today <= row.return_date}">
+				貸出中
+			</c:if>
+		</c:if>
+	</c:if>
+</td>
+<td>
+	<c:if test="${empty row.lend_date}">
+	<c:if test="${row.state == 2}">-</c:if>
+	<c:if test="${row.state == 1}">
+		<form method="POST" action="book_lend">
+			<input type="hidden" value="${row.book_no}" name="book_no">
+			<input type="hidden" value="${row.genre_no}" name="genre_no">
+			<INPUT style="color:white;
+ 	background-color:D57200; width:60px; height:40px;" type="submit" value="貸出" />
+		</form>
+	</c:if>
+	</c:if>
+<c:if test="${!empty row.lend_date}">
+	<form method="GET" action="book_lend">
+		<input type="hidden" value=${row.book_no} name="book_no" />
+		<INPUT style="color:white;
+ 	background-color:AFD170; width:60px; height:40px;" type="submit" value="返却" />
 	</form>
+</c:if>
+</td>
+<td>
+<c:if test="${!empty row.lend_date}">
+<option value=${row.user_no}>${row.user_id}</option>
+</c:if>
+</td>
+</c:forEach>
+</table>
-	<br>
+<br>
-	<form action="Login.jsp">
+<form action="kanri_mypage.jsp">
+<input style="color:white;
-		<input style="color: white; background-color: D57200;" type="submit"
+ 	background-color:D57200;"  type="submit" name="mypage" value="TOPページ">
-			name="reset" value="戻る">
-	</form>
+</form>
 </body>
@@ -124,161 +340,233 @@
 import javax.servlet.http.HttpServletResponse;
+import javax.servlet.http.HttpSession;
 import javax.sql.DataSource;
-@WebServlet("/newuser_tsuika")
+@WebServlet("/book_lend")
-public class newuser_tsuika extends HttpServlet {
+public class book_lend extends HttpServlet {
 	private static final long serialVersionUID = 1L;
-	protected void doPost(HttpServletRequest request,
-			HttpServletResponse response) throws ServletException, IOException {
+	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException,
+	IOException {
 		request.setCharacterEncoding("UTF-8");
+		String bookNo = request.getParameter("book_no");
+		HttpSession session = request.getSession();
+		Boolean userResult = (Boolean) session.getAttribute("userResult");
-		Connection con = null;
+			Connection con = null;
-		PreparedStatement ps = null;
+			PreparedStatement ps = null;
-		String sql = null;
+			String sql = null;
-		ResultSet rs = null;
+			ResultSet rs = null;
-		if (request.getParameter("first_name").equals("")
-				|| request.getParameter("last_name").equals("")
-				|| request.getParameter("first_name_kana").equals("")
-				|| request.getParameter("last_name_kana").equals("")
-				|| request.getParameter("user_id").equals("")
-				|| request.getParameter("password").equals("")) {
-			request.setAttribute("first_name",
+			if(session.getAttribute("userResult")!=null) {
-					request.getParameter("first_name"));
-			request.setAttribute("last_name", request.getParameter("last_name"));
-			request.setAttribute("first_name_kana",
-					request.getParameter("first_name_kanae"));
-			request.setAttribute("last_name_kana",
+	            userResult = (boolean)session.getAttribute("userResult");
-					request.getParameter("last_name_kana"));
-			request.setAttribute("user_id", request.getParameter("user_id"));
-			request.setAttribute("password", request.getParameter("password"));
-			request.setAttribute("errorMessage", "未入力項目があります");
-			// ログイン画面遷移
+	    	}
-			this.getServletContext().getRequestDispatcher("/shinki.jsp")
-					.forward(request, response);
+	        if(userResult) {
-		} else {
-			try {
+			try{
-				// データベースの接続を確立
 				InitialContext initContext = new InitialContext();
-				DataSource ds = (DataSource) initContext
-						.lookup("java:comp/env/jdbc/Library");
+				DataSource ds = (DataSource) initContext.lookup("java:comp/env/jdbc/Library");
 				con = ds.getConnection();
-				// SQL
-				sql = "INSERT INTO user (first_name,last_name,first_name_kana,last_name_kana,user_id,password,admin)"
-						+ "VALUES (?,?,?,?,?,?,0)";
+				sql = "delete from lend where book_no = ?";
-				// UPDATE命令の準備
 				ps = con.prepareStatement(sql);
-				// UPDATE命令にポストデータの内容をセット
-				ps.setString(1, request.getParameter("first_name"));
-				ps.setString(2, request.getParameter("last_name"));
-				ps.setString(3, request.getParameter("first_name_kana"));
-				ps.setString(4, request.getParameter("last_name_kana"));
-				ps.setString(5, request.getParameter("user_id"));
-				ps.setString(6, request.getParameter("password"));
+				ps.setString(1, bookNo);
-				// UPDATE命令を実行
 				ps.executeUpdate();
-				// UPDATE命令後の画面遷移
-				this.getServletContext().getRequestDispatcher("/shinki.jsp")
-						.forward(request, response);
-			} catch (Exception e) {
+			}catch(Exception e){
 				throw new ServletException(e);
-			} finally {
+			}finally{
-				try {
+				try{
-					if (rs != null) {
+					if(rs != null){
 						rs.close();
 					}
+					if(con != null){
+						con.close();
+					}
-					if (ps != null) {
+					if(ps != null){
 						ps.close();
 					}
+				}catch(Exception e){
+				}
+				this.getServletContext().getRequestDispatcher("/book_lend.jsp").forward(request, response);
+			}
+		}
+	}
+	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
+		request.setCharacterEncoding("UTF-8");
+		String genreNo = request.getParameter("genre_no");
+		String bookNo = request.getParameter("book_no");
+		HttpSession session = request.getSession();
+		Boolean userResult = false;
+			Connection con = null;
+			PreparedStatement ps = null;
+			String sql = null;
+			ResultSet rs = null;
+			if(session.getAttribute("userResult")!=null) {
+	            userResult = (boolean)session.getAttribute("userResult");
+	    	}
+	        if(userResult) {
+				try{
+					InitialContext initContext = new InitialContext();
+					DataSource ds = (DataSource) initContext.lookup("java:comp/env/jdbc/Library");
+					con = ds.getConnection();
+					sql = "insert into lend (user_no,book_no,lend_date,return_date,genre_no) values (?,?,cast(now() as date) ,cast((now() + interval 6 day) as date),?)";
+					ps = con.prepareStatement(sql);
+					Integer a =(Integer)session.getAttribute("user_no");
+					ps.setInt(1, a);
+					ps.setString(2, bookNo);
+					ps.setString(3, genreNo);
+					ps.executeUpdate();
+				}catch(Exception e){
+					throw new ServletException(e);
+				}finally{
+					try{
+						if(rs != null){
+							rs.close();
+						}
-					if (con != null) {
+						if(con != null){
-						con.close();
+							con.close();
+						}
+						if(ps != null){
+							ps.close();
+						}
+					}catch(Exception e){
 					}
-				} catch (Exception e) {
+					this.getServletContext().getRequestDispatcher("/book_lend.jsp").forward(request, response);
 				}
@@ -286,13 +574,7 @@
-		}
+	        }
-	}
 }