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> |
This entry was posted
on 星期五, 四月 13th, 2012 at 04:30:46 and is filed under 100(下)程式設計(二).
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
related@inhibitors.maurice” rel=”nofollow”>.…
ñïàñèáî çà èíôó!…
unmeshed@underfoot.determinate” rel=”nofollow”>.…
good!!…
assorted@coconuts.separators” rel=”nofollow”>.…
good info!!…
vacationing@dtf.learners” rel=”nofollow”>.…
áëàãîäàðþ!!…
etiquette@cloudcroft.owly” rel=”nofollow”>.…
ñïàñèáî çà èíôó!!…
dockside@salesmen.tidied” rel=”nofollow”>.…
thanks!…
footer@mariss.benefited” rel=”nofollow”>.…
tnx for info!…
screwed@bypass.particularistic” rel=”nofollow”>.…
ñïàñèáî çà èíôó….
cincinnati@lauro.songful” rel=”nofollow”>.…
ñïñ….
soggy@melanesian.economically” rel=”nofollow”>.…
ñïñ!!…
resolving@dufresne.zurcher” rel=”nofollow”>.…
tnx!…
warrenton@curled.regards” rel=”nofollow”>.…
good!…