sqlite插入数据sql语句

1、sqlite插入语句正确的形式：
   例一：
        stmt.text = "INSERT INTO snNetShop (province) VALUES ('北京市')";
   例二：
        stmt.text = "INSERT INTO snNetShop (province, name, addr, lat, lng) VALUES ('" + snID.province[i].@pName + "', " + 
                           "'" + snID.province.point[j].name + "', " +
             "'" + snID.province.point[j].addr + "', " + 
             "'" + snID.province.point[j].lat + "', " + 
             "'" + snID.province.point[j].lng + "')";
   trace出的字符串的形式为：INSERT INTO snNetShop (province) VALUES ('北京市')
   总结：自己定义的变量要写在单引号里面，而单引号由双引号包裹着!

2、错误的写法：
   stmt.text ="INSERT INTO snNetShop (province, name, addr, lat, lng) VALUES (" + snID.province[i].@pName + ", " + snID.province.point[j].name +
                       ", " + snID.province.point[j].addr + ", " + snID.province.point[j].lat + 
                       ", " + snID.province.point[j].lng + ");";
   错误的trace出的字符串的形式则为：INSERT INTO snNetShop (province) VALUES (北京市)