go 插入postgres 数据库 2021-09-05

最新推荐文章于 2024-04-15 15:33:14 发布

国毅

最新推荐文章于 2024-04-15 15:33:14 发布

阅读量352

点赞数

分类专栏： code 文章标签： golang big data 数据库

本文链接：https://blog.csdn.net/zhuchance/article/details/120108423

版权

code 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

golang postgres

话不多直接上代码

话不多直接上代码

package main

import (
	"database/sql"
	"fmt"
	_ "github.com/lib/pq"
	"io"
	"log"
	"math/rand"
	"time"
	// "log"
	"net/http"
)

const (
	host     = "127.0.0.2"
	port     = 5432
	user     = "postgres"
	password = "00000000"
	dbname   = "postgres"
	//dbname   = "registry"
)

func connectDB() *sql.DB{
	psqlInfo := fmt.Sprintf("host=%s port=%d user=%s "+
		"password=%s dbname=%s sslmode=disable",
		host, port, user, password, dbname)

	db, err := sql.Open("postgres", psqlInfo)
	if err != nil {
		panic(err)
	}

	err = db.Ping()
	if err != nil {
		panic(err)
	}
	return db
}


func randomtime() []int64 {
	timestamp := time.Now().Unix()
	fmt.Printf("时间戳（秒）：%v\n", timestamp)
	return nil
}





//func insertUser(db *sql.DB)  {
//	stmt,err := db.Prepare("insert into public.harbor_user(user_id,username,email,password,realname,comment,deleted,reset_uuid,salt,sysadmin_flag,creation_time,update_time,password_version) values($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13)")
//	if err != nil {
//		log.Fatal(err)
//	}
//	_,err = stmt.Exec("100","000000", "yb", "12345678AbC", "xx", "from LDAP", "f", "NULL", "NULL", "f", "2021-07-16 14:57:52.460499", "2021-07-16 14:57:52.460499", "sha256")
//	if err != nil {
//		log.Fatal(err)
//	}else {
//		fmt.Println("insert into user_tbl success")
//	}
//}

const form = `<html><body><form action="#" method="post" name="bar">
                    user: <input type="text" name="in"/>
                    email: <input type="text" name="in"/>
                     <input type="submit" value="Submit"/>
             </form></body></html>`


func FormServer( w http.ResponseWriter, request *http.Request)   {
	db:=connectDB()
	//insertUser(db)

	w.Header().Set("Content-Type", "text/html")
	switch request.Method {
	case "GET":
		io.WriteString(w, form)
	case "POST":
		request.ParseForm()
		io.WriteString(w, request.Form["in"][1])
		var a = request.FormValue("in")
		io.WriteString(w, "\n"+"\n")
		fmt.Printf(a)
		io.WriteString(w, request.FormValue("in"))
		stmt,err := db.Prepare("insert into public.harbor_user(user_id,username,email,password,realname,comment,deleted,reset_uuid,salt,sysadmin_flag,creation_time,update_time,password_version) values($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13)")
		//stmt,err := db.Prepare("insert into public.harbor_user(user_id,username,email,password,realname,comment,deleted,reset_uuid,salt,sysadmin_flag,creation_time,update_time,password_version) values($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13)")
		if err != nil {
			log.Fatal(err)
		}
		_,err = stmt.Exec(fmt.Sprintf("%03v", rand.New(rand.NewSource(time.Now().UnixNano())).Int31n(1000)),a, a, "12345678AbC", "xx", "from LDAP", "f", "NULL", "NULL", "f", "2021-07-16 14:57:52.460499", "2021-07-16 14:57:52.460499", "sha256")
		//_,err = stmt.Exec(fmt.Sprintf("%03v", rand.New(rand.NewSource(time.Now().UnixNano())).Int31n(1000)),a, "yb", "12345678AbC", "xx", "from LDAP", "f", "NULL", "NULL", "f", "2021-07-16 14:57:52.460499", "2021-07-16 14:57:52.460499", "sha256")
		//_,err = stmt.Exec(randomtime(),"8787", "randomtime()", "12345678AbC", "x33x", "from LDAP", "f", "NULL", "NULL", "f", "2021-07-16 14:57:52.460499", "2021-07-16 14:57:52.460499", "sha256")
		if err != nil {
			log.Fatal(err)
		}else {
			fmt.Println("insert into user_tbl success")
		}
	}

}


//func HandleFunc(pattern string, handler func(ResponseWriter, *Request)) {
//  DefaultServeMux.HandleFunc(pattern, handler)
//}

func main() {

	http.HandleFunc("/", FormServer)
	if err := http.ListenAndServe(":80", nil); err != nil {
	}


	//randomtime()
}

国毅

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
go 插入postgres 数据库 2021-09-05

golang postgres话不多直接上代码话不多直接上代码package mainimport ( "database/sql" "fmt" _ "github.com/lib/pq" "io" "log" "math/rand" "time" // "log" "net/http")const ( host = "127.0.0.2" port = 5432 user = "postgres" password = "00000000"
复制链接

扫一扫