I created a project in android database.
it first it work correctly but i remove some coding and again past it.then it show me
the "the bind value at index 1 is null"
when i press the follwoing delete button
delet_btn.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View arg0) {
try{
pass=delet_edtt.getText().toString();
DOP=new DatabaseOperations(CTX);
Cursor CR=DOP.getUserPass(DOP, USERNAME);
CR.moveToFirst();
boolean login_status=false;
String NAME="";
if( delet_edtt.getText().toString().trim().length()==0)
{
Toast.makeText(getBaseContext(), "Please Enter password", Toast.LENGTH_LONG).show();
}
else{
do{
if(USERNAME!=null)
{
if(pass.equals(CR.getString(0)))
{
login_status=true;
}
}
}while(CR.moveToNext());
if(login_status)
{
DOP.deleteUser(DOP, USERNAME, pass);
Toast.makeText(getBaseContext(), "Account removed successfully....", Toast.LENGTH_LONG).show();
}
else
{
Toast.makeText(getBaseContext(), "Invalid user password....try with correct password", Toast.LENGTH_LONG).show();
finish();
}
}
}
catch(Exception e)
{
Toast.makeText(getBaseContext(), e.getMessage(), Toast.LENGTH_LONG).show();
}
}
});
}
}
this is the database coding
public class DatabaseOperations extends SQLiteOpenHelper {
public static final int database_version=1;
public String CREATE_QUERY= "CREATE TABLE "+TableInfo.TABLE_NAME+"("+ TableInfo.USER_NAME+" TEXT,"+TableInfo.USER_PASS+" TEXT);";
public DatabaseOperations(Context context) {
super(context, TableInfo.DATABASE_NAME, null, database_version);
Log.d("Database operations","Database created");
}
@Override
public void onCreate(SQLiteDatabase sdb) {
sdb.execSQL(CREATE_QUERY);
Log.d("Database operations","Table created");
}
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
}
public void putInformation(DatabaseOperations dop,String name,String pass)
{
SQLiteDatabase SQ=dop.getWritableDatabase();
ContentValues cv=new ContentValues();
cv.put(TableInfo.USER_NAME, name);
cv.put(TableInfo.USER_PASS,pass);
long k= SQ.insert(TableInfo.TABLE_NAME, null, cv);
Log.d("Database operations","one raw inserted");
}
public Cursor getInformation(DatabaseOperations dop)
{
SQLiteDatabase SQ=dop.getReadableDatabase();
String[] columns={TableInfo.USER_NAME,TableInfo.USER_PASS};
Cursor CR=SQ.query(TableInfo.TABLE_NAME, columns, null, null, null, null, null);
return CR;
}
public Cursor getUserPass(DatabaseOperations DOP,String user)
{
SQLiteDatabase SQ=DOP.getReadableDatabase();
String selection=TableInfo.USER_NAME +" LIKE ?";
String columns[]={TableInfo.USER_PASS};
String args[]={user};
Cursor CR=SQ.query(TableInfo.TABLE_NAME, columns, selection, args, null, null, null);
return CR;
}
public void deleteUser(DatabaseOperations DOP,String user,String pass)
{
String selection=TableInfo.USER_NAME +" LIKE ? AND "+TableInfo.USER_PASS +" LIKE ?";
String columns[]={TableInfo.USER_PASS};
String args[]={user,pass};
SQLiteDatabase SQ=DOP.getWritableDatabase();
SQ.delete(TableInfo.TABLE_NAME,selection,args);
}
}