Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package main
- import (
- "./mydb"
- "fmt"
- "log"
- )
- func main() {
- db := mydb.MyDB{}
- db.Connect()
- defer db.Close()
- // get results as *sql.Rows
- rows := db.Query("select code, name from Company where name like '%ソニー%'")
- defer rows.Close()
- for rows.Next() {
- var name string
- var code string
- err := rows.Scan(&code, &name)
- if err != nil {
- log.Fatal(err)
- }
- fmt.Println(code, name)
- }
- // get results as slice
- results := db.FetchAll("select code, name from Company where name like '%ソニー%'")
- for _, val := range results {
- fmt.Println(val)
- }
- }
Add Comment
Please, Sign In to add comment