Áö±Ý±îÁö ÀÛ¼ºÇÑ È¸¿øµî·ÏÆûÀº ´ÙÀ½°ú °°´Ù.



ÀÌÁ¦ ÇØ¾ß ÇÒÀÏÀº µî·ÏÇϰíÀÚ ÇÏ´Â ÀûÀýÇÑ È¸¿øÁ¤º¸¸¦ ÀÔ·ÂÇϰí È®ÀÎÀ» ´©¸£¸é Àü´ÞµÇ´Â °¢°¢ÀÇ Äõ¸®°ªµéÀ» DB¾È¿¡ ÀúÀåÇÏ´Â ÀÏÀÌ ÇÊ¿äÇÏ´Ù. ¿ì¸° À̰ÍÀ» login_insert.asp ¹®¼­¿¡¼­ ´Ù·ç°Ô µÉ°ÍÀÌ´Ù.

±×Àü¿¡ ´ÙÀ½°ú °°ÀÌ È¸¿øÁ¤º¸¸¦ ÀúÀåÇÒ Å×À̺íÀ» DB¾È¿¡ ¸¸µé¾î ÁÖ¾î¾ß ÇÑ´Ù.

Login DataBase¿¡ member Å×ÀÌºí¸¸µé±â

°íÀ¯¹øÈ£ : u_num - °¢°¢ÀÇ ·¹Äڵ带 ±¸º°ÇÑ °íÀ¯Å°°ª.
¾ÆÀ̵ð : u_id - ±æÀÌ 15
ºñ¹Ð¹øÈ£ : u_pwd - ±æÀÌ 15
À̸§ : u_name - ±æÀÌ 15
Áֹεî·Ï¹øÈ£ : u_jumin - ±æÀÌ 14
À̸ÞÀÏ : u_email - ±æÀÌ 50
¿ìÆí¹øÈ£ : u_zipcode - ±æÀÌ 7
ÁÖ¼Ò : u_address - ±æÀÌ 100
µî·ÏÀÏ : u_regdate - µî·Ï³¯Â¥µµ ÀÚµ¿À¸·Î ±â·ÏÇϱâ À§ÇØ.

(1) SQL Query Analyzer ¸¦ ½ÇÇàÇÏ¿© ´ÙÀ½°ú °°ÀÌ ÀÔ·ÂÇÏ°í ½ÇÇà½ÃŲ´Ù.



(2) Á¤»óÀûÀ¸·Î ½ÇÇàÀÌ µÇ¸é SQL Server Enterprise Manager¿¡¼­ ´ÙÀ½ ±×¸²°ú °°ÀÌ Login DB ÀÇ member Å×ÀÌºí¿¡¼­ È®ÀÎ.



(3) Å×ÀÌºíµµ ¸¸µé¾úÀ¸´Ï±ñ ÀÌÁ¦ Àü´Þ¹ÞÀº Äõ¸®°ªµéÀ» ÀúÀåÇÏ´Â login_insert.asp ¹®¼­¸¦ ´ÙÀ½°ú °°ÀÌ ÀÛ¼ºÇÑ´Ù.

login_insert.asp
<%

'Àü´Þ¹ÞÀº Äõ¸®°ªÀ» °¢°¢ÀÇ º¯¼ö¿¡ ÀúÀå
Dim id,pwd,name,jumin,email,zipcode,address
id = Request("id")
pwd =Request("pwd")
name = Request("name")
jumin = Request("jumin1") & "-" & Request("jumin2")
email = Request("email")
zipcode = Request("zipcode1") & "-" & Request("zipcode2")
address = Request("address") & " " & Request("address2")

'µ¥ÀÌÅͺ£À̽º ¿¬°á ¼³Á¤
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open ("DSN=dsn_login;UID=abcd;PWD=abcd;")

'Áߺ¹¾ÆÀ̵ðüũ
Dim MemberCnt
sql = "select Count(u_num) from member where u_id ='" & id & "'"
MemberCnt = objConn.execute(sql)

'Áߺ¹¾ÆÀ̵𰡠¾øÀ» ¶§
if MemberCnt(0) = 0 then
    SQL = "insert into member(u_id,u_pwd,u_name,u_jumin,u_email,u_zipcode,u_address,u_regdate) "
    SQL = SQL & "values('" & id & "','" & pwd & "','" & name & "','" & jumin & "','" & email & "','" & zipcode & "','" & address & "',getdate())"
    objConn.Execute(SQL)
    '½ÇÇàÈÄ º¸¿©ÁÙ È­¸é ÁöÁ¤
    Response.Redirec "index.asp"
'Áߺ¹¾ÆÀ̵𰡠ÀÖÀ» ¶§
else
    Response.Write "ÀÌ¹Ì µî·ÏµÈ ¾ÆÀ̵ðÀÔ´Ï´Ù.<br> È®ÀÎÈÄ ´Ù½Ã ½ÃµµÇØ ÁֽʽÿÀ<p>"
    Response.Write "<a href=Javascript:history.go(-1)>µÚ·Î°¡±â</a>"
end if

%>


(4) ´ÙÀ½Àº login_new.asp ¹®¼­¸¦ ºê¶ó¿ìÀú·Î È®ÀÎÇϰí ÀûÀýÇÑ Á¤º¸¸¦ ÀÔ·ÂÇÑÈÄ ÃÖÁ¾ÀûÀ¸·Î ȸ¿ø¿¡ µî·ÏÈÄÀÇ DB¾ÈÀÇ ¸ð½ÀÀÌ´Ù. ( Áֹεî·ÏÀº ³»²¬ ½á¼­ ÀÓÀÇ·Î Áö¿ü´Ù. µî·Ï¾ÈµÈ°Ô ¾Æ´Ï´Ù. --). ¾ÏÅϰ¡³×...Å×½ºÆ®Çغ¸°í ±×¸²Ã³·³ È®ÀÎÇØº¸½Ã¶ó..Àßµé¾î°¡´ÂÁö..