現在、Eclipseで作成中のjavaプログラムがエラーで実行できません。正しく直して頂けたら、ありがたいです。回答よろしくお願いします。
(仕様)
ブラウザ上では、入力画面→確認画面→最終画面の順でページ移動する。
入力した情報は確認画面でOKを押した後、データベースに保存される。
詳細は下の画像の通りです。
※●はエクリプス上で警告、または波線がひかれている行です。
lang
1\(Input\.java\) 2 3protected void doGet\(HttpServletRequest request, HttpServletResponse response\) throws ServletException, IOException { 4 // TODO Auto-generated method stub 5 6 request\.setCharacterEncoding\("UTF-8"\); 7 8 String str_name = request\.getParameter\("minintei_name"\); 9 String str_sei = request\.getParameter\("minintei_sei"\); 10 String str_sentaku = request\.getParameter\("minintei_sentaku"\); 11 12 HttpSession session = request\.getSession\(\); 13 14 session\.setAttribute\("s_name",str_name\); 15 session\.setAttribute\("s_sei",str_sei\); 16 session\.setAttribute\("s_sentaku",str_sentaku\); 17 18 request\.setAttribute\("minintei_name",str_name\); 19 request\.setAttribute\("minintei_sei",str_sei\); 20 request\.setAttribute\("minintei_sentaku",str_sentaku\); 21 22 RequestDispatcher dis = request\.getRequestDispatcher\("Check\.jsp"\); 23 dis\.forward\(request, response\); 24 }
lang
1\(Insert\.java\) 2 3protected void doGet\(HttpServletRequest request, HttpServletResponse response\) throws ServletException, IOException { 4 // TODO Auto-generated method stub 5 HttpSession session = request\.getSession\(\); 6 String str_name = \(String\)session\.getAttribute\("s_name"\); 7 String str_sei = \(String\)session\.getAttribute\("s_sei"\); 8 String str_sentaku = \(String\)session\.getAttribute\("s_sentaku"\); 9 10 try{ 11 Class\.forName\("com\.mysql\.jdbc\.Driver"\); 12 13 Connection con= DriverManager\.getConnection\("jdbc:mysql://127\.0\.0\.1:3306/jv16", "root", ""\); 14 Statement st=con\.createStatement\(\); 15 16 String sql ="INSERT INTO minintei VALUES\('"\+str_name\+"','"\+str_sei\+"','"\+str_sentaku\+"'\)"; 17 st\.executeUpdate\(sql\); 18 19 ResultSet all=st\.executeQuery\("select \* from minintei"\); 20 21 ArrayList<minintei> alls=new ArrayList<minintei>\(\); 22 while\(all\.next\(\)\){ 23 minintei std=new minintei\(\); 24● std\.setMinintei_name\(all\.getInt\("minintei_name"\)\); 25● std\.setMinintei_sei\(all\.getString\("minintei_sei"\)\); 26 std\.setMinintei_sentaku\(all\.getInt\("minintei_sentaku"\)\); 27 alls\.add\(std\); 28 } 29 all\.close\(\); 30 st\.close\(\); 31 con\.close\(\); 32 33 request\.setAttribute\("all",alls\); 34 RequestDispatcher dis=request\.getRequestDispatcher\("kekka\.jsp"\); 35 36 dis\.forward\(request, response\); 37 38 }catch\(ClassNotFoundException e\){ 39 System\.out\.println\("JDBCドライバーエラー"\); 40 }catch\(SQLException e\){ 41 System\.out\.println\("SQLエラー"\); 42 } 43 }
lang
1\(minintei\.java\) 2 3package test; 4 5public class minintei { 6 7String minintei_name; 8int minintei_sei; 9int minintei_sentaku; 10 11public void setMinintei_no\(String minintei_name\){ 12 this\.minintei_name=minintei_name; 13} 14public void setMinintei_sei\(String minintei_sei\){ 15● this\.minintei_sei=minintei_sei; 16} 17public void setMinintei_sentaku\(int minintei_sentaku\){ 18 this\.minintei_sentaku=minintei_sentaku; 19} 20public String getMinintei_name\(\){ 21 return minintei_name; 22} 23public String getMinintei_sei\(\){ 24● return minintei_sei; 25} 26public int getMinintei_sentaku\(\){ 27 return minintei_sentaku; 28} 29}
lang
1\(Check\.jsp\) 2 3\(<%@ page language="java" contentType="text/html; charset=UTF-8" 4 pageEncoding="UTF-8"%> 5<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4\.01 Transitional//EN" "http://www\.w3\.org/TR/html4/loose\.dtd"> 6<html> 7<head> 8<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 9<title>Insert title here</title> 10</head> 11<body> 12 13<% 14● String str_name_kakunin = \(String\)request\.getAttribute\("minintei_name"\); 15● String str_sei_kakunin = \(String\)request\.getAttribute\("minintei_sei"\); 16● String str_sentaku_kakunin = \(String\)request\.getAttribute\("minintei_sentaku"\); 17%> 18<form action="\./Insert"> 19<table> 20 <tr> 21 <td colspan="2">確認画面</td> 22 </tr> 23 24 <tr> 25 <td>氏名</td> 26 <td><% out\.println\(str_name_kakunin\); %></td> 27 </tr> 28 29 <tr> 30 <td>性別</td> 31 <td><% out\.println\(str_sei_kakunin\); %></td> 32 </tr> 33 34 <tr> 35 <td>勉強好きですか</td> 36 <td><% out\.println\(str_sentaku_kakunin\); %></td> 37 </tr> 38 39 <tr> 40 <td><input type="submit" value="登録"name="btn"></td> 41 </tr> 42</table> 43</form> 44</body> 45</html>\)
lang
1\(Minintei_input\.jsp\) 2 3<%@ page language="java" contentType="text/html; charset=UTF-8" 4 pageEncoding="UTF-8"%> 5<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4\.01 Transitional//EN" "http://www\.w3\.org/TR/html4/loose\.dtd"> 6<html> 7<head> 8<script type="text/javascript"> 9function check\(\){ 10 var name = document\.getElementById\("minintei_name"\)\.value; 11 var sei = document\.getElementById\("minintei_sei"\)\.value; 12 var sentaku = document\.getElementById\("minintei_sentaku"\)\.value; 13 if \( \(name == ""\)||\(sei == ""\)||\(sentaku == ""\) \) { 14 document\.getElementById\("e_msg"\)\.innerHTML="未入力項目があります"; 15 return false; 16 }; 17} 18</script> 19 20</head> 21<body> 22<form action="Input" onSubmit="return check\(\);"> 23 <table> 24 <tr> 25 <td colspan="2"><span id="e_msg"></span></td> 26 </tr> 27 28 <tr> 29 <th>氏名</th> 30 <td><input type="text" id="minintei_name" name="minintei_name"></td> 31 </tr> 32 33 <tr> 34 <th>性別</th> 35 <td><input type="text" id="minintei_sei" name="minintei_sei"></td> 36 </tr> 37 38 <tr> 39 <th>勉強好きですか</th> 40 <td><input type="radio" id="minintei_sentaku 41 " name="minintei_sentaku" value="1">YES 42 <input type="radio" id="minintei_sentaku" name="minintei_sentaku" value="2">NO 43 </td> 44 </tr> 45 46 <tr> 47 <td> </td> 48 <td><input type="submit" value="登録"></td> 49 </tr> 50 </table> 51 52</form> 53</body> 54</html>
lang
1\(kekka\.jsp\) 2 3<%@ page import="java\.util\.ArrayList" 4 import="test\.item" %> 5<%@ page language="java" contentType="text/html; charset=UTF-8" 6 pageEncoding="UTF-8"%> 7<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4\.01 Transitional//EN" "http://www\.w3\.org/TR/html4/loose\.dtd"> 8<html> 9<head> 10<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 11<title>Insert title here</title> 12</head> 13<body> 14</head> 15<body> 16<%-- テーブル作成 --%> 17<table border="1" cellspacing="0"> 18<tr> 19<th>氏名</th> 20<th>性別</th> 21<th>勉強好きですか</th> 22</tr> 23 24<% 25● ArrayList<minintei> 26●mininteis=\(ArrayList<minintei>\)request\.getAttribute\("all"\); 27● for\(int i=0;i<mininteis\.size\(\);i\+\+\){ 28● minintei minintei = mininteis\.get\(i\); 29 out\.println\("<tr>"\); 30 out\.println\("<td>"\+minintei\.getMinintei_name\(\)\+"</td>"\); 31 out\.println\("<td>"\+minintei\.getMinintei_sei\(\)\+"</td>"\); 32 out\.println\("<td>"\+minintei\.getMinintei_sentaku\(\)\+"</td>"\); 33 out\.println\("</tr>"\); 34 } 35%> 36</table> 37 38</body> 39</html>
また、データベースで CREATE TABLE minintei(minintei_name VARCHAR(10),minintei_sei VARCHAR(2),minintei_sentaku int);
で実行するとエラーが返ってくるのですが、どうすれば実行できますか。
![イメージ説明]WIDTH:600