我们还应该在Golang中关闭DB的.Prepare（）吗？

Question

From this tutorial shown that rows.Closed() must be called where rows is from stmt.Query(), is stmt.Closed() also should be called where stmt is from db.Prepare()?

// inside a function
stmt, err := db.Prepare(cmd) // cmd is SQL string
Check(err)
// should we add: defer stmt.Close()
rows, err := stmt.Query(params) // params is map/interface{}
defer rows.Close()
Check(err)

Answer 1

The short answer is Yes. You should call stmt.Close();

The long answer can be found in this google groups thread.