package main
import (
"fmt"
"database/sql"
_ "github.com/go-sql-driver/mysql"
)
var db *sql.DB
func initDB() (err error) {
dsn :="jbjb:123456@tcp(192.168.8.177:3306)/jbjb"
db, err = sql.Open("mysql", dsn)
if err != nil{
fmt.Printf("Open %s failed, err:%v\n", dsn, err)
return
}
err = db.Ping()
if err != nil{
return
}
return
}
type runoob_tbl struct{
runoob_id int
runoob_title string
runoob_author string
}
func insertDemo() {
sqlStr := `INSERT INTO runoob_tbl (runoob_title, runoob_author, submission_date) VALUES ("爱PY", "爱jb", NOW());`
ret, err := db.Exec(sqlStr)
if err != nil {
fmt.Printf("insert failed, err:%v\n", err)
return
}
theID, err := ret.LastInsertId() // 新插入数据的id
if err != nil {
fmt.Printf("get lastinsert ID failed, err:%v\n", err)
return
}
fmt.Printf("runoob_id is %d.\n", theID)
}
func main() {
err := initDB() // 调用输出化数据库的函数
if err != nil {
fmt.Printf("init db failed,err:%v\n", err)
}
fmt.Println("链接成功")
//queryOne(2)
//queryMulti(0)
insertDemo()
}
Go连接及操作MySQL-插入
最新推荐文章于 2024-05-24 14:07:41 发布