demo for web sql

order.js

var order = { 
    orderId: 100314, format_city: "New York, NY, USA", 
    lat: 40.7127837, lng: -74.0059413,
    price: 150, createTime: "2017-06-08"
};

const db = window.openDatabase("order_test", "1.0", "order map data", 2*1024*1024)

db.transaction(function(tx){
    tx.executeSql( "create table if not exists order_data(order_id primary key, format_city, lat, lng, price, create_time)", [], null,  
      function(tx, err){
          throw(`execute sql failed: ${err.code} ${err.message}`);
      });
    tx.executeSql(`insert into order_data values(${order.orderId}, '${order.format_city}',
          ${order.lat}, ${order.lng}, ${order.price}, '${date}')`);
});