簡單的Android Sqlite 使用

標籤：sqlite   android   java   

簡單的Android Sqlite 使用：

package com.pdsu.db_test;import java.sql.Date;import android.app.Activity;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.os.Bundle;import android.widget.Toast;public class MainActivity extends Activity {@Overrideprotected void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);setContentView(R.layout.activity_main);SQLiteDatabase db = openOrCreateDatabase("test.db", MODE_PRIVATE, null);// db.execSQL("CREATE TABLE IF NOT EXISTS person (number INT(11),name// VARCHAR(255),birthday DATE);");db.execSQL("insert into person (number,name,birthday) values(12,\"zhangqing\",\"20150803\");");Cursor cursor = db.query("person", null, null, null, null, null, null);cursor.moveToFirst();while (cursor.moveToNext()) {int number = cursor.getInt(0);String name = cursor.getString(1);String date = cursor.getString(2);Toast.makeText(this, number + ">>" + name + ">>" + date, 0).show();}Toast.makeText(this, cursor.toString(), Toast.LENGTH_SHORT).show();}}

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。

簡單的Android Sqlite 使用