음식 검색을 하면 아무런 결과가 안나오는데 뭐가 잘못된 것일까요?

 

테이블명 : SF

DB명 : FOOD.sql

 

         STATE     CITY      SFOOD    URL

1       경상도      경주          과자        11

2       경상도      경주            쌀           12

3      경상도       경주          미역        13

4      경상도       경주        다시마      14

 

public class DBFood extends SQLiteOpenHelper {

   private static  final String  DATABASE_NAME = "FOOD.sql";
   private static  final int  DATABASE_VERSION = 1;
   private final  Context mContext;
    
       public DBFood(Context context) {
             super(context, DATABASE_NAME, null, DATABASE_VERSION);
             this.mContext = context;
    }   
    @Override
    public void onCreate(SQLiteDatabase db) {   
     StringBuffer sqlStr = new StringBuffer();
    
        sqlStr.append("\n CREATE TABLE BOARD (   ");
        sqlStr.append("\n   SEQ   INTEGER PRIMARY KEY AUTOINCREMENT ");
        sqlStr.append("\n  ,STATE  TEXT   ");
        sqlStr.append("\n  ,CITY TEXT   ");
        sqlStr.append("\n  ,SFOOD  TEXT   ");
        sqlStr.append("\n  ,URL   TEXT   ");
        sqlStr.append("\n );        ");
       
        db.beginTransaction();     
        try {
              db.execSQL(sqlStr.toString());
              db.setTransactionSuccessful();
        
               Log.d("DBFOOD.onCreate", "BOARD table was created");
        
         }catch (SQLException se) {
                // TODO: handle exception
                Log.e("DBFOOD.onCreate", se.toString());
         }catch (Exception e) {
                 // TODO: handle exception
                 Log.e("DBFOOD.onCreate", e.toString());
         }finally{
                 db.endTransaction();
         }
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
          // TODO Auto-generated method stub
          onCreate(db);
     }
 
 public BoardCursor searchList(String searchType, String SearchValue){
      StringBuffer sqlStr = new StringBuffer();
     
 sqlStr.append("\n SELECT * FROM 'SF' WHERE SFOOD");

     
     SQLiteDatabase  rd = getReadableDatabase();


         BoardCursor  bc = (BoardCursor) rd.rawQueryWithFactory(
              new BoardCursor.Factory()
              ,sqlStr.toString()
              ,null
              ,null);
 

        bc.moveToFirst();
 
     return bc;
  }
 
 public static class BoardCursor extends SQLiteCursor{
 
  public BoardCursor(SQLiteDatabase db, SQLiteCursorDriver driver, String editTable, SQLiteQuery query) {
             super(db, driver, editTable, query);
             // TODO Auto-generated constructor stub
  }
 
  public static class Factory implements SQLiteDatabase.CursorFactory{
  
           public Cursor newCursor(
                 SQLiteDatabase   db
                ,SQLiteCursorDriver  masterQuery
                ,String     editTable
                ,SQLiteQuery    query) {

          return new BoardCursor(db, masterQuery, editTable, query);
   }
  }
 }
}