How To Add New Column Into Database, I Already Have A Database Which The Username And Password Data.I Want To Add Firstlastname,Email,Phone,Address Column Into The Database

See more:

Java

Eclipse

i have LoginDatabaseAdapter,DataBaseHelper,MainActivity,SignUpActivity

public class LoginDataBaseAdapter {

static final String DATABASE_NAME = "customer.db";
static final int DATABASE_VERSION = 1;
public static final int NAME_COLUMN = 1;
// TODO: Create public field for each column in your table.
// SQL Statement to create a new database.
static final String DATABASE_CREATE = "create table "+"CUSTOMER"+
"( " +"ID"+" integer primary key autoincrement,"+"FIRSTLASTNAME text"+"EMAIL text" +"PHONE INT"+"ADDRESS text"+ "USERNAME text,PASSWORD text, ); ";
// Variable to hold the database instance
public SQLiteDatabase db;
// Context of the application using the database.
private final Context context;
// Database open/upgrade helper
private DataBaseHelper dbHelper;
public LoginDataBaseAdapter(Context _context)
{
context = _context;
dbHelper = new DataBaseHelper(context, DATABASE_NAME, null, DATABASE_VERSION);
}
public LoginDataBaseAdapter open() throws SQLException
{
db = dbHelper.getWritableDatabase();
return this;
}
public void close()
{
db.close();
}

public SQLiteDatabase getDatabaseInstance()
{
return db;
}

public void insertEntry(String FirstLastName,String Email,int Phone,String Address,String userName,String password)
{
ContentValues newValues = new ContentValues();
// Assign values for each row.
newValues.put("FIRSTLASTNAME", FirstLastName);
newValues.put("EMAIL",Email);
newValues.put("PHONE", Phone);
newValues.put("ADDRESS",Address);
newValues.put("USERNAME", userName);
newValues.put("PASSWORD",password);

// Insert the row into your table
db.insert("CUSTOMER", null, newValues);
///Toast.makeText(context, "Reminder Is Successfully Saved", Toast.LENGTH_LONG).show();
}
public int deleteEntry(String UserName)
{
//String id=String.valueOf(ID);
String where="USERNAME=?";
int numberOFEntriesDeleted= db.delete("CUSTOMER", where, new String[]{UserName}) ;
// Toast.makeText(context, "Number for Entry Deleted Successfully : "+numberOFEntriesDeleted, Toast.LENGTH_LONG).show();
return numberOFEntriesDeleted;
}
public String getSinlgeEntry(String userName)
{
Cursor cursor=db.query("CUSTOMER", null, " USERNAME=?", new String[]{userName}, null, null, null);
if(cursor.getCount()<1) // UserName Not Exist
{
cursor.close();
return "NOT EXIST";
}
cursor.moveToFirst();
String password= cursor.getString(cursor.getColumnIndex("PASSWORD"));
cursor.close();
return password;
}
public void updateEntry(String FirstLastName,String Email,int Phone,String Address,String userName,String password)
{
// Define the updated row content.
ContentValues updatedValues = new ContentValues();
// Assign values for each row.
updatedValues.put("FIRSTLASTNAME", FirstLastName);
updatedValues.put("EMAIL",Email);
updatedValues.put("PHONE", Phone);
updatedValues.put("ADDRESS",Address);
updatedValues.put("USERNAME", userName);
updatedValues.put("PASSWORD",password);

String where="USERNAME = ?";
db.update("CUSTOMER",updatedValues, where, new String[]{userName});
}
}


public class SignUpActivity extends Activity {

EditText editTextUserName,editTextPassword,editTextConfirmPassword, txtName, txtEmail, txtPhone, txtAddress;
ImageButton btnSignIn;

LoginDataBaseAdapter loginDataBaseAdapter;
@Override
protected void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.sign_up);

// get Instance of Database Adapter
loginDataBaseAdapter=new LoginDataBaseAdapter(this);
loginDataBaseAdapter=loginDataBaseAdapter.open();

// Get References of Views
editTextUserName=(EditText)findViewById(R.id.editTextUserName);
editTextPassword=(EditText)findViewById(R.id.editTextPassword);
editTextConfirmPassword=(EditText)findViewById(R.id.editTextConfirmPassword);
txtName = (EditText) findViewById(R.id.txtName);
txtEmail = (EditText) findViewById(R.id.txtEmail);
txtPhone = (EditText) findViewById(R.id.txtPhone);

btnSignIn=(ImageButton) findViewById(R.id.btnSignIn);
btnSignIn.setOnClickListener(new View.OnClickListener() {

public void onClick(View v) {
// TODO Auto-generated method stub

String FirstLastName = txtName.getText().toString();
String Email = txtEmail.getText().toString();
int Phone = Integer.parseInt(txtPhone.getText().toString());
String Address = txtAddress.getText().toString();
String userName=editTextUserName.getText().toString();
String password=editTextPassword.getText().toString();
String confirmPassword=editTextConfirmPassword.getText().toString();




// check if any of the fields are vacant
if(userName.equals("")||password.equals("")||confirmPassword.equals(""))
{
Toast.makeText(getApplicationContext(), "Field Vaccant", Toast.LENGTH_LONG).show();
return;
}
// check if both password matches
if(!password.equals(confirmPassword))
{
Toast.makeText(getApplicationContext(), "Password does not match", Toast.LENGTH_LONG).show();
return;
}
else
{
// Save the Data in Database
loginDataBaseAdapter.insertEntry(FirstLastName,Email,Phone,Address,userName,password);
Toast.makeText(getApplicationContext(), "Account Successfully Created ", Toast.LENGTH_LONG).show();
}
}
});
}
@Override
protected void onDestroy() {
// TODO Auto-generated method stub
super.onDestroy();

loginDataBaseAdapter.close();
}
}

public class MainActivity extends ActionBarActivity {


ImageButton btnSignIn;
EditText txtUsername, txtPassword;
TextView register,txtSignup;
LoginDataBaseAdapter loginDataBaseAdapter;

@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);

// create a instance of SQLite Database
loginDataBaseAdapter=new LoginDataBaseAdapter(this);
loginDataBaseAdapter=loginDataBaseAdapter.open();

btnSignIn = (ImageButton) findViewById(R.id.btnSignIn);
txtUsername = (EditText) findViewById(R.id.editTextUserName);
txtPassword = (EditText) findViewById(R.id.txtPassword);

txtSignup = (EditText) findViewById(R.string.title_activity_sign_up);
String tempString="Register to Sign In this application";
TextView txtSignup=(TextView)findViewById(R.id.txtSignup);
SpannableString spanString = new SpannableString(tempString);
spanString.setSpan(new UnderlineSpan(), 0, spanString.length(), 0);
txtSignup.setText(spanString);
txtSignup.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {
// TODO Auto-generated method stub

Intent i = new Intent ("com.example.SignUpActivity");
startActivity (i);
}
});

btnSignIn.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {

// get The User name and Password
String userName = txtUsername.getText().toString();
String passWord = txtPassword.getText().toString();

// fetch the Password form database for respective user name
String storedPassword=loginDataBaseAdapter.getSinlgeEntry(userName);

// check if the Stored password matches with Password entered by user

if(passWord.equals(storedPassword))
{
Toast.makeText(MainActivity.this, "Congrats: Login Successfull", Toast.LENGTH_LONG).show();

}
else
{
Toast.makeText(MainActivity.this, "User Name or Password does not match", Toast.LENGTH_LONG).show();
}
}
});

}
@Override
protected void onDestroy() {
super.onDestroy();
// Close The Database
loginDataBaseAdapter.close();
}



@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.main, menu);
return true;
}

@Override
public boolean onOptionsItemSelected(MenuItem item) {
// Handle action bar item clicks here. The action bar will
// automatically handle clicks on the Home/Up button, so long
// as you specify a parent activity in AndroidManifest.xml.
int id = item.getItemId();
if (id == R.id.action_settings) {
return true;
}
return super.onOptionsItemSelected(item);
}
}

public class DataBaseHelper extends SQLiteOpenHelper {

public DataBaseHelper(Context context, String name, CursorFactory factory,int version)
{
super(context, name, factory, version);

}
// Called when no database exists in disk and the helper class needs
// to create a new one.
@Override
public void onCreate(SQLiteDatabase _db) {

_db.execSQL(LoginDataBaseAdapter.DATABASE_CREATE);
}

// Called when there is a database version mismatch meaning that the version
// of the database on disk needs to be upgraded to the current version.
@Override
public void onUpgrade(SQLiteDatabase db, int _oldVersion, int _newVersion) {

// Log the version upgrade.
Log.w("TaskDBAdapter", "Upgrading from version " +_oldVersion + " to " +_newVersion + ", which will destroy all old data");


// Upgrade the existing database to conform to the new version. Multiple
// previous versions can be handled by comparing _oldVersion and _newVersion
// values.
// The simplest case is to drop the old table and create a new one.
db.execSQL("DROP TABLE IF EXISTS " + "TEMPLATE");
// Create a new one.
onCreate(db);

}

}