名称绑定

示例如下,演示通过名称方式绑定参数

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)
}