package com.example.myapplication;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
public class StudentDao {
private SQLiteDatabase db;
public StudentDao(SQLiteOpenHelper dbHelper){
db = dbHelper.getWritableDatabase();
}
public void execQuery(List> list, final String strSQL){
try{
Cursor cursor = db.rawQuery(strSQL,null);
cursor.moveToFirst();
list.clear();
while(! cursor.isAfterLast()){
Map map = new HashMap();
map.put("sid", cursor.getInt(0));
map.put("stu_no", cursor.getString(1));
map.put("name", cursor.getString(2));
map.put("clazz", cursor.getString(3));
map.put("publish", cursor.getString(4));
list.add(map);
cursor.moveToNext();
}
}catch(RuntimeException e){
e.printStackTrace();
}
}
public boolean execSQL(final String strSQL){
db.beginTransaction();
try{
db.execSQL(strSQL);
db.setTransactionSuccessful();
}catch(RuntimeException e){
e.printStackTrace();
return false;
}finally {
db.endTransaction();
}
return true;
}
}
Original: https://blog.csdn.net/weixin_51852915/article/details/127728081
Author: 我滴名痣叫老八
Title: asdasd
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/816548/
转载文章受原作者版权保护。转载请注明原作者出处!