Golang连接postgresql示例

golang连接postgresql

package main

import (
   "bufio"
   "database/sql"
   "fmt"
   . "github.com/lib/pq"
   "log"
   "os"
)

func main() {
   //连接postgres
   connStr := "host=localhost port=5432 dbname=postgres user=postgres password=123456 sslmode=disable"
   db, err := sql.Open("postgres", connStr)
   if err != nil {
      log.Fatal(err)
   }
   rows, err := db.Query("select * from student")
   if err != nil {
      log.Fatal(err)
   }
   for rows.Next() {
      var id string
      var name string
      var age string
      err = rows.Scan(&id, &name, &age)
      if err != nil {
         log.Fatal(err)
      }
      //fmt.Print("id:" + id)
      //fmt.Print(" name:" + name)
      //fmt.Println(" age:" + age)
      file, err := os.OpenFile("impala", os.O_WRONLY|os.O_APPEND, 0644)
      defer file.Close()
      writer := bufio.NewWriter(file)
      writer.WriteString("id:" + id)
      writer.WriteString(" name:" + name)
      writer.WriteString(" age:" + age + "\n")
      writer.Flush()
      if err != nil {
         return

      }

      //db.Prepare("INSERT INTO student(id,name,age) VALUES('55','lisa','kook')")
   }
   ms, _ := os.ReadFile("impala")
   stmt, err := db.Prepare("INSERT INTO student(id,name,age) VALUES ($1,$2,$3) ")
   checkErr(err)
   fmt.Print(string(ms))
   stmt.Exec()

}

func checkErr(err error) {
   if err != nil {
      return
   }
}