Android SQLite3 入门基础

核心提示：REAL 小数NONE 无类型* 查询可否发送select ?*/public void CreateTable() {try {db.execSQL("CREATE TABLE t_user (" +"_ID INTEGER PRIMARY KEY autoincrement,"

REAL 小数

NONE 无类型

* 查询可否发送select ?

*/

public void CreateTable() {

try {

db.execSQL("CREATE TABLE t_user (" +

"_ID INTEGER PRIMARY KEY autoincrement,"

+ "NAME TEXT"

+ ");");

Log.v(TAG, "Create Table t_user ok");

} catch (Exception e) {

Log.v(TAG, "Create Table t_user err,table exists.");

}

}

/**

* 增加数据

* @param id

* @param uname

* @return

*/

public boolean save(String uname){

String sql="";

try{

sql="insert into t_user values(null,'"+uname+"')";

db.execSQL(sql);

Log.v(TAG,"insert Table t_user ok");

return true;

}catch(Exception e){

Log.v(TAG,"insert Table t_user err ,sql: "+sql);

return false;

}

}

/**

* 查询所有记录

*

* @return Cursor 指向结果记录的指针，类似于JDBC 的 ResultSet

*/

public Cursor loadAll(){

Cursor cur=db.query("t_user", new String[]{"_ID","NAME"}, null,null, null, null, null);

return cur;

}

public void close(){

db.close();

}

}