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

---

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

---

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