1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 | <%@ page language="java" contentType="text/html; charset=BIG5" pageEncoding="BIG5"%> <html> <head> <meta http-equiv='Content-Language' content='zh-tw'> <meta http-equiv='Content-Type' content='text/html; charset=big5'> <title>2012畢業旅行投票資料(ex-confirm)</title> </head> <% //將表單元件的值轉成jsp變數 request.setCharacterEncoding("Big5"); String Var1 = request.getParameter("SID"); String Var2 = request.getParameter("SName"); String Var3 = request.getParameter("SCode"); String Var4 = request.getParameter("SLoc"); String Var5 = request.getParameter("SComment"); %> <body> <p>2010生姿畢業旅行投票-確認投票</p> <form method='post' action='ex-save.jsp'> <table border='1' width='100%' id='table1'> <tr> <td align=right width=200>學號</td> <td><input type='hidden' name='SID' value='<%= Var1 %>'><%= Var1 %></td> </tr> <tr> <td align=right width=200>姓名</td> <td><input type='hidden' name='SName' value='<%= Var2 %>'><%= Var2 %></td> </tr> <tr> <td align=right width=200>身份證末四碼</td> <td><input type='hidden' name='SCode' value='<%= Var3 %>'><%= Var3 %></td> </tr> <tr> <td align=right width=200>選擇地點</td> <td><input type='hidden' name='SLoc' value='<%= Var4 %>'><%= Var4 %></td> </tr> <tr> <td align=right width=200>意見</td> <td><input type='hidden' name='SComment' value='<%= Var5 %>'><%= Var5 %></td> </tr> <tr> <td align=right width=200> <input type='submit' name='Submit' value='確認投票'></td> <td> <% if (Var4=="") out.print( "沒有選擇地點<a href='javascript:history.back()'>,請回上一頁重新填寫</a>"); else out.print( "若要更改<a href='javascript:history.back()'>,請回上一頁重新填寫</a>"); %> </td> </tr> </table> <hr> </form> </body> </html> |
Posts Tagged ‘jsp’
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | <%@ page language="java" contentType="text/html; charset=BIG5" pageEncoding="BIG5"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv='Content-Language' content='zh-tw'> <meta http-equiv='Content-Type' content='text/html; charset=BIG5'> <title>2012畢業旅行投票資料(ex-vote)</title> </head> <body> <p>2012畢業旅行投票</p> <form method='post' action='ex-confirm.jsp'> <table border='1' width='100%' id='table1'> <tr> <td align=right width=200>學號</td> <td><input type='text' name='SID' size='10'> </td> </tr> <tr> <td align=right width=200>姓名</td> <td><input type='text' name='SName' size='10'> </td> </tr> <tr> <td align=right width=200>身份證末四碼</td> <td><input type='text' name='SCode' size='10'></td> </tr> <tr> <td align=right width=200>選擇地點</td> <td><input type='radio' value='澎湖' name='SLoc'>澎湖 <input type='radio' value='花蓮' name='SLoc'>花蓮 <input type='radio' value='泰國' name='SLoc'>泰國</td> </tr> <tr> <td align=right width=200>意見</td> <td><input type='text' name='SComment' size='50'> </td> </tr> <tr> <td align=right width=200> </td> <td><input type='submit' name='Submit' value='投票'> </td> </tr> </table> </form> </body> </html> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 | <%@ page language="java" contentType="text/html; charset=BIG5" pageEncoding="BIG5"%> <%@ page import="java.sql.*" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv='Content-Language' content='zh-tw'> <meta http-equiv='Content-Type' content='text/html; charset=big5'> <title>2012畢業旅行投票資料(ex-save)</title> </head> <% //將表單元件的值轉成jsp變數 request.setCharacterEncoding("Big5"); String Var1 = request.getParameter("SID"); String Var2 = request.getParameter("SName"); String Var3 = request.getParameter("SCode"); String Var4 = request.getParameter("SLoc"); String Var5 = request.getParameter("SComment"); %> <% //將表單元件的值存入資料庫 String SID = new String(Var1.getBytes("Big5"), "ISO-8859-1"); String SName = new String(Var2.getBytes("Big5"), "ISO-8859-1"); String SCode = new String(Var3.getBytes("Big5"), "ISO-8859-1"); String SLoc = new String(Var4.getBytes("Big5"), "ISO-8859-1"); String SComment = new String(Var5.getBytes("Big5"), "ISO-8859-1"); Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://aiplab.net:3306/coursedb"; Connection con = DriverManager.getConnection( url,"db_user", "password"); Statement stmt = con.createStatement(); String query="INSERT INTO vote(SID, SName, SCode, SLoc, SComment) VALUES('"+SID+"', '"+SName+"', '"+SCode+"', '"+SLoc+"', '"+SComment+"')"; stmt.executeUpdate(query); con.close(); %> <body> <p>2010生姿畢業旅行投票-投票完成</p> <table border='1' width='100%' id='table1'> <tr> <td align=right width=200>學號</td> <td><%= Var1 %></td> </tr> <tr> <td align=right width=200>姓名</td> <td><%= Var2 %></td> </tr> <tr> <td align=right width=200>身份證末四碼</td> <td><%= Var3 %></td> </tr> <tr> <td align=right width=200>選擇地點</td> <td><%= Var4 %></td> </tr> <tr> <td align=right width=200>意見</td> <td><%= Var5 %></td> </tr> </table> <hr> <a href='ex-list.jsp'>查看報名資料</a> </body> </html> |