java datahelper_MyDatabaseHelper.java

import android.content.ContentValues;

import android.content.Context;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import android.widget.Toast;

/**

* Created by Administrator on 2017/5/17 0017.

*/

public class MyDatabaseHelper extends SQLiteOpenHelper {

public static final String CREATE_SCORE = "create table MAXScore(" +

"score_id char(10) not null)";

private Context mContext;

public MyDatabaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version){

super(context,name,factory,version);

mContext=context;

}

public void onCreate(SQLiteDatabase db){

db.execSQL(CREATE_SCORE);

db.execSQL("INSERT INTO MAXScore VALUES('0')");

// Toast.makeText(mContext,"创建数据库成功",Toast.LENGTH_SHORT).show();

}

//插入

public void Insert(SQLiteDatabase db,String s){

String SQL = "INSERT INTO MAXScore VALUES('"+s+"')";

db.execSQL(SQL);

}

//查询

public String query(SQLiteDatabase db){

Cursor cursor = db.query("MAXScore",null,null,null,null,null,null);

cursor.moveToFirst();

String Score = cursor.getString(cursor.getColumnIndex("score_id"));

return Score;

}

//更新

public void Update(SQLiteDatabase db,String s1,String s2){

ContentValues values = new ContentValues();

values.put("score_id",s1);

db.update("MAXScore",values,"score_id=?",new String[]{s2});

}

public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){

}

}

一键复制

编辑

Web IDE

原始数据

按行查看

历史