[android-developers] hi

public class loginactivity extends Activity{

@Override

protected void onCreate(Bundle savedInstanceState) {

// TODO Auto-generated method stub

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

Log.e("oncreate", "inside oncreate");

final EditText userid = (EditText) findViewById(R.id.userid);

   final EditText userpassword = (EditText) findViewById(R.id.userpassword);

Button b1 = (Button) findViewById(R.id.button1);

b1.setOnClickListener(new OnClickListener(){

public void onClick(View v) {

Log.e("onclick","inside onclick"); 

String username = userid.getText().toString();

String password = userpassword.getText().toString();

try{

Log.e("try","inside try");

if(username.length() > 0 && password.length() >0)

{

DatabaseAdapter dbUser = new DatabaseAdapter(loginactivity.this);

dbUser.open();

Log.e("if", "inside if loop");

if(dbUser.Login(username, password))

{

Toast.makeText(loginactivity.this,"Successfully Logged In", Toast.LENGTH_LONG).show();

}else{

Toast.makeText(loginactivity.this,"Invalid Username/Password", Toast.LENGTH_LONG).show();

}

dbUser.close();

}

}catch(Exception e)

{

Toast.makeText(loginactivity.this,e.getMessage(), Toast.LENGTH_LONG).show();

}

}

});

}

}

package com.example.mylogin;

import android.content.ContentValues;

import android.content.Context;

import android.database.Cursor;

import android.database.SQLException;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import android.util.Log;

public class DatabaseAdapter{

public static final String KEY_ROWID = "_id";

public static final String KEY_USERNAME = "username";

public static final String KEY_PASSWORD = "password";

private static final String TAG = "DBAdapter";

private static final String DATABASE_NAME = "usersdb";

private static final String DATABASE_TABLE = "users";

private static final int DATABASE_VERSION = 1;

private static final String DATABASE_CREATE = "create table users (_id integer primary key autoincrement, "

+ "username text not null, " + "password text not null);";

private Context context = null;

private DatabaseHelper DBHelper;

private SQLiteDatabase db;

public DatabaseAdapter(Context ctx) {

this.context = ctx;

DBHelper = new DatabaseHelper(context);

}

public static class DatabaseHelper extends SQLiteOpenHelper {

DatabaseHelper(Context context) {

super(context, DATABASE_NAME, null, DATABASE_VERSION);

}

public void onCreate(SQLiteDatabase db) {

db.execSQL(DATABASE_CREATE);

}

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

Log.w(TAG, "Upgrading database from version " + oldVersion + " to "

+ newVersion + ", which will destroy all old data");

db.execSQL("DROP TABLE IF EXISTS users");

onCreate(db);

}

}

public boolean Login(String username, String password) 

{

Cursor mCursor = db.rawQuery("SELECT * FROM " + DATABASE_TABLE

+ " WHERE username=? AND password=?", new String[] { username,

password });

if (mCursor != null) {

if (mCursor.getCount() > 0) 

{

return true;

}

}

return false;

}

public void open() throws SQLException {

db = DBHelper.getWritableDatabase();

}

public void close() throws SQLException {

DBHelper.close();

}

public long AddUser(String username, String password) {

ContentValues initialValues = new ContentValues();

initialValues.put(KEY_USERNAME, username);

initialValues.put(KEY_PASSWORD, password);

return db.insert(DATABASE_TABLE, null, initialValues);

}

}

i'm having problem with this program please help me

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en