Hey,
I have two activities one is Database helper and other is main activity. There is no sytax error but whenever I press Accept button (accButton), my app stops working.
Please help me out thanks.
DBHelper class:
And this is Main activity class:
I have two activities one is Database helper and other is main activity. There is no sytax error but whenever I press Accept button (accButton), my app stops working.
Please help me out thanks.
DBHelper class:
Java:
package com.example.anum.lmslite;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.Toast;
public class sqliteDbHelper extends SQLiteOpenHelper {
public static final int DATABASE_VERSION = 1;
public static final String DATABASE_NAME = "LMSLiteDB.db";
public static final String TABLE_NAME = "LMSLiteDB";
public static final String COLUMN_ID = "ID";
public static final String COLUMN_PASSWORD = "Password";
public static final String COLUMN_Name = "Name";
public static final String COLUMN_VUEmail = "VU-Email";
public static final String COLUMN_CITY = "City";
public static final String COLUMN_COUNTRY = "Country";
public static final String COLUMN_SELECTEDCOURSE = "Selected_Course";
//constructor for SQLiteDBHelper class
public sqliteDbHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION); //four perameters factory is null
}
//implementing and overriding two methods of SQLiteDatabaseOpenHelper class
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table" + TABLE_NAME + "create table LMSLiteDB(ID text primary key not null," +
"Password text not null, Name text not null, VU-Email text not null, City text not null," +
"Country text not null, Selected_Course text not null);");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS" + TABLE_NAME);
onCreate(db);
}
public boolean insertValues(String id, String autoPass, String name, String mail, String city, String contry , String selectedCourse) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(COLUMN_ID, id);
values.put(COLUMN_PASSWORD, autoPass);
values.put(COLUMN_Name, name);
values.put(COLUMN_VUEmail, mail);
values.put(COLUMN_CITY, city);
values.put(COLUMN_COUNTRY, contry);
values.put(COLUMN_SELECTEDCOURSE, selectedCourse);
long result = db.insert(TABLE_NAME, null, values);
if (result == -1)
return false;
else
return true;
}
/*public String searchinf(String id) {
db = this.getReadableDatabase();
String query = "select ID , Password from" + TABLE_NAME;
Cursor cursor = db.rawQuery(query, null);
String dbName, dbPassword;
dbPassword = "Password not found";
dbName = cursor.getString(0);
if (dbName.equals(id)) {
dbPassword = cursor.getString(1);
} else{
return dbPassword; }
return dbPassword;
}*/
}
And this is Main activity class:
Java:
sqliteDbHelper db = new sqliteDbHelper(this);
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_accept);
String fName = getIntent().getStringExtra("fName");
TextView tfName = (TextView)findViewById(R.id.fName);
tfName.setText(fName);
String vuEmail = getIntent().getStringExtra("vuEmail");
TextView tEmail = (TextView)findViewById(R.id.vuEmail);
tEmail.setText(vuEmail);
String id = getIntent().getStringExtra("id");
TextView tId = (TextView)findViewById(R.id.id);
tId.setText(id);
String password = getIntent().getStringExtra("password");
TextView tPassword = (TextView)findViewById(R.id.password);
tPassword.setText(password);
String city = getIntent().getStringExtra("city");
TextView tCity = (TextView)findViewById(R.id.city);
tCity.setText(city);
String contry = getIntent().getStringExtra("contry");
TextView tContry = (TextView)findViewById(R.id.contry);
tContry.setText(contry);
String item = getIntent().getStringExtra("item");
TextView tItem = (TextView)findViewById(R.id.item);
tItem.setText(item);
}
public void onAccClick(View view) {
TextView tfName = (TextView) findViewById(R.id.fName);
TextView tEmail = (TextView) findViewById(R.id.vuEmail);
TextView tId = (TextView) findViewById(R.id.id);
TextView tPassword = (TextView) findViewById(R.id.password);
TextView tCity = (TextView) findViewById(R.id.city);
TextView tContry = (TextView) findViewById(R.id.contry);
TextView tItem = (TextView) findViewById(R.id.item);
boolean isInserted = db.insertValues(tId.getText().toString(), tPassword.getText().toString(), tfName.getText().toString(),
tEmail.getText().toString(), tCity.getText().toString(), tContry.getText().toString(),
tItem.getText().toString());
if (isInserted = true) {
Toast.makeText(ACCEPT.this, "Data Inserted", Toast.LENGTH_LONG).show();
} else {
Toast.makeText(ACCEPT.this, "Data not Inserted", Toast.LENGTH_LONG).show();
}
}