Android SQLite, create db with 4 columns and insert values

Question

I am missing something with all of the android SQLite tutorials.

I want to create a SQLite database that holds the autoincrementing key, and four text fields that I will pass in

I intend to pass in this SQL database

private static final String INSERT = "insert into " + TABLE_NAME + "(field1) values (?)" + "(field2) values (?)" + "(field3) values (?)";

but I'm not sure if the android sdk has a proper insert function.

I'm not sure how "Cursor" relates to anything I am trying to do, and I'm not sure how much object oriented initializing I should be trying to as opposed to just calling some built in android sdk functions.

insight appreciated, but please break it down

Gopal · Accepted Answer · 2011-06-13 23:22:11Z

2

Will recommend you to go through NotePad exercise here is a link. Specially go through Exercise 1.

And for more depth knowledge you can go through project which I have created. Here is a link

Look for creatFeed function call here. I think will help to answer your problem.

edited Jun 13, 2011 at 23:22

answered Jun 13, 2011 at 23:14

Gopal

1,71912 silver badges13 bronze badges

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

3 Comments

CQM Over a year ago

the creatFeed class looks very relevant to what I am trying to do. Which class do you call it and do the inserts and other queries in? FeedDB it seems

Gopal Over a year ago

I call it from RSSHandler class here is link and look at line 160. Sorry man, do not have good comments. Still working on this project. And rest of the queries I call from this class here is link

Gopal Over a year ago

@RD, If answer helped you to resolve your problem, will appreciate if you can tick and accept my answer. Will help me to increase my reputation. Thanks.

Collectives™ on Stack Overflow

Android SQLite, create db with 4 columns and insert values

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related