android创建数据库(SQLite)保存图片示例

android创建数据库创建数据库(SQLite)保存图片示例保存图片示例

主要介绍了android创建数据库，保存图片到数据库再从数据库取图片的方法，大家参考使用吧

复制代码 代码如下:

//1.创建数据库

public class DBService extends SQLiteOpenHelper {

private final static int VERSION = 1;

private final static String DATABASE_NAME = "uniteqlauncher.db";

public DBService(Context context) {

@Override

public void onCreate(SQLiteDatabase db) {

String sql = "CREATE TABLE [launcher]("

+ "[_id] INTEGER PRIMARY KEY AUTOINCREMENT,"

+ "[photo] BINARY)"; //保存为binary格式

db.execSQL(sql);

}

@Override

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

if(newVersion > oldVersion){

}

//保存图片到数据库

public void savePhoto(Drawable appIcon, Context mContext){

LayoutInflater mInflater = (LayoutInflater) mContext

.getSystemService(Context.LAYOUT_INFLATER_SERVICE);

View v = inflater.inflate(R.layout.app_view, null);

ImageView iv = (ImageView) v.findViewById(R.id.appicon);

iv.setImageDrawable(appIcon);

String INSERT_SQL = "INSERT INTO launcher(photo) values(?)";

SQLiteDatabase db = mDBService.getWritableDatabase(); // 得到数据库

baos.close();

db.close();

} catch (Exception e) {

e.printStackTrace();

}

}

//3.从数据库中取图片

public void getPhoto() {

String SELECT_SQL = "SELECT photo FROM launcher";

ImageView appIcon = (ImageView) v.findViewById(R.id.appicon);//v是我在类中定义的一个view对象，跟前面保存图片一样