当前位置: 代码迷 >> SQL >> 简略的Android Sqlite 使用
  详细解决方案

简略的Android Sqlite 使用

热度:101   发布时间:2016-05-05 10:06:41.0
简单的Android Sqlite 使用

简单的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 {	@Override	protected 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();	}}

版权声明:本文为博主原创文章,未经博主允许不得转载。

  相关解决方案