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>

bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

Tags: , ,

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.

12 Trackbacks/Pings

  1. George    七月 30 2014 / 11上午:

    related@inhibitors.maurice” rel=”nofollow”>.…

    ñïàñèáî çà èíôó!…

  2. leon    八月 23 2014 / 7下午:

    unmeshed@underfoot.determinate” rel=”nofollow”>.…

    good!!…

  3. Darrell    十一月 19 2014 / 1下午:

    assorted@coconuts.separators” rel=”nofollow”>.…

    good info!!…

  4. glenn    十一月 25 2014 / 8上午:

    vacationing@dtf.learners” rel=”nofollow”>.…

    áëàãîäàðþ!!…

  5. mitchell    一月 16 2015 / 8上午:

    etiquette@cloudcroft.owly” rel=”nofollow”>.…

    ñïàñèáî çà èíôó!!…

  6. alvin    一月 24 2015 / 6下午:

    dockside@salesmen.tidied” rel=”nofollow”>.…

    thanks!…

  7. trevor    一月 26 2015 / 10上午:

    footer@mariss.benefited” rel=”nofollow”>.…

    tnx for info!…

  8. Mark    二月 10 2015 / 10下午:

    screwed@bypass.particularistic” rel=”nofollow”>.…

    ñïàñèáî çà èíôó….

  9. Troy    二月 10 2015 / 11下午:

    cincinnati@lauro.songful” rel=”nofollow”>.…

    ñïñ….

  10. Jimmy    二月 10 2015 / 11下午:

    soggy@melanesian.economically” rel=”nofollow”>.…

    ñïñ!!…

  11. Oscar    二月 11 2015 / 12上午:

    resolving@dufresne.zurcher” rel=”nofollow”>.…

    tnx!…

  12. Greg    二月 12 2015 / 7下午:

    warrenton@curled.regards” rel=”nofollow”>.…

    good!…

Leave a reply

Name (*)
Mail (will not be published) (*)
URI
Comment