go对数据库的基本操作

package main

import(
“github.com/jmoiron/sqlx”
_ “github.com/go-sql-driver/mysql”
)
func main(){
database, err := sqlx.Open(“mysql”, “root:root@tcp(127.0.0.1:3306)/logadmin”)//格式 (用户名：密码@tcp(ip:端口号)/数据库名)
r, err := Db.Exec(“insert into person(username, sex, email)values(?, ?, ?)”, “stu001”, “man”, "stu01@qq.com")//插入 person为logadmin数据库里的表名
err := Db.Select(&person, “select user_id, username, sex, email from person where user_id=?”, 1) //查询
_, err := Db.Exec(“update person set username=? where user_id=?”, “stu0003”, 1)//更新
_, err := Db.Exec(“delete from person where user_id=?”, 1) //删除
}