在使用SQLite数据库时,AS我们可以通过Tools–>Android–>Android Device Monitor的流程来导出数据库里面的内容;导入至SQLite for Navicat中,来查看数据库里的具体内容;SQLite的使用比较简单!!!
使用SQLite数据库实现简单的日志的打印:
效果图如下:
(https://img-blog.csdn.net/20161008225522534)
java代码如下:
“`
package com.example.debug;
import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
public class MainActivity extends Activity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
//创建数据库,并打开;openOrCreateDatabase有则打开,没有则自动创建
//数据库的名字user.db
SQLiteDatabase db=openOrCreateDatabase("user.db",MODE_PRIVATE,null);
db.execSQL("create table if not exists usertb(_id integer primary key autoincrement,name text not null,age integer not null,sex text not null)");
db.execSQL("insert into usertb(name,sex,age) values('张三','男','16')");
db.execSQL("insert into usertb(name,sex,age) values('李四','男','17')");
db.execSQL("insert into usertb(name,sex,age) values('王五','男','18')");
Cursor c=db.rawQuery("select * from usertb",null);
if(c!=null){
while(c.moveToNext()){
Log.i("info","_id"+c.getInt(c.getColumnIndex("_id")));
Log.i("info","name"+c.getString(c.getColumnIndex("name")));
Log.i("info","age"+c.getInt(c.getColumnIndex("age")));
Log.i("info","sex"+c.getString(c.getColumnIndex("sex")));
Log.i("info","---------------");
}
c.close();
}
db.close();
}
}
注意:关闭cursor;