我試圖運(yùn)行下面的代碼段并不斷拋出以下錯(cuò)誤QueryRowContextsql: 應(yīng)有 0 個(gè)參數(shù)，得到 2 個(gè)這種方法適用于純 SQL 查詢，當(dāng)我嘗試使用關(guān)鍵字將存儲(chǔ)產(chǎn)品調(diào)用到query參數(shù)時(shí)，我不斷遇到問(wèn)題CALL。import ("database/sql""net/http")func VerifyUser(user User) (*User, string, error) { db, ctx := db.GetDB() query := "CALL usp_GetUserByUsername(@Email)"stmt, err := db.Prepare(query)if err != nil { log.Errorln("Error in preparing statement. " + err.Error()) return nil, "Error in preparing statement.", err}defer stmt.Close()row := stmt.QueryRowContext(ctx, sql.Named("Email", user.Email))var retUser Usererr = row.Scan(&retUser.ID, &retUser.Email, &retUser.Password, &retUser.Status)if err != nil { log.Warningln("Unknown Email: " + user.Email + ". " + err.Error()) return nil, "Invalid user.", err}這里似乎出了什么問(wèn)題？提前致謝。
1 回答
子衿沉夜
TA貢獻(xiàn)1828條經(jīng)驗(yàn) 獲得超3個(gè)贊
import (
"database/sql"
"net/http"
)
func VerifyUser(user User) (*User, string, error) {
db, ctx := db.GetDB()
query := "CALL usp_GetUserByUsername(?)"
stmt, err := db.Prepare(query)
if err != nil {
log.Errorln("Error in preparing statement. " + err.Error())
return nil, "Error in preparing statement.", err
}
defer stmt.Close()
row := stmt.QueryRowContext(ctx, user.Email)
var retUser User
err = row.Scan(&retUser.ID, &retUser.Email, &retUser.Password, &retUser.Status)
if err != nil {
log.Warningln("Unknown Email: " + user.Email + ". " + err.Error())
return nil, "Invalid user.", err
}
將查詢中的@Email 替換為 ? 并將電子郵件傳遞到 QueryRowContext not named statement
- 1 回答
- 0 關(guān)注
- 194 瀏覽
添加回答
舉報(bào)
0/150
提交
取消