Go language development of door-to-door cooking system: How to implement user address management function?

Go language development of door-to-door cooking system: How to implement user address management function?

Introduction:
With the promotion of fast-paced life, more and more people choose to order takeout at home or book home cooking services to solve the problem of hunger. The door-to-door cooking system emerged as the times require, providing users with a convenient and fast healthy eating option. In this system, it is very important to implement the user address management function. This article will introduce in detail how to implement this function using Go language.

1. Database design
First, we need to design a database table to save the user's address information. In this table, we need to include at least the following fields:

• User ID: used to associate the user table
• Consignee name
• Mobile phone number
• Province
• City
• District/County
• Detailed address
• Default address flag: used to identify whether the address is the user's default address

2. Data model definition
In the Go language, we can use a structure to define a data model to represent the user's address information. The following is a sample code:

type Address struct {
    UserID       int    `json:"user_id"`
    ReceiverName string `json:"receiver_name"`
    PhoneNumber  string `json:"phone_number"`
    Province     string `json:"province"`
    City         string `json:"city"`
    District     string `json:"district"`
    Detail       string `json:"detail"`
    IsDefault    bool   `json:"is_default"`
}

In this structure, we use the json tag to specify the field names during JSON serialization and deserialization.

3. Database Operation
Next, we need to encapsulate some database operation methods to add, delete, modify and check user address information. The following is a simple sample code:

// 添加用户地址
func AddAddress(address Address) error {
    // 连接数据库
    db, err := sql.Open("mysql", "root:123456@tcp(localhost:3306)/mydb")
    if err != nil {
        return err
    }
    defer db.Close()

    // 执行插入操作
    _, err = db.Exec("INSERT INTO address(user_id, receiver_name, phone_number, province, city, district, detail, is_default) VALUES (?, ?, ?, ?, ?, ?, ?, ?)", address.UserID, address.ReceiverName, address.PhoneNumber, address.Province, address.City, address.District, address.Detail, address.IsDefault)
    if err != nil {
        return err
    }

    return nil
}

// 根据用户ID查询地址列表
func GetAddressesByUserID(userID int) ([]Address, error) {
    // 连接数据库
    db, err := sql.Open("mysql", "root:123456@tcp(localhost:3306)/mydb")
    if err != nil {
        return nil, err
    }
    defer db.Close()

    // 执行查询操作
    rows, err := db.Query("SELECT * FROM address WHERE user_id = ?", userID)
    if err != nil {
        return nil, err
    }
    defer rows.Close()

    // 解析查询结果
    addresses := []Address{}
    for rows.Next() {
        var address Address
        err := rows.Scan(&address.UserID, &address.ReceiverName, &address.PhoneNumber, &address.Province, &address.City, &address.District, &address.Detail, &address.IsDefault)
        if err != nil {
            return nil, err
        }
        addresses = append(addresses, address)
    }

    return addresses, nil
}

// 删除用户地址
func DeleteAddress(userID int, addressID int) error {
    // 连接数据库
    db, err := sql.Open("mysql", "root:123456@tcp(localhost:3306)/mydb")
    if err != nil {
        return err
    }
    defer db.Close()

    // 执行删除操作
    _, err = db.Exec("DELETE FROM address WHERE user_id = ? AND id = ?", userID, addressID)
    if err != nil {
        return err
    }

    return nil
}

In these methods, we use the database/sql package of Go language to connect to the database and execute SQL statements.

4. Interface Design
Finally, we need to design some interfaces so that users can operate address information through HTTP requests. The following is a simple sample code:

// 添加用户地址
func AddAddressHandler(w http.ResponseWriter, r *http.Request) {
    // 解析请求体
    decoder := json.NewDecoder(r.Body)
    var address Address
    err := decoder.Decode(&address)
    if err != nil {
        http.Error(w, err.Error(), http.StatusBadRequest)
        return
    }

    // 调用数据库操作方法
    err = AddAddress(address)
    if err != nil {
        http.Error(w, err.Error(), http.StatusInternalServerError)
        return
    }

    // 返回成功响应
    w.WriteHeader(http.StatusOK)
}

// 查询用户地址列表
func GetAddressesHandler(w http.ResponseWriter, r *http.Request) {
    // 解析URL参数
    userID, err := strconv.Atoi(r.URL.Query().Get("user_id"))
    if err != nil {
        http.Error(w, err.Error(), http.StatusBadRequest)
        return
    }

    // 调用数据库操作方法
    addresses, err := GetAddressesByUserID(userID)
    if err != nil {
        http.Error(w, err.Error(), http.StatusInternalServerError)
        return
    }

    // 返回JSON响应
    w.Header().Set("Content-Type", "application/json")
    encoder := json.NewEncoder(w)
    err = encoder.Encode(addresses)
    if err != nil {
        http.Error(w, err.Error(), http.StatusInternalServerError)
        return
    }
}

// 删除用户地址
func DeleteAddressHandler(w http.ResponseWriter, r *http.Request) {
    // 解析URL参数
    userID, err := strconv.Atoi(r.URL.Query().Get("user_id"))
    if err != nil {
        http.Error(w, err.Error(), http.StatusBadRequest)
        return
    }
    addressID, err := strconv.Atoi(r.URL.Query().Get("address_id"))
    if err != nil {
        http.Error(w, err.Error(), http.StatusBadRequest)
        return
    }

    // 调用数据库操作方法
    err = DeleteAddress(userID, addressID)
    if err != nil {
        http.Error(w, err.Error(), http.StatusInternalServerError)
        return
    }

    // 返回成功响应
    w.WriteHeader(http.StatusOK)
}

// 注册HTTP路由
func RegisterHandlers() {
    http.HandleFunc("/address/add", AddAddressHandler)
    http.HandleFunc("/address/get", GetAddressesHandler)
    http.HandleFunc("/address/delete", DeleteAddressHandler)
}

In these interfaces, we use the net/http package of the Go language to handle HTTP requests and responses, and by calling the database operation method Implement addition, deletion and query of address information.

Conclusion:
Through the above code examples, we can see that using Go language to develop the user address management function of the door-to-door cooking system is relatively simple and efficient. By properly designing the database structure, defining the data model, encapsulating database operation methods, and designing reasonable interfaces, we can easily manage and operate user address information. I hope this article can be helpful to you in implementing the user address management function when developing a door-to-door cooking system.

The above is the detailed content of Go language development of door-to-door cooking system: How to implement user address management function?. For more information, please follow other related articles on the PHP Chinese website!