Posts Tagged ‘jsp’

13
四月

程式設計二程式 04/06: ex-vote.jsp

   Posted by: admin    in 100(下)程式設計(二)

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>

bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

Tags: , , ,

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>

bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

Tags: , , ,

13
四月

程式設計二程式 04/06: ex-save.jsp

   Posted by: admin    in 100(下)程式設計(二)

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: , ,