Android Sqlite Database Setup Issue

Question

Hey Folks am making a simple application in which ill insert two accounts manually into a table for the login authentication and then after that ill do some working based on the accounts type. Am having issues in setting up Sqlite functions. I have one package com.example.emp_management and in it i have 2 classes MainActivity.java and Database_Wrap.java. Code for the Database_Wrap.java is given below:

package com.example.emp_management;


import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class Database_Wrap            //hotornot
{
public static final String Database_name = "Employee_Managament_System";
public Sql_Lite_Work OurHelper;
public  final Context OurContext;
public SQLiteDatabase ourDatabase;

public static class Sql_Lite_Work extends SQLiteOpenHelper
{   //dbhelper = sql_lite_work

    public Sql_Lite_Work(Context context) 
    {
        super(context,Database_name , null, 1);
        // TODO Auto-generated constructor stub
    }
    @Override
    public void onCreate(SQLiteDatabase db)
    {
        // TODO Auto-generated method stub

        db.execSQL("CREATE TABLE" + "Login_Authentication"+ "(" +
               "ID" + "INTEGER PRIMARY KEY AUTOINCREMENT, " +
                "UserName" + "TEXT NOT NULL," +
               "Password" + "TEXT NOT NULL);"                   
                );

    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
    {
        // TODO Auto-generated method stub

        db.execSQL("DROP TABLE IF EXISTS " + "Login_Authentication");
        onCreate(db);
    }


}
public Database_Wrap(Context c)
{
    OurContext = c;
}
public Database_Wrap Open()
{
    OurHelper = new Sql_Lite_Work(OurContext);
    ourDatabase = OurHelper.getWritableDatabase();
    return this;
}
public void close()
{
    OurHelper.close();
}
}

Now next thing i want to do is in my mainactivity i want to do something like:

Database_Wrap entry= new Database_Wrap(MainActivity.this);

and then acces the function written in Database_Wrap to open the database and write the values into table for admin and other users:

entry.Open();

but in eclipse am not able to access open function on entry. I dnt know what is wrong here. Am a beginer. May be am forgetting something. Kindly have a look thankyou!

the point is when i write entry. i get nothing in eclipse so .Open or .open is not the point here :) — Alfred
– Alfred, Commented Feb 17, 2013 at 15:20
@GreenGuerilla methods in Java start with lower-case (Java convention). — m0skit0
– m0skit0, Commented Feb 17, 2013 at 15:28

Raghav Sood · Accepted Answer · 2013-02-17 15:25:26Z

1

Java is case sensitive. Try:

Database_Wrap entry= new Database_Wrap(MainActivity.this);

Both your ws in Wrap were lower case.

answered Feb 17, 2013 at 15:25

Raghav Sood

82.6k26 gold badges195 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alfred Over a year ago

i have correct my question the things you are pointing out are already handled in my code. there is this something else which am not able to spot out

Raghav Sood Over a year ago

@Alfred Check under the problems tab in eclipse for a more exact error message

G. Blake Meike · Accepted Answer · 2013-02-17 17:12:29Z

0

I just put your code into a small test project. It compiles just fine. I then added this code, in an Activity in the same project:

protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);

    Database_Wrap entry= new Database_Wrap(MainActivity.this);
    entry.Open();
}

That too, works just fine.

Judging by the appearance of the code (nothing at all wrong with it, just that the style makes experienced Java devs cringe), you are new to Java; probably eclipse too. Eclipse is weird and does funky stuff all the time. Perhaps you've just encountered some short term anomaly.

answered Feb 17, 2013 at 17:12

G. Blake Meike

6,7053 gold badges27 silver badges41 bronze badges

Collectives™ on Stack Overflow

Android Sqlite Database Setup Issue

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related