golang中的postgres查询

package main

import (
    "database/sql"
    "fmt"

    _ "github.com/lib/pq"
)

func main() {
    // 连接数据库
    db, err := sql.Open("postgres", "host=localhost port=5432 user=your_username password=your_password dbname=your_database sslmode=disable")
    if err != nil {
        fmt.Println("连接数据库失败:", err)
        return
    }
    defer db.Close()

    // 查询数据
    rows, err := db.Query("SELECT * FROM your_table")
    if err != nil {
        fmt.Println("查询数据失败:", err)
        return
    }
    defer rows.Close()

    // 遍历结果
    for rows.Next() {
        var id int
        var name string
        err = rows.Scan(&id, &name)
        if err != nil {
            fmt.Println("读取数据失败:", err)
            return
        }
        fmt.Println("ID:", id, "Name:", name)
    }

    // 检查错误
    err = rows.Err()
    if err != nil {
        fmt.Println("遍历结果失败:", err)
        return
    }
}

package main

import (
    "database/sql"
    "fmt"

    "github.com/lib/pq"
)

func main() {
    // 连接数据库
    connStr := "postgres://your_username:your_password@localhost/your_database?sslmode=disable"
    db, err := sql.Open("postgres", connStr)
    if err != nil {
        fmt.Println("连接数据库失败:", err)
        return
    }
    defer db.Close()

    // 查询数据
    rows, err := db.Query("SELECT * FROM your_table")
    if err != nil {
        fmt.Println("查询数据失败:", err)
        return
    }
    defer rows.Close()

    // 遍历结果
    for rows.Next() {
        var id int
        var name string
        err = rows.Scan(&id, &name)
        if err != nil {
            fmt.Println("读取数据失败:", err)
            return
        }
        fmt.Println("ID:", id, "Name:", name)
    }

    // 检查错误
    err = rows.Err()
    if err != nil {
        fmt.Println("遍历结果失败:", err)
        return
    }
}