Advertisement
Guest User

Untitled

a guest
Aug 11th, 2016
215
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. +-----+------------+
  2. | no | nama |
  3. +-----+------------+
  4. | 001 | Example |
  5. +-----+------------+
  6.  
  7. MySQL username: golang
  8. MySQL password: cobadatabase
  9.  
  10. func main() {
  11. /* Ini konekin database-nya dulu */
  12. app_database, err := sql.Open("mysql", "golang:cobadatabase@tcp(192.168.102.175:3360)/example")
  13.  
  14. /* Nah klo ini Error Handling */
  15. if err != nil {
  16. log.Fatal(err) // informasi log jika koneksi database gagal
  17. }
  18. defer app_database.Close() // Close koneksi jika benar-benar gagal
  19. /* End of Error Handling Connection */
  20.  
  21. var (
  22. no string
  23. nama string
  24. )
  25.  
  26. baris, err := app_database.Query("SELECT * FROM example_table")
  27. if err != nil {
  28. log.Fatal(err)
  29. }
  30. defer baris.Close()
  31.  
  32. for baris.Next() {
  33. err := baris.Scan(&no, &nama)
  34. if err != nil {
  35. log.Fatal(err)
  36. }
  37. log.Println(no, nama)
  38. }
  39. err = baris.Err()
  40.  
  41. if err != nil {
  42. log.Fatal(err)
  43. }
  44. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement