Golang数据库操作错误处理技巧

result, err := db.Exec("INSERT INTO users(name, email) VALUES(?, ?)", name, email)
if err != nil {
    log.Printf("数据库插入失败: %v", err)
    // 可以根据错误类型做进一步处理
    return err
}

var user User
err := db.QueryRow("SELECT id, name FROM users WHERE id = ?", id).Scan(&user.ID, &user.Name)
if err != nil {
    if err == sql.ErrNoRows {
        log.Printf("用户不存在")
        return ErrUserNotFound
    }
    log.Printf("查询出错: %v", err)
    return err
}

if mysqlErr, ok := err.(*mysql.MySQLError); ok {
    switch mysqlErr.Number {
    case 1062:
        return ErrDuplicateEntry
    case 1045:
        return ErrInvalidCredentials
    }
}

tx, err := db.Begin()
if err != nil {
    return err
}
defer func() {
    if p := recover(); p != nil {
        tx.Rollback()
        panic(p)
    } else if err != nil {
        tx.Rollback()
    }
}()
_, err = tx.Exec("UPDATE accounts SET balance = balance - 100 WHERE userid = ?", from)
if err != nil {
return err
}
, err = tx.Exec("UPDATE accounts SET balance = balance + 100 WHERE user_id = ?", to)
if err != nil {
return err
}
err = tx.Commit()
if err != nil {
return err
}