public class DatabaseActivity extends AppCompatActivity implements View.OnClickListener { private TextView activity_database; private String mDatabaseName; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_database); activity_database = findViewById(R.id.activity_database); findViewById(R.id.bth_insert).setOnClickListener(this); findViewById(R.id.bth_delete).setOnClickListener(this); //生成一个测试数据库的完整路径 mDatabaseName = getFilesDir()+"test.db"; } @Override public void onClick(View v) { String desc=null; switch (v.getId()){ case R.id.bth_insert: //创建打开数据库,数据库如果不存在就创建它,如果存在就打开它 SQLiteDatabase db = openOrCreateDatabase(mDatabaseName, Context.MODE_PRIVATE, null); desc=String.format("数据库%s创建%s",db.getPath(),(db!=null)?"成功":"失败"); activity_database.setText(desc); break; //删除数据库数据库 case R.id.bth_delete: boolean result = deleteDatabase(mDatabaseName); desc=String.format("数据库%s删除%s",mDatabaseName,result?"成功":"失败"); activity_database.setText(desc); break; } } }
android之SQLiteDatabase
于 2024-08-21 09:37:06 首次发布