插入或更新语句

func prepareStatementInsert(db * sql.DB){
        var err       error
        var stmt    * sql.Stmt
        var result    sql.Result
        var val1      int      = 10
        var val2      string   = "hello"
        var insertSQL string   = "insert into testcase1(col1, col2) values(:1, :2)"
        //准备查询语句
        stmt, err = db.Prepare(insertSQL)
        getError(err)
        defer stmt.Close()
        result, err = stmt.Exec(val1, val2)
        getError(err)
        //获取执行影响行数
        rowsAffected, err := result.RowsAffected()
        getError(err)
        fmt.Println(rowsAffected)
}