public class DBHelper extends SQLiteOpenHelper {public final static String DATABASENAME = "diaryOpenHelper.db";public final static int DATABASEVERSION = 1;//创建数据库public DBHelper(Context context,String name,CursorFactory factory,int version){super(context, name, factory, version);}//创建表等机构性文件public void onCreate(SQLiteDatabase db){String sql ="create table diary"+"("+"_id integer primary key autoincrement,"+"topic varchar(100),"+"content varchar(1000)"+")";db.execSQL(sql);List<ClassifyFoodType> list = ClassifyFoodTypeManagerDao.findAllClassifyFoodChannel();    for(ClassifyFoodType item : list){        ContentValues values = new ContentValues();        values.put(NEWS_CATEGORY_TBL_CLASSIFYFOODID, item.getClassifyFoodId());        values.put(NEWS_CATEGORY_TBL_CLASSIFYFOODNAME, item.getClassifyFoodName());        values.put(NEWS_CATEGORY_TBL_CLASSIFYFOODTYPE, item.getClassifyFoodType());                            db.insert(NEWS_CATEGORY_TBL_GUODOURECIPE, null, values);    }}//若数据库版本有更新，则调用此方法public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){String sql = "drop table if exists diary";db.execSQL(sql);this.onCreate(db);}}