¼¼¼Çº¯¼ö¸¦ ÀÌ¿ëÇÑ ·Î±×Àο¡¼ ¹®Á¦Á¡[Áú¹®]
¾È³çÇϼ¼¿ä. 5¿ù ÃÊ »çÀÌÆ®¸¦ ¿ÀÇÂÇÏ¿© ¿ÀÇÂÁßÀÎ »çÀÌÆ® °ü¸®ÀÚÀÔ´Ï´Ù. ´ä´äÇÑ°Ô ÀÖ¾î¼ ¹®ÀÇ µå¸³´Ï´Ù.
asp¿¡¼ ¼¼¼Çº¯¼ö¸¦ »ç¿ëÇÏ¿© ·Î±×Àΰú ·Î±×¾Æ¿ô ±×¸®°í ȸ¿øÁ¤º¸¸¦ ¿¬°áÇÏ¿© ¼¼¼Çº¯¼ö¿¡ ´ã¾Æ »ç¿ëÇÏ°í ÀÖ½À´Ï´Ù. ±×·±µ¥ ÀϺΠºê¶ó¿ìÀú¿¡¼ ÀÌ°Ô Àß µÇÁö ¾Ê½À´Ï´Ù. ·Î±×ÀÎÀ» Çϸé À̸§°ú ¹æ¹®È½¼öµîÀ» DB¿¡¼ ºÒ·¯¿Í¼ ***´Ô ¾È³çÇϼ¼¿ä? **¹ø° ¹æ¹®ÀÔ´Ï´Ù.¶ó°í ·Î±×ÀΠâ¿¡ ¶ç¿ö¾ß µÇ´Âµ¥ ¾î´ÀÄÄ¿¡¼´Â µÇ°í ¾î´ÀÄÄ¿¡¼´Â Çѹø¿¡ ·Î±×ÀÎÀÌ µÉ¶§µµ ÀÖ°í »õ·Î°íħÇØ¾ß µÉ¶§µµ ÀÖ°í »õ·Î°íħÀ» °è¼Ó ´·¯ºÁµµ µÇÁö¾Ê´Â °æ¿ìµµ ÀÖ½À´Ï´Ù. ¼¼¼Çº¯¼ö°¡ »õ·Î ÁöÁ¤ µÇ¾ú´Âµ¥ Àü¿¡ ÀÖ´ø ÀúÀåµÈ ÆäÀÌÁö¸¦ °è¼Ó ÀÐ¾î ¿À´Âµí ½Í½À´Ï´Ù. ¼Ò½º´Â ´ëÃæ ¾Æ·¡¿Í °°½À´Ï´Ù. ´Ù¸¥ ÆäÀÌÁö¿¡µµ <% response.expires=0 %> Äڵ尡 ùÁÙ¿¡ µé¾î ÀÖ½À´Ï´Ù.
<% response.expires=0 %> <% id=request("userid") pwd=request("pwd") nowdoc=request("nowdoc")
set db=Server.CreateObject("ADODB.Connection") db.open ("dsn=datenaraDB; uid=sa; pwd=hmk0129") SQL="select mem_name,mem_id,mem_pwd,mem_sex,mem_class from Member where mem_id='" & id & "'" set rs=Server.CreateObject("ADODB.Recordset") rs.Open SQL, db
if rs.eof or rs.bof then %> <script language="javascript"> <!-- alert("Á¸ÀçÇÏÁö ¾Ê´Â IDÀÔ´Ï´Ù.") history.back() file://--> </script> <% elseif rs("mem_pwd")<>pwd then %> <script language="javascript"> <!-- alert("PassWord°¡ ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù") history.back() file://--> </script> <% else session("id")=rs("mem_id") session("name")=rs("mem_name") session("mclass")=rs("mem_class") & nbsp;session("sex")=rs("mem_sex") rs.close set rs = Nothing
SQL="select count(*) from SendDate where mem_id = '" & id & "'" set rt1=db.execute(SQL) session("sdate") = rt1(0) rt1.close set rt1 = Nothing
SQL="select count(*) from SendDate where mem_id = '" & id & "' and sd_ok='ok'" 'ok¹ÞÀº ¼ö set rt2=db.execute(SQL) session("sdok") = rt2(0) rt2.close set rt2 = Nothing
SQL="select count(*) from RcvDate where mem_id = '" & id & "'" set rt3=db.execute(SQL) session("rdate") = rt3(0) rt3.close set rt3 = Nothing
SQL="select count(*) from RcvDate where mem_id = '" & id & "' and rd_ok='ok'" set rt4=db.execute(SQL) session("rdok") = rt4(0) rt4.close set rt4 = Nothing
SQL="select count(*) from ImrList where mem_id = '" & id & "'" set rt5=db.execute(SQL) session("imr") = rt5(0) rt5.close set rt5 = Nothing
SQL="select count(*) from ImeList where mem_id = '" & id & "'" set rt6=db.execute(SQL) session("ime") = rt6(0) rt6.close set rt6 = Nothing
SQL="update Actstatus set act_visit = act_visit + 1 where mem_id = '" & id & "'" db.execute SQL
SQL="update Actstatus set act_lastday ='" & now() & "' where mem_id = '" & id & "'" db.execute SQL %> <script language="javascript"> <!-- window.top.location.replace('<%=nowdoc%>') window.close(); file://--> </script> <% end if db.close set db = Nothing %>
¹Ù»Ú½Ã´õ¶óµµ °æÇèÀÌ °è½Å ºÐµéÀÇ Á¶¾ðÀ» ±â´Ù¸®°Ú½À´Ï´Ù. ¼¹öÀÇ ¹®Á¦ÀÎÁö.. ºê¶ó¿ìÀúÀÇ ¹®Á¦ÀÎÁö... ¾Æ´Ï¸é ÇÁ·Î±×·¥ÀÇ ¹®Á¦ÀÎÁö ¾Ë ¼ö°¡ ¾ø½À´Ï´Ù. ¼¹ö³ª ºê¶ó¿ìÀúÀÇ ¹®Á¦¶ó¸é ¼³Á¤À» ¾î¶»°Ô ¹Ù²Ù¾î¾ß µÇ´ÂÁö ¾Æ½Ã´Â ºÐ ´äº¯À» ¾ÖŸ°Ô ±â´Ù¸®°Ú½À´Ï´Ù.
Á¦»ý°¢¿£ ºê¶ó¿ìÀú ¹öÀü¿¡ µû¶ó ¶Ç´Â ºê¶ó¿ìÀú ¼³Á¤¿¡ µû¶ó ÀÌ·± Çö»óÀÌ »ý±â´Â°Ô ¾Æ´Ñ°¡ »ý°¢ µË´Ï´Ù. ¿Ö³Ä¸é ÄÄÇ»ÅÍ¿¡ µû¶ó Á¤»óÀûÀ¸·Î µ¿ÀÛÇÏ´Â°Ô ´õ ¸¹½À´Ï´Ù.
Ȥ½Ã ¸ÞÀÏ Áֽøé datenara@empal.com ÀÔ´Ï´Ù. °áÈ¥Á¤º¸ »çÀÌÆ®Àε¥ ¸ÞÀÏ·Î ¿¬¶ôÁÖ½Ã¸é ´õ¿í °¨»çÇÏ°Ú½À´Ï´Ù.
°¨»çÇÕ´Ï´Ù. ÁÁÀº ÇÏ·ç µÇ½Ê½Ã¿ä.
|