package main
import (
"database/sql"
"fmt"
_ "github.com/jinzhu/gorm/dialects/mysql"
)
func main() {
dsn := "root:@tcp(localhost:3306)/test2"
db, err := sql.Open("mysql", dsn)
if err != nil {
fmt.Printf("dsn:%s invalid,err:%v\n", dsn, err)
return
}
fmt.Println("连接数据库成功~")
sqlStr := "insert into user666(name,age) values('如履薄冰','77')"
_, err3 := db.Exec(sqlStr)
if err3 != nil {
fmt.Printf("insert failed,err:%v\n", err3)
return
}
}
结果
