37-1.´Ù¸¥ °ø±ÞÀÚ¿¡ ¿¬°á

37-1-1.¾×¼¼½º¿¡ ¿¬°á

ADO.NETÀº DB Á¢¼Ó ÀÎÅÍÆäÀ̽ºÀ̹ǷΠ´Ù¾çÇÑ µ¥ÀÌÅÍ ¼Ò½º¸¦ Áö¿øÇÑ´Ù. SQL ¼­¹ö³ª ¿À¶óŬ°°Àº ´ë¿ë·® DBMS »Ó¸¸ ¾Æ´Ï¶ó ÆÄÀÏ ±â¹ÝÀÇ ·ÎÄà µ¥ÀÌÅ͵µ »ç¿ëÇÒ ¼ö ÀÖ´Ù. ´ë±Ô¸ðÀÇ DBMS´Â ¼º´ÉÀº ÈǸ¢ÇÏÁö¸¸ ºñ¿ëÀÌ ¸¸¸¸Ä¡ ¾Ê°í ¼³Ä¡ ¹× °ü¸®µµ ½±Áö ¾Ê¾Æ ¼Ò±Ô¸ðÀÇ ÀÀ¿ë ÇÁ·Î±×·¥¿¡ ¾²±â¿¡´Â ÀûÇÕÇÏÁö ¾Ê´Ù. ÄÄÇ»ÅÍÀÇ ¼º´ÉÀÌ ´ëÆøÀûÀ¸·Î Çâ»óµÊ¿¡ µû¶ó ÆÄÀÏ ±â¹ÝÀÇ ·ÎÄà µ¥ÀÌÅͺ£À̽º·Îµµ À¢¸¸ÇÑ ±Ô¸ðÀÇ ÀÀ¿ë ÇÁ·Î±×·¥Àº ¼ÒÈ­Çس¾ ¼ö ÀÖ´Ù.

´å³ÝÀÌ Áö¿øÇÏ´Â ·ÎÄà µ¥ÀÌÅͺ£À̽º´Â ´ëÇ¥ÀûÀ¸·Î ¾×¼¼½º ÆÄÀÏÀÎ mdb¿Í SQL ¼­¹ö Express ÆÄÀÏÀÎ mdf µÎ °¡Áö°¡ ÀÖ´Ù. ¿©±â¼­´Â ¼Ò±Ô¸ð DB·Î ¾²±â¿¡ ¹«³­ÇÑ ¾×¼¼½º ÆÄÀÏ¿¡ ¿¬°áÇØ º¸ÀÚ. ¾×¼¼½º 2010À̳ª »óÀ§ ¹öÀüÀ¸·Î ADOTest.mdb ÆÄÀÏÀ» ¸¸µé°í tblPeople°ú tblSale Å×À̺íÀ» ¸¸µç´Ù. Á÷Á¢ ¸¸µé±â ¹ø°Å·Ó´Ù¸é ¿¹Á¦ Æú´õ¿¡ Á¦°øµÇ´Â ÆÄÀÏÀ» »ç¿ëÇصµ ¹«°üÇÏ´Ù.

¸ÕÀú ¸¶¹ý»ç¾øÀÌ ÄÚµå·Î ¿¬°áÇÏ¿© ±×¸®µå¿¡ Å×À̺íÀ» Ãâ·ÂÇÏ´Â ¿¹Á¦¸¦ ÀÛ¼ºÇØ º¸ÀÚ. ¾×¼¼½º´Â º°µµÀÇ Àü¿ë °ø±ÞÀÚ°¡ Á¦°øµÇÁö ¾Ê¾Æ OLE DB °ø±ÞÀÚ·Î ¿¬°áÇØ¾ß ÇÑ´Ù. ºó Æû¿¡ ±×¸®µå¿Í ¹öÆ°À» ¹èÄ¡ÇÏ°í ´ÙÀ½ Äڵ带 ÀÛ¼ºÇÑ´Ù.

 

AccessCon

using System; ~ using System.Windows.Forms;

using System.Data.OleDb;

 

namespace AccessCon {

             public partial class Form1 : Form {

                           private OleDbConnection Con;

                           private OleDbDataAdapter Adpt;

                           private DataTable tblPeople;

 

                           public Form1() {

                                        InitializeComponent();

                           }

 

                           private void Form1_Load(object sender, EventArgs e) {

                                        Con = new OleDbConnection();

                                        Con.ConnectionString = "Provider = Microsoft.JET.OLEDB.4.0;" +

                                                     "Data Source = c:\\ADOTest.mdb";

                           }

 

                           private void btnConnect_Click(object sender, EventArgs e) {

                                        Adpt = new OleDbDataAdapter("SELECT * FROM tblPeople", Con);

                                        tblPeople = new DataTable("tblPeople");

                                        Adpt.Fill(tblPeople);

                                        dataGridView1.DataSource = tblPeople;

                           }

             }

}

 

ÀüüÀûÀÎ ±¸Á¶´Â SQL ¼­¹ö¿¡ ¿¬°áÇÏ´Â ¿¹Á¦¿Í °ÅÀÇ µ¿ÀÏÇÏ´Ù. ´Ù¸¸ °ø±ÞÀÚ°¡ ´Ù¸§À¸·Î ÀÎÇØ using¹®ÀÇ ³×ÀÓ½ºÆäÀ̽º°¡ ¹Ù²î¾ú°í °ü·Ã Ŭ·¡½º À̸§ÀÇ Á¢µÎ¾î°¡ ¸ðµÎ Sql¿¡¼­ OleDb·Î ¹Ù²î¾ú´Ù. ±× ¿Ü ´Ù¸¥ ºÎºÐÀº ¿¬°á ¹®ÀÚ¿­ Á¤µµ »ÓÀÌ´Ù. SQL °ø±ÞÀÚ´Â Á¢¼Ó ´ë»óÀÌ SQL ¼­¹ö·Î °íÁ¤µÇ¾î ÀÖÁö¸¸ OLE DB´Â ±×·¸Áö ¾ÊÀ¸¹Ç·Î Provider Å°·Î Á¢¼Ó ´ë»óÀ» ÁöÁ¤ÇÑ´Ù.

OLE DB ÀÚüµµ DB Á¢¼Ó ÀÎÅÍÆäÀ̽ºÀÇ ÀÏÁ¾À̹ǷΠ´Ù¾çÇÑ µ¥ÀÌÅÍ ¼Ò½º¸¦ Áö¿øÇÏ¸ç µû¶ó¼­ ¿¬°á ¹®ÀÚ¿­¿¡ Á¢¼Ó ´ë»óÀ» ¸í½ÃÇØ¾ß ÇÑ´Ù. ¾×¼¼½º´Â Á¦Æ® ¿£ÁøÀ¸·Î ±¸ÇöµÇ¹Ç·Î ProviderÅ°¿¡ JET ¿£ÁøÀ» ´ëÀÔÇÏ°í Data Source Å°¿¡ mdb ÆÄÀÏÀÇ °æ·Î¸¦ ÁöÁ¤ÇÑ´Ù. ¿¹Á¦¿¡¼­´Â ÆíÀÇ»ó ADOTest.mdb ÆÄÀÏÀÌ C µå¶óÀ̺êÀÇ ·çÆ® µð·ºÅ͸®¿¡ ÀÖ´Â °ÍÀ¸·Î °¡Á¤Çß´Ù. ¾î´ðÅÍ·Î Å×À̺íÀ» Àд ÄÚµå´Â µ¿ÀÏÇÏ´Ù.

ÀÌ ¿¹Á¦ÀÇ ÄÚµå´Â Áö±ØÈ÷ ÆòÀÌÇÏÁö¸¸ ³Ê¹« ¿À·¡µÈ ¹æ¹ýÀ̾ 32ºñÆ® ¿î¿µÃ¼Á¦¿¡¼­¸¸ ½ÇÇàµÇ¸ç 64ºñÆ®¿¡¼­´Â ½ÇÇàµÇÁö ¾Ê´Â´Ù. 64ºñÆ®¿ëÀÇ µå¶óÀ̹ö¸¦ º°µµ·Î ¼³Ä¡Çϰųª ¾Æ´Ï¸é 32ºñÆ®¿Í 64ºñÆ®¸¦ µ¿½Ã¿¡ Áö¿øÇÏ´Â ACE µå¶óÀ̹ö¸¦ »ç¿ëÇÑ´Ù. ¸¶¹ý»ç¸¦ »ç¿ëÇϸé ÀÌ ¹öÀüÀ» »ç¿ëÇϵµ·Ï µÇ¾î ÀÖ¾î ºü¸£°í ½±´Ù.

 

AccessCon2

 

»õ ÇÁ·ÎÁ§Æ®¸¦ ¸¸µç´Ù. µ¥ÀÌÅÍ ¼Ò½º ±¸¼º ¸¶¹ý»ç¸¦ ½ÇÇàÇÏ°í µ¥ÀÌÅÍ ¿¬°á ¼±Åà ´ëÈ­»óÀÚ¿¡¼­ »õ ¿¬°á ¹öÆ°À» ´©¸¥´Ù. ÀÌÀü¿¡ Ãß°¡Çß´ø µ¥ÀÌÅÍ ¼Ò½º(¾Æ¸¶µµ SQL ¼­¹ö)ÀÇ ¿¬°áâÀÌ ¶ãÅÙµ¥ º¯°æ ¹öÆ°À» ´­·¯ Access·Î º¯°æÇÑ´Ù.

µ¥ÀÌÅÍ °ø±ÞÀÚ´Â OLE DB°¡ ¼±ÅõǾî ÀÖ´Ù. ¾×¼¼½º´Â Àü¿ë °ø±ÞÀÚ°¡ ¾øÀ¸¹Ç·Î OLE DB·Î¸¸ ¿¬°áÇÒ ¼ö ÀÖ´Ù. ¿¬°á Ãß°¡ ´ëÈ­»óÀÚ°¡ ´ÙÀ½°ú °°ÀÌ ¹Ù²ï´Ù.

µ¥ÀÌÅͺ£À̽º ÆÄÀÏ À̸§¶õ¿¡ ã¾Æº¸±â ¹öÆ°À» ´­·¯ C:\ADOTest.mdb ÆÄÀÏÀ» ¼±ÅÃÇÑ´Ù. ¾ÏÈ£°¡ ¼³Á¤µÇ¾î ÀÖ´Ù¸é ¾ÏÈ£µµ ÀÔ·ÂÇØ¾ß Çϴµ¥ ADOTest.mdb¿¡´Â ¾ÏÈ£°¡ ÁöÁ¤µÇ¾î ÀÖÁö ¾Ê¾Æ ÀÌ´ë·Î µÎ¸é µÈ´Ù. È®ÀÎ ¹öÆ°À» ´©¸£¸é ´ÙÀ½ ¿¬°á ¹®ÀÚ¿­ÀÌ »ý¼ºµÈ´Ù.

 

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\ADOTest.mdb

 

Äڵ忡¼­ ÀÛ¼ºÇÑ ¿¬°á ¹®ÀÚ¿­°ú µ¿ÀÏÇÏ´Ù. ¿¬°á ¹®ÀÚ¿­ÀÇ Æ÷¸ËÀ» Àß ¸ð¸¥´Ù¸é ·¹ÆÛ·±½º¸¦ ÂüÁ¶ÇÏ´Â °Íº¸´Ù ¸¶¹ý»ç¸¦ ½ÇÇàÇÏ´Â °ÍÀÌ ´õ ºü¸£´Ù. ´ÙÀ½ ¹öÆ°À» ´©¸£¸é ·ÎÄà µ¥ÀÌÅͺ£À̽º ÆÄÀÏÀ» º¹»çÇÒ °ÍÀΰ¡¸¦ ¹¯´Â´Ù.

C:\¿¡ ÀÖ´Â ADOTest.mdb ÆÄÀÏÀ» ÇÁ·ÎÁ§Æ® Æú´õ·Î º¹»çÇÏ°Ú´À³Ä´Â ¶æÀÌ´Ù. ¾Æ¹«·¡µµ ÇÁ·ÎÁ§Æ®¿¡ Æ÷ÇÔ½ÃÅ°´Â °ÍÀÌ °ü¸®Çϱ⿡ À¯¸®ÇϹǷΠ¿¹¸¦ ¼±ÅÃÇÑ´Ù. ±¸¼º ÆÄÀÏ¿¡ ÀúÀåµÇ´Â ¿¬°á ¹®ÀÚ¿­Àº Àý´ë °æ·Î°¡ ¾Æ´Ï¶ó »ó´ë°æ·Î·Î mdb ÆÄÀÏÀ» ã±â À§Çؼ­ ´ÙÀ½Ã³·³ ¼öÁ¤µÈ´Ù.

 

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\People.mdb

 

ÀÌÈÄÀÇ °úÁ¤Àº SQL ¼­¹ö¿Í µ¿ÀÏÇÏ´Ù. ¿¬°á ¹®ÀÚ¿­À» ±¸¼º ÆÄÀÏ¿¡ ÀúÀåÇÏ°í °³Ã¼ ¼±Åà ´ëÈ­»óÀÚ¿¡¼­ tblPeople¸¦ ¼±ÅÃÇÏ¸é µÈ´Ù. µ¥ÀÌÅÍ ¼Ò½ºÃ¢Àº º° ´Ù¸¦°Ô ¾øÁö¸¸ ¼Ö·ç¼Ç Ž»ö±â´Â Á» ´Ù¸£´Ù.

 

ADOTest.mdb ÆÄÀÏÀÌ ¼Ö·ç¼Ç¿¡µµ Ãß°¡µÇ¾î ÀÖÀ¸¸ç ÇÁ·ÎÁ§Æ® Æú´õ¿¡µµ º¹»çµÇ¾î ÀÖ´Ù. µ¥ÀÌÅÍ ¼Ò½ºÃ¢¿¡¼­ tblPeopleÀ» ²ø¾î Æû¿¡ ¶³¾î¶ß¸®¸é ±×¸®µå ºä°¡ »ý¼ºµÈ´Ù. ÀÌ »óÅ¿¡¼­ ½ÇÇàÇÏ¸é ¾×¼¼½º Å×À̺íÀÇ ³»¿ëÀÌ ±×¸®µå¿¡ ³ªÅ¸³­´Ù.

Debug Æú´õ¸¦ º¸¸é ADOTest.mdb°¡ ¶Ç º¹»çµÇ¾î ÀÖ´Ù. ·ÎÄà µ¥ÀÌÅÍ ÆÄÀÏÀº ÇÁ·ÎÁ§Æ® Æú´õ¿¡µµ º¹»çµÇ°í Ãâ·Â Æú´õ·Îµµ º¹»çµÈ´Ù. ÀÌ·¸°Ô ÀÌÁß º¹»ç¸¦ ÇÏ´Â ÀÌÀ¯´Â µ¥ÀÌÅÍ ÆÄÀÏÀ» ½ÇÇà ÆÄÀÏ°ú Ç×»ó °°ÀÌ µÒÀ¸·Î½á ¾ðÁ¦³ª ½ÇÇà °¡´ÉÇÑ »óÅ·Π¸¸µé±â À§Çؼ­ÀÌ´Ù. ÀÌ·± µ¿ÀÛÀº mdb ÆÄÀÏ ÀÚüÀÇ ¼Ó¼ºÀ¸·Î Á¶Á¤ÇÑ´Ù.

µðÆúÆ®´Â Ç×»ó º¹»çÀε¥ º¹»çÇÏÁö ¾Ê°Å³ª º¯°æµÉ ¶§¸¸ º¹»çÇϵµ·Ï ¼öÁ¤ÇÒ ¼ö ÀÖ´Ù. º¯°æµÉ ¶§¸¸ º¹»çÇϱâ´Â ³¯Â¥¸¦ ºñ±³ÇÏ¿© º¹»ç ¿©ºÎ¸¦ °áÁ¤Çϴµ¥ µ¥ÀÌÅͺ£À̽º ÆÄÀÏÀº ´Ü¼øÈ÷ Àб⸸ Çصµ ³¯Â¥°¡ ¹Ù²î´Â °æ¿ì°¡ ÀÖ¾î º¯°æ ½ÃÁ¡À» Á¤È®ÇÏ°Ô ÆľÇÇϱ⠾î·Æ´Ù. °¡±ÞÀûÀ̸é Ç×»ó º¹»çÇÏ´Â °ÍÀÌ ¾ÈÀüÇÏ´Ù.

·ÎÄà µ¥ÀÌÅÍ ÆÄÀÏÀº µ¥ÀÌÅÍ ¼Ò½º ±¸¼º ¸¶¹ý»ç¸¦ ¾²Áö ¾Ê°íµµ ÇÁ·ÎÁ§Æ®¿¡ Ãß°¡ÇÒ ¼ö ÀÖ´Ù. ÇÁ·ÎÁ§Æ®/±âÁ¸ Ãß°¡ Ç׸ñÀ» ¼±ÅÃÇؼ­ mdb ÆÄÀÏÀ» ÇÁ·ÎÁ§Æ®¿¡ Ãß°¡Çϰųª ¾Æ´Ï¸é ´õ °£´ÜÇÏ°Ô Å½»ö±â¿¡¼­ mdb ÆÄÀÏÀ» ÁöÀÌÀÍ ²ø¾î ¼Ö·ç¼Ç Ž»ö±âÀÇ ÇÁ·ÎÁ§Æ® À̸§¿¡ Åå ¶³¾î¶ß¸®¸é µÈ´Ù. ¸¶¹ý»çº¸´Ù ´õ °£´ÜÇÏ´Ù.

È®ÀåÀÚ¸¦ ÅëÇØ µ¥ÀÌÅͺ£À̽º ÆÄÀÏÀÇ Á¾·ù¸¦ ¾Ë ¼ö ÀÖ°í ÆÄÀÏÀÌ ÀÖ´Â °æ·Î°¡ µå·ÓµÇ¾úÀ¸¹Ç·Î ÀÌ Á¤º¸¸¸À¸·Îµµ µ¥ÀÌÅÍ ¼Ò½º¸¦ ±¸¼ºÇϴµ¥ ÃæºÐÇÏ´Ù. ·ÎÄà µ¥ÀÌÅÍ ÆÄÀÏÀº º¹¼öÀÇ »ç¿ëÀÚ¸¦ Áö¿øÇÏÁö ¸øÇÏÁö¸¸ º¹»ç ¹× »èÁ¦°¡ ÀÚÀ¯·Ó°í °ü¸®Çϱ⵵ Æí¸®ÇÏ´Ù.

OLE DB °ø±ÞÀÚ´Â ¹ü¿ëÀÇ Á¢¼Ó ÀÎÅÍÆäÀ̽ºÀ̹ǷΠÀ¢¸¸ÇÑ µ¥ÀÌÅͺ£À̽º¿¡´Â ´Ù Á¢¼ÓÇÒ ¼ö ÀÖ´Ù. SQL ¼­¹ö¿¡ Á¢¼ÓÇÒ ¶§µµ SQL °ø±ÞÀÚ°¡ ¾Æ´Ñ OLE DB °ø±ÞÀÚ¸¦ ¾µ ¼ö ÀÖ´Ù. ±×·¯³ª OLE DB´Â ºñ°ü¸® Äڵ带 ½ÇÇàÇØ¾ß ÇϹǷΠ¾Æ¹«·¡µµ ´À¸± °ÍÀÌ°í º¸¾È»óÀÇ ¹®Á¦µµ ¹ß»ýÇÒ ¼ö ÀÖ´Ù. Àü¿ë °ø±ÞÀÚ°¡ ÀÖ´Â DBMS´Â °¡±ÞÀûÀ̸é Àü¿ëÀ» ¾²´Â °ÍÀÌ À¯¸®ÇÏ´Ù.

OLE DB¸¦ óÀ½ ¹ßÇ¥ÇÒ ¶§ ¸¶ÀÌÅ©·Î¼ÒÇÁÆ®´Â ÀÌ°Å Çϳª¸¸ ÀÖÀ¸¸é ¼¼»óÀÇ ¸ðµç µ¥ÀÌÅÍ¿¡ ¿¬°áÇÒ ¼ö ÀÖ´Ù°í ±¤°íÇß´Ù. Áö±ÝÀº ´å³ÝÀÇ ÇÑ ¿¬°á ¹æ¹ýÀ¸·Î Àü¶ôÇØ ¹ö·ÈÀ¸¸ç ¼º´Éµµ ÁÁÁö ¾Ê°í Á¦¾àµµ ¸¹´Ù. °ú°ÅÀÇ µå¶óÀ̹ö¸¦ ¹ö¸®Áö ¸øÇØ ÀÓ½ÃÀûÀ¸·Î Áö¿øÇÏ´Â °ÍÀÌ¸ç ¾Æ¸¶ ¸ðµç µ¥ÀÌÅÍ ¼Ò½º¿¡ ´ëÇÑ Àü¿ë °ø±ÞÀÚ°¡ ±¸ºñµÇ¸é ±×¶§´Â ¹ö¸²¹ÞÀ» °ÍÀÌ´Ù. ÀÌ Á¡Àº ODBCµµ ¸¶Âù°¡Áö´Ù. ±×·¸´Ù¸é Áö±ÝÀÇ ADO.NETÀº ¾î¶»°Ô µÉ °ÍÀÎÁöµµ ¿¹Ãø °¡´ÉÇÏ´Ù. ¿µ¿øÇÑ °ÍÀº ¾ø´Ù.

37-1-2.MySQL¿¡ ¿¬°á

MySQLÀº Áß¼Ò ±Ô¸ð ÀÀ¿ë ÇÁ·Î±×·¥¿¡ Á¾Á¾ »ç¿ëµÇ´Â ¿ÀÇ ¼Ò½º µ¥ÀÌÅͺ£À̽ºÀÌ´Ù. ´Ù¾çÇÑ Ç÷§ÆûÀ» Áö¿øÇϸç ƯÈ÷ ¸®´ª½º¿¡¼­ ¾ÆÆÄÄ¡, PHP¿Í ±ÃÇÕÀÌ Àß¸Â¾Æ °Ô½ÃÆÇ¿ëÀ¸·Î ¸¹ÀÌ È°¿ëµÈ´Ù. ¼±(Sum)¿¡ ¸Å°¢µÇ¾ú´Ù°¡ ¿À¶óŬ·Î ¼ÒÀ¯±ÇÀÌ ³Ñ¾î°¡ À¯·áÈ­µÇ¾ú´Ù. À¯·áÈ­ Á¤Ã¥¿¡ ¹Ý¹ßÇÏ¿© ÇÙ½É °³¹ßÀÚ°¡ µ¶¸³ÇÏ¿© ¸¸µç MariaDBµµ ¸¹ÀÌ »ç¿ëµÈ´Ù. Á¦ÀÛ»ç ȨÆäÀÌÁö¿¡¼­ ÇÁ·Î±×·¥Àº ¹°·Ð ¼Ò½º¿Í µå¶óÀ̹ö±îÁö ´Ù¿î·Îµå¹ÞÀ» ¼ö ÀÖ´Ù.

 

http://www.mysql.com

 

»ó¾÷¿ë ¹öÀüÀº À¯·áÀÌÁö¸¸ Ä¿¹ÂƼ´Ï ¹öÀüÀº °è¼Ó ¹«·á·Î »ç¿ëÇÒ ¼ö ÀÖ´Ù. ÇöÀç ÃֽŠ¹öÀüÀº 8.0.15ÀÌµÇ ´õ ÃֽŠ¹öÀüÀÌ ¹ßÇ¥µÇ¾î ÀÖ´Ù¸é °¡±ÞÀû ÃֽŠ¹öÀüÀ» ¾²´Â °ÍÀÌ ÁÁ´Ù. À©µµ¿ì¿ë 64ºñÆ® ¼³Ä¡ ÆÄÀÏÀ» ¹Þ¾Æ ¼³Ä¡ÇÑ´Ù. ¼³Ä¡ ¹æ¹ýÀº ¹öÀüÀ̳ª ȯ°æ¿¡ µû¶ó Á¶±Ý¾¿ ´Ù¸¥µ¥ ÇÑ±Û È¯°æ°ú Àß ¸ÂÁö ¾Ê´Â °æ¿ì°¡ ÀÖ¾î °¡±ÞÀû ÃֽŠÀνºÅç·¯¸¦ »ç¿ëÇÏ´Â °ÍÀÌ ÁÁ´Ù.

°³¹ß¿ëÀ¸·Î »ç¿ëÇÒ ¶§´Â ù ¹ø° ¿É¼ÇÀÎ Developer Default¸¦ ¼±ÅÃÇÏ´Â °ÍÀÌ ¹«³­ÇÏ´Ù. ¼­¹ö ÇÁ·Î±×·¥°ú °³¹ßȯ°æ, ´å³Ý¿ë Ä¿³ØÅÍ, ¹®¼­±îÁö °°ÀÌ ¼³Ä¡µÈ´Ù. ¿É¼ÇÀº µðÆúÆ®°¡ ¹«³­ÇÏ°Ô ¼³Á¤µÇ¾î ÀÖ¾î Ưº°ÇÑ ÀÌÀ¯°¡ ¾ø´Â ÇÑ º¯°æÇÏÁö ¾Ê°í ¹Þ¾ÆµéÀÌ´Â °ÍÀÌ ÁÁ´Ù. ·çÆ® ±ÇÇÑÀÇ Æнº¿öµå´Â °£´ÜÇÏ°Ô asdf·Î ¼³Á¤Çß´Ù. ¹°·Ð ½Ç¹« ȯ°æ¿¡¼­´Â ´õ º¹ÀâÇÑ ¾ÏÈ£¸¦ ¼³Á¤ÇØ¾ß ÇÑ´Ù.

 

ÀÌÈÄÀÇ ¼³Ä¡ °úÁ¤Àº Ưº°ÇÑ »çÇ× ¾øÀÌ Next ¹öÆ°¸¸ ¿­½ÉÈ÷ ´­·¯ÁÖ¸é µÈ´Ù. ±×·¡ÇÈ È¯°æ¿¡¼­ ½ÇÇàµÇ´Â MySQL ¿öÅ©º¥Ä¡°¡ ÀÖÁö¸¸ óÀ½ ¹è¿ï ¶§´Â ¿ÀÈ÷·Á ´õ Çò°¥¸®¹Ç·Î ¸í·ÉÇà¿¡¼­ ½Ç½ÀÀ» ÁøÇàÇØ º¸ÀÚ. ´ÙÀ½ ¸í·ÉÀ¸·Î ADOTest µ¥ÀÌÅͺ£À̽º¸¦ »ý¼ºÇÑ´Ù.

 

mysql> CREATE DATABASE ADOTest;

mysql> USE ADOTest;

 

SQL ±¸¹®Àº ±¹Á¦ Ç¥ÁØÀ» µû¸£¹Ç·Î SQL ¼­¹ö¿¡¼­¿Í °ÅÀÇ °°Àº ¹®¹ýÀ» »ç¿ëÇÑ´Ù. ´ÙÀ½Àº Å×À̺íÀ» »ý¼ºÇÏ°í »ùÇà µ¥ÀÌÅ͵µ »ðÀÔÇÑ´Ù. MySQL ÀÚü´Â ÇѱÛÀ» ¿Ïº®ÇÏ°Ô Áö¿øÇÏÁö¸¸ µðÆúÆ® ¹®ÀÚ¼ÂÀÌ ANSIÀÌ°í ´å³ÝÀº À¯´ÏÄÚµå¶ó Àß ¸ÂÁö ¾Ê´Ù. ¼³Á¤À» º¯°æÇÏ¸é ¹Ù²Ü ¼öµµ ÀÖÁö¸¸ ¿©·¯ ¸ð·Î ¹ø°Å·Î¿ì¹Ç·Î ¿µ¹®À¸·Î µ¥ÀÌÅ͸¦ ÀÔ·ÂÇß´Ù.

 

CREATE TABLE tblPeople

(

         Name VARCHAR(20) PRIMARY KEY,

         Age INT NOT NULL,

         Male BIT NOT NULL

);

 

INSERT INTO tblPeople VALUES ('Jung Woo Sung', 36, 1);

INSERT INTO tblPeople VALUES ('Ko So Young', 32, 0);

INSERT INTO tblPeople VALUES ('Bae Yong Jun', 37, 1);

INSERT INTO tblPeople VALUES ('Kim Tae Hee', 29, 0);

 

ÀÌ Å×À̺íÀ» ÀÐ¾î ±×¸®µå¿¡ Ãâ·ÂÇØ º¸ÀÚ. »õ ÇÁ·ÎÁ§Æ®¸¦ ½ÃÀÛÇÏ°í ¸ÕÀú ÂüÁ¶¸¦ Ãß°¡ÇÑ´Ù. MySQL °ø±ÞÀÚ´Â ºñÁÖ¾ó ½ºÆ©µð¿À¿Í ÇÔ²² ¼³Ä¡µÇ´Â °ÍÀÌ ¾Æ´Ï¹Ç·Î ÇÁ·ÎÁ§Æ®º°·Î µû·Î Ãß°¡ÇØ¾ß ÇÑ´Ù. ¼Ö·ç¼Ç Ž»ö±âÀÇ ÂüÁ¶ ³ëµå¿¡¼­ Æ˾÷ ¸Þ´º¸¦ ¿­¾î ÂüÁ¶ Ãß°¡ Ç׸ñÀ» ¼±ÅÃÇÏ°í MySQL.Data¸¦ Ãß°¡ÇÑ´Ù.

ÀÌ ¾î¼Àºí¸®¿¡ MySQLÀ» ¾×¼¼½ºÇÏ´Â ´å³Ý Ŭ·¡½º°¡ Á¦°øµÇ¸ç Ŭ·¡½º À̸§Àº MySql Á¢µÎ¾î·Î ½ÃÀ۵ȴÙ. Æû¿¡ ¸®½ºÆ® ¹Ú½º¸¦ Çϳª ¹èÄ¡ÇÏ°í MySQL¿¡¼­ µ¥ÀÌÅ͸¦ Àоî¿Í Ãâ·ÂÇØ º¸ÀÚ.

 

MySqlCon

using System; ~ using System.Windows.Forms;

using MySql.Data.MySqlClient;

 

namespace MySqlCon {

             public partial class Form1 : Form {

                           public Form1() {

                                        InitializeComponent();

                           }

 

                           private void Form1_Load(object sender, EventArgs e) {

                                        MySqlConnection Con = new MySqlConnection();

                                        Con.ConnectionString = "Data Source=localhost;Database=ADOTest;"

                                                     + "User Id=root;Password=asdf";

                                        Con.Open();

                                        string Rec;

                                        MySqlCommand Com = new MySqlCommand("SELECT * FROM tblPeople", Con);

                                        MySqlDataReader R;

                                        R = Com.ExecuteReader();

                                        listBox1.Items.Clear();

                                        while (R.Read()) {

                                                     Rec = string.Format("À̸§ : {0}, ³ªÀÌ : {1}, ¼ºº° : {2}",

                                                                   R["Name"], R["Age"], R["Male"]);

                                                     listBox1.Items.Add(Rec);

                                        }

                                        R.Close();

                                        Con.Close();

                           }

             }

}

 

Äڵ带 º¸´Ù½ÃÇÇ ³×ÀÓ½ºÆäÀ̽º¿¡ ´ëÇÑ using¹®°ú Ŭ·¡½º¸í¸¸ ´Ù¸¦»Ó ÀüüÀûÀÎ ±¸Á¶´Â °ÅÀÇ °°´Ù. ¿¬°áÇÏ°í Äõ¸®¹®À» ½ÇÇàÇÏ°í ¸®´õ·Î °á°ú¼ÂÀ» ÀÐÀ¸¸é µÈ´Ù.

µÎ °³ÀÇ °ø±ÞÀÚ¿¡ ´ëÇؼ­¸¸ ½Ç½ÀÇØ º¸¾Ò´Âµ¥ ÀÌ ¿Ü¿¡µµ ¼ö¸¹Àº °ø±ÞÀÚ°¡ ÀÖ´Ù. ÀÎÅͳÝÀ» °Ë»öÇØ º¸¸é À¢¸¸Å­ ¾Ë·ÁÁø Á¦Ç°¿¡ ´ëÇؼ­´Â ´å³Ý °ø±ÞÀÚ°¡ ¸ðµÎ Á¦°øµÇ¹Ç·Î ´Ù¿î·Îµå¹Þ¾Æ ¼³Ä¡Çϸé SQL ¼­¹ö¿Í °ÅÀÇ µ¿ÀÏÇÑ ÄÚµå·Î È°¿ëÇÒ ¼ö ÀÖ´Ù. ÀÎÁõ ¹æ¹ýÀ̳ª ¿¬°á ¹®ÀÚ¿­ Æ÷¸Ë µî¿¡¼­¸¸ Á¶±Ý¾¿ Â÷ÀÌ°¡ ³¯»Ó ÀÎÅÍÆäÀ̽º´Â ÅëÀϵǾî ÀÖ´Ù.