I would like to Insert data in my next columns of TABLE with help of
Signup2Activity which has been already inserted by "SIgnup1Activity.java".
HereBy i had attached all the necessary file to find the error.
ERROR: Database: near "Where": near "INSERT INTO"+TABLE+" ( "+columns+")
VALUES ("+first.getText().toString()+") WHERE "+ID+ "="+ id;
how can we insert data in next columns of database with already entered
data in their first few columns??
ANy help is most welcome!!
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=enpackage com.project.vikalp;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
public class DatabaseHandler extends SQLiteOpenHelper {
public static final String DATABASE_NAME="registerdb";
public static final int DATABASE_VERSION=1;
public static final String TABLE="register";
private static final String _ID="id";
public static final String FIRST_NAME="firstname";
public static final String LAST_NAME="lastname";
public static final String EMAIL1="email1";
public static final String PASSWORD="password";
public static final String CONFIRM_PASSWORD="confirmpassword";
public static final String SECURITY1="security1";
public static final String ANSWER1="answer1";
public static final String SECURITY2="security2";
public static final String ANSWER2="answer2";
public static final String EMAIL2="email2";
public static final String UPLOAD="upload";
public static final String[] allColumns={_ID,FIRST_NAME,LAST_NAME,EMAIL1,PASSWORD,CONFIRM_PASSWORD
,SECURITY1,ANSWER1,SECURITY2,ANSWER2,EMAIL2,UPLOAD};
public DatabaseHandler(Context context)
{
super(context,DATABASE_NAME,null,DATABASE_VERSION);
}
public void onCreate(SQLiteDatabase database)
{
String DATABASE_CREATE = "create table "
+ TABLE
+"(" + _ID +" " + "integer primary key autoincrement,"
+ FIRST_NAME+" " + "text not null,"
+ LAST_NAME +" "+ "text not null,"
+ EMAIL1 +" "+ "text not null,"
+ PASSWORD +" "+ "text not null,"
+ CONFIRM_PASSWORD +" "+ "text not null,"
+ SECURITY1 +" " +"text,"
+ ANSWER1 +" "+ "text ,"
+ SECURITY2 +" "+ "text,"
+ ANSWER2 +" "+ "text,"
+ EMAIL2 +" "+"text,"
+ UPLOAD + " "+"text"
+ ")";
database.execSQL(DATABASE_CREATE);
Log.w("Create:","Creating Database...");
}
public void onUpgrade(SQLiteDatabase database,int oldversion,int newversion)
{
Log.w(SignupActivity.class.getName(),"Upgrading Database Version"
+ oldversion + "to" +newversion );
//database.execSQL("DROP TABLE IF EXISTS"+ TABLE);
onCreate(database);
}
public void addregister(Register register)
{
SQLiteDatabase db= this.getWritableDatabase();
ContentValues values=new ContentValues();
values.put(FIRST_NAME,register.getFName());
values.put(LAST_NAME, register.getLName());
values.put(EMAIL1,register.getEmail1());
values.put(PASSWORD, register.getPass());
values.put(CONFIRM_PASSWORD,register.getCPass());
db.insert(TABLE, null, values);
db.close();
}
public void addregister1(Register register)
{
SQLiteDatabase db=this.getWritableDatabase();
String sec,ans1,sec2,ans2,mail2;
sec=register.getSecurity1();
ans1=register.getAnswer1();
sec2=register.getSecurity2();
ans2=register.getAnswer2();
mail2=register.getEmail2();
String[] wid={Integer.toString(register.getId())};
String sql="INSERT INTO " + TABLE + "("
+ SECURITY1 + ","
+ ANSWER1 + ","
+ SECURITY2 + ","
+ ANSWER2 + ","
+ EMAIL2
+") VALUES("
+ sec + ","
+ ans1 + ","
+ sec2 + ","
+ ans2 + ","
+ mail2
+") "
+"WHERE "+_ID +" = ?";
// db.update(TABLE,values1, _ID +" = ?",new String[]{(String.valueOf(register.getId())) });
/*db.execSQL("INSERT INTO " + TABLE + "("
+ SECURITY1 + ","
+ ANSWER1 + ","
+ SECURITY2 + ","
+ ANSWER2 + ","
+ EMAIL2
+") VALUES("
+ sec + ","
+ ans1 + ","
+ sec2 + ","
+ ans2 + ","
+ mail2
+") "
+"WHERE "+_ID +" = "+register.getId());*/
db.rawQuery(sql, wid);
db.close();
}
public int getId(Register register)
{
SQLiteDatabase db= this.getReadableDatabase();
Cursor cursor=db.query(TABLE,allColumns, null, null, null, null, null);
cursor.moveToLast();
int i=Integer.parseInt(cursor.getString(0));
return i;
}
/*public void onUpdate(SQLiteDatabase database)
{
database.execSQL("ALTER TABLE"+ TABLE+"ADD"
+SECURITY1+ " " +"text,"
+ ANSWER1 +" "+ "text ,"
+ SECURITY2 +" "+ "text,"
+ ANSWER2 +" "+ "text,"
+ EMAIL2 +" "+"text,"
);
}*/
}
package com.project.vikalp;
public class Register {
int _id;
String _fname,_lname,_email1,_pass,_cpass,_security1,_answer1,_security2,_answer2,_upload,_email2;
public Register(String fname, String lname, String email1, String pass, String cpass)
{
this._fname=fname;
this._lname=lname;
this._email1=email1;
this._pass=pass;
this._cpass=cpass;
}
public Register(int id,String security1, String answer1, String security2, String answer2, String email2)
{
this._security1=security1;
this._answer1=answer1;
this._security2=security2;
this._answer2=answer2;
this._email2=email2;
this._id=id;
}
public Register()
{
}
public Register(String upload)
{
this._upload=upload;
}
public String getFName()
{
return this._fname;
}
public String getLName()
{
return this._lname;
}
public String getEmail1()
{
return this._email1;
}
public String getPass()
{
return this._pass;
}
public String getCPass()
{
return this._cpass;
}
public String getSecurity1()
{
return this._security1;
}
public String getAnswer1()
{
return this._answer1;
}
public String getSecurity2()
{
return this._security2;
}
public String getAnswer2()
{
return this._answer2;
}
public String getEmail2()
{
return this._email2;
}
public String getUpload()
{
return this._upload;
}
public int getId()
{
return this._id;
}
public void setFName(String fname)
{
this._fname=fname;
}
public void setLName(String lname)
{
this._lname=lname;
}
public void getEmail1(String email1)
{
this._email1=email1;
}
public void setPass(String pass)
{
this._pass=pass;
}
public void setCPass(String cpass)
{
this._cpass=cpass;
}
public void setSecurity1(String security1)
{
this._security1=security1;
}
public void setAnswer1(String answer1)
{
this._answer1=answer1;
}
public void setSecurity2(String security2)
{
this._security2=security2;
}
public void setAnswer2(String answer2)
{
this._answer2=answer2;
}
public void setEmail2(String email2)
{
this._email2=email2;
}
public void setUpload(String upload)
{
this._upload=upload;
}
}
package com.project.vikalp;
import com.project.vikalp.R;
import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
public class Signup1Activity extends Activity
{
//Spinner spinsecurity1;
EditText answer1,security2,answer2,email2,security1;
Button reg1back,reg1next;
public void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.register1);
/* spinsecurity1=(Spinner)findViewById(R.id.security1);
ArrayAdapter<CharSequence> adapter= ArrayAdapter.createFromResource(this, R.array.security1spinner, android.R.layout.simple_spinner_item);
adapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
spinsecurity1.setAdapter(adapter);
spinsecurity1.setOnItemSelectedListener(new MyOnItemSelectedListener());*/
security1=(EditText)findViewById(R.id.security1);
answer1=(EditText)findViewById(R.id.answer1);
security2=(EditText)findViewById(R.id.security2);
answer2=(EditText)findViewById(R.id.answer2);
email2=(EditText)findViewById(R.id.email2);
reg1back=(Button)findViewById(R.id.reg1back);
reg1next=(Button)findViewById(R.id.reg1next);
final DatabaseHandler mydb=new DatabaseHandler(this);
reg1next.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
Log.d("Insert:","Updating More Registration Info...");
final String sec1=security1.getText().toString();
final String ans1=answer1.getText().toString();
final String sec2=security2.getText().toString();
final String ans2=answer2.getText().toString();
final String mail1=email2.getText().toString();
int id=mydb.getId(new Register());
mydb.addregister1(new Register(id,sec1,ans1,sec2,ans2,mail1));
Log.d("Update:", "Updating via Second-Form Of Registration...");
Intent i=new Intent(getApplicationContext(),Signup2Activity.class);
startActivity(i);
}
});
reg1back.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
Intent i=new Intent(getApplicationContext(),SignupActivity.class);
startActivity(i);
}
});
}
/* public class MyOnItemSelectedListener implements OnItemSelectedListener
{
public void onItemSelected(AdapterView<?> parent, View v, int pos, long id)
{
String security1=parent.getItemAtPosition(pos).toString();
Toast.makeText(parent.getContext(), " "+parent.getItemAtPosition(pos).toString() , Toast.LENGTH_SHORT).show();
}
@Override
public void onNothingSelected(AdapterView<?> arg0) {
// TODO Auto-generated method stub
}
}
*/
}
package com.project.vikalp;
import com.project.vikalp.R;
import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.CheckBox;
import android.widget.Toast;
public class Signup2Activity extends Activity {
CheckBox accept;
Button submit,back,upload;
public void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.register2);
accept=(CheckBox)findViewById(R.id.checkbox);
submit=(Button)findViewById(R.id.register);
back=(Button)findViewById(R.id.reg2back);
upload=(Button)findViewById(R.id.upload);
back.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
}
});
upload.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
Intent i=new Intent();
i.setType("image/*");
i.setAction(Intent.ACTION_GET_CONTENT);
int REQUEST_CODE=100;
startActivityForResult(Intent.createChooser(i, "Select Picture..."), REQUEST_CODE);
}
});
submit.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
Toast.makeText(getApplicationContext(), "Finally get Updated...", Toast.LENGTH_SHORT).show();
}
});
}
}
