在連接數據庫的基礎上
步驟:
- Query-查詢
- 關閉查詢
- db.Next()逐行輸出,并指定到當前變量
- Scan-掃描
rows, err := db.Query("SELECT id,server_ip FROM softswitch_server_info")
package main//查詢語句-demo
//關鍵字-queryimport ("database/sql""fmt"_ "github.com/go-sql-driver/mysql""log"
)func main() {//連接數據庫db, err := sql.Open("mysql", "ims:123456@tcp(192.168.0.26:3306)/ibcf")if err != nil {log.Fatal("連接數據庫失敗:", err)}//關閉連接defer db.Close()//驗證是否連接成功err = db.Ping()if err != nil {log.Fatal("連接失敗:", err)}fmt.Println("鏈接MySQL數據庫成功!")//查詢數據庫rows, err := db.Query("SELECT id,server_ip FROM softswitch_server_info")if err != nil {log.Fatal("查詢失敗:", err)}//關閉查詢defer rows.Close()//逐行輸出,并且綁定到當前變量中for rows.Next() { //逐行掃描var id intvar serverIP stringerr = rows.Scan(&id, &serverIP)if err != nil {log.Fatal("掃描失敗:", err)}//查看查詢結果fmt.Println("查詢的結果為:", id, serverIP)}}