1.创建数据库表的时候选择存图片的字段类型为blob

?

Java代码

1. StringBuffer createTableOfHistory = new StringBuffer();
2. createTableOfHistory.append("CREATE TABLE "+某表名);
3. createTableOfHistory.append(" ( _id INTEGER PRIMARY KEY AUTOINCREMENT ,");
4. createTableOfHistory.append(该存图片的字段名+" BLOB ,");
5. createTableOfHistory.append(其他字段名1+" TEXT ,");
7. .......
9. createTableOfHistory.append(其他字段名n+" TEXT );");//记得这里带个“;”封号
10. db.execSQL(createTableOfHistory.toString());//执行该创表语句

StringBuffer createTableOfHistory = new StringBuffer();
createTableOfHistory.append("CREATE TABLE "+某表名);
createTableOfHistory.append(" ( _id INTEGER PRIMARY KEY AUTOINCREMENT ,");
createTableOfHistory.append(该存图片的字段名+" BLOB ,");
createTableOfHistory.append(其他字段名1+" TEXT ,");

.......

createTableOfHistory.append(其他字段名n+" TEXT );");//记得这里带个“;”封号
db.execSQL(createTableOfHistory.toString());//执行该创表语句

?

?

?

2.存储数据

2.1将数据流转成数组的方法

Java代码

1. InputStream inputStream = getResources().openRawResource(R.drawable.icon);
3. private static byte[] streamToBytes(InputStream is) {
4. ByteArrayOutputStream os = new ByteArrayOutputStream(1024);
5. byte[] buffer = new byte[1024];
6. int len;