android sqlite数据库操作实例1（完整程序压缩包）

package com.ex08_1.SQLite;

import android.app.Activity;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;

public class ActivityMain extends Activity {
	OnClickListener listener1 = null;
	OnClickListener listener2 = null;
	OnClickListener listener3 = null;
	OnClickListener listener4 = null;
	OnClickListener listener5 = null;

	Button button1;
	Button button2;
	Button button3;
	Button button4;
	Button button5;

	DatabaseHelper mOpenHelper;

	private static final String DATABASE_NAME = "dbForTest.db";
	private static final int DATABASE_VERSION = 1;
	private static final String TABLE_NAME = "diary";
	private static final String TITLE = "title";
	private static final String BODY = "body";

	private static class DatabaseHelper extends SQLiteOpenHelper {
		DatabaseHelper(Context context) {
			super(context, DATABASE_NAME, null, DATABASE_VERSION);
		}

		@Override
		public void onCreate(SQLiteDatabase db) {

			String sql = "CREATE TABLE "   TABLE_NAME   " ("   TITLE
					  " text not null, "   BODY   " text not null "   ");";
			Log.i("haiyang:createDB=", sql);
			db.execSQL(sql);

		}

		@Override
		public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		}
	}

	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.main);
		prepareListener();
		initLayout();
		mOpenHelper = new DatabaseHelper(this);

	}

	private void initLayout() {
		button1 = (Button) findViewById(R.id.button1);
		button1.setOnClickListener(listener1);

		button2 = (Button) findViewById(R.id.button2);
		button2.setOnClickListener(listener2);

		button3 = (Button) findViewById(R.id.button3);
		button3.setOnClickListener(listener3);
		button4 = (Button) findViewById(R.id.button4);
		button4.setOnClickListener(listener4);

		button5 = (Button) findViewById(R.id.button5);
		button5.setOnClickListener(listener5);

	}

	private void prepareListener() {
		listener1 = new OnClickListener() {
			public void onClick(View v) {
				CreateTable();
			}
		};
		listener2 = new OnClickListener() {
			public void onClick(View v) {
				dropTable();
			}
		};
		listener3 = new OnClickListener() {
			public void onClick(View v) {
				insertItem();
			}
		};
		listener4 = new OnClickListener() {
			public void onClick(View v) {
				deleteItem();
			}
		};
		listener5 = new OnClickListener() {
			public void onClick(View v) {
				showItems();
			}
		};
	}

	/*
	 * 重新建立数据表
	 */
	private void CreateTable() {
		SQLiteDatabase db = mOpenHelper.getWritableDatabase();
		String sql = "CREATE TABLE "   TABLE_NAME   " ("   TITLE
				  " text not null, "   BODY   " text not null "   ");";
		Log.i("haiyang:createDB=", sql);

		try {
			db.execSQL("DROP TABLE IF EXISTS diary");
			db.execSQL(sql);
			setTitle("数据表成功重建");
		} catch (SQLException e) {
			setTitle("数据表重建错误");
		}
	}

	/*
	 * 删除数据表
	 */
	private void dropTable() {
		SQLiteDatabase db = mOpenHelper.getWritableDatabase();
		String sql = "drop table "   TABLE_NAME;
		try {
			db.execSQL(sql);
			setTitle("数据表成功删除："   sql);
		} catch (SQLException e) {
			setTitle("数据表删除错误");
		}
	}

	/*
	 * 插入两条数据
	 */
	private void insertItem() {
		SQLiteDatabase db = mOpenHelper.getWritableDatabase();
		String sql1 = "insert into "   TABLE_NAME   " ("   TITLE   ", "   BODY
				  ") values('haiyang', 'android的发展真是迅速啊');";
		String sql2 = "insert into "   TABLE_NAME   " ("   TITLE   ", "   BODY
				  ") values('icesky', 'android的发展真是迅速啊');";
		try {
			Log.i("haiyang:sql1=", sql1);
			Log.i("haiyang:sql2=", sql2);
			db.execSQL(sql1);
			db.execSQL(sql2);
			setTitle("插入两条数据成功");
		} catch (SQLException e) {
			setTitle("插入两条数据失败");
		}
	}

	/*
	 * 删除其中的一条数据
	 */
	private void deleteItem() {
		try {
			SQLiteDatabase db = mOpenHelper.getWritableDatabase();
			db.delete(TABLE_NAME, " title = 'haiyang'", null);
			setTitle("删除title为haiyang的一条记录");
		} catch (SQLException e) {

		}

	}

	/*
	 * 在屏幕的title区域显示当前数据表当中的数据的条数。
	 */
	private void showItems() {

		SQLiteDatabase db = mOpenHelper.getReadableDatabase();
		String col[] = { TITLE, BODY };
		Cursor cur = db.query(TABLE_NAME, col, null, null, null, null, null);
		Integer num = cur.getCount();
		setTitle(Integer.toString(num)   " 条记录");
	}
}

资源下载

此资源下载价格为3D币（VIP免费），请先登录

资源文件列表

ex08_1_ContentProvider/.classpath , 364
ex08_1_ContentProvider/.project , 858
ex08_1_ContentProvider/.settings/org.eclipse.jdt.core.prefs , 177
ex08_1_ContentProvider/AndroidManifest.xml , 656
ex08_1_ContentProvider/bin/AndroidManifest.xml , 656
ex08_1_ContentProvider/bin/classes/com/eoeAndroid/contentProvider/ActivityMain.class , 1394
ex08_1_ContentProvider/bin/classes/com/eoeAndroid/contentProvider/BuildConfig.class , 369
ex08_1_ContentProvider/bin/classes/com/eoeAndroid/contentProvider/R$attr.class , 376
ex08_1_ContentProvider/bin/classes/com/eoeAndroid/contentProvider/R$drawable.class , 436
ex08_1_ContentProvider/bin/classes/com/eoeAndroid/contentProvider/R$layout.class , 430
ex08_1_ContentProvider/bin/classes/com/eoeAndroid/contentProvider/R$string.class , 463
ex08_1_ContentProvider/bin/classes/com/eoeAndroid/contentProvider/R.class , 561
ex08_1_ContentProvider/bin/classes/com/ex09_1_contentProvider/ActivityMain.class , 1386
ex08_1_ContentProvider/bin/classes/com/ex09_1_contentProvider/R$attr.class , 364
ex08_1_ContentProvider/bin/classes/com/ex09_1_contentProvider/R$drawable.class , 424
ex08_1_ContentProvider/bin/classes/com/ex09_1_contentProvider/R$layout.class , 418
ex08_1_ContentProvider/bin/classes/com/ex09_1_contentProvider/R$string.class , 451
ex08_1_ContentProvider/bin/classes/com/ex09_1_contentProvider/R.class , 537
ex08_1_ContentProvider/bin/classes/R$attr.class , 283
ex08_1_ContentProvider/bin/classes/R$drawable.class , 343
ex08_1_ContentProvider/bin/classes/R$id.class , 421
ex08_1_ContentProvider/bin/classes/R$layout.class , 403
ex08_1_ContentProvider/bin/classes/R$string.class , 370
ex08_1_ContentProvider/bin/classes/R.class , 398
ex08_1_ContentProvider/bin/classes.dex , 5048
ex08_1_ContentProvider/bin/ex08_1_ContentProvider.apk , 9518
ex08_1_ContentProvider/bin/res/drawable/icon.png , 3366
ex08_1_ContentProvider/bin/resources.ap_ , 5769
ex08_1_ContentProvider/gen/com/eoeAndroid/contentProvider/BuildConfig.java , 172
ex08_1_ContentProvider/gen/com/eoeAndroid/contentProvider/R.java , 652
ex08_1_ContentProvider/gen/com/ex09_1_contentProvider/R.java , 648
ex08_1_ContentProvider/gen/R.java , 789
ex08_1_ContentProvider/project.properties , 583
ex08_1_ContentProvider/readme.txt , 37
ex08_1_ContentProvider/res/drawable/icon.png , 3180
ex08_1_ContentProvider/res/layout/main.xml , 382
ex08_1_ContentProvider/res/values/strings.xml , 183
ex08_1_ContentProvider/src/com/eoeAndroid/contentProvider/ActivityMain.java , 879
ex08_1_ContentProvider/src/com/ex09_1_contentProvider/ActivityMain.java , 875
ex08_1_ContentProvider/说明.htm , 4317
ex08_1_SQLite/.classpath , 280
ex08_1_SQLite/.project , 849
ex08_1_SQLite/AndroidManifest.xml , 656
ex08_1_SQLite/bin/classes.dex , 7732
ex08_1_SQLite/bin/com/eoeAndroid/SQLite/ActivityMain$1.class , 798
ex08_1_SQLite/bin/com/eoeAndroid/SQLite/ActivityMain$2.class , 798
ex08_1_SQLite/bin/com/eoeAndroid/SQLite/ActivityMain$3.class , 798
ex08_1_SQLite/bin/com/eoeAndroid/SQLite/ActivityMain$4.class , 798
ex08_1_SQLite/bin/com/eoeAndroid/SQLite/ActivityMain$5.class , 798
ex08_1_SQLite/bin/com/eoeAndroid/SQLite/ActivityMain$DatabaseHelper.class , 1403
ex08_1_SQLite/bin/com/eoeAndroid/SQLite/ActivityMain.class , 5638
ex08_1_SQLite/bin/com/eoeAndroid/SQLite/R$attr.class , 349
ex08_1_SQLite/bin/com/eoeAndroid/SQLite/R$drawable.class , 409
ex08_1_SQLite/bin/com/eoeAndroid/SQLite/R$id.class , 518
ex08_1_SQLite/bin/com/eoeAndroid/SQLite/R$layout.class , 403
ex08_1_SQLite/bin/com/eoeAndroid/SQLite/R$string.class , 436
ex08_1_SQLite/bin/com/eoeAndroid/SQLite/R.class , 552
ex08_1_SQLite/bin/ex08_1_SQLite.apk , 11429
ex08_1_SQLite/bin/resources.ap_ , 6111
ex08_1_SQLite/default.properties , 960
ex08_1_SQLite/gen/com/eoeAndroid/SQLite/R.java , 951
ex08_1_SQLite/gen/com/ex08_1/SQLite/R.java , 947
ex08_1_SQLite/readme.txt , 113
ex08_1_SQLite/res/drawable/icon.png , 3180
ex08_1_SQLite/res/layout/main.xml , 997
ex08_1_SQLite/res/values/strings.xml , 183
ex08_1_SQLite/src/com/eoeAndroid/SQLite/ActivityMain.java , 4655
ex08_1_SQLite/src/com/ex08_1/SQLite/ActivityMain.java , 4688