質問編集履歴

追記

2016/06/21 01:56

投稿

l_l_l_l_l_l_l_l

スコア38

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -298,7 +298,7 @@
 ###追記
-javaファイルを下記のしたところ下記のエラーが出てしまいました
+javaファイルを変更しましたら下記のエラーが出てしまいました

追記

2016/06/21 01:56

投稿

l_l_l_l_l_l_l_l

スコア38

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -92,458 +92,294 @@
 ```
-###jsp
+###servlet
 ```
-<%@ page contentType="text/html; charset=UTF-8"
-import="java.sql.*,javax.naming.*,javax.sql.*,java.text.*"%>
-<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
-<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
-<html>
-<sql:setDataSource var="db" driver="com.mysql.jdbc.Driver"
-	url="jdbc:mysql://localhost/Library" user="root" password="" />
-<sql:query var="rs1" dataSource="${db}">
-	select * from user
-</sql:query>
-<head>
-<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
-<title>ユーザ管理画面</title>
-</head>
-<body>
-<h2>ユーザー管理画面</h2>
-<form method="POST" action="user_edit">
-ユーザーID
-	<select name="user_no">
-		<c:forEach var="row" items="${rs1.rows}">
-		<option value=${row.user_no}>${row.user_id}</option>
-		</c:forEach>
-	</select>
-	<br>
-名前（姓）
-<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 style="color:white;
- 	background-color:D57200;" type="submit" value="更新"/>
-</form>
-	<c:if test="${!empty requestScope['errorMessage']}">
-		<div>${requestScope['errorMessage']}</div>
-	</c:if>
-<h3>ユーザリスト</h3>
-<table border="1" width=70%>
-<tr>
-<th>ユーザNo</th>
-<th>名前（姓）</th>
-<th>名前（名）</th>
-<th>カナ（姓）</th>
-<th>カナ（名）</th>
-<th>ID</th>
-<th>パスワード</th>
-</tr>
-<%
-Connection con = null;
-PreparedStatement ps = null;
-String sql = null;
-ResultSet rs = null;
-try{
-	InitialContext initContext = new InitialContext();
-	DataSource ds = (DataSource) initContext.lookup("java:comp/env/jdbc/Library");
-	con = ds.getConnection();
-sql = "SELECT user_no,first_name,last_name,first_name_kana,last_name_kana,user_id,password FROM user";
-// SELECT命令の準備
-ps = con.prepareStatement(sql);
-// UPDATE命令を実行
-rs = ps.executeQuery();
-// 結果セットの内容を順に出力
-while(rs.next()){
-%>
-<tr>
-<td height=70><%=rs.getString("user_no") %></td>
-<td height=70><%=rs.getString("first_name") %></td>
-<td height=70><%=rs.getString("last_name") %></td>
-<td height=70><%=rs.getString("first_name_kana") %></td>
-<td height=70><%=rs.getString("last_name_kana") %></td>
-<td height=70><%=rs.getString("user_id") %></td>
-<td height=70><%=rs.getString("password") %></td>
-<%
+package servlet;
+import java.io.IOException;
+import java.sql.Connection;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import javax.naming.InitialContext;
+import javax.servlet.ServletException;
+import javax.servlet.annotation.WebServlet;
+import javax.servlet.http.HttpServlet;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+import javax.servlet.http.HttpSession;
+import javax.sql.DataSource;
+@WebServlet("/user_edit")
+public class user_edit extends HttpServlet {
+	private static final long serialVersionUID = 1L;
+	protected void doPost(HttpServletRequest request,
+			HttpServletResponse response) throws ServletException, IOException {
+		request.setCharacterEncoding("UTF-8");
+		String userId = request.getParameter("user_id");
+		Connection con = null;
+		PreparedStatement ps = null;
+		String sql = null;
+		ResultSet rs = null;
+		// セッションを取得する
+		HttpSession session = request.getSession();
+		// 変数の初期化
+		boolean userResult = false;
+		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 = "UPDATE user SET (first_name,last_name,first_name_kana,last_name_kana,user_id,password)=(?,?,?,?,?,?) WHERE user_id=?";
+				// 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(7, userId);
+				// UPDATE命令を実行
+				ps.executeUpdate();
+				// UPDATE命令後の画面遷移
+				this.getServletContext().getRequestDispatcher("/user_edit.jsp")
+						.forward(request, response);
+			} catch (Exception e) {
+				throw new ServletException(e);
+			} finally {
+				try {
+					if (rs != null) {
+						rs.close();
+					}
+					if (ps != null) {
+						ps.close();
+					}
+					if (con != null) {
+						con.close();
+					}
+				} catch (Exception e) {
+				}
+			}
+		} else {
+			// エラーメッセージをリクエスト格納
+			request.setAttribute("errorMessage", "ログインが行われていません。");
+			// ログイン画面遷移
+			this.getServletContext().getRequestDispatcher("/Login.jsp")
+					.forward(request, response);
+		}
+	}
 }
-}catch(Exception e){
-	throw new ServletException(e);
-}finally{
-	try{
-		if(rs != null){rs.close();}
-		if(rs != null){ps.close();}
-		if(rs != null){con.close();}
-	}catch(Exception e){}
-	}
-%>
-</table>
-<form  action="kanri_mypage.jsp">
-<input style="color:white;
- 	background-color:D57200;"  type="submit"  value="TOPページ">
-</form>
-<form  action="user_kanri.jsp">
-<input style="color:white;
- 	background-color:D57200;"  type="submit" value="戻る">
-</form>
-</body>
-</html>
 ```
-###servlet
-```
-package servlet;
-import java.io.IOException;
-import java.sql.Connection;
-import java.sql.PreparedStatement;
-import java.sql.ResultSet;
-import javax.naming.InitialContext;
-import javax.servlet.ServletException;
-import javax.servlet.annotation.WebServlet;
-import javax.servlet.http.HttpServlet;
-import javax.servlet.http.HttpServletRequest;
-import javax.servlet.http.HttpServletResponse;
-import javax.servlet.http.HttpSession;
-import javax.sql.DataSource;
-@WebServlet("/user_edit")
-public class user_edit extends HttpServlet {
-	private static final long serialVersionUID = 1L;
-	protected void doPost(HttpServletRequest request,
-			HttpServletResponse response) throws ServletException, IOException {
-		request.setCharacterEncoding("UTF-8");
-		Connection con = null;
-		PreparedStatement ps = null;
-		String sql = null;
-		ResultSet rs = null;
-		// セッションを取得する
-		HttpSession session = request.getSession();
-		// 変数の初期化
-		boolean userResult = false;
-		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
-				sql = "UPDATE user SET (first_name,last_name,first_name_kana,last_name_kana,"
-						+ "user_id,password)=(?,?,?,?,?,?) WHERE user_id=?";
-				// 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"));
-				// UPDATE命令を実行
-				ps.executeUpdate();
-				// UPDATE命令後の画面遷移
-				this.getServletContext().getRequestDispatcher("/user_edit.jsp")
-						.forward(request, response);
-			} catch (Exception e) {
-				throw new ServletException(e);
-			} finally {
-				try {
-					if (rs != null) {
-						rs.close();
-					}
-					if (ps != null) {
-						ps.close();
-					}
-					if (con != null) {
-						con.close();
-					}
-				} catch (Exception e) {
-				}
-			}
-		} else {
-			// エラーメッセージをリクエスト格納
-			request.setAttribute("errorMessage", "ログインが行われていません。");
-			// ログイン画面遷移
-			this.getServletContext().getRequestDispatcher("/Login.jsp")
-					.forward(request, response);
-		}
-	}
-}
-```
+###追記
+javaファイルを下記のしたところ下記のエラーが出てしまいました
+↓   ↓   ↓   ↓   ↓
+HTTPステータス 500 - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(first_name,last_name,first_name_kana,last_name_kana,user_id,password)=('aa','aa' at line 1
+type 例外レポート
+メッセージ com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(first_name,last_name,first_name_kana,last_name_kana,user_id,password)=('aa','aa' at line 1
+説明 The server encountered an internal error that prevented it from fulfilling this request.
+例外
+javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(first_name,last_name,first_name_kana,last_name_kana,user_id,password)=('aa','aa' at line 1
+	servlet.user_edit.doPost(user_edit.java:69)
+	javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
+	javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
+	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
+原因
+com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(first_name,last_name,first_name_kana,last_name_kana,user_id,password)=('aa','aa' at line 1
+	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
+	sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
+	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
+	java.lang.reflect.Constructor.newInstance(Constructor.java:422)
+	com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
+	com.mysql.jdbc.Util.getInstance(Util.java:387)
+	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942)
+	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
+	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
+	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
+	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
+	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
+	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
+	com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
+	com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
+	com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5098)
+	com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
+	org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:97)
+	org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:97)
+	servlet.user_edit.doPost(user_edit.java:62)
+	javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
+	javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
+	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)