最近的评论

• 评论了主题 google 登入問題
  #3楼 @jarlyyn 感謝 已解決~
• 评论了主题 google 登入問題
  #1楼 @jarlyyn 我目前是完全copy他的程式碼 出現上圖的問題 https://github.com/plutov/packagemain/blob/master/11-oauth2/main.go 是不是要額外把client id 存到某個地方?
• 评论了主题 如何用golang把mysql的資料傳輸到web上
  @didadi 想請教一下，整體的流程嗎? 希望能有個較完整程式碼 感謝~
• 评论了主题 如何用golang把mysql的資料傳輸到web上
  package main import ( //"html/template" //"strings" "log" "net/http" "fmt" "database/sql" _ "github.com/go-sql-driver/mysql" ) var ( t , i int array[]string v string c map[int]data base []data = make([]data,0) ) type data struct{ uid string username string departname string created string } func main() { fmt.Println("connect success") db, err := sql.Open("mysql", "root:12345@tcp(127.0.0.1:3306)/123")//用户：密码@主机/数据库 checkErr(err) defer db.Close() i=0 rows, err := db.Query("SELECT * FROM userinfo") checkErr(err) for rows.Next() { var uid, username, department, created string err = rows.Scan(&uid, &username, &department, &created) checkErr(err) c = make(map[int]data) c[i] = data{uid, username, department, created} fmt.Println(c[i]) } http.HandleFunc("/",index) log.Println("Start") err1 :=http.ListenAndServe(":9090", nil) if err1!=nil { log.Fatal("ListenAndServe:", err1) } } func index(w http.ResponseWriter, r *http.Request) { db, err := sql.Open("mysql", "root:123456789@tcp(127.0.0.1:3306)/123")//用户：密码@主机/数据库 checkErr(err) defer db.Close() rows, err := db.Query("SELECT * FROM userinfo") checkErr(err) for rows.Next(){ data := data{} err = rows.Scan(&data.uid, &data.username, &data.departname, &data.created) checkErr(err) base = append(base, data) } fmt.Fprintf(w,"%s", base) } func checkErr(err error) { if err != nil { panic(err) } } 這是目前的程式碼 在web上輸出的是 [{1 andy a01 2018-07-05} {2 bob b01 2018-07-04} {3 couch c01 2018-07-03} {5 astaxie software developement 2012-12-09} {6 lin y c so tired 2018-07-05} {7 lin y c so tired 2018-07-05} {8 dean go is too hard to learn 2018-07-05} {9 sour2015 welcome to golang world 2018-07-11} {11 atm dont forget to eat lunch 2018-07-11} {12 atm dont forget to eat lunch 2018-07-11} {17 atm zxczqws 2017-01-12}] 無分行 希望是能夠放入一個表單中，看起來比較整潔