sql-server - 如何在swift中执行插入、更新和删除(sql server)查询
问题描述
我正在尝试通过 Xcode (swift) 为我的业务创建一个 IOS 应用程序。我使用https://github.com/martinrybak/SQLClient进行连接并且我成功了。我可以连接,我可以执行选择查询,获得成功的结果。但我不知道如何快速执行插入、更新和删除查询。例如,对于删除查询(代码如下)没有结果,查询无法执行。对于更新查询(代码如下)“调用中的参数“完成”缺少参数”错误已经发生。我该如何完成这个问题,请帮助我。
@IBAction func FbtnDeleteAct(_ sender: Any) {
let username = FtxtUserOut.text
let usersifre = FtxtPassOut.text
let userstatu = FtxtStatuOut.text
if (username == "" || username == nil || usersifre == "" || usersifre == nil || userstatu == "" || userstatu == nil){
let alert = UIAlertController(title: "Deneme", message: "Kullanıcı Adı, Şifre ve Statu Boş Olamaz..", preferredStyle: .alert)
alert.addAction(UIAlertAction(title: "Tamam", style: .cancel, handler: nil))
self.present(alert, animated: true)
}else {
deletequery = "Delete from Usertbl where Id=" + kulid
client = SQLClient.sharedInstance()!
client.delegate = self
client.connect(strIP,username: strUName,password: strPass,database: strDBName){ success in
if success {
self.client.execute(self.deletequery){
results in
for table in results as! [[[String:AnyObject]]] {
for row in table {
for (columnName, value) in row {
print("\(columnName) = \(value)")}}}
}
}}
}
}
@IBAction func FbtnUpdateAct(_ sender: Any) {
let username = FtxtUserOut.text
let usersifre = FtxtPassOut.text
let userstatu = FtxtStatuOut.text
updatequery = "Update Usertbl set UserId='" + username! + "',Password='" + usersifre! + "' , UserStatus='" + userstatu! + "' where Id=" + kulid
if (username == "" || username == nil || usersifre == "" || usersifre == nil || userstatu == "" || userstatu == nil){
let alert = UIAlertController(title: "Deneme", message: "Kullanıcı Adı, Şifre ve Statu Boş Olamaz..", preferredStyle: .alert)
alert.addAction(UIAlertAction(title: "Tamam", style: .cancel, handler: nil))
self.present(alert, animated: true)
}else {
client = SQLClient.sharedInstance()!
client.delegate = self
client.connect(strIP,username: strUName,password: strPass,database: strDBName){ success in
if success {
self.client.execute(self.updatequery)
}}
}
}
调用 Insert '中缺少参数'completion' 的参数,完成:<#(([Any]?) -> Void)?#>'
解决方案
推荐阅读
- r - 按分隔符解析 sqldf
- homebrew - 如何安装专为不同(以前)版本的 macOS 设计的 Homebrew 瓶
- excel - VBA填充公式到最后一行
- linux - 阻止指向您的其他域
- java - 为什么 next() 方法会停止无限循环?
- laravel - Laravel 结合 Passport 认证和普通认证
- vue.js - 我如何使用计算属性从另一个商店中获取价值?
- python - TypeError:'numpy.ndarray'对象在for循环Python中不可调用
- python - 用卡尔曼滤波器过滤磁力计航向
- apache-nifi - 将字符串字段转换为 Nifi 记录中的 JSON 数组或 Avro 数组