这段代码展示了如何使用Go语言连接并操作MySQL数据库，包括插入数据、更新数据和查询数据的基本步骤。通过`sql.Open`建立连接，使用`Prepare`预编译SQL语句，然后执行`Exec`和`Query`进行数据操作。
基本连接
// mysql.go
package main
import (
"database/sql"
"fmt"
_ "github.com/go-sql-driver/mysql"
)
func main() {
db, err := sql.Open("mysql", "root:123@tcp(127.0.0.1:3306)/test?charset=utf8")
if err != nil {
panic(err)
}
stmt, err := db.Prepare("INSERT user_info SET username=?,departname=?,create_time=?")
res, err := stmt.Exec("zhangsan", "技术部", "2016-12-09")
id, err := res.LastInsertId()
if err != nil {
panic(err)
}
fmt.Println(id)
}
更新
// mysql.go
package main
import (
"database/sql"
"fmt"
_ "github.com/go-sql-driver/mysql"
)
func main() {
db, err := sql.Open("mysql", "root:123@tcp(127.0.0.1:3306)/test?charset=utf8")
if err != nil {
panic(err)
}
stmt, err := db.Prepare("update user_info set username=? where id=?")
res, err := stmt.Exec("lisi", 22)
id, err := res.RowsAffected()
if err != nil {
panic(err)
}
fmt.Println(id)
}
// mysql.go
package main
import (
"database/sql"
"fmt"
_ "github.com/go-sql-driver/mysql"
)
func main() {
db, err := sql.Open("mysql", "root:123@tcp(127.0.0.1:3306)/test?charset=utf8")
if err != nil {
panic(err)
}
rows, err := db.Query("SELECT * FROM user_info")
if err != nil {
panic(err)
}
for rows.Next() {
var id int
var username string
var department string
var create_time string
err = rows.Scan(&id, &username, &department, &create_time)
fmt.Println(id, username, department, create_time)
}
}
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
