Android中4中数据存储方式:
Shared Preferences:用来存储“key-value paires”格式的数据,它是一个轻量级的键值存储机制,只可以存储基本数据类型
Files:它通过FileInputStream和FileOutputStream对文件进行操作。但是在Android中,文件是一个应用程序私有的,一个应用程序无法读写其他应用程序的文件
SQLite:Android提供的一个标准的数据库,支持SQL语句Network:通过网络来存储和获得数据
Shared Preferences主要是针对系统配置信息的保存。
Files就是把需要保存的东西通过文件的形式记录下来,当需要这些数据时,通过读取这个文件来获得这些数据即可。
SQLite是一个开源的关系型数据库,与普通关系型数据库一样,也具有ACID的特性。它可以用来存储大量的数据,并且能够很容易地对数据进行使用、更新、维护等操作。
Network用于将数据存储于网络,还需要使用java.net.*和android.net.*这些类。
主界面
布局
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:paddingBottom="@dimen/activity_vertical_margin"
android:paddingLeft="@dimen/activity_horizontal_margin"
android:paddingRight="@dimen/activity_horizontal_margin"
android:paddingTop="@dimen/activity_vertical_margin"
tools:context=".MainActivity"
android:orientation="vertical" >
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="@string/hello_world" />
<Button
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="button1"
android:onClick="Button1"/>
<Button
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="button2"
android:onClick="Button2"/>
<Button
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="button3"
android:onClick="Button3"/>
<Button
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="button4"
android:onClick="Button4"/>
<Button
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="button5"
android:onClick="Button5"/>
<Button
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="button6"
android:onClick="Button6"/>
</LinearLayout>
处理
package com.sl.datafiledemo;
import android.os.Bundle;
import android.app.Activity;
import android.content.Intent;
import android.view.View;
public class MainActivity extends Activity
{
@Override
protected void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
}
public void Button1(View view)
{
Intent intent = new Intent();
intent.setClass(MainActivity.this, Activity01.class);
startActivity(intent);
}
public void Button2(View view)
{
Intent intent = new Intent();
intent.setClass(MainActivity.this, Activity02.class);
startActivity(intent);
}
public void Button3(View view)
{
Intent intent = new Intent();
intent.setClass(MainActivity.this, Activity03.class);
startActivity(intent);
}
public void Button4(View view)
{
Intent intent = new Intent();
intent.setClass(MainActivity.this, Activity04.class);
startActivity(intent);
}
public void Button5(View view)
{
Intent intent = new Intent();
intent.setClass(MainActivity.this, Activity05.class);
startActivity(intent);
}
public void Button6(View view)
{
Intent intent = new Intent();
intent.setClass(MainActivity.this, Activity06.class);
startActivity(intent);
}
}
效果
Shared Preferences
Shared Preferences类似于我们常用的ini文件,用来保存应用程序的一些属性设置,在Android平台常用于存储较简单的参数设置。布局
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical" >
<TextView
android:id="@+id/tv01"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="@string/hello_world"/>
<Button
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="open"
android:onClick="Open"/>
<Button
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="close"
android:onClick="Close"/>
</LinearLayout>
处理
package com.sl.datafiledemo;
import android.app.Activity;
import android.content.SharedPreferences;
import android.os.Bundle;
import android.view.View;
import android.widget.TextView;
public class Activity01 extends Activity
{
private String mKey = "bmusic"; //key
private boolean mbMusic = false; //value
private TextView mTextView = null;
@Override
protected void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.layout01);
mTextView = (TextView)findViewById(R.id.tv01);
//装载数据,取得活动的preferences对象
SharedPreferences sharedata = getPreferences(Activity.MODE_PRIVATE);
//取得值
mbMusic = sharedata.getBoolean(mKey, false);
if (mbMusic)
{
mTextView.setText("当前音乐状态:开");
}
else
{
mTextView.setText("当前音乐状态:关");
}
}
public void Open(View view)
{
mTextView.setText("当前音乐状态:开");
mbMusic = true;
}
public void Close(View view)
{
mTextView.setText("当前音乐状态:关");
mbMusic = false;
}
@Override
protected void onDestroy()
{
super.onDestroy();
//这里我们在退出应用程序时保存数据 取得活动的preferences对象
SharedPreferences uiState = getPreferences(0);
//取得编辑对象
SharedPreferences.Editor editor = uiState.edit();
//添加值
editor.putBoolean(mKey, mbMusic);
//提交保存
editor.commit();
}
}
效果
Files
Android中可以在设备本身的存储设备或者外接的存储设备中创建用于保存数据的文件。同样,在默认的状态下,文件是不能再不同的程序间共享的。布局
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical" >
<TextView
android:id="@+id/tv01"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="@string/hello_world"/>
<Button
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="open"
android:onClick="Open"/>
<Button
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="close"
android:onClick="Close"/>
</LinearLayout>
处理
package com.sl.datafiledemo;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.util.Properties;
import android.app.Activity;
import android.content.Context;
import android.os.Bundle;
import android.view.View;
import android.widget.TextView;
public class Activity02 extends Activity
{
private String mFile = "music.cfg"; //file
private String mKey = "bmusic"; //key
private boolean mbMusic = false; //value
private TextView mTextView = null;
@Override
protected void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.layout02);
mTextView = (TextView)findViewById(R.id.tv01);
//读取文件数据
load();
if (mbMusic)
{
mTextView.setText("当前音乐状态:开");
}
else
{
mTextView.setText("当前音乐状态:关");
}
}
public void Open(View view)
{
mTextView.setText("当前音乐状态:开");
mbMusic = true;
}
public void Close(View view)
{
mTextView.setText("当前音乐状态:关");
mbMusic = false;
}
@Override
protected void onDestroy()
{
super.onDestroy();
save();
}
void load()
{
//构建Properties对对象
Properties properties = new Properties();
try
{
//开发文件
FileInputStream stream = this.openFileInput(mFile);
//读取文件内容
properties.load(stream);
}
catch (Exception e)
{
return;
}
mbMusic = Boolean.valueOf(properties.get(mKey).toString());
}
boolean save()
{
Properties properties = new Properties();
//将数据打包成Properties
properties.put(mKey, String.valueOf(mbMusic));
try
{
FileOutputStream stream = this.openFileOutput(mFile, Context.MODE_WORLD_WRITEABLE);
//将打包好的数据写入文件中
properties.store(stream, "");
}
catch (Exception e)
{
return false;
}
return true;
}
}
效果
邮件
布局
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical" >
<TextView
android:id="@+id/tv01"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="@string/hello_world"/>
</LinearLayout>
处理
package com.sl.datafiledemo;
import android.app.Activity;
import android.content.Intent;
import android.net.Uri;
import android.os.Bundle;
public class Activity03 extends Activity
{
private int miCount = 0;
@Override
protected void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.layout03);
miCount=1000;
}
@Override
protected void onDestroy()
{
super.onDestroy();
//退出应用程序时保存数据
//发送邮件的地址
Uri uri = Uri.parse("mailto:test@163.com");
//创建Intent
Intent it = new Intent(Intent.ACTION_SENDTO, uri);
//设置邮件的主题
it.putExtra(android.content.Intent.EXTRA_SUBJECT, "数据备份");
//设置邮件的内容
it.putExtra(android.content.Intent.EXTRA_TEXT, "本次计数:"+miCount);
//开启
startActivity(it);
}
}
效果
Network
通过网络来获取和保存数据资源,这个方法需要设备保持网络连接状态,所以相对存在一些限制。既然可以将数据发送到网络上保存,当然也可以获得网络上的数据。
由于需要使用网络,所以要申明网络权限。
<uses-permission android:name="android.permission.INTERNET" />
布局
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical" >
<TextView
android:id="@+id/tv01"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="@string/hello_world"/>
</LinearLayout>
处理
package com.sl.datafiledemo;
import java.io.BufferedInputStream;
import java.io.InputStream;
import java.net.URL;
import java.net.URLConnection;
import org.apache.http.util.ByteArrayBuffer;
import android.app.Activity;
import android.os.Bundle;
import android.widget.TextView;
public class Activity04 extends Activity
{
@Override
protected void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.layout04);
TextView tv = new TextView(this);
String myString = null;
try
{
//定义我们要访问的地址url
URL uri = new URL("http://192.168.1.110:8080/android.txt");
//打开这个url连接
URLConnection ucon = uri.openConnection();
//从上面的链接中取得InputStream
InputStream is = ucon.getInputStream();
BufferedInputStream bis = new BufferedInputStream(is);
ByteArrayBuffer baf = new ByteArrayBuffer(100);
int current = 0;
//一直读到文件结束
while ((current = bis.read()) != -1)
{
baf.append((byte) current);
}
myString = new String(baf.toByteArray());
}
catch (Exception e)
{
myString = e.getMessage();
}
//将信息设置到TextView
tv.setText(myString);
//将TextView显示到屏幕上
this.setContentView(tv);
}
}
效果
SQLite
SQLite数据库专门用来处理数据量较大的数据,它在数据的存储、管理、维护等各个方面都更加合理,功能更加强大。SQLite数据库的一般操作包括:创建数据库、打开数据库、创建表、向表中添加数据、从表中删除数据、修改表中的数据、关闭数据库、删除指定表、删除数据库和查询表中的某条数据。
package com.sl.datafiledemo;
import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.Color;
import android.os.Bundle;
import android.view.KeyEvent;
import android.view.View;
import android.widget.Button;
import android.widget.LinearLayout;
import android.widget.LinearLayout.LayoutParams;
import android.widget.ListAdapter;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
public class Activity05 extends Activity
{
private static int miCount = 0;
//数据库对象
private SQLiteDatabase mSqLiteDatabase = null;
//数据库名
private final static String DATABASE_NAME = "examples05.db";
//表名
private final static String TABLE_NAME = "table1";
//表中的字段
private final static String TABLE_ID = "_id";
private final static String TABLE_NUM = "num";
private final static String TABLE_DATA = "data";
//创建表的sql语句
private final static String CREATE_TABLE = "CREATE TABLE " + TABLE_NAME + " (" + TABLE_ID + " INTEGER PRIMARY KEY," + TABLE_NUM + " INTERGER,"+ TABLE_DATA + " TEXT)";
//线性布局
LinearLayout m_LinearLayout = null;
//列表视图-显示数据库中的数据
ListView m_ListView = null;
Button mButtonAddData = null;
Button mButtonDeleteData = null;
Button mButtonUpData = null;
Button mButtonDeleteTable = null;
Button mButtonDeleteDataBase = null;
@Override
protected void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
//创建LinearLayout布局对象
m_LinearLayout = new LinearLayout(this);
//设置布局LinearLayout的属性
m_LinearLayout.setOrientation(LinearLayout.VERTICAL);
//m_LinearLayout.setBackgroundColor(android.graphics.Color.BLACK);
//创建ListView对象
m_ListView = new ListView(this);
LinearLayout.LayoutParams param = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.MATCH_PARENT, LinearLayout.LayoutParams.WRAP_CONTENT);
//m_ListView.setBackgroundColor(Color.BLACK);
//添加m_ListView到m_LinearLayout布局
m_LinearLayout.addView(m_ListView, param);
mButtonAddData = new Button(this);
mButtonAddData.setText("添加数据");
LinearLayout.LayoutParams params = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.MATCH_PARENT,LinearLayout.LayoutParams.WRAP_CONTENT);
m_LinearLayout.addView(mButtonAddData, params);
mButtonDeleteData = new Button(this);
mButtonDeleteData.setText("删除数据");
m_LinearLayout.addView(mButtonDeleteData, params);
mButtonUpData = new Button(this);
mButtonUpData.setText("更新数据");
m_LinearLayout.addView(mButtonUpData, params);
mButtonDeleteTable = new Button(this);
mButtonDeleteTable.setText("删除表");
m_LinearLayout.addView(mButtonDeleteTable, params);
mButtonDeleteDataBase = new Button(this);
mButtonDeleteDataBase.setText("删除数据库");
m_LinearLayout.addView(mButtonDeleteDataBase, params);
//设置显示m_LinearLayout布局
setContentView(m_LinearLayout);
//打开已经存在的数据库
mSqLiteDatabase = this.openOrCreateDatabase(DATABASE_NAME, MODE_PRIVATE, null);
//获取数据库Phones的Cursor
try
{
//在数据库mSQLiteDatabase中创建一个表
mSqLiteDatabase.execSQL(CREATE_TABLE);
} catch (Exception e)
{
UpdataAdapter();
}
mButtonAddData.setOnClickListener(new View.OnClickListener()
{
@Override
public void onClick(View v)
{
AddData();
}
});
mButtonDeleteData.setOnClickListener(new View.OnClickListener()
{
@Override
public void onClick(View v)
{
DeleteData();
}
});
mButtonUpData.setOnClickListener(new View.OnClickListener()
{
@Override
public void onClick(View v)
{
UpData();
}
});
mButtonDeleteTable.setOnClickListener(new View.OnClickListener()
{
@Override
public void onClick(View v)
{
DeleteTable();
}
});
mButtonDeleteDataBase.setOnClickListener(new View.OnClickListener()
{
@Override
public void onClick(View v)
{
DeleteDataBase();
}
});
}
public void DeleteDataBase()//删除数据库
{
this.deleteDatabase(DATABASE_NAME);
this.finish();
}
public void DeleteTable()//删除一个表
{
mSqLiteDatabase.execSQL("DROP TABLE " + TABLE_NAME);
this.finish();
}
public void UpData()//更新一条数据
{
ContentValues cv = new ContentValues();
cv.put(TABLE_NUM, miCount);
cv.put(TABLE_DATA, "修改后的数据"+miCount);
//更新数据
mSqLiteDatabase.update(TABLE_NAME, cv, TABLE_NUM + "=" + Integer.toString(miCount - 1), null);
UpdataAdapter();
}
public void AddData()//向表中添加一条数据
{
ContentValues cv = new ContentValues();
cv.put(TABLE_NUM, miCount);
cv.put(TABLE_DATA, "测试数据库数据" + miCount);
//插入数据
mSqLiteDatabase.insert(TABLE_NAME, null, cv);
miCount++;
// String INSERT_DATA = "INSERT INTO table1 (_id,num,data) values(1,1,'通过SQL语句插入')";
// mSqLiteDatabase.execSQL(INSERT_DATA);
UpdataAdapter();
}
public void DeleteData()//从表中删除指定的一条数据
{
//删除数据
mSqLiteDatabase.execSQL("DELETE FROM " + TABLE_NAME + " WHERE _id=" + Integer.toString(miCount));
miCount--;
if (miCount < 0)
{
miCount = 0;
}
UpdataAdapter();
}
@SuppressWarnings("deprecation")
public void UpdataAdapter()//更新视图显示
{
//获取数据库Phones的Cursor
Cursor cur = mSqLiteDatabase.query(TABLE_NAME, new String[] { TABLE_ID, TABLE_NUM, TABLE_DATA }, null, null, null, null, null);
miCount = cur.getCount();
if (cur != null && cur.getCount() >= 0)
{
// ListAdapter是ListView和后台数据的桥梁
ListAdapter adapter = new SimpleCursorAdapter(this,
android.R.layout.simple_list_item_2,// 定义List中每一行的显示模板,表示每一行包含两个数据项
cur,// 数据库的Cursor对象
new String[] { TABLE_NUM, TABLE_DATA },// 从数据库的TABLE_NUM和TABLE_DATA两列中取数据
new int[] { android.R.id.text1, android.R.id.text2 });// 与NAME和NUMBER对应的Views
//将adapter添加到m_ListView中
m_ListView.setAdapter(adapter);
}
// Cursor cur = mSqLiteDatabase.rawQuery("SELECT * FROM table", null);
// if (cur != null)
// {
// if (cur.moveToFirst())
// {
// do
// {
// int numColumn = cur.getColumnIndex("num");
// int num = cur.getInt(numColumn);
// } while (cur.moveToNext());
// }
// }
}
@Override
public boolean onKeyDown(int keyCode, KeyEvent event)
{
if (keyCode == KeyEvent.KEYCODE_BACK)
{
//退出时,不要忘记关闭
mSqLiteDatabase.close();
this.finish();
return true;
}
return super.onKeyDown(keyCode, event);
}
}
效果
SQLiteOpenHelper应用
在实际开发中,为了能够更好地管理和维护数据库,我们会封装一个继承自SQLiteOpenHelper类的数据库操作类。
package com.sl.datafiledemo;
import android.app.Activity;
import android.database.Cursor;
import android.graphics.Color;
import android.os.Bundle;
import android.view.KeyEvent;
import android.view.View;
import android.widget.Button;
import android.widget.LinearLayout;
import android.widget.ListAdapter;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
public class Activity06 extends Activity
{
private static int miCount = 0;
LinearLayout mLinearLayout = null;
ListView mListView = null;
MyDataBaseAdapter myDataBaseAdapter;
Button mButtonAddData = null;
Button mButtonDeleteData = null;
Button mButtonUpData = null;
@Override
protected void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
mLinearLayout = new LinearLayout(this);
mLinearLayout.setOrientation(LinearLayout.VERTICAL);
// mLinearLayout.setBackgroundColor(android.graphics.Color.BLACK);
mListView = new ListView(this);
LinearLayout.LayoutParams param = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.MATCH_PARENT, LinearLayout.LayoutParams.WRAP_CONTENT);
// mListView.setBackgroundColor(Color.BLACK);
mLinearLayout.addView(mListView,param);
mButtonAddData = new Button(this);
mButtonAddData.setText("添加数据");
LinearLayout.LayoutParams params = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.MATCH_PARENT,LinearLayout.LayoutParams.WRAP_CONTENT);
mLinearLayout.addView(mButtonAddData, params);
mButtonDeleteData = new Button(this);
mButtonDeleteData.setText("删除数据");
mLinearLayout.addView(mButtonDeleteData, params);
mButtonUpData = new Button(this);
mButtonUpData.setText("更新数据");
mLinearLayout.addView(mButtonUpData, params);
setContentView(mLinearLayout);
myDataBaseAdapter = new MyDataBaseAdapter(this);
myDataBaseAdapter.open();
UpdataAdapter();
mButtonAddData.setOnClickListener(new View.OnClickListener()
{
@Override
public void onClick(View v)
{
AddData();
}
});
mButtonDeleteData.setOnClickListener(new View.OnClickListener()
{
@Override
public void onClick(View v)
{
DeleteData();
}
});
mButtonUpData.setOnClickListener(new View.OnClickListener()
{
@Override
public void onClick(View v)
{
UpData();
}
});
}
public void UpData()
{
myDataBaseAdapter.updateData(miCount, miCount, "修改后的数据" + miCount);
UpdataAdapter();
}
public void AddData()
{
myDataBaseAdapter.insertData(miCount, "测试数据库数据" + miCount);
miCount++;
UpdataAdapter();
}
public void DeleteData()
{
myDataBaseAdapter.deleteData(miCount);
miCount--;
if (miCount < 0)
{
miCount = 0;
}
UpdataAdapter();
}
public boolean onKeyDown(int keyCode, KeyEvent event)
{
if (keyCode == KeyEvent.KEYCODE_BACK)
{
//退出时,不要忘记关闭
myDataBaseAdapter.close();
this.finish();
return true;
}
return super.onKeyDown(keyCode, event);
}
@SuppressWarnings("deprecation")
public void UpdataAdapter()
{
// 获取数据库Phones的Cursor
Cursor cur = myDataBaseAdapter.fetchAllData();
miCount = cur.getCount();
if (cur != null && cur.getCount() >= 0)
{
// ListAdapter是ListView和后台数据的桥梁
ListAdapter adapter = new SimpleCursorAdapter(this,
android.R.layout.simple_list_item_2,// 定义List中每一行的显示模板,表示每一行包含两个数据项
cur,// 数据库的Cursor对象
new String[] {MyDataBaseAdapter.KEY_NUM, MyDataBaseAdapter.KEY_DATA },// 从数据库的TABLE_NUM和TABLE_DATA两列中取数据
new int[] { android.R.id.text1, android.R.id.text2 });// 与NAME和NUMBER对应的Views
//将adapter添加到m_ListView中
mListView.setAdapter(adapter);
}
}
}
数据库类
package com.sl.datafiledemo;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class MyDataBaseAdapter
{
//用于打印log
private static final String TAG = "MyDataBaseAdapter";
//表中一条数据的名称
public static final String KEY_ID = "_id";
//表中一条数据的内容
public static final String KEY_NUM = "num";
//表中一条数据的id
public static final String KEY_DATA = "data";
//数据库名称为data
private static final String DB_NAME = "example06.db";
//数据库表名
private static final String DB_TABLE = "table1";
//数据库版本
private static final int DB_VERSION = 1;
//本地Context对象
private Context mContext = null;
//创建一个表
private static final String DB_CREATE = "CREATE TABLE " + DB_TABLE + " (" + KEY_ID + " INTEGER PRIMARY KEY," + KEY_NUM + " INTERGER,"+ KEY_DATA + " TEXT)";
//执行open()打开数据库时,保存返回的数据库对象
private SQLiteDatabase mSqLiteDatabase = null;
//由SQLiteOpenHelper继承过来
private DatabaseHelper mDatabaseHelper = null;
private static class DatabaseHelper extends SQLiteOpenHelper
{
DatabaseHelper(Context context)
{
//当调用getWritableDatabase()或 getReadableDatabase()方法时则创建一个数据库
super(context, DB_NAME, null, DB_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db)
{
db.execSQL(DB_CREATE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
{
db.execSQL("DROP TABLE IF EXISTS notes");
onCreate(db);
}
}
public MyDataBaseAdapter(Context context)
{
mContext = context;
}
public void open() throws SQLException
{
mDatabaseHelper = new DatabaseHelper(mContext);
mSqLiteDatabase = mDatabaseHelper.getWritableDatabase();
}
public void close()
{
mDatabaseHelper.close();
}
public long insertData(int num, String data)
{
ContentValues initialValues = new ContentValues();
initialValues.put(KEY_NUM, num);
initialValues.put(KEY_DATA, data);
return mSqLiteDatabase.insert(DB_TABLE, KEY_ID, initialValues);
}
public boolean deleteData(long rowId)
{
return mSqLiteDatabase.delete(DB_TABLE, KEY_ID + "=" + rowId, null) > 0;
}
public Cursor fetchAllData()
{
return mSqLiteDatabase.query(DB_TABLE, new String[] { KEY_ID, KEY_NUM, KEY_DATA }, null, null, null, null, null);
}
public Cursor fetchData(long rowId) throws SQLException
{
Cursor mCursor = mSqLiteDatabase.query(true, DB_TABLE, new String[] { KEY_ID, KEY_NUM, KEY_DATA }, KEY_ID + "=" + rowId, null, null, null, null, null);
if (mCursor != null)
{
mCursor.moveToFirst();
}
return mCursor;
}
public boolean updateData(long rowId, int num, String data)
{
ContentValues args = new ContentValues();
args.put(KEY_NUM, num);
args.put(KEY_DATA, data);
return mSqLiteDatabase.update(DB_TABLE, args, KEY_ID + "=" + rowId, null) > 0;
}
}
效果