如何在Golang中将列表传递给模板

Question

I want to use a query which looks like

rows:= db.Query("SELECT * FROM names")

var name string

for rows.Next() {
    rows.Scan(&name)
}

//There should be a map

t.Execute(w,p)

I want to shape up this to list all names in template like

{{range .name}}
{{.}}
{{end}}

How can i exactly do that?

Answer 1

Something Like This?

rows, err := db.Query("SELECT name FROM names")
if err != nil {
    // Handle error
}

names := make([]string, 0)

for rows.Next() {
    var name string

    err := rows.Scan(&name)
    if err != nil {
        // Handle error
        continue
    }

    names = append(names, name)
}

t := template.New("index")
t, _ = t.Parse(`{{range .}}{{.}} {{end}}`)
t.Execute(w, names)

---

Things to Note

• You should generally avoid using * in your sql queries to make it clear what fields are being selected
• If any fields in your database table can be NULL, then use sql.NullBool, sql.NullFloat64, sql.NullInt64 or sql.NullString to avoid possible errors

---

Possible Output

Bob Jim David Henry Jerry