android学习系列八 SQLite的使用

设置几个按钮：

  protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        create=(Button)findViewById(R.id.create);
        create.setOnClickListener(new CreateListener());
        insert=(Button)findViewById(R.id.insert);
        insert.setOnClickListener(new InsertListener());
        
    }

    class CreateListener implements OnClickListener{

		@Override
		public void onClick(View v) {
			// TODO Auto-generated method stub
			SQLiteHelper dh=new SQLiteHelper(MainActivity.this,"testdb",null,1);
			SQLiteDatabase db=dh.getReadableDatabase();
		}
    	
    }
    class InsertListener implements OnClickListener{

		@Override
		public void onClick(View v) {
			// TODO Auto-generated method stub
			System.out.println("insert data---");
			SQLiteHelper dh=new SQLiteHelper(MainActivity.this,"testdb",null,1);
			ContentValues values=new ContentValues();
			values.put("name", "daizhou");
			values.put("age", 25);
			SQLiteDatabase db=dh.getWritableDatabase();
			db.insert("user", null, values);
		}
    	
    }

有个Helper类：

package com.example.sqlitetest.db;

import android.os.Bundle;
import android.app.Activity;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.view.Menu;

public class SQLiteHelper extends SQLiteOpenHelper {

	public SQLiteHelper(Context context, String name, CursorFactory factory,
			int version) {
		super(context, name, factory, version);
		// TODO Auto-generated constructor stub
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
		System.out.println("create database------");
		db.execSQL("create table user(name varchar(20),age int)");
		
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO Auto-generated method stub
		System.out.println("upgrade ");
	}

  
    
}

利用adb命令查看：

adb shell

cd data

cd data

cd com.example.sqlitetest

cd databases

 sqlite3 testdb

.schema查看得到结果:

CREATE TABLE android_metadata (locale TEXT);
CREATE TABLE user(name varchar(20),age int);

再按下插入按钮后就可以查看了：

select * from user