android怎麼串連sqlite資料庫？

標籤：

SQLite資料庫
首先先建立SQLiteOpenHelper()的子類實現SQLiteOpenHelper中的OnCreate()方法和構造方法。 this class takes care of opening the database if it exists, creating it if it does not, and upgrading it as necessary.
 
SQLiteOpenHelper()主要是提供資料庫的對象，其中的getWriteableDatabase
 
public class PersonSQLiteOpenHelper extends SQLiteOpenHelper
{
public PersonSQLiteOpenHelper(Context context)
{
super(context, "person.db", null, 1);
}
 
/**
 * 第一次被建立的時候調用的方法
 */
@Override
public void onCreate(SQLiteDatabase db)
{
db.execSQL("create table person(id primary key autoincrement,name varchar(20),number varchar(20)");
}
 
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2)
{
 
}
 
}
 
有了SQLiteOpenHelper的子類後，就可建立其引用hrelper,用引用獲得資料庫db=helper.getWritableDataBase();
Db.execSQL(“select * from table”);
建立與資料庫操作相關的類（選擇）
public class PersonDao
{
private PersonSQLiteOpenHelper helper;
 
public PersonDao(Context context)
{
helper = new PersonSQLiteOpenHelper(context);
}
/**
 *  
 * @param name
 * @param number
 */
public void add(String name, String number)
{
SQLiteDatabase db = helper.getWritableDatabase();
db.execSQL("insert into person(name,number) values(?,?)", new Object[] {
name, number });
db.close();
}
 
/**
 * 
 * @param name
 * @return
 */
public boolean find(String name)
{
SQLiteDatabase db = helper.getReadableDatabase();
Cursor cursor = db.rawQuery("select *from person where name=?",
new String[] { name });
boolean result = cursor.moveToNext();
cursor.close();
db.close();
return result;
}
 
/**
 * 
 * @param name
 * @param number
 */
public void update(String name, String number)
{
SQLiteDatabase db = helper.getWritableDatabase();
db.execSQL("update person set number=? where name=?", new Object[] {
number, name });
db.close();
}
 
/**
 * 
 * @param name
 */
public void delete(String name)
{
SQLiteDatabase db = helper.getWritableDatabase();
db.execSQL("delete from person where name=?", new Object[] { name });
db.close();
}
/**
 * 
 * @return
 */
public List<Person> findAll()
{
SQLiteDatabase db = helper.getReadableDatabase();
Cursor cursor = db.rawQuery("select *from person", null);
ArrayList<Person> list = new ArrayList<Person>();
while (cursor.moveToNext())
{
int id = cursor.getInt(cursor.getColumnIndex("id"));
String name = cursor.getString(cursor.getColumnIndex("name"));
String number = cursor
.getString(cursor.getColumnIndex("number"));
Person person = new Person(id, name, number);
list.add(person);
}
return list;
}
}

事物
//開啟事物
db.beginTransaction();
try
{
//標記事物執行成功
db.setTransactionSuccessful();
} finally
{
db.endTransaction();
}

android怎麼串連sqlite資料庫？