jeudi 24 septembre 2015

SQLite database is not beeing created and no error coming

SQLite database is not beeing created while no error coming I have checked the android/data folder trying many things. I am using eclipse. Someone kindly help me and thanks in advance. My Database.java file is this

public class Database extends SQLiteOpenHelper {

    public static final String DATABASE_NAME="Table.db";
    public static final String TABLE_NAME="table_one";
    public static final String COL_1="ID";
    public static final String COL_2="NAME";
    public static final String COL_3="SURNAME";
    public static final String COL_4="MARKS";

    public Database(Context context) {
        super(context, TABLE_NAME, null, 1);
        // TODO Auto-generated constructor stub
    }

    @Override
    public void onCreate(SQLiteDatabase arg) {
        // TODO Auto-generated method stub
        arg.execSQL("create table "+TABLE_NAME+"(ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT, SURNAME TEXT, MARKS INTEGER)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase arg, int arg1, int arg2) {
        // TODO Auto-generated method stub
        arg.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME);
        onCreate(arg);
    }

    public boolean insert(String name, String sname, String marks)
    {
        SQLiteDatabase arg=this.getWritableDatabase();
        ContentValues content=new ContentValues();
        content.put(COL_2, name);
        content.put(COL_3, sname);
        content.put(COL_4, marks);
        long result=arg.insert(TABLE_NAME, null, content);
        if(result==-1)
            return false;
        else
        return true;

    }
}

MainActivity.java is

public class MainActivity extends Activity {

Database myDb;
EditText name,sname,marks;
Button add;
@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    myDb=new Database(this);
    name=(EditText)findViewById(R.id.ename);
    sname=(EditText)findViewById(R.id.esname);
    marks=(EditText)findViewById(R.id.emarks);
    add=(Button)findViewById(R.id.button1);
    addData();
}

public void addData()
{
    add.setOnClickListener(new View.OnClickListener() {

        @Override
        public void onClick(View arg0) {
            // TODO Auto-generated method stub
        boolean isInserted=myDb.insert(name.getText().toString(), sname.getText().toString(), marks.getText().toString());
        if(isInserted==true)
            Toast.makeText(MainActivity.this,"Data is inserted",Toast.LENGTH_LONG).show();
        else
            Toast.makeText(MainActivity.this,"Data is NOT inserted",Toast.LENGTH_LONG).show();
        }
    });
}

@Override
public boolean onCreateOptionsMenu(Menu menu) {
    // Inflate the menu; this adds items to the action bar if it is present.
    getMenuInflater().inflate(R.menu.main, menu);
    return true;
}

}

Aucun commentaire:

Enregistrer un commentaire