package main
import (
"fmt"
_ "github.com/go-sql-driver/mysql"
"github.com/jmoiron/sqlx"
)
type Users struct {
ID int `db:"id"`
Name string `db:"name"`
Password string `db:"password"`
Email string `db:"email"`
}
type Place struct {
Country string `db:"country"`
City string `db:"city"`
TelCode int `db:"telcode"`
}
var Db2 *sqlx.DB
func init() {
database, err := sqlx.Open("mysql", "root:123456@tcp(127.0.0.1:3306)/book")
if err != nil {
fmt.Println("open mysql failed,", err)
return
}
Db2 = database
}
func CheckErr(err error){
if err != nil{
panic(err)
}
}
func Query() {
var person []Users
err := Db2.Select(&person, "select id, name, password, email from users where id=?", 1)
CheckErr(err)
fmt.Println(person)
}
func main() {
//_, err := Db2.Exec("", 1)
//if err != nil {
// fmt.Println("exec failed, ", err)
// return
//}
Query()
fmt.Println("delete succ")
}