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 부분에서 오류가 난다고 하는데 왜 나는지 알려주실 수 있으신가요..?