---------- Forwarded message ----------
From: Devendran Raju <[email protected]>
Date: Mon, Sep 19, 2011 at 7:56 PM
Subject: Doubt on database access.
To: [email protected]
This is my code. While run this program i could not access the database.
Exception is coming. Please give me the sollution.
import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Spinner;
public class OwnerRegistration extends Activity implements
AdapterView.OnItemSelectedListener {
private final String SAMPLE_DB_NAME = "my_Db";
private final String SAMPLE_TABLE_NAME = "login";
private final String SAMPLE_TABLE_COL = "Questions";
private final String SQ_Table_Name = "tblSecurityQuestion";
int i=0;
String[] ques=new String[10];
EditText user_name, password, c_password, F_n, L_n, adr, cty, state, zip,
email, security_A;
Spinner security_Q;
Button button_1, button_2;
String user, pass, c_pass, F_name, L_name, Addr, City, State, Zip, Email,
Security_A;
//String pass;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.registration);
user_name=(EditText)findViewById(R.id.editText1);
password=(EditText)findViewById(R.id.editText2);
c_password=(EditText)findViewById(R.id.editText3);
F_n=(EditText)findViewById(R.id.editText4);
L_n=(EditText)findViewById(R.id.editText5);
adr=(EditText)findViewById(R.id.editText6);
cty=(EditText)findViewById(R.id.editText7);
state=(EditText)findViewById(R.id.editText8);
zip=(EditText)findViewById(R.id.editText9);
email=(EditText)findViewById(R.id.editText10);
security_Q=(Spinner)findViewById(R.id.spinner1);
security_A=(EditText)findViewById(R.id.editText11);
Button myButton = (Button) findViewById(R.id.b1);
myButton.setOnClickListener(new View.OnClickListener() {
public void onClick(View v) {
insert();
}
});
Button myButton2 = (Button) findViewById(R.id.b2);
myButton2.setOnClickListener(new View.OnClickListener() {
public void onClick(View v) {
Intent intent = new Intent(getApplicationContext(),
Session_2Activity.class);
startActivity(intent);
}
});
spinnerQry();
security_Q.setOnItemSelectedListener(this);
ArrayAdapter<String> adp=new ArrayAdapter<String>(this,
android.R.layout.simple_spinner_item, ques);
adp.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
security_Q.setAdapter(adp);
}
public void onItemSelected(AdapterView<?> parent, View v, int
position, long id) {
//tv.setText(items[position]);
}
public void onNothingSelected(AdapterView<?> parent) {
//tv.setText("");
}
public void insert( ) {
user=user_name.getText().toString();
pass=password.getText().toString();
c_pass=c_password.getText().toString();
F_name=F_n.getText().toString();
L_name=L_n.getText().toString();
Addr=adr.getText().toString();
City=cty.getText().toString();
State=state.getText().toString();
Zip=zip.getText().toString();
Email=email.getText().toString();
// Security_Q=security_Q.getText().toString();
Security_A=security_A.getText().toString();
Log.v("first",user);
Log.v("last",pass);
SQLiteDatabase sampleDB = null;
try {
sampleDB = this.openOrCreateDatabase(SAMPLE_DB_NAME,
MODE_PRIVATE, null);
//sampleDB.execSQL("SELECT "+SAMPLE_TABLE_Spnner+" from
"+SQ_Table_Name,new String [] {});
sampleDB.execSQL("INSERT INTO " + SAMPLE_TABLE_NAME +"(user,
pwd, c_pwd, f_name, l_name, address, city, state, zip, email, security_a)"+
" Values
('"+user+"','"+pass+"','"+c_pass+"','"+F_name+"','"+L_name+"','"+Addr+"','"+City+"','"+State+"','"+Zip+"','"+Email+"','"+Security_A+"');");
} catch (SQLiteException se ) {
Log.e(getClass().getSimpleName(), "Could not create or Open
the database");
} finally {
if (sampleDB != null)
sampleDB.close();
user_name.setText("");
password.setText("");
c_password.setText("");
F_n.setText("");
L_n.setText("");
adr.setText("");
cty.setText("");
state.setText("");
zip.setText("");
email.setText("");
//security_Q.setText(spn);
security_A.setText("");
}
}
private void spinnerQry(){
SQLiteDatabase sampleDB = null;
try {
sampleDB = this.openOrCreateDatabase(SAMPLE_DB_NAME,
MODE_PRIVATE, null);
Cursor c = sampleDB.rawQuery("SELECT "+SAMPLE_TABLE_COL+"
FROM " + SQ_Table_Name , null);
if (c != null ) {
if (c.moveToFirst()) {
for (int i = 0; i < c.getCount(); i++){
ques[i] =
c.getString(c.getColumnIndex(SAMPLE_TABLE_COL));
}
}
}
} catch (SQLiteException se ) {
Log.e(getClass().getSimpleName(), "Could not create or Open
the database");
} finally {
if (sampleDB != null)
sampleDB.close();
}
}
}
--
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=en
