DB를 불러오는 가족에서 syntax error 가 뜹니다.. [closed]

Question

public class LoginActivity extends AppCompatActivity {
    DBHelper_User db;
    List<UserModel> list;
    TextView Idinput, Pwdinput, Nameinput;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_login);
        Nameinput = (TextView)findViewById(R.id.inputName);
        Idinput = (TextView)findViewById(R.id.inputId);
        Pwdinput = (TextView)findViewById(R.id.inputPwd);
        final EditText LogId = (EditText)findViewById(R.id.logID);
        final EditText LogPwd = (EditText)findViewById(R.id.logPWD);
        Button LogBtn = (Button) findViewById(R.id.Login);
        Button Regist = (Button)findViewById(R.id.Regist);

        db = new DBHelper_User(this);
        final UserModel model = new UserModel();
        list = db.GetAllUser();

마지박 부분의 GetAllUser 에서 "SQLiteDatabase": syntax error 가 뜹니다.

public List<UserModel> GetAllUser(){
    StringBuffer stringBuffer = new StringBuffer();
    stringBuffer.append("SELECT _ID, UserId, UserPwd, UserName FROM User order by _ID desc");
    SQLiteDatabase sdb = getReadableDatabase();
    Cursor cursor = sdb.rawQuery(sdb.toString(), null);
    List<UserModel> userList = new ArrayList<UserModel>();
    Log.d("RESULT",cursor.getCount()+"");
    UserModel user = null;
    while (cursor.moveToNext()){
        user = new UserModel();
        user.ID = String.valueOf(cursor.getInt(0));
        user.UserId = cursor.getString(1);
        user.UserPwd = cursor.getString(2);
        user.UserName = cursor.getString(3);
        userList.add(user);
        }
    sdb.close();
    return userList;
}

불러오는 DB는 이렇구요. 

 

java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.jangan.myapplication/com.example.jangan.myapplication.LoginActivity}: android.database.sqlite.SQLiteException: near "SQLiteDatabase": syntax error (code 1 SQLITE_ERROR): , while compiling: SQLiteDatabase: /data/user/0/com.example.jangan.myapplication/databases/User
        at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2913)
        at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3048)
        at android.app.servertransaction.LaunchActivityItem.execute(LaunchActivityItem.java:78)
        at android.app.servertransaction.TransactionExecutor.executeCallbacks(TransactionExecutor.java:108)
        at android.app.servertransaction.TransactionExecutor.execute(TransactionExecutor.java:68)
        at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1808)
        at android.os.Handler.dispatchMessage(Handler.java:106)
        at android.os.Looper.loop(Looper.java:193)
        at android.app.ActivityThread.main(ActivityThread.java:6669)
        at java.lang.reflect.Method.invoke(Native Method)
        at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:493)
        at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:858)
     Caused by: android.database.sqlite.SQLiteException: near "SQLiteDatabase": syntax error (code 1 SQLITE_ERROR): , while compiling: SQLiteDatabase: /data/user/0/com.example.jangan.myapplication/databases/User
       

로그캣은 이렇습니다ㅠㅠ

Cursor 부분에서 오류가 난다고 하는데 왜 나는지 알려주실 수 있으신가요..?

Comments

at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
        at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:903)
        at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:514)
        at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
        at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
        at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
        at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:46)
        at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1408)
        at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1347)
        at com.example.jangan.myapplication.DBHelper_User.GetAllUser(DBHelper_User.java:70)
        at com.example.jangan.myapplication.LoginActivity.onCreate(LoginActivity.java:38)
        at android.app.Activity.performCreate(Activity.java:7136)
        at android.app.Activity.performCreate(Activity.java:7127)
        at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1271)
        at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2893)
        at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3048)
        at android.app.servertransaction.LaunchActivityItem.execute(LaunchActivityItem.java:78)
        at android.app.servertransaction.TransactionExecutor.executeCallbacks(TransactionExecutor.java:108)
        at android.app.servertransaction.TransactionExecutor.execute(TransactionExecutor.java:68)
        at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1808)
        at android.os.Handler.dispatchMessage(Handler.java:106)
        at android.os.Looper.loop(Looper.java:193)
        at android.app.ActivityThread.main(ActivityThread.java:6669)
        at java.lang.reflect.Method.invoke(Native Method)
        at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:493)
        at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:858)

---

로그캣이 뒤에 더 있어 올립니다!

---

http://www.masterqna.com/android/1 이거 참고하셔서 좀 더 보기쉽게 정리해보세요.

---

감사합니다! 코드 다시 정리해서 작성했습니다~

---

하시는 김에 로그도 하시죠. 댓글에 있는 로그도 본문으로 옮기시고요.
https://susemi99.gitbooks.io/howto-for-beginners/content/chapter2.html

---

ㅠㅠ 다시 질문했습니다 급해서 코드만 올리고 갔었네요 죄송합니다..

---

다시 질문이 아니라 본문 수정만 하면 될 일이었는데요 ;;;;