名称绑定¶
示例如下,演示通过名称方式绑定参数
func bindParam2(db * sql.DB){
var err error
var result sql.Result
var rowsAffected int64
var insertSQL string = "insert into testcase1(col1, col2) values(:c1, :c2)"
var tStr string = "hello2!"
result, err = db.Exec(insertSQL, sql.Named("c1", 10), sql.Named("c2", tStr))
getError(err)
rowsAffected, err = result.RowsAffected()
getError(err)
fmt.Println(rowsAffected)
}