LoginActivity.java

package notes.bapakkau;

import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class LoginActivity extends Activity {
    SQLiteDatabase db;
    Database sqlite, sqlite2;
    EditText user,pass;
    Button login, keluar;
    Cursor cursor;

    @SuppressWarnings("unused")

	public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.login);
        Database sqlite=new Database(this);
        final SQLiteDatabase db=sqlite.getWritableDatabase();

        user=(EditText)findViewById(R.id.edusername);
        pass=(EditText)findViewById(R.id.edpassword);
        login=(Button)findViewById(R.id.btnlogin);
        keluar=(Button)findViewById(R.id.btnkeluar);
        sqlite2=new Database(this);

        login.setOnClickListener(new View.OnClickListener() {

			public void onClick(View arg0) {

			SQLiteDatabase db=sqlite2.getReadableDatabase();
			cursor=db.rawQuery("Select*from login where username='"+ user.getText().toString() +
					"' and password= '" + pass.getText().toString() +"'", null);
				cursor.moveToFirst();
				if (cursor.getCount()>0){
					Toast.makeText(getBaseContext(), "Login Berhasil", Toast.LENGTH_SHORT).show();
					Intent i=new Intent (getBaseContext(),MenuActivity.class);
					startActivity(i);
				}else{
					Toast.makeText(getBaseContext(), "Login Gagal", Toast.LENGTH_SHORT).show();
				}
			}
		});

        keluar.setOnClickListener(new OnClickListener() {

			public void onClick(View arg0) {
				finish();

			}
		});

    }
}

//ig harymalau