4.23

mysql.java 

package 你的包名；

import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;


public class Mysql extends SQLiteOpenHelper {

private static final String DB_NAME="INFORM.db";
private static final int DB_VERSION=1;

public Mysql(Context context){
super(context,DB_NAME,null,DB_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(
"CREATE TABLE INFORMATION(" +
"_id INTEGER PRIMARY KEY AUTOINCREMENT,"
+"NAME TEXT,"
+"TITLE TEXT,"
+"image blob,"
+"TEXTS TEXT);"
);


insertTest(db, "程序员", "程序员.exe无响应","祝你有美好的一天");
insertTest(db, "程序员", "已停止运行","下辈子再也不用sqlite了");

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

}

public void insertTest(SQLiteDatabase db,String name,String title,String texts){
ContentValues value=new ContentValues();
value.put("NAME",name);
value.put("TITLE",title);
value.put("TEXTS",texts);
db.insert("INFORMTION",null,value);
}
}