package main
import (
"database/sql"
"fmt"
_ "github.com/go-sql-driver/mysql"
"log"
)
func main() {
db, err := sql.Open("mysql", "chenxun:123456@tcp(202.120.1.1:330)/ppserver?charset=utf8")
if err != nil {
log.Fatalf("Open database error: %s\n", err)
}
defer db.Close()
rows, err := db.Query("SELECT userId, nickName FROM userInfo where userId = 1")
if err != nil {
log.Println(err)
}
defer rows.Close()
var userId int
var nickName string
for rows.Next() {
err := rows.Scan(&userId, &nickName)
if err != nil {
log.Fatal(err)
}
log.Println(userId, nickName)
}
err = rows.Err()
if err != nil {
log.Fatal(err)
}
}
func checkErr(err error) {
if err != nil {
panic(err)
}
}
go语言学习----mysql的操作
最新推荐文章于 2024-06-20 22:56:03 发布