Android sqlite 基础实例

1、创建DBhelper类 来实现数库的创建

package net.android.androidDB;

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import android.database.sqlite.SQLiteDatabase.CursorFactory;

public class DBhelper extends SQLiteOpenHelper{

private static final int VERSION = 1;

public DBhelper(Context context, String name, CursorFactory factory,

int version) {

super(context, name, factory, version);

}

public DBhelper(Context context, String name) {

this(context, name, VERSION);

}

public DBhelper(Context context, String name, int version) {

this(context, name, null, version);

}

@Override

public void onCreate(SQLiteDatabase arg0) {

System.out.println("create a DB");

// arg0.execSQL("create table user(id int, name varchar(20))");

}

@Override

public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {

System.out.println("update a DB");

}

2、 创建运行类

package net.android.android_db;

import java.util.Date;

import java.util.Random;

import android.app.Activity;

import android.content.ContentValues;

import android.content.Context;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.os.Bundle;

import android.util.Log;

import android.view.View;

import android.view.View.OnClickListener;

import android.widget.Button;

import android.widget.TextView;

import com.ko8e.DBhelper;

public class android_db extends Activity {

/** Called when the activity is first created. */

private Button button1 = null;

private Button button2 = null;

private Button button3 = null;

private Button button4 = null;

private Button button5 = null;

private TextView show=null;

@Override

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.main);

show=(TextView)findViewById(R.id.show);

button1 = (Button) findViewById(R.id.button1);

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

button3 = (Button) findViewById(R.id.button3);

button4 = (Button) findViewById(R.id.button4);

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

button1.setOnClickListener(new CreateListener());

button2.setOnClickListener(new UpdateRecordListener());

button3.setOnClickListener(new InsertListener());

button4.setOnClickListener(new QueryListener());

button5.setOnClickListener(new UpdateListener());

}

private class CreateListener implements OnClickListener {

@Override

public void onClick(View v) {

DBhelper db = new DBhelper(android_db.this, "ko8e_db");

SQLiteDatabase sqld = db.getReadableDatabase();

}

private class UpdateRecordListener implements OnClickListener {

@Override

public void onClick(View v) {

DBhelper db = new DBhelper(android_db.this, "ko8e_db");

SQLiteDatabase sqld = db.getReadableDatabase();

ContentValues values = new ContentValues();

values.put("name", "kobe bryant");

sqld.update("user", values, "id=?", new String[]{"1"});

}

private class InsertListener implements OnClickListener {

@Override

public void onClick(View v) {

ContentValues values = new ContentValues();

values.put("id", 1);

Random ran=new Random();

values.put("name", new Date().toString()+" "+String.valueOf(ran.nextInt(10000))+" ko8e");

DBhelper db = new DBhelper(android_db.this, "ko8e_db", Context.MODE_WORLD_WRITEABLE);

SQLiteDatabase sqld = db.getReadableDatabase();

sqld.insert("user", null, values);

}

private class QueryListener implements OnClickListener {

@Override

public void onClick(View v) {

DBhelper db = new DBhelper(android_db.this, "ko8e_db");

SQLiteDatabase sqld = db.getReadableDatabase();

Cursor cursor = sqld.query("user", new String[]{"id","name"}, "id=?", new String[]{"1"}, null, null, null);

String resu="";

while(cursor.moveToNext()) {

String name = cursor.getString(cursor.getColumnIndex("name"));

//System.out.println("quer： " + name);

Log.e("****query", name);

resu+=" name:"+cursor.getString(cursor.getColumnIndex("name"))+" aa /r/n";

}

Log.e("**result*", resu);

// show.setText("dddd");

}

private class UpdateListener implements OnClickListener {

@Override

public void onClick(View v) {

DBhelper db = new DBhelper(android_db.this, "ko8e_db", 2);

SQLiteDatabase sqld = db.getReadableDatabase();

}

3、 main.xml

<?xml version="1.0" encoding="utf-8"?>

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

android:orientation="vertical" android:layout_width="fill_parent"

android:layout_height="fill_parent">

<Button android:id="@+id/btn_create" android:layout_width="fill_parent"

android:layout_height="wrap_content" android:text="创建表(含库)" />

<Button android:id="@+id/btn_insert" android:layout_width="fill_parent"

android:layout_height="wrap_content" android:text="添加记录" />

<Button android:id="@+id/btn_query" android:layout_width="fill_parent"

android:layout_height="wrap_content" android:text="查询记录" />

<Button android:id="@+id/btn_update" android:layout_width="fill_parent"

android:layout_height="wrap_content" android:text="更新记录" />

<Button android:id="@+id/btn_delete" android:layout_width="fill_parent"

android:layout_height="wrap_content" android:text="删除记录" />

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

android:orientation="horizontal" android:layout_width="fill_parent"

android:layout_height="wrap_content">

<TextView android:text="ID" android:layout_width="wrap_content"

android:layout_height="wrap_content" />

<EditText android:id="@+id/edID" android:layout_width="100px"

android:layout_height="wrap_content" />

</LinearLayout>

<TextView android:id="@+id/show" android:layout_width="wrap_content"

android:layout_height="wrap_content" android:text="show"/>

</LinearLayout>

更多相关文章

随机推荐