大家好,我对
Android开发很新,我想在我的应用程序中添加一个数据库
问题是我不知道如何只初始化整个表一次.
我做了很多阅读,我发现你可以做到
在helper类中重写onCreate(sqliteDatabase db)方法.
这些是我的数据字段和我的onCreate(sqliteDatabase db)方法
public static final String KEY_ROWID = "_id";
public static final String KEY_NAME = "name";
public static final String KEY_EIGHTU = "8u";
public static final String KEY_NINEU = "9u";
public static final String KEY_TENU = "10u";
public static final String KEY_ELEVENU = "11u";
private static final String TAG = "DBAdapter";
@Override
public void onCreate(sqliteDatabase db)
{
db.execsql(DATABASE_CREATE);
}
但我不确定如何…任何想法？
我的主要问题是我有多行我想初始化
解决方法
试试这种方式：
public class MyDBHelper
{
// Database properties
private static final String DATABASE_NAME = "Test.sqlite";
private static final String DATABASE_TABLE_NAME = "Table 1";
private static final int DATABASE_VERSION = 4;
// Table1 properties
public static final String KEY_ROWID = "_id";
public static final String KEY_NAME = "name";
public static final String KEY_EIGHTU = "8u";
public static final String KEY_NINEU = "9u";
public static final String KEY_TENU = "10u";
public static final String KEY_ELEVENU = "11u";
private static final String TAG = "DBAdapter";
// Create Script
private static final String 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();
}
}
