0
 35   4   1
  View Articles

Name  
   ¼Õº´¸ñ  (2002-07-29 00:55:53, Hit : 23781, Vote : 2047)
Homepage  
   http://www.itmembers.net
Subject  
   DB¿¬µ¿ÇÁ·Î±×·¥ ½Ç½À(5/7) - ÄÚµù(1)
Áö³­ ½Ã°£±îÁö ÇÁ·Î±×·¥¿¡ ÇÊ¿äÇÑ ²®µ¥±â(Æû)´Â ¸ðµÎ ¸¸µé¾úÀ¸´Ï ÀÌÁ¦ º»°ÝÀûÀÎ ÇÁ·Î±×·¡¹Ö¿¡ µ¹ÀÔÇϰڽÀ´Ï´Ù.
¸ÕÀú ù ¹øÂ° ÆûÀÎ frmDb1 ÆûÀ» ¿­°í ÄÚµå â¿¡¼­ ¾Æ·¡¿Í °°Àº Äڵ带 ÀÔ·ÂÇÏ¸é µË´Ï´Ù.
¾Æ·¡´Â Äڵ带 ºÎºÐº°·Î ¼³¸íÇϰí ÀÖÀ¸´Ï ÀüüÀûÀÎ Äڵ带 È®ÀÎÇϽ÷Á¸é ÀÚ·á½ÇÀÇ ¼Ò½º ÆÄÀÏÀ» ÂüÁ¶ÇϽñ⠹ٶø´Ï´Ù.

Á¶±Ý ¾î·Á¿ï ¼öµµ ÀÖ½À´Ï´Ù. ±×¸®°í ¼³¸íÀÌ ¸¹ÀÌ ºÎÁ·ÇÒ ¼öµµ ÀÖ½À´Ï´Ù.
±×·¯³ª ºñÁÖ¾óº£ÀÌÁ÷À» Á¦´ë·Î °øºÎÇÏ·Á´Â ºÐÀ̶ó¸é Áö±ÝÂë ¾à°£Àº µµÅèÇÑ ºñº£ Ã¥ ÇѱǾ¿Àº »ç µÎ¼Ì°ÚÁÒ?

[1]
Private Sub Form_Load()
    datDb1.DatabaseName = App.Path + "\db1.mdb"
    datDb1.RecordSource = "employee"
    datDb1.Refresh
    
    If datDb1.Recordset.RecordCount = 0 Then
        Call TextUnabled
    End If
End Sub

Form °³Ã¼ÀÇ Load À̺¥Æ®¿¡ À§¿Í °°Àº Äڵ带 Ãß°¡ÇÕ´Ï´Ù. ÇÑÁÙÇÑÁÙ ¼³¸íµå¸®ÀÚ¸é,
  • µ¥ÀÌÅÍ ÄÁÆ®·Ñ(datDb1)ÀÇ DatabaseName ¼Ó¼º°ªÀ» ÇöÀç ÇÁ·Î±×·¥ÀÌ ½ÇÇàµÇ°íÀÖ´Â °æ·Î(App.Path)ÀÇ db1.mdb ÆÄÀÏ·Î ÁöÁ¤Çϰí
  • µ¥ÀÌÅÍ ÄÁÆ®·Ñ(datDb1)ÀÇ RecordSource ¼Ó¼º°ªÀ» "employee"·Î ÁöÁ¤ÇÑ ´ÙÀ½
  • µ¥ÀÌÅÍ ÄÁÆ®·Ñ(datDb1)À» »õ·Î°íħ(Refresh)ÇÕ´Ï´Ù.
  • ·¹ÄÚµå¼ÂÀÇ ·¹Äڵ尡 ¾øÀ¸¸é TextUnabled ÇÔ¼ö¸¦ ½ÇÇàÇÕ´Ï´Ù.

ÀÌ ÇÁ·Î±×·¥¿¡¼­´Â TextUnabled(), TextEnabled() ¿Í °°Àº »ç¿ëÀÚ°¡ Á÷Á¢ ¸¸µç ÇÔ¼ö¸¦ »ç¿ëÇÕ´Ï´Ù.
TextEnabled()´Â ÅØ½ºÆ® ¹Ú½º¸¦ ¸ðµÎ ÀÔ·ÂÇÒ ¼ö ÀÖ´Â »óÅ·Π¸¸µé°í, TextUnabled()´Â ÅØ½ºÆ® ¹Ú½º¿¡ ÀÔ·ÂÇÒ ¼ö ¾øµµ·Ï ¸¸µå´Â ÇÔ¼öÀÔ´Ï´Ù.(¾Æ·¡ [2]¿Í [3]ÀÇ ÇÔ¼öÀÔ´Ï´Ù.) µû¶ó¼­ À§ÀÇ If~End If´Â µ¥ÀÌÅͰ¡ Çϳªµµ ¾øÀ¸¸é [Ãß°¡] ´ÜÃ߸¦ ´©¸£±â Àü±îÁö µ¥ÀÌÅ͸¦ ÀÔ·ÂÇÒ ¼ö ¾øµµ·Ï ¸¸µå´Â ±â´ÉÀÔ´Ï´Ù.

[2]
Private Sub TextEnabled()
        txtNumber.Enabled = True
        txtName.Enabled = True
        txtClass.Enabled = True
        txtPosition.Enabled = True
        txtToeic.Enabled = True
End Sub

»ç¿ëÀÚ Á¤ÀÇ ÇÔ¼öÀÔ´Ï´Ù. ÄÚµå â¿¡¼­ ÇÔ¼ö À̸§ºÎÅÍ ¸ðµÎ Á÷Á¢ ÀÔ·ÂÇØ¾ß µË´Ï´Ù.
ÅØ½ºÆ® ¹Ú½º 5°³¸¦ ¸ðµÎ ÀÔ·ÂÇÒ ¼ö ÀÖ´Â »óÅ·Π¸¸µé¾î ÁÖ´Â ±â´ÉÀ» ÇÕ´Ï´Ù.

[3]
Private Sub TextUnabled()
        txtNumber.Enabled = False
        txtName.Enabled = False
        txtClass.Enabled = False
        txtPosition.Enabled = False
        txtToeic.Enabled = False
End Sub

»ç¿ëÀÚ Á¤ÀÇ ÇÔ¼öÀÔ´Ï´Ù.
ÅØ½ºÆ® ¹Ú½º 5°³ ¸ðµÎ ÀÔ·ÂÇÒ ¼ö ¾ø´Â »óÅ·Π¸¸µì´Ï´Ù. ¿¹¸¦ µé¾î [Ãß°¡] ´ÜÃ߸¦ ´©¸£Áö ¾ÊÀº »óÅ¿¡¼­´Â ÅØ½ºÆ® ¹Ú½º¿¡ ¾Æ¹«·± µ¥ÀÌÅ͵µ ÀÔ·ÂÇÏÁö ¸øÇϵµ·Ï ÇÒ ¶§ »ç¿ëÇÕ´Ï´Ù.

[4]
Private Sub cmdAdd_Click()
    datDb1.Recordset.AddNew
    Call TextEnabled
    txtNumber.SetFocus
End Sub

[Ãß°¡] ´ÜÃ߸¦ ´­·¶À» ¶§ »ç¿ëµÇ´Â ÄÚµåÀÔ´Ï´Ù. cmdAdd ÄÁÆ®·ÑÀÇ Click À̺¥Æ®¿¡ À§¿Í °°Àº Äڵ带 Ãß°¡ÇÕ´Ï´Ù.
  • ù ¹øÂ° ÁÙÀº ÇöÀçÀÇ µ¥ÀÌÅͺ£À̽ºÀÇ ·¹Å©µå¼Â¿¡ »õ µ¥ÀÌÅ͸¦ Ãß°¡ÇÏ´Â ¸Þ¼Òµå(AddNew)
  • µÎ ¹øÂ° ÁÙÀº ÅØ½ºÆ® ¹Ú½º¿¡ ¸ðµÎ ÀÔ·ÂÇÒ ¼ö ÀÖ´Â »óÅ·Π¸¸µå´Â °Í
  • ¸¶Áö¸· ÁÙÀº ¹øÈ£ ÀԷ¶õ(ù¹øÂ° ÅØ½ºÆ® ¹Ú½º)·Î Ä¿¼­¸¦ À§Ä¡½ÃŰ´Â ±â´É
ÀÔ´Ï´Ù.

[5]
Private Sub cmdDelete_Click()
    If datDb1.Recordset.RecordCount > 0 Then
        datDb1.Recordset.Delete
        datDb1.Refresh
    Else
        Call TextUnabled
    End If
End Sub

[»èÁ¦] ´ÜÃ߸¦ ´­·¶À» ¶§ »ç¿ëµÇ´Â ÄÚµåÀÔ´Ï´Ù. cmdDelete ÄÁÆ®·ÑÀÇ Click À̺¥Æ®¿¡ À§¿Í °°Àº Äڵ带 Ãß°¡ÇÕ´Ï´Ù.
¸¸¾à ·¹Äڵ尡 Çϳª¶óµµ ÀÖÀ¸¸é(Áï, RecordCount°¡ 0º¸´Ù Å©¸é) ÇöÀçÀÇ ·¹Äڵ带 »èÁ¦(Delete)ÇÏ°í »õ·Î°íħ(Refresh)ÇÕ´Ï´Ù.
±×·¸Áö ¾ÊÀ¸¸é(·¹Äڵ尡 Çϳªµµ ¾øÀ¸¸é) ÅØ½ºÆ® ¹Ú½º¸¦ ÀÔ·ÂÇÏÁö ¸øÇϵµ·Ï ¸¸µì´Ï´Ù.

[6]
Private Sub cmdSearch_Click()
    frmDb1S.Show
End Sub

[°Ë»ö] ´ÜÃ߸¦ ´­·¶À» ¶§ »ç¿ëµÇ´Â ÄÚµåÀÔ´Ï´Ù. cmdSearch ÄÁÆ®·ÑÀÇ Click À̺¥Æ®¿¡ À§¿Í °°Àº Äڵ带 Ãß°¡ÇÕ´Ï´Ù.
frmDb1S ÆûÀ» º¸¿©ÁÖ´Â ±â´ÉÀÔ´Ï´Ù.

[7]
Private Sub cmdSQL_Click()
    frmSqlSearch.Show
End Sub

À§¿Í ¸¶Âù°¡Áö·Î [SQL ½ÇÇà] ´ÜÃ߸¦ ´­·¶À» ¶§ frmSqlSearch ÆûÀ» º¸¿©ÁÖ´Â ±â´ÉÀÔ´Ï´Ù.

[8]
Private Sub datDb1_Reposition()
   datDb1.Caption = CStr(datDb1.Recordset.AbsolutePosition + 1) + "/" + CStr(datDb1.Recordset.RecordCount)
End Sub


datDb1 ÄÁÆ®·ÑÀÇ Reposition À̺¥Æ®¿¡ Ãß°¡ÇÏ´Â ÄÚµåÀÔ´Ï´Ù.(µ¥ÀÌÅÍÄÁÆ®·ÑÀ» ´õºíŬ¸¯Çϰí À§ÀÇ Äڵ带 Ãß°¡Çصµ µË´Ï´Ù.)
µ¥ÀÌÅÍÄÁÆ®·ÑÀÇ Ä¸¼Ç ¼Ó¼º°ª(datDb1.Caption)À» ·¹ÄÚµå¼ÂÀÇ ÇöÀç À§Ä¡(datDb1.Recordset.AbsolutePosition)¿¡ 1À» ´õÇÑ ¼ýÀÚ¸¦ ¹®ÀÚ¿­·Î ¹Ù²Ù°í(CStr), ·¹ÄÚµå¼ÂÀÇ Àüü °³¼ö(datDb1.Recordset.RecordCount)¸¦ ¹®ÀÚ¿­·Î ¹Ù²Ù¾î(Cstr) ÇöÀçÀ§Ä¡/Àüü¼ýÀÚ¿Í °°Àº ½ÄÀ¸·Î Ç¥½ÃÇ϶ó´Â ¶æÀÔ´Ï´Ù.


¿Ãµé¾î °¡Àå ´õ¿î ³¯¾¾¶ó³×¿ä. Àü±â¿ä±ÝÀÌ ¹«¼­¿ö(?) ÇԺηΠƲÁö ¸øÇÏ´Â ¿¡¾îÄÁÀ» ¿À´ÃÀº ¹ã»õµµ·Ï Äѳõ¾Æ¾ß ÇÒ ÆÇÀÔ´Ï´Ù.
³¯ÀÌ »õ¸é ¶Ç »õ·Î¿î ÇÑÁÖ°¡ ½ÃÀ۵˴ϴÙ.
»õ·Ó°Ô ÈûÂ÷°Ô ÇÑÁÖ¸¦ ½ÃÀÛÇսôÙ. ¿©·¯ºÐ ¸ðµÎ ÆÄÀÌÆÃ~

ÀÌ»ó µ¿ÁÖ ¾Æºü ¼Õº´¸ñÀ̾ú½À´Ï´Ù.

Prev
   DB¿¬µ¿ÇÁ·Î±×·¥ ½Ç½À(6/7) - ÄÚµù(2)

¼Õº´¸ñ
Next
   DB¿¬µ¿ÇÁ·Î±×·¥ ½Ç½À(4/7) - SQL ½ÇÇà Æû ¸¸µé±â [1]

¼Õº´¸ñ


Copyright 1999-2025 Zeroboard / skin by Zetyx