插入数据

示例如下,省略数据库连接操作:

func insertWithParam1(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)
}