Advertisement
Guest User

Untitled

a guest
Mar 22nd, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. package hello
  2.  
  3. import (
  4. "net/http"
  5. "github.com/go-martini/martini"
  6. "fmt"
  7. "database/sql"
  8. _ "github.com/go-sql-driver/mysql"
  9. )
  10. func handler(w http.ResponseWriter, r *http.Request) {
  11. fmt.Fprintln(w, "mainDesc")
  12. }
  13.  
  14. const (
  15. DATABASE = "dbname"
  16. USERNAME = "name"
  17. PASSWORD = "pass"
  18. HOST = "93.189.45.34"
  19. )
  20.  
  21.  
  22. func handler2(w http.ResponseWriter, r *http.Request) {
  23. db, err := sql.Open("mysql",USERNAME+":"+PASSWORD+"@tcp("+HOST+")/"+DATABASE)
  24. var (
  25. id int
  26. description string
  27. )
  28. if err != nil {
  29. fmt.Fprintln(w, "Error connect ")
  30. }
  31.  
  32. err2 := db.QueryRow("SELECT * FROM main").Scan(&id, &description)
  33. if err2 != nil {
  34. fmt.Fprintln(w, "Error!")
  35. }
  36. fmt.Fprintln(w, description)
  37. }
  38. func init() {
  39. m := martini.Classic()
  40. m.Get("/", handler)
  41. m.Get("/go", handler2)
  42. http.Handle("/", m)
  43. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement