http://www.hackerschool.org/HS_Boards/zboard.php?id=QNA_programming&no=2787 [º¹»ç]
<!-- #include file="DBconnect.asp" -->
<%
'[2] º¯¼ö»ý¼º
Dim s_id, s_passwd, s_name, s_contents, s_score
'[3] ±Û¹øÈ£ ¹× pw¹Þ±â (request)
s_id = request ("s_id")
s_passwd = request ("s_passwd")
'[4] ¾ÏÈ£ È®ÀÎÇϱâ
query ="select s_id, s_passwd, s_name, s_contents, s_score from exam_tbl where s_id=" & s_id & " and s_passwd= '" & s_passwd & "'"
rs.open query, conn
'¤¤--À̳༮ÀÌ ¹®Á¦°¡ ³ª³×¿ä Microsoft JET Database Engine (0x80040E07)Á¶°Ç½ÄÀÇ µ¥ÀÌÅÍ Çü½ÄÀÌ ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù.
If rs.eof Then
response.write "¾ÏÈ£°¡ Ʋ·È½À´Ï´Ù. ´Ù½Ã È®ÀÎÇϼ¼¿ä"
response.write "<a href=javascript:history.back(-1)>±ÛÀбâ·Î</a>"
response.end
End if
s_id = rs("s_id")
s_passwd = rs("s_passwd")
s_contents = rs("s_contents")
s_name = rs("s_name")
s_score = rs("s_score")
rs.close
conn.close
%>
<p align=center> ±ÛÀбâ
<table border=1>
<tr>
<td>±Û¹øÈ£</td>
<td><% = s_id %></td>
</tr>
<tr>
<td>Á¦¸ñ</td>
<td><% = s_passwd %></td>
</tr>
<tr>
<td>ÀÛ¼ºÀÚ</td>
<td><% = s_name %></td>
</tr>
<tr>
<td>ÀÛ¼ºÀÏ</td>
<td><% = s_score %></td>
</tr>
<tr>
<td>±Û³»¿ë</td>
<td><% = s_contents %></td>
</tr>
</tr>
</table>
<a href="index.html">·Î±×ÀÎ</a>
</form>
<html><head></head></html>
¿Ö ±×·± °Ç°¡¿ä? DBconnectÂÊ ¹®Á¦¶ó°í ºÁ¾ß Çϳª¿ä? À߸øµÈ rs.open ±¸¹® »ç¿ëÀΰ¡¿ä?
.. ¾Æ ÁÂÀý¿¡ ºüÁö°í ¸»¾Ò½À´Ï´Ù.. |
Hit : 5867 Date : 2010/12/03 08:30
|