使用 QueryRowContent 在 Go 语言中调用存储过程

Question

我试图运行下面的代码段并不断抛出以下错误QueryRowContextsql: 应有 0 个参数，得到 2 个这种方法适用于纯 SQL 查询，当我尝试使用关键字将存储产品调用到query参数时，我不断遇到问题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}这里似乎出了什么问题？提前致谢。

Answer 1

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