let path = NSSearchPathForDirectoriesInDomains(.documentDirectory, .userDomainMask, true)[0]\nlet db = try? Connection(\"\\(path)\/Chuhuo.sqlite\")\n<\/code><\/pre>\n\u63a5\u4e0b\u4f86\uff0c\u6211\u5011\u9700\u8981\u5275\u5efa\u4e00\u500b\u8cc7\u6599\u8868\uff0c\u9019\u88e1\u6211\u5011\u4f7f\u7528 `stock` \u4f5c\u70ba\u8868\u540d\uff1a<\/p>\n
let users = Table(\"stock\")\n<\/code><\/pre>\n\u7136\u5f8c\u8a2d\u7f6e\u8cc7\u6599\u8868\u7684\u6b04\u4f4d\u8cc7\u6599\u683c\u5f0f\uff0c\u9664\u4e86 id \u6b04\u4f4d\u5916\uff0c\u6211\u5011\u5c07\u4f7f\u7528 String \u4f86\u9032\u884c\u6e2c\u8a66\uff1a<\/p>\n
let id = Expression<Int64>(\"id\")\nlet price = Expression<String>(\"price\")\nlet product = Expression<String>(\"product\")\nlet date = Expression<String>(\"date\")\nlet amount = Expression<String>(\"amount\")\n<\/code><\/pre>\n\u63a5\u4e0b\u4f86\uff0c\u6211\u5011\u5c07\u5275\u5efa\u8cc7\u6599\u8868\uff0c\u4e26\u78ba\u4fdd id \u6b04\u4f4d\u662f\u4e3b\u9375\uff0c\u4ee5\u4fbf\u65bc\u672a\u4f86\u7684\u8cc7\u6599\u5eab\u7ba1\u7406\uff1a<\/p>\n
\u65b0\u589e CREATE<\/h2>\n
\u4f7f\u7528\u4ee5\u4e0b\u7a0b\u5f0f\u78bc\u5275\u5efa\u8cc7\u6599\u8868\uff1a<\/p>\n
try! db?.run(users.create(ifNotExists: true, block: { (table) in\n table.column(id, primaryKey: true)\n table.column(price)\n table.column(product)\n table.column(date)\n table.column(amount)\n}))\n<\/code><\/pre>\n\u9019\u6bb5\u7a0b\u5f0f\u78bc\u7b49\u540c\u65bc\u4ee5\u4e0b\u7684 SQL \u8a9e\u53e5\uff1a<\/p>\n
CREATE TABLE IF NOT EXISTS \"stock\" (\n \"id\" INTEGER PRIMARY KEY NOT NULL,\n \"price\" TEXT,\n \"product\" TEXT,\n \"date\" TEXT,\n \"amount\" TEXT\n)\n<\/code><\/pre>\n\u63d2\u5165 INSERT<\/h2>\n
\u63a5\u4e0b\u4f86\uff0c\u6211\u5011\u5c07\u65b0\u589e\u8cc7\u6599\u5230\u8cc7\u6599\u8868\u4e2d\u3002\u4ee5\u4e0b\u662f\u63d2\u5165\u8cc7\u6599\u7684\u7bc4\u4f8b\u7a0b\u5f0f\u78bc\uff1a<\/p>\n
do {\n let rowid = try db?.run(users.insert(price <- \"100\", product <- \"car\", date <- \"2025\/06\/01\", amount <- \"1\"))\n print(\"inserted id: \\(rowid!)\")\n} catch {\n print(\"insertion failed: \\(error)\")\n}\n<\/code><\/pre>\n\u9019\u6bb5\u7a0b\u5f0f\u78bc\u7684 SQL \u7b49\u50f9\u8a9e\u53e5\u5982\u4e0b\uff1a<\/p>\n
INSERT INTO stock (price, product, date, amount) VALUES ('100', 'car', '2025\/06\/01', '1')\n<\/code><\/pre>\n\u67e5\u8a62 SELECT<\/h2>\n
\u8981\u67e5\u8a62\u8cc7\u6599\uff0c\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u7a0b\u5f0f\u78bc\uff1a<\/p>\n
for user in (try? db?.prepare(users))!! {\n print(\"id: \\(user[id]), price: \\(user[price]), product: \\(user[product])\")\n}\n<\/code><\/pre>\n\u9019\u6bb5\u7a0b\u5f0f\u78bc\u5c0d\u61c9\u7684 SQL \u8a9e\u53e5\u662f\uff1a<\/p>\n
SELECT * FROM stock\n<\/code><\/pre>\n\u66f4\u65b0 UPDATE<\/h2>\n
\u82e5\u8981\u66f4\u65b0\u8cc7\u6599\uff0c\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u7a0b\u5f0f\u78bc\uff1a<\/p>\n
let alice = users.filter(id == 5)\ntry? db?.run(alice.update(price <- \"130\"))\n<\/code><\/pre>\n\u9019\u76f8\u7576\u65bc\u4ee5\u4e0b\u7684 SQL \u8a9e\u53e5\uff1a<\/p>\n
UPDATE stock SET price = '130' WHERE id = 5\n<\/code><\/pre>\n\u522a\u9664 DELETE<\/h2>\n
\u6700\u5f8c\uff0c\u82e5\u8981\u522a\u9664\u8cc7\u6599\uff0c\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u7a0b\u5f0f\u78bc\uff1a<\/p>\n
let alice = users.filter(id == 5)\ntry? db?.run(alice.delete())\n<\/code><\/pre>\n\u5c0d\u61c9\u7684 SQL \u8a9e\u53e5\u70ba\uff1a<\/p>\n
DELETE FROM stock WHERE id = 5\n<\/code><\/pre>\n\u4ee5\u4e0a\u662f\u4f7f\u7528 SQLite \u5728 Swift \u4e2d\u9032\u884c\u57fa\u672c\u8cc7\u6599\u64cd\u4f5c\u7684\u5b8c\u6574\u6d41\u7a0b\u3002\u6211\u5011\u5df2\u7d93\u6e2c\u8a66\u904e\u6240\u6709\u7a0b\u5f0f\u78bc\uff0c\u78ba\u4fdd\u5176\u6b63\u78ba\u904b\u884c\u3002<\/p>\n
\n
![\"Swift](\"https:\/\/badgameshow.com\/steven\/wp-content\/uploads\/2020\/11\/cup-1-1.png\" "\\"\\"")
<\/a><\/p>\n