2024.3.7

第三天

所花时间：1小时

代码量：200+

博客量：1

了解到的知识点：MySQL连接尝试二，驱动下载不下来，可能网络原因吧，还是失败了，准备转战sqlite了

package com.hui.shujuku;

import android.annotation.SuppressLint;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper extends SQLiteOpenHelper {

public DBHelper(Context context) {
super(context, "mydb.db", null, 1);
// TODO Auto-generated constructor stub
}

@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String sql="CREATE TABLE test(account VARCHAR(20),password VARCHAR(20))";
db.execSQL(sql);

}

@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
// TODO Auto-generated method stub

}


@Override
public void onCreate(SQLiteDatabase db) {

}
@SuppressLint("Range")
public String queryPassword(String sql, String[] bindArgs){
SQLiteDatabase database = getWritableDatabase();
Cursor cursor = database.rawQuery(sql, bindArgs);
String result = null;
while(cursor.moveToNext()){
result = cursor.getString(cursor.getColumnIndex("password"));
}
return result;
}
}