package introduction1

import (
"database/sql"
"fmt"
_ "github.com/go-sql-driver/mysql"
)

func ConnMysql() {
connStr := "root:passwd@tcp(192.168.234.129:3311)/djweb"
db, err := sql.Open("mysql", connStr)
if err != nil {
fmt.Printf("Connect mysql fail: %s\n", err)
} else { // 连接成功
fmt.Println("Connect to mysql success")
}
defer db.Close()

sqlQuery := "select * from user"
rows, err := db.Query(sqlQuery)
if err != nil {
	fmt.Printf("select fail: %s\n", err)
}

// var mapUser map[string]int
// mapUser = make(map[string]int)

// var mapUser = make(map[string]int)

for rows.Next() {
	var id int
	rows.Columns()
	err := rows.Scan(&id)
	if err != nil {
		fmt.Printf("get user info error: %s\n", err)
	}
	fmt.Println(id)
}

// for k, v := range mapUser {
// 	fmt.Println(k, v)
// }

}