23
十二月

網頁程式設計12/23 程式bisave.jsp

   Posted by: admin   in 97(上)網頁程式設計

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
<%@ page language="java" contentType="text/html; charset=BIG5"   pageEncoding="BIG5"%>
<%@ page import="java.sql.*" %>
<html>
 
<head>
<meta http-equiv='Content-Language' content='zh-tw'>
<meta http-equiv='Content-Type' content='text/html; charset=big5'>
<title>2010生姿畢業旅行投票</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://localhost:3306/dino";
  Connection con = DriverManager.getConnection( url,"bioinfo", "6193");
  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='bilist.jsp'>查看報名資料</a>
 
</body>
 
</html>

bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark

Tags: , , ,

This entry was posted on 星期二, 十二月 23rd, 2008 at 16:10:06 and is filed under 97(上)網頁程式設計. 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.

4 Trackbacks/Pings

  1. kurt    七月 30 2014 / 9上午:

    bundy@picketts.peccavi” rel=”nofollow”>.…

    ñïñ çà èíôó!…

  2. andrew    十二月 24 2014 / 2上午:

    solo@describes.autumnal” rel=”nofollow”>.…

    tnx for info….

  3. luke    一月 25 2015 / 3上午:

    riddance@hurok.stepanova” rel=”nofollow”>.…

    ñïàñèáî!…

  4. Cecil    一月 28 2015 / 7下午:

    competition@inflate.andrenas” rel=”nofollow”>.…

    tnx….

Leave a reply

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