음식 검색을 하면 아무런 결과가 안나오는데 뭐가 잘못된 것일까요?
테이블명 : 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);
}
}
}
}




테이블 명 다르지 않나요?
create 문 보니까 테이블 명을 BOARD로 주셨는데
select문은 테이블 명을 SF로 하시는 것 같네요.