import android.content.context;
import android.database.cursor;
import android.database.sqlite.sqlitedatabase;
import android.database.sqlite.sqliteopenhelper;
/**
*
* @author lai_zs
* @date:2012-2-16 下午4:16:02
*/
public class dbhelper extends sqliteopenhelper {
private static final int database_version = 1;
private static final string database_name = "autocomplete.db";
public static final string name = "name";
public dbhelper(context context) {
super(context, database_name, null, database_version);
}
@override
public void oncreate(sqlitedatabase db) {
string sqlstring = "createtable test (_id integer primary key autoincrement,name varchat(20) not null onconflict fail)";
db.execsql(sqlstring);
string[] namestrarraystr = new string[] { "aaa", "abc", "cde", "中国", "美女", "提示" };
for (int i = 0; i < namestrarraystr.length; i++) {
db.execsql("insert intotest(" + name + ")values(?)",new object[] { namestrarraystr[i] });
}
}
@override
public void onupgrade(sqlitedatabase arg0, int arg1, int arg2) {
}
/**
* 根据输入内容模糊查询
* @param name
* @return
*/
public cursor query(string name) {
sqlitedatabase db = this.getreadabledatabase();
return db.rawquery("select* from test where name like '%" + name + "%' limit 10",null);
}
}
发表评论