{"id":9007,"date":"2010-04-02T09:34:00","date_gmt":"2010-04-02T09:34:00","guid":{"rendered":"http:\/\/melotopia.net\/b\/?p=9007"},"modified":"2010-04-02T09:34:00","modified_gmt":"2010-04-02T09:34:00","slug":"sqlite-on-vb-net","status":"publish","type":"post","link":"http:\/\/melotopia.net\/b\/?p=9007","title":{"rendered":"SQLite on VB.net"},"content":{"rendered":"
\n SQLite\ub294 \ub9e4\uc6b0 \uac00\ubcbc\uc6b4 SQL DB\ud504\ub85c\uadf8\ub7a8\uc774\ub2e4. \uc11c\ubc84\uac00 \uc5c6\uace0, \ud504\ub85c\uadf8\ub7a8\uc5d0 \ubd99\uc5b4\uc11c \ub3d9\uc791\ud558\ub294 DLL \ub610\ub294 EXE\ud30c\uc77c \ud615\ud0dc\ub85c \uc2e4\ud589\ub41c\ub2e4. \uc790\uc138\ud55c \uc124\uba85\uc740 \uc0dd\ub7b5\ud55c\ub2e4. Visual basic 2005\uc5d0\uc11c SQLite\ub97c \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ud558\ub294\uc9c0 \uc54c\uc544\ubcf4\uc790.
\n
\n \uc544\ub798 \ub9c1\ud06c\uc5d0 \uac00\uba74 \uc880 \ub354 \uc0c1\uc138\ud55c \uc124\uba85\uacfc Tutorial\uc774 \uc788\ub2e4.
\n
\n
\n http:\/\/www.kirupa.com\/net\/sqllite_vb_pg1.htm
\n <\/a>
\n
\n \uc704 \ub9c1\ud06c\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 Tutorial\uc740 VS 2008\uc774\ub098 VS 2010\ubc84\uc804\uc778 \uac83 \uac19\ub2e4. \ub09c 2005\ubc84\uc804\ub9cc \uac16\uace0 \uc788\uc5b4\uc11c \uc2e4\ud589\uc2dc\ud0ac \uc218\uac00 \uc5c6\ub2e4.<\/p>\n

\uc77c\ub2e8, \uc544\ub798 \ub9c1\ud06c\uc5d0 \uac00\uc11c System.Data.SQLite \uc758 \ucd5c\uc2e0 \ubc84\uc804\uc744 \ubc1b\ub294\ub2e4. \uc774\uac83\uc740 Visual Basic\uc5d0\uc11c SQLite\ub97c \uc4f8 \uc218 \uc788\uac8c \ud574\uc8fc\ub294 \ucef4\ud3ec\ub10c\ud2b8\ub4e4\uc744 \ubaa8\uc544\ub454 \uac83\uc774\ub2e4.
\n
\n
\n http:\/\/sqlite.phxsoftware.com\/
\n <\/a><\/p>\n

\uc81c\ub300\ub85c \uc124\uce58\ud588\ub2e4\uba74
\n <\/p>\n

\n\"\"\n<\/div>\n

\ub3c4\uad6c\uc0c1\uc790\uc5d0\uc11c SQLite\ub77c\ub294 \uac83\uc744 \ucc3e\uc744 \uc218 \uc788\uc744 \uac83\uc774\ub2e4. \uc774\uc81c \uc2dc\uc791\uc774\ub2e4.<\/p>\n

1\ub2e8\uacc4 – DB\uc0dd\uc131\ud558\uae30
\n
\n \ubb58 \ud558\ub4e0\uc9c0, \uc77c\ub2e8 \uac16\uace0 \ub180 \ub300\uc0c1\uc774 \uc788\uc5b4\uc57c \uc791\uc5c5\uc744 \ud560 \uc218 \uc788\ub2e4. DB\ub97c \ub9cc\ub4e4\uc5b4 \ubcf4\uc790.<\/p>\n

\uc6b0\uc120, SQLite.SQLiteConnection \uac1d\uccb4 \ud558\ub098\ub97c \ub9cc\ub4e4\uc5b4\uc57c \ud55c\ub2e4. SQLconnect\ub77c\ub294 \uc778\uc2a4\ud134\uc2a4 \uc774\ub984\uc744 \uc8fc\uc790.
\n <\/p>\n

\n Dim SQLconnect As New SQLite.SQLiteConnection()\n <\/div>\n

\uc774\ub300\ub85c \uc120\uc5b8\ud558\uba74, \uc544\ub9c8 \ubb50\uac00 \uc5c6\ub2e4\uace0 \ud560 \uac83\uc774\ub2e4. \uadf8\ub7ec\ub2c8\uae4c, \uc704\uc5d0 \ub3c4\uad6c\uc0c1\uc790\uc5d0\uc11c SQLiteConnection \ud558\ub098\ub97c \ub04c\uc5b4\ub2e4\uac00 \ucc3d\uc5d0 \uac16\ub2e4 \ub454\ub2e4.
\n <\/p>\n

\n\"\"\n<\/div>\n

\uadf8\ub7fc \uc774\uc81c SQLiteConnection\uc744 \uc4f8 \uc218 \uc788\uac8c \ub41c\ub2e4.<\/p>\n

\ubc29\uae08 \ub9cc\ub4e0 SQLconnect\ub97c DB\uc5d0 \uc5f4\uc5b4\uc57c \ud558\ub294\ub370, \ub9e4\uc6b0 \uac04\ub2e8\ud558\ub2e4. \ub2e4\uc74c\uc758 \uc138 \ubb38\uc7a5\uc774\uba74 \ub41c\ub2e4.
\n <\/p>\n

\n SQLconnect.ConnectionString = “Data Source=” & dbfile & “;”
\n
\n SQLconnect.Open()
\n
\n SQLconnect.Close()\n <\/div>\n

\uc5ec\uae30\uc11c dbfile\uc740 DB\ub85c \uc0ac\uc6a9\ud560 \ud30c\uc77c\uc758 \uacbd\ub85c\uc774\ub2e4. SQLite\ub294 \ud30c\uc77c \ud655\uc7a5\uc790\ub85c db3\uc744 \uc0ac\uc6a9\ud558\uba70, \ud30c\uc77c 1\uac1c\uac00 DB 1\uac1c\uc5d0 \ud574\ub2f9\ud55c\ub2e4. dbfile\uc758 \uacbd\ub85c\ub294 SaveFileDialog \uac19\uc740\ub370\uc11c \uc801\ub2f9\ud788 \uc9c0\uc815\ud574\uc11c \uc54c\ub824\uc8fc\uba74 \ub41c\ub2e4.<\/p>\n

\uc544\ubb34\ud2bc \uc5ec\uae30\uae4c\uc9c0 \ud588\uc73c\uba74 DB\ud30c\uc77c\uc774 \ud558\ub098 \uc0dd\uc131\ub418\uc5b4 \uc788\uc744 \uac83\uc774\ub2e4. \ubc29\uae08 \uc6b0\ub9ac\uac00 \ud55c \uac83\uc740 \uc0c8\ub85c\uc6b4 DB\ud30c\uc77c\uc744 \ub9cc\ub4e4\uc5b4\uc11c, \uc5f4\uc5c8\ub2e4\uac00, \ub2eb\uc740 \uac83\uc774\ub2e4.<\/p>\n

2\ub2e8\uacc4 – DB\uc5d0 \ud14c\uc774\ube14 \ub9cc\ub4e4\uae30
\n
\n \uc54c\ub2e4\uc2dc\ud53c SQL\ub85c DB\ub97c \uac16\uace0 \ub180\uae30 \uc704\ud574\uc11c\ub294, DB\uac00 \uc788\uc5b4\uc57c \ud558\uace0, \uadf8 \uc548\uc5d0 Table\uc774 \uc788\uc5b4\uc57c \ud558\uace0, \uadf8 \uc548\uc5d0 Column\uacfc Record\uac00 \uc788\uc5b4\uc57c \ud55c\ub2e4. \uc21c\uc11c\ub300\ub85c \ud615\uc131\ud574\uc57c \ud558\ub294\ub370, \uc77c\ub2e8 \ud14c\uc774\ube14\ubd80\ud130 \ub9cc\ub4e4\uc790.<\/p>\n

\uc774 \uc791\uc5c5\uc740, \uc55e\uc5d0 1\ub2e8\uacc4\uc5d0\uc11c \ud588\ub358 \uba85\ub839\uc5b4 \uc911, \uc77c\ub2e8 SQLconnect.Open()\uae4c\uc9c0\ub294 \ub611\uac19\ub2e4. \uc65c\ub0d0\ud558\uba74, \ubb54\uac00 \uc791\uc5c5\uc744 \ud558\ub824\uba74 \uc77c\ub2e8 DB\ub97c \uc5f4\uc5b4\uc57c \ud558\uae30 \ub54c\ubb38\uc774\ub2e4. \uacf5\ucc45\uc5d0 \ubb54\uac00\ub97c \uc801\uae30 \uc704\ud574\uc11c\ub294 \uc77c\ub2e8 \uacf5\ucc45\uc744 \ud3bc\uccd0\uc57c \ud558\uc9c0 \uc54a\uaca0\ub294\uac00? \ub530\ub77c\uc11c, SQLconnect.Open()\uae4c\uc9c0\ub294 \uc2e4\ud589\ud588\ub2e4 \uce58\uace0, SQLconnect.Close()\ub294 \uc544\uc9c1 \uc2e4\ud589\ud558\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\uc774\ub2e4. \uc989, DB\uac00 \uc5f4\ub824\uc788\ub294 \uc0c1\ud0dc\uc5d0\uc11c \ub2e4\uc74c\uacfc \uac19\uc740 \ucf54\ub4dc\ub97c \uc368\ub123\uc73c\uba74 \ub41c\ub2e4.<\/p>\n

\n SQLcommand = SQLconnect.CreateCommand
\n
\n SQLcommand.CommandText = “CREATE TABLE tablename( tablespecification );”
\n
\n SQLcommand.ExecuteNonQuery()
\n
\n SQLcommand.Dispose()
\n \n<\/div>\n

\n SQLcommand\ub77c\ub294 \uac1d\uccb4\ub97c \ub3c4 \ub9cc\ub4e0\ub2e4. \uc774 \uac1d\uccb4\ub294 SQLconnect.CreateCommand\ub77c\ub294 \ud074\ub798\uc2a4\uc758 \uac1d\uccb4\uc774\ub2e4. \ud558\uc9c0\ub9cc \uc774\ub300\ub85c \ud558\uba74 \ub610 \ubb54\uac00 \uc548\ub41c\ub2e4\uace0 \ud560 \uc218\ub3c4 \uc788\ub2e4.<\/p>\n

\n\"\"\n<\/div>\n

\uc774 \uacbd\uc6b0, \uc704\uc640 \uac19\uc774 SQLiteCommand\ub77c\ub294 \ucef4\ud3ec\ub10c\ud2b8\ub97c \uac16\ub2e4\uac00 \ub07c\uc6cc\uc900\ub2e4. \uadf8\ub7fc \uc774\uc81c SQLconnect.CreateCommand\ub97c \uc4f8 \uc218 \uc788\uac8c \ub41c\ub2e4.
\n
\n \uadf8 \ub2e4\uc74c, SQLcommand.CommandText\uc5d0\ub294 \ud14c\uc774\ube14\uc744 \ub9cc\ub4dc\ub294 SQL\uba85\ub839\ubb38\uc774 \ub4e4\uc5b4\uac00\uba74 \ub41c\ub2e4. \ub2e4\ub4e4 \uc54c\ub2e4\uc2dc\ud53c CREATE TABLE\uc774 \ubc14\ub85c \uadf8 \uba85\ub839\uc774\ub2e4. SQL\uc5d0\uc11c \ud14c\uc774\ube14\uc744 \uc5b4\ub5bb\uac8c \ub9cc\ub4dc\ub294\uc9c0\ub294 SQL\ucc45\uc744 \ucc38\uace0\ud558\uc790. \uc544\ubb34\ud2bc, \uc5b4\ub5a4 \uba85\ub839\uc744 \ub0b4\ub9b4 \uac83\uc778\uc9c0 \uc9c0\uc815\uc744 \ud588\uc73c\ub2c8\uae4c, \uc774\uc81c SQLcommand.ExecuteNonQuery()\ub97c \uc2e4\ud589\uc2dc\ud0a8\ub2e4. \uc774 \uba85\ub839\uc5b4\ub294 CREATE, INSERT, UPDATE, DELETE\uac19\uc740 DB\uc758 \ub0b4\uc6a9\uc744 \ubc14\uafb8\ub294 \uac83\ub4e4\uc5d0 \ub300\ud55c \uba85\ub839\uc774\ub2e4.<\/p>\n

\ub208\uce58\ucc44\uc57c \ud558\ub294 \ubd80\ubd84\uc740, SQLite\ub97c \uc4f0\ub824\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ud558\uba74 \ub41c\ub2e4\ub294 \uac83\uc774\ub2e4.
\n
\n 1. DB\ub97c \uc5f0\ub2e4
\n
\n 2. SQLCommand \uac1d\uccb4\uc5d0 SQL\uba85\ub839\uc5b4\ub97c \uc785\ub825\ud55c\ub2e4.
\n
\n 3. \uadf8 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\uc2dc\ud0a8\ub2e4.
\n
\n 4. \uba85\ub839\uc5b4 \uac1d\uccb4\uc640 DB\uac1d\uccb4\ub97c \ub2eb\ub294\ub2e4.<\/p>\n

\uadf8\uac74 \uadf8\ub807\uace0, \ud14c\uc774\ube14 \ub9cc\ub4dc\ub294\uac74 CREATE\ub85c \ud558\uba74 \ub418\uace0, \uac70\uae30\uc5d0 \ub0b4\uc6a9 \ub123\ub294\uac74 INSERT\ub791 UPDATE\ub85c \ud558\uba74 \ub418\uace0 \uc9c0\uc6b8\uac70\uba74 DELETE\ub85c \ud558\uba74 \ub418\ub294\ub370, \ub123\uc740\uac78 \uc77d\uc5b4\uc624\ub824\uba74?<\/p>\n

\uc774\uc81c SQL\uc758 \uac00\uc7a5 \uc911\uc694\ud55c \uad6c\ubb38\uc778 SELECT\ub97c \ud574\ubcfc \ucc28\u008e?
\n
\n \uc55e\uc5d0\uc11c SQLcommand\uc758 SQLcommand.CommandText\uc5d0\ub2e4\uac00 SELECT \uba85\ub839\uc5b4\uc640 \uadf8\uc5d0 \ub530\ub978 \uad6c\ubb38\uc744 \uc785\ub825\ud558\ub294 \uac83 \uae4c\uc9c0\ub294 \ub611\uac19\ub2e4. \uadf8\ub7f0\ub370, \uc774\ubc88\uc5d4 \uc2e4\ud589\uc2dc\ucf1c\uc57c \ud558\ub294 \uba85\ub839\uc5b4\uac00 \ub2e4\ub974\ub2e4.<\/p>\n

\n Dim SQLreader As SQLiteDataReader = SQLcommand.ExecuteReader()\n <\/div>\n

\n \uc5ec\uae30\uc11c SQLreader\ub294 \uadf8\ub0e5 \ud3c9\ubc94\ud55c \ubc30\uc5f4\uc774\ub2e4. \ubcc4\uac70 \uc5c6\ub2e4. TABLE\uc5d0\uc11c \uc9c0\uc815\ud55c column\uc774 \uc21c\uc11c\ub300\ub85c \ub4e4\uc5b4\uac00 \uc788\uc744 \ubfd0\uc774\ub2e4. SQLreader(0)\ud558\uba74 TABLE\uc758 \uac00\uc7a5 \uccab\ubc88\uc9f8 \uc5f4\uc5d0 \uc788\ub294 \uc560\ub4e4\uc758 column\uc774 \ucb49 \ub4e4\uc5b4\uac00 \uc788\ub2e4.<\/p>\n

\uc790\uc138\ud55c\uac74 \uc880 \ub354 \uc5f0\uad6c\ud574 \ubd10\uc57c\uaca0\ub2e4. \uae30\ub85d\uc744 \uc704\ud55c \uae00\uc4f0\uae30\ub294 \uc5ec\uae30\uae4c\uc9c0. \ub098\ub3c4 \uc798 \ubaa8\ub984.
\n <\/p>\n

\n
\n
\n\"\uc2e0\uace0\"
\n<\/a>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

SQLite\ub294 \ub9e4\uc6b0 \uac00\ubcbc\uc6b4 SQL DB\ud504\ub85c\uadf8\ub7a8\uc774\ub2e4. \uc11c\ubc84\uac00 \uc5c6\uace0, \ud504\ub85c\uadf8\ub7a8\uc5d0 \ubd99\uc5b4\uc11c \ub3d9\uc791\ud558\ub294 DLL \ub610\ub294 EXE\ud30c\uc77c \ud615\ud0dc\ub85c \uc2e4\ud589\ub41c\ub2e4. \uc790\uc138\ud55c \uc124\uba85\uc740 \uc0dd\ub7b5\ud55c\ub2e4. Visual basic 2005\uc5d0\uc11c SQLite\ub97c \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ud558\ub294\uc9c0 \uc54c\uc544\ubcf4\uc790. \uc544\ub798 \ub9c1\ud06c\uc5d0 \uac00\uba74 \uc880 \ub354 \uc0c1\uc138\ud55c \uc124\uba85\uacfc Tutorial\uc774 \uc788\ub2e4. http:\/\/www.kirupa.com\/net\/sqllite_vb_pg1.htm \uc704 \ub9c1\ud06c\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 Tutorial\uc740 VS 2008\uc774\ub098 VS 2010\ubc84\uc804\uc778 \uac83 \uac19\ub2e4. \ub09c 2005\ubc84\uc804\ub9cc \uac16\uace0 \uc788\uc5b4\uc11c \uc2e4\ud589\uc2dc\ud0ac \uc218\uac00 \uc5c6\ub2e4. \uc77c\ub2e8, \uc544\ub798 \ub9c1\ud06c\uc5d0 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[12],"tags":[],"class_list":["post-9007","post","type-post","status-publish","format-standard","hentry","category-12"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8o6gA-2lh","jetpack-related-posts":[],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=\/wp\/v2\/posts\/9007","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9007"}],"version-history":[{"count":0,"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=\/wp\/v2\/posts\/9007\/revisions"}],"wp:attachment":[{"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9007"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}