顺序绑定

示例如下,演示通过顺序方式绑定参数

func bindParam1(db * sql.DB){
        var err          error
        var result       sql.Result
        var rowsAffected int64
        var insertSQL    string = "insert into testcase1(col1, col2) values(:1, :2)"
        var tStr         string = "hello2!"
        result, err = db.Exec(insertSQL, 10, tStr)
        getError(err)
        rowsAffected, err = result.RowsAffected()
        getError(err)
        fmt.Println(rowsAffected)
}