本次我实现了向SQLite数据库存储用户手写的字符图片的矩阵,因为没有查到关于向SQLite数据库中存二维数组的方法的资料,所以我将这个过程实现为了先将二维数组连接成字符串,然后存入数据库中,取出后再将其转换为二维数组。
package com.ezreal.ezchat.utils;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
/**
* Created by
*/
public class ImageSQLiteHelper extends SQLiteOpenHelper {
public static final int VERSION = 1;
public ImageSQLiteHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version){
super(context, name, factory, version);
}
public ImageSQLiteHelper(Context context, String name, int version){
this(context,name,null,version);
}
public ImageSQLiteHelper(Context context, String name){
this(context,name,VERSION);
}
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
sqLiteDatabase.execSQL("create table array(id varchar(20), content text, name int)");
System.out.println("create a tableBase!");
}
@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
}
}
它的后续使用在之后要写的用户手写字体输入activity中
ContentValues values = new ContentValues();
char letter = (char)('!'+count);
String str = ""+letter;
values.put("id",str);
values.put("content",s);
values.put("name",count);
ImageSQLiteHelper dbHelper = new ImageSQLiteHelper(CreateActivity.this,"my_nn_database");
SQLiteDatabase db = dbHelper.getWritableDatabase();
db.insert("array",null,values);