Android SQLite数据库实例

最新推荐文章于 2024-05-11 04:54:27 发布

{丸の子}

最新推荐文章于 2024-05-11 04:54:27 发布

阅读量58

点赞数

分类专栏： android基础知识文章标签： Android SQLite ITeye OS SQL

本文链接：https://blog.csdn.net/waterseason/article/details/88332023

版权

android基础知识专栏收录该内容

1693 篇文章 2 订阅

订阅专栏

DatabaseOpenHelper.java:


package com.iaiai.activity;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DatabaseOpenHelper extends SQLiteOpenHelper {

	private static final String DBNAME = "iaiai"; // 数据库名子

	private static final int VERSION = 1; // 版本

	public DatabaseOpenHelper(Context context) {
		// 第三个参数CursorFactory指定在执行查询时获得一个游标实例的工厂类,设置为null,代表使用系统默认的工厂类
		super(context, DBNAME, null, VERSION);
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		// 创建表
		db.execSQL("CREATE TABLE ADMIN (ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME VARCHAR(50), PHONE VARCHAR(20))");
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// 升级更新
		db.execSQL("DROP TABLE IF EXISTS ADMIN");
		onCreate(db);
	}

}

IaiaiActivity.java类:


package com.iaiai.activity;

import android.app.Activity;
import android.database.Cursor;
import android.os.Bundle;
import android.util.Log;

public class IaiaiActivity extends Activity {

	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.main);

		DatabaseOpenHelper databaseOpenHelper = new DatabaseOpenHelper(this);
		databaseOpenHelper.getWritableDatabase().execSQL(
				"insert into ADMIN(name, phone) values (?, ?)",
				new Object[] { "用户名1", "111111" });

		Cursor cursor = databaseOpenHelper.getReadableDatabase().query("ADMIN",
				new String[] { "count(*)" }, null, null, null, null, null);
		if (cursor.moveToNext()) {
			Log.i("******************SQL", "总记录数:" + cursor.getLong(0));
		}

//		cursor = databaseOpenHelper.getReadableDatabase().rawQuery("select ID,NAME,PHONE from ADMIN where id=?", 
//                new String[]{String.valueOf(1)});
		cursor = databaseOpenHelper.getReadableDatabase().query("ADMIN",null, null, null, null, null, null);
        while(cursor.moveToNext()){
            int adminId = cursor.getInt(0);
            String name = cursor.getString(1);
            String phone = cursor.getString(2);
            Log.i("******************数据"+adminId, "NAME:" + name+"----PHONE:"+phone);
        }
	}
}