I have created a SQLite DB in Android Studio which stores 4 values. When I
attempt to create another column to store another piece of data, the data
is not being store in DB. Only the first 4 columns I created are being used.
Here's the code for reference:
DATABASEHELPERCLASS:
package com.example.rahul.referenceproject;
/**
* Created by Rahul on 9/8/17.
*/
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class DatabaseHelper extends SQLiteOpenHelper {
public static final String DATABASE_NAME = "fueldata.db";
public static final String TABLE_NAME = "fuel_data";
public static final String COL_1 = "ID";
public static final String COL_2 = "NAME";//PRICE
public static final String COL_3 = "SURNAME";//GALLLONS
public static final String COL_4 = "MARKS";//TOTALAMT
//public static final String COL_5 = "STATION";
public DatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
//db.execSQL("create table " + TABLE_NAME + COL_1 + " INTEGER PRIMARY
KEY AUTOINCREMENT , " + COL_2 + " TEXT," +
// COL_3 + " TEXT, "+ COL_4 + " INTEGER, " + COL_5 + " TEXT" +
")");//STATION TEXT)");
db.execSQL("create table " + TABLE_NAME +" (ID INTEGER PRIMARY KEY
AUTOINCREMENT , PRICE TEXT , GALLONS TEXT , TOTAL TEXT )"); //STATION TEXT ) ");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME);
onCreate(db);
}
public boolean insertData(String price,String gallons,String ttlamt){ //,
String station) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues contentValues = new ContentValues();
contentValues.put(COL_2,price);
contentValues.put(COL_3,gallons);
contentValues.put(COL_4,ttlamt);
//contentValues.put(COL_5,station);
long result = db.insert(TABLE_NAME,null ,contentValues);
if(result == -1)
return false;
else
return true;
}
public Cursor getAllData() {
SQLiteDatabase db = this.getWritableDatabase();
Cursor res = db.rawQuery("select * from "+TABLE_NAME,null);
return res;
}
public boolean updateData(String id,String price,String gallons,String
ttlamt){//, String station) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues contentValues = new ContentValues();
contentValues.put(COL_1,id);
contentValues.put(COL_2,price);
contentValues.put(COL_3,gallons);
contentValues.put(COL_4,ttlamt);
//contentValues.put(COL_5,station);
db.update(TABLE_NAME, contentValues, "ID = ?",new String[] { id });
return true;
}
public Integer deleteData (String id) {
SQLiteDatabase db = this.getWritableDatabase();
return db.delete(TABLE_NAME, "ID = ?",new String[] {id});
}
}
MAIN ACTIVITY
package com.example.rahul.referenceproject;
import android.app.AlertDialog;
import android.database.Cursor;
import android.support.v7.app.ActionBarActivity;
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
public class MainActivity extends AppCompatActivity {
DatabaseHelper myDb;
EditText editPrice,editGallons,editTotalAmt ,editTextId, editStation;
Button btnAddData;
Button btnviewAll;
Button btnDelete;
Button btnviewUpdate;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
myDb = new DatabaseHelper(this);
editPrice = (EditText)findViewById(R.id.editText_price);
editGallons = (EditText)findViewById(R.id.editText_gallons);
editTotalAmt = (EditText)findViewById(R.id.editText_totalamt);
//editTextId = (EditText)findViewById(R.id.editText_id);
//editStation=(EditText) findViewById(R.id.editText_Station);
btnAddData = (Button)findViewById(R.id.button_add);
btnviewAll = (Button)findViewById(R.id.button_viewAll);
btnviewUpdate= (Button)findViewById(R.id.button_update);
btnDelete= (Button)findViewById(R.id.button_delete);
AddData();
viewAll();
}
public void AddData() {
btnAddData.setOnClickListener(
new View.OnClickListener() {
@Override
public void onClick(View v) {
if (editPrice.getText().toString().isEmpty());
{
editPrice.setError("Invalid price");
}
if
(editPrice.getText().toString().contains("!@#$%^&*()_+?><:{}[];',./-="));
{
editPrice.setError("Please enter a valid price");
}
if
(editPrice.getText().toString().contains("qwertyuiopasdfghjklzxcvbnm"));
{
editPrice.setError("Please enter a valid price");
}
if (editGallons.getText().toString().isEmpty());
{
editGallons.setError("Please enter the number of
gallons before proceeding");
}
if (editGallons.getText().toString().length()==2)
{
editGallons.setError("Please enter the number of
gallons before proceeding");
}
if
(editGallons.getText().toString().contains("!@#$%^&*()_+?><:{}[];',./-="));
{
editGallons.setError("Please enter a valid number
of gallons");
}
if (editTotalAmt.getText().toString().isEmpty());
{
editTotalAmt.setError("Please enter the total
amount before proceeding");
}
if (editTotalAmt.getText().toString().length()==4)
{
editTotalAmt.setError("Please enter the total
amount before proceeding");
}
if
(editTotalAmt.getText().toString().contains("!@#$%^&*()_+?><:{}[];',./-="));
{
editTotalAmt.setError("Please enter a valid total
amount");
}
boolean isInserted =
myDb.insertData(editPrice.getText().toString(),
editGallons.getText().toString(),
editTotalAmt.getText().toString());//,
editStation.getText().toString() );
if(isInserted == true)
Toast.makeText(MainActivity.this,"Data
Inserted",Toast.LENGTH_LONG).show();
else
Toast.makeText(MainActivity.this,"Data not
Inserted",Toast.LENGTH_LONG).show();
editPrice.getText().clear();
editGallons.getText().clear();
editTotalAmt.getText().clear();
}
}
);
}
public void viewAll() {
btnviewAll.setOnClickListener(
new View.OnClickListener() {
@Override
public void onClick(View v) {
Cursor res = myDb.getAllData();
if(res.getCount() == 0) {
// show message
showMessage("Error","Nothing found");
return;
}
StringBuffer buffer = new StringBuffer();
while (res.moveToNext()) {
buffer.append("Id :"+ res.getString(0)+"\n");
buffer.append("Price :"+ res.getString(1)+"\n");
buffer.append("Gallons :"+ res.getString(2)+"\n");
buffer.append("Ttlamt :"+ res.getString(3)+"\n");
//buffer.append("Station :"+
res.getString(4)+"\n\n");
}
// Show all data
showMessage("Data",buffer.toString());
}
}
);
}
public void showMessage(String title,String Message){
AlertDialog.Builder builder = new AlertDialog.Builder(this);
builder.setCancelable(true);
builder.setTitle(title);
builder.setMessage(Message);
builder.show();
}
}
--
You received this message because you are subscribed to the Google Groups
"Android Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to android-developers+unsubscr...@googlegroups.com.
To post to this group, send email to android-developers@googlegroups.com.
Visit this group at https://groups.google.com/group/android-developers.
To view this discussion on the web visit
https://groups.google.com/d/msgid/android-developers/e82293ec-15d4-4334-9edc-c1e4c0d95ad1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
