1.安裝golang的開發環境點擊打開鏈接
2.下載github開源的MySQL驅動:
go get github.com/go-sql-driver/mysql如果無法下載建議連接VPN。3.mysql的連接,建議查看相關的源碼database/sql,了解相關的函數,特別是理解Rows和Row的概念,第一次接觸不是很好理解,
了解之后你會發現封裝的挺好的。
db, err := sql.Open("mysql", "root:123456@tcp(localhost:3306)/test?charset=utf8")連接的方式變化不大,mysql為驅動名,root為mysql數據的用戶名,123456為密碼,tcp(localhost:3306)為數據庫的地址,test為數據庫名。
4.先來了解一下database/sql.go文件中的Rows struct:
rows, err := db.Query("select id, companyname from baseinfo") defer rows.Close() for rows.Next() { var id int var name string err = rows.Scan(&id, &name) fmt.PRintf("rows id = %d, value = %s", id, name) }具體demo代碼如下:
package mainimport _ "github.com/go-sql-driver/mysql"import "database/sql"import "fmt"func main() { db, err := sql.Open("mysql", "root:123456@tcp(localhost:3306)/test?charset=utf8") if err != nil { panic(err.Error()) } defer db.Close() err = db.Ping() if err != nil { panic(err.Error()) } rows, err := db.Query("select id, companyname from baseinfo") defer rows.Close() for rows.Next() { var id int var name string err = rows.Scan(&id, &name) fmt.Printf("rows id = %d, value = %s", id, name) } err = rows.Err() if err != nil { panic(err.Error()) }}
新聞熱點
疑難解答