关于android中使用SQLite数据库的查询基本 *** 作.贴上代码.

sqlite\.classpath

......\.project

......\.settings\org.eclipse.jdt.core.prefs

......\AndroidManifest.xml

......\bin\AndroidManifest.xml

......\...\classes\mars\sqlite3\BuildConfig.class

......\...\.......\....\.......\db\DatabaseHelper.class

......\...\.......\....\.......\R$attr.class

......\...\.......\....\.......\R$drawable.class

......\...\.......\....\.......\R$id.class

......\...\.......\....\.......\R$layout.class

......\...\.......\....\.......\R$string.class

......\...\.......\....\.......\R.class

......\...\.......\....\.......\SQLiteActivity$CreateListener.class

......\...\.......\....\.......\SQLiteActivity$InsertListener.class

......\...\.......\....\.......\SQLiteActivity$QueryListener.class

......\...\.......\....\.......\SQLiteActivity$UpdateListener.class

......\...\.......\....\.......\SQLiteActivity$UpdateRecordListener.class

......\...\.......\....\.......\SQLiteActivity.class

......\...\classes.dex

......\...\dexedLibs\annotations-228642ec9c33a1a0b73883a45604ffcd.jar

......\...\jarlist.cache

......\...\res\drawable-hdpi\icon.png

......\...\...\.........ldpi\icon.png

......\...\...\.........mdpi\icon.png

......\...\resources.ap_

......\...\sqlite.apk

......\gen\mars\sqlite3\BuildConfig.java

......\...\....\.......\R.java

......\project.properties

......\res\drawable-hdpi\icon.png

......\...\.........ldpi\icon.png

......\...\.........mdpi\icon.png

......\...\layout\main.xml

......\...\values\strings.xml

......\src\mars\sqlite3\db\DatabaseHelper.java

......\...\....\.......\SQLiteActivity.java

......\bin\classes\mars\sqlite3\db

......\...\.......\....\sqlite3

......\src\mars\sqlite3\db

......\bin\classes\mars

......\...\res\drawable-hdpi

......\...\...\drawable-ldpi

......\...\...\drawable-mdpi

......\gen\mars\sqlite3

......\src\mars\sqlite3

......\bin\classes

......\...\dexedLibs

......\...\res

......\gen\mars

......\res\drawable-hdpi

......\...\drawable-ldpi

......\...\drawable-mdpi

......\...\drawable-xhdpi

......\...\layout

......\...\values

......\src\mars

......\.settings

......\assets

......\bin

......\gen

......\res

......\src

sqlite

Android读写数据库代码比较多,以下为基本步骤:

创建数据库,并读写</ol>创建一个名为Test的数据库，并返回一个SQLiteDatabase对象mSQLiteDatabasemSQLiteDatabase=this.openOrCreateDatabase("Test",MODE_PRIVATE,null)通过execSQL方法来执行一条SQL语句。String CREATE_TABLE="create table 表名（列名，列名，……）"mSQLiteDatabase.execSQL(CREATE_TABLE)

2.以使用insert方法来添加数据，但是insert方法要求把数据都打包到ContentValues中，ContentValues其实就是一个Map，Key值是字段名称，Value值是字段的值。通过ContentValues的put方法就可以把数据放到ContentValues对象中，然后插入到表中去。具体实现如下：<pre t="code" l="java">ContentValues cv=new ContentValues()

cv.put(TABLE_NUM,1)

cv.put(TABLE_DATA,"测试数据库数据")

mSQLiteDatabase.insert(Test,null,cv)

//同样可以使用execSQL方法来执行一条“插入“的SQL语句

String INSERT_DATA="insert into 表名（列名，……） values （值，……）"

mSQLiteDatabase.execSQL(INSERT_DATA)

3.创建TextView对象,并赋值TextView textView = (TextView) finadViewById(R.id.textView)textView.setTextView(text)

---