I am new to Sqlite, I am unable to insert values in DB, by the following code both database and tables are created but the values are no inserted, What is wrong with my code? Any suggestions!!! I am able to see the alert values are stored but not able to see in table data.

     $("#btnDefaultSave").click(function(){
              var Latlongs = "Test1";
              var Location = "Test2";
              var Category = "Test3";
              var Address = "Test4";
              var db = window.sqlitePlugin.openDatabase({name: "TestDB"});
              db.transaction(function (tx) {
   tx.executeSql('CREATE TABLE IF NOT EXISTS Locationlog (id INTEGER PRIMARY KEY, Coordinates TEXT, Location TEXT, Category TEXT, Address TEXT)');
          });
     db.transaction(function (tx){
tx.executeSql('INSERT INTO Locationlog (Coordinates, Location, Category, Address) VALUES ('+Latlongs+', '+Location+', '+Category+', '+Address+')');
                                                                        alert("values are stored");
                                                                        });

                                                        });

I have changed the format of insert query as follows,

     db.transaction(function (tx){

  tx.executeSql('INSERT INTO Locationlog (Coordinates, Location, Category, Address) VALUES (?,?,?,?)',[Latlongs,Location,Category,Address]);
   alert("values are stored");
       });