Thursday, 21 March 2013

SIMPLE SQLITE DATABASE APPLICATION

                                                   1.SQL  BASIC SYNTAX
Create DataBase                           
                   CREATE DATABASE database_name
Create Table
                    CREATE TABLE table_name
                        (
                        column_name1 data_type,
                        column_name2 data_type,
                        column_name3 data_type,
                        ....
                        )
InsertValues
                       INSERT INTO table_name
                      VALUES (value1, value2, value3,...)
                      like below
                      INSERT INTO Persons
                     VALUES (4,'Nilsen', 'Johan', 'Bakken 2', 'Stavanger')

 DeleteValues
                     DELETE FROM table_name
                    WHERE some_column=some_value
                     like below
                     DELETE FROM Persons
                     WHERE LastName='Tjessem' AND FirstName='Jakob'
UpdateValues
                   UPDATE table_name
                   SET column1=value, column2=value2,...
                   WHERE some_column=some_value
 -------------------------------------------------------------------------------------------------------------
                                                       2.SQLiteOpenHelper


                                 
 SQLiteOpenHelper is Superclass ,Which is use for Database Operations







 

No comments:

Post a Comment