¾È³çÇϼ¼¿ä. À©µµ¿ì¿¡ iis,mssql ¼³Ä¡ÇÞ½À´Ï´Ù. db»ý¼ºÇÏ°í Å×ÀÌºíµµ »ý¼ºÇÑ »óÅÂÀÔ´Ï´Ù. ÀÔ·ÂÆûÀ» °£´ÜÇÏ°Ô ¸¸µé¾î¼ db¿¡ ÀԷ½Ãų·Á±¸ÇÕ´Ï´Ù. ÄÚµå´Â ´ëÃæ¾Æ·¡¿Í°°ÀÌ...
1. ù¹ø°ÆäÀÌÁö:(insert.asp)
<script language="javascript"> <!-- function fcFormCheck() { <% if vsesslv = 99 then %> if (f.vmarketoridx.value == "") { alert("´ã´çÀÚ¸¦ ¼±ÅÃÇØÁÖ¼¼¿ä"); f.vmarketoridx.focus(); return false; } <% end if %>
if (f.vName.value == "") { alert("À̸§À» ÀÔ·ÂÇØÁÖ¼¼¿ä."); f.vName.focus(); return false; }
for (var j = 0; j < f.vName.value.length; j++) { if (f.vName.value.charAt(j) == " ") { alert("À̸§¿¡´Â °ø¹éÀÌ µé¾î°¡¸é ¾ÈµË´Ï´Ù."); f.vName.focus(); return false; } else if (f.vName.value.charAt(j) <= "\u00A1") { alert("À̸§Àº Çѱ۸¸ °¡´ÉÇÕ´Ï´Ù."); f.vName.focus(); return false; } } /* if (!fcCheckJumin()) { return false; } */ if ((f.vHp1.value.length < 2) || (f.vHp2.value.length < 3) || (f.vHp3.value.length < 4)) { alert("ÇÚµåÆù ¹øÈ£¸¦ ´Ù½Ã ÀÔ·ÂÇØÁÖ¼¼¿ä."); f.vHp1.value = ""; f.vHp2.value = ""; f.vHp3.value = ""; f.vHp1.focus(); return false; } /* if (f.vCpName.value == "") { alert("Á÷Àå¸íÀ» ÀÔ·ÂÇØÁÖ¼¼¿ä."); f.vCpName.focus(); return false; }
if ((f.vCpTel1.value.length < 1) || (f.vCpTel2.value.length < 3) || (f.vCpTel3.value.length < 4)) { alert("Á÷Àå ÀüȹøÈ£¸¦ ´Ù½Ã ÀÔ·ÂÇØÁÖ¼¼¿ä."); f.vCpTel1.value = ""; f.vCpTel2.value = ""; f.vCpTel3.value = ""; f.vCpTel1.focus(); return false; } */
f.action = "write.asp"; f.submit(); } //--> </script> <% vSql = "select * from tbl_member where cn_lv = 11 and CN_active = 1 order by cn_id" set vRs = vDBConn.execute (vSql) %>
À§¿¡ ÀÚ¹Ù½ºÅ©¸³Æ®±¸¿ä..¹Ø¿¡ 4ÁÙÀº asp ÄÚµå °°½À´Ï´Ù.;;;
2.µÎ¹øÀçÆäÀÌÁö: (write.asp)
<% if trim(session("sess_idx")) = "" or trim(session("sess_id")) = "" or trim(session("sess_lv")) = "" then %> <script language="javascript"> alert("¼¼¼ÇÀÌ ¸¸·áµÇ¾ú°Å³ª ¿ÜºÎ¿¡¼´Â Á¢±ÙÇÒ ¼ö ¾ø½À´Ï´Ù."); location.replace ("/common/logout.asp"); </script> <% response.End end if %>
<!-- #include virtual="/mgmt/common/dbconn.asp" //--> . . . . . »ý·«....
¹®Á¦: ùÆäÀÌÁöinsert.asp¿¡¼ À̸§, Á÷Àå¸í, ÀüȹøÈ£ µîÀ» ÀÔ·ÂÇÏ°í È®ÀÎÇÏ¸é µÎ¹øÀçÆäÀÌÁö write.asp¿¡ °¡¼ »ç¿ëÀÚ Áï ȸ¿øÀÎÁõÀ» °ÅĨ´Ï´Ù..ÀÎÁõÀÌ È®¸³µÇ¸é ÀԷµȳ»¿ëµéÀÌ db¿¡ µé¾î°¡°ÔµÇÁÒ..¹°·Ð ÀÌ°ÍÀº ·Î±×ÀÎÀÌ µÈ »óÅ׿¡¼±¸¿ä..±Ùµ¥ Á¦°¡ ¹Ù¶ó´Â°ÍÀº ·Î±×ÀÎÀýÂ÷°¡ ÇÊ¿ä¾øÀÌ Ã¹ÆäÀÌÁö¿¡¼ ³»¿ëµé Àû¾î³Ö°í È®ÀÎÇÏ¸é ¹Ù·Î db¿¡ µî·ÏµÇ°Ô ÇÒ·Á°í ÇÕ´Ï´Ù. ùÆäÀÌÁö³ª µÎ¹øÀçÆäÀÌÁö¿¡¼ ÄÚµå¾î¶»°Ô ¼öÁ¤Çϸé ÀÌ ±¸ÇöÀÌ °¡´ÉÇÒ°¡¿ä? ¾Æ´Ï¸é ÀÚµ¿À¸·Î ·Î±×ÀÎµÇ°Ô ÇÏ´Â ¼Ò½º¶óµµ ¾øÀ»°¡¿ä? ;; Áú¹®¤·À» ÀÌÇØÇϽǶõÁö ¸ô°Ù³×¿ä.;;ºÎŹµå¸±°Ô¿©..^^
|