title: SQLite android login and register
body: <p>From the previous question I asked, I am still having the same question. I do not know how to use database (SQLite) to 'sync' with my application to log in or register </p>
  
  <pre><code> package log1.log2;
  
  
  import android.app.Activity;
  import android.content.Intent;
  import android.os.Bundle;
  import android.view.View;
  import android.view.View.OnClickListener;
  import android.widget.Button;
  import android.widget.EditText;
  import android.widget.TextView;
  
  
  
  public class Login extends Activity {
  
  
   UserDB db = new UserDB(this);
  /** Called when the activity is first created. */
  
   private EditText etUsername;
   private EditText etPassword;
   private Button btnLogin;
   private Button btnRegister;
   private TextView lblResult;
  
      @Override
  
      public void onCreate(Bundle savedInstanceState) {
  
          super.onCreate(savedInstanceState);
  
          setContentView(R.layout.main);
       // Get the EditText and Button References
          etUsername = (EditText)findViewById(R.id.usernametxt);
          etPassword = (EditText)findViewById(R.id.passwordtxt);
          btnLogin = (Button)findViewById(R.id.btnLogin);
          btnRegister = (Button)findViewById(R.id.btnRegister);
          lblResult = (TextView)findViewById(R.id.msglbl);
  
          //Cursor c = (Cursor) db.getAllTitles();
  
          //Button btnArrival = (Button) findViewById(R.id.btnRegister);
       //btnArrival.setOnClickListener(this);
  
  
      // Set Click Listener
  
          btnRegister.setOnClickListener(new OnClickListener() {
           @Override
           public void onClick(View v) {
            Intent intent=new Intent(Login.this,Register.class);
              startActivity(intent);
  
           }
          });
  
      btnLogin.setOnClickListener(new OnClickListener() {
   @Override
   public void onClick(View v) {
    db.open();
    // Check Login
    String username = etUsername.getText().toString();
    String password = etPassword.getText().toString();
  
    if(username.equals("select username from Users")){
     if(password.equals("select password from users where username = username"))
     {
  
       Intent intent=new Intent(Login.this,Test.class);
       startActivity(intent);
  
  
     }
     else
     {
      lblResult.setText("Wrong password");
     }
  
    } else {
     lblResult.setText("Username does not exist. Please register.");
    }
  
    db.close();
   }
  });  
  
  
  
  
  }
  
  }
  </code></pre>
  
  <p>Should I use the 'select' 'from' 'where' statement? Or there is another way? </p>