안드로이드 플랫폼 내에 데이터베이스 삽입하기

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>d:

D:\>cd Tools

D:\Tools>cd android-sdk

D:\Tools\android-sdk>cd platforms

D:\Tools\android-sdk\platforms>cd ..

D:\Tools\android-sdk>cd platform-tools

D:\Tools\android-sdk\platform-tools>dir
 D 드라이브의 볼륨에는 이름이 없습니다.
 볼륨 일련 번호: F470-78C8

 D:\Tools\android-sdk\platform-tools 디렉터리

2012-10-18  오후 08:18    <DIR>          .
2012-10-18  오후 08:18    <DIR>          ..
2012-10-18  오후 08:18           851,968 aapt.exe
2012-10-18  오후 08:18           191,488 adb.exe
2012-10-18  오후 08:18            96,256 AdbWinApi.dll
2012-10-18  오후 08:18            60,928 AdbWinUsbApi.dll
2012-10-18  오후 08:18           275,456 aidl.exe
2012-10-18  오후 08:18    <DIR>          api
2012-10-18  오후 08:18           161,280 dexdump.exe
2012-10-18  오후 08:18             2,618 dx.bat
2012-10-18  오후 08:18           140,800 fastboot.exe
2012-10-18  오후 08:18    <DIR>          lib
2012-10-18  오후 08:18        22,601,216 llvm-rs-cc.exe
2012-10-18  오후 08:18           401,602 NOTICE.txt
2012-10-18  오후 08:18    <DIR>          renderscript
2012-10-18  오후 08:18               211 source.properties
              11개 파일          24,783,823 바이트
               5개 디렉터리  45,410,197,504 바이트 남음

D:\Tools\android-sdk\platform-tools>adb shell
root@android:/ # ls
ls
acct
cache
config
d
data
default.prop
dev
etc
init
init.goldfish.rc
init.rc
init.trace.rc
init.usb.rc
mnt
proc
root
sbin
sdcard
sys
system
ueventd.goldfish.rc
ueventd.rc
vendor
root@android:/ # cd data
cd data
root@android:/data # cd data
cd data
root@android:/data/data # ls
ls
com.android.backupconfirm
com.android.browser
com.android.calculator2
com.android.calendar
com.android.camera
com.android.certinstaller
com.android.contacts
com.android.customlocale2
com.android.defcontainer
com.android.deskclock
com.android.development
com.android.email
com.android.emulator.connectivity.test
com.android.emulator.gps.test
com.android.exchange
com.android.fallback
com.android.gallery
com.android.gesture.builder
com.android.htmlviewer
com.android.inputdevices
com.android.inputmethod.latin
com.android.inputmethod.pinyin
com.android.keychain
com.android.launcher
com.android.mms
com.android.music
com.android.netspeed
com.android.packageinstaller
com.android.phone
com.android.protips
com.android.providers.applications
com.android.providers.calendar
com.android.providers.contacts
com.android.providers.downloads
com.android.providers.downloads.ui
com.android.providers.drm
com.android.providers.media
com.android.providers.settings
com.android.providers.telephony
com.android.providers.userdictionary
com.android.quicksearchbox
com.android.sdksetup
com.android.settings
com.android.sharedstoragebackup
com.android.smoketest
com.android.smoketest.tests
com.android.soundrecorder
com.android.speechrecorder
com.android.systemui
com.android.vpndialogs
com.android.wallpaper.livepicker
com.android.widgetpreview
com.example.android.apis
com.example.android.livecubes
com.example.android.softkeyboard
com.example.helloandroid
com.svox.pico
jp.co.omronsoft.openwnn
root@android:/data/data # ls
ls
com.android.backupconfirm
com.android.browser
com.android.calculator2
com.android.calendar
com.android.camera
com.android.certinstaller
com.android.contacts
com.android.customlocale2
com.android.defcontainer
com.android.deskclock
com.android.development
com.android.email
com.android.emulator.connectivity.test
com.android.emulator.gps.test
com.android.exchange
com.android.fallback
com.android.gallery
com.android.gesture.builder
com.android.htmlviewer
com.android.inputdevices
com.android.inputmethod.latin
com.android.inputmethod.pinyin
com.android.keychain
com.android.launcher
com.android.mms
com.android.music
com.android.netspeed
com.android.packageinstaller
com.android.phone
com.android.protips
com.android.providers.applications
com.android.providers.calendar
com.android.providers.contacts
com.android.providers.downloads
com.android.providers.downloads.ui
com.android.providers.drm
com.android.providers.media
com.android.providers.settings
com.android.providers.telephony
com.android.providers.userdictionary
com.android.quicksearchbox
com.android.sdksetup
com.android.settings
com.android.sharedstoragebackup
com.android.smoketest
com.android.smoketest.tests
com.android.soundrecorder
com.android.speechrecorder
com.android.systemui
com.android.vpndialogs
com.android.wallpaper.livepicker
com.android.widgetpreview
com.example.android.apis
com.example.android.livecubes
com.example.android.softkeyboard
com.example.helloandroid
com.example.todo
com.svox.pico
jp.co.omronsoft.openwnn
root@android:/data/data # cd com.example.todo
cd com.example.todo
root@android:/data/data/com.example.todo # ls
ls
cache
databases
lib
root@android:/data/data/com.example.todo # cd database
cd database
/system/bin/sh: cd: /data/data/com.example.todo/database: No such file or direct
ory
2|root@android:/data/data/com.example.todo # cd databases
cd databases
root@android:/data/data/com.example.todo/databases # ls
ls
todo.db
todo.db-journal
root@android:/data/data/com.example.todo/databases # sqlite3 todo.db
sqlite3 todo.db
SQLite version 3.7.11 2012-03-20 11:35:50
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from todo;
select * from todo;
sqlite> insert into todo values(1,'test','2012-10-18','20:53:00';
insert into todo values(1,'test','2012-10-18','20:53:00';
Error: near ";": syntax error
sqlite> insert into todo values(1,'test','2012-10-18','20:53:00');
insert into todo values(1,'test','2012-10-18','20:53:00');
sqlite> insert into todo values (2,'할일','2012-10-18','20:53:00');
insert into todo values (2,'할일','2012-10-18','20:53:00');
sqlite> select * from todo;
select * from todo;
1|test|2012-10-18|20:53:00
2|할일|2012-10-18|20:53:00
sqlite>