//这里是写的工具类
class wenSql(context: Context, name: String, factory: SQLiteDatabase.CursorFactory?, ver: Int) : SQLiteOpenHelper(context, name, factory, ver) {
val Create_ = "Create table wen(id integer primary key autoincrement,title text , url text);"//SQL语句
val mContext = context
var marks = arrayListOf<Map<String, Any>>()//存放数据
override fun onCreate(db: SQLiteDatabase?) {
try {
db!!.execSQL(Create_)
// Toast.makeText(mContext, "初始化完成!", Toast.LENGTH_SHORT).show()
} catch (e: NullPointerException) {
println(e)
}
}
override fun onUpgrade(db: SQLiteDatabase?, oldVersion: Int, newVersion: Int) {}
fun wen_add(title: String, url: String, db: SQLiteDatabase,hand:Handler): Boolean {
try {
var cv = ContentValues()
cv.put("title", title)
cv.put("url", url)
Log.d("添加:",cv.getAsString("title"))
Log.d("添加:",cv.getAsString("url"))
db.insert("wen", null, cv)
cv.clear()
var msg = Message()
msg.what = 2
hand.sendMessage(msg)
return true
} catch (e: NullPointerException) {
var msg = Message()
msg.what = 0
hand.sendMessage(msg)//通知UI线程刷新数据
return false
}
}
fun wen_delete(sql: String): Boolean {
return false
}
fun wen_query(id: String, db: SQLiteDatabase, hand: Handler): Boolean {
var cursor = db.query("wen", null, null, null, null, null, null, null)
if (cursor.moveToFirst()) {
do {
var temMAp = linkedMapOf<String, Any>()
var title = cursor.getString(cursor.getColumnIndex("title"))
var url = cursor.getString(cursor.getColumnIndex("url"))
temMAp.put("title", title)
temMAp.put("url", url)
marks.add(temMAp)
// println(temMAp)
//temMAp.clear()
} while (cursor.moveToNext())
println(marks)
val msg = Message()
msg.what = 1
hand.sendMessage(msg)
cursor.close()
}
return false
}
fun wen_update(sql: String): Boolean {
return false
}
}
IWH冬
JavaScript
React.js
PHP
擅长JavaScript开发的独立开发者。技术栈:React,Redux,ReactNative,PHP,Laravel,Swift。友情:http://undo.borebooks.top