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 (北京市)