AndroidStudio中SQLite数据库的创建
ORSQL 2017-10-27 11:25:54 package com.sqlite.ch15_hellosqlite;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.widget.TextView;
public class MainActivity extends AppCompatActivity {
static final String db_name="testDB";
static final String tb_name="test";
SQLiteDatabase db;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
db = openOrCreateDatabase(db_name, Context.MODE_PRIVATE,null);
String createTable="CREATE TABLE IF NOT EXISTS" +
tb_name +
"(name VARCHAR(32),"+
"phone VARCHAR(16)"+
"email VARCHAR(64))";
db.execSQL(createTable);
addData("Flag Publishing Co.","10-12345678","servic@flag. com");
addData("Jun Magazine","10-24680135","service@Jun.com");
TextView txv=(TextView)findViewById(R.id.txv);
txv.setText("数据库文件路径:"+db.getPath()+ "\n" +
"数据库分页大小:"+db.getPageSize() + "Byte\n" +
"数据量上限:"+db.getMaximumSize() + "Byte\n");
db.close();
}
private void addData(String name,String phone,String email){
ContentValues cv=new ContentValues(3);
cv.put("name",name);
cv.put("phone",phone);
cv.put("email",email);
db.insert(tb_name,null,cv);
}
}
各位大神,我这是按照安卓书上,创建数据库和数据表的程序,但是仿真器上运行不出来,这是什么问题呢,跪求