大佬教程收集整理的这篇文章主要介绍了初始化一个sqlite数据库android,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
问题是我不知道如何只初始化整个表一次.
我做了很多阅读,我发现你可以做到
在Helper类中重写onCreate(sqliteDatabase db)方法.
这些是我的数据字段和我的onCreate(sqliteDatabase db)方法
public static final @R_262_10495@ng KEY_ROWID = "_ID"; public static final @R_262_10495@ng KEY_name = "name"; public static final @R_262_10495@ng KEY_EIGHTU = "8u"; public static final @R_262_10495@ng KEY_NINEU = "9u"; public static final @R_262_10495@ng KEY_TENU = "10u"; public static final @R_262_10495@ng KEY_ELEVENU = "11u"; private static final @R_262_10495@ng TAG = "DBAdapter"; @OverrIDe public voID onCreate(sqliteDatabase db) { db.execsql(DATABASE_create); }
但我不确定如何…任何想法?
我的主要问题是我有多行我想初始化
public class MyDBHelper { // Database propertIEs private static final @R_262_10495@ng DATABASE_name = "Test.sqlite"; private static final @R_262_10495@ng DATABASE_table_name = "table 1"; private static final int DATABASE_VERSION = 4; // table1 propertIEs public static final @R_262_10495@ng KEY_ROWID = "_ID"; public static final @R_262_10495@ng KEY_name = "name"; public static final @R_262_10495@ng KEY_EIGHTU = "8u"; public static final @R_262_10495@ng KEY_NINEU = "9u"; public static final @R_262_10495@ng KEY_TENU = "10u"; public static final @R_262_10495@ng KEY_ELEVENU = "11u"; private static final @R_262_10495@ng TAG = "DBAdapter"; // Create Script private static final @R_262_10495@ng DATABASE_CREATE_PLAYER = "create table IF NOT EXISTS " + DATABASE_table_name + "( " + KEY_ROWID + " IntegeR," + KEY_name + " TEXT," + KEY_EIGHTU + " TEXT," + KEY_NINEU + " TEXT," + KEY_TENU + " TEXT," + KEY_ELEVENU + " TEXT);"; private final Context m_context; private DatabaseHelper m_dbHelper; public static sqliteDatabase m_db; public MyDBHelper(Context ctX) { this.m_context = ctx; m_dbHelper = new DatabaseHelper(m_context); } private static class DatabaseHelper extends sqliteOpenHelper { DatabaseHelper(Context context) { super(context,DATABASE_name,null,DATABASE_VERSION); } @OverrIDe public voID onCreate(sqliteDatabase db) { db.execsql(DATABASE_table_Name); } @OverrIDe public voID onUpgrade(sqliteDatabase db,int oldVersion,int newVersion) { db.execsql("drop table IF EXISTS " + DATABASE_table_name ); onCreate(db); } } //---opens the database--- public MyDBHelper open() throws sqlException { m_db = m_dbHelper.getWritableDatabase(); return this; } //---closes the database--- public voID close() { if (m_db != null) m_db.close(); if (m_dbHelper != null) m_dbHelper.close(); } }
以上是大佬教程为你收集整理的初始化一个sqlite数据库android全部内容,希望文章能够帮你解决初始化一个sqlite数据库android所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。