go 语言操作数据库
mellen · · 4106 次点击 · · 开始浏览package main
import "fmt"
import "database/sql"
import _ "github.com/go-sql-driver/mysql"
type Vr struct {
name string
vrurl string
belong string
vrid int
}
func main() {
var Vr1 Vr
var Vr2 Vr
Vr1.name = "跪射俑"
Vr1.vrurl = "http:"
Vr1.belong = "一号坑"
Vr1.vrid = 1
Vr2.name = "铜车马俑"
Vr2.vrurl = "http:"
Vr2.belong = "展览厅"
Vr2.vrid = 2
db, err := sql.Open("mysql", "root:root@/ai?charset=utf8")
checkErr(err)
//查询数据
rows, err := db.Query("SELECT * FROM users")
checkErr(err)
for rows.Next() {
var uid int
var name string
var age string
var sex string
err = rows.Scan(&uid, &name, &age, &sex)
checkErr(err)
fmt.Println(name)
fmt.Println(age)
fmt.Println(sex)
}
}
func checkErr(err error) {
if err != nil {
panic(err)
}
}
有疑问加站长微信联系(非本文作者)
入群交流(和以上内容无关):加入Go大咖交流群,或添加微信:liuxiaoyan-s 备注:入群;或加QQ群:692541889
关注微信- 请尽量让自己的回复能够对别人有帮助
- 支持 Markdown 格式, **粗体**、~~删除线~~、
`单行代码` - 支持 @ 本站用户;支持表情(输入 : 提示),见 Emoji cheat sheet
- 图片支持拖拽、截图粘贴等方式上传
收入到我管理的专栏 新建专栏
package main
import "fmt"
import "database/sql"
import _ "github.com/go-sql-driver/mysql"
type Vr struct {
name string
vrurl string
belong string
vrid int
}
func main() {
var Vr1 Vr
var Vr2 Vr
Vr1.name = "跪射俑"
Vr1.vrurl = "http:"
Vr1.belong = "一号坑"
Vr1.vrid = 1
Vr2.name = "铜车马俑"
Vr2.vrurl = "http:"
Vr2.belong = "展览厅"
Vr2.vrid = 2
db, err := sql.Open("mysql", "root:root@/ai?charset=utf8")
checkErr(err)
//查询数据
rows, err := db.Query("SELECT * FROM users")
checkErr(err)
for rows.Next() {
var uid int
var name string
var age string
var sex string
err = rows.Scan(&uid, &name, &age, &sex)
checkErr(err)
fmt.Println(name)
fmt.Println(age)
fmt.Println(sex)
}
}
func checkErr(err error) {
if err != nil {
panic(err)
}
}