xorm数据简单查询

package main

import (
"fmt"
_ "github.com/go-sql-driver/mysql"
"github.com/go-xorm/core"
"github.com/go-xorm/xorm"
"time"
)

type Member struct {
Memberid int64 `xorm:"int(10) pk not null autoincr 'member_id'"`
Member_name string `xorm:"char(50) not null"`
Member_pwd string `xorm:"char(32) not null"`
Member_count int64 `xorm:"smallint(6) not null default 0 "`
Member_ok string `xorm:"varchar(50) not null"`
Member_del int64 `xorm:"bigint(1) not null default 0 "`
Member_email string `xorm:"varchar(40) not null"`
Member_logintime time.Time `xorm:"updated"`
Member_createtime int64 `xorm:"int(11) not null default 0"`
Member_updatetime int64 `xorm:"int(11) not null default 0"`
Member_ip string `xorm:"varchar(40) not null"`
Member_version int64 `xorm:"version"`
}

var (
engine *xorm.Engine
)

func main() {
//数据库连接参数
params := fmt.Sprintf("%s:%s@tcp(%s)/%s?charset=utf8&parseTime=true", "root", "root", "localhost:3306", "go")
var err error
//连接数据库
engine, err = xorm.NewEngine("mysql", params)
if err != nil {
panic(err)
}
//添加统一前缀
tbMapper := core.NewPrefixMapper(core.SnakeMapper{}, "go_")
engine.SetTableMapper(tbMapper)
defer engine.Close()

//查询多条数据
tests := make([]Member, 0)
errr := engine.Distinct("member_id", "member_name", "member_email").Limit(10, 0).Find(&tests)
if errr != nil {
panic(errr)
}
fmt.Printf("总共查询出 %d 条数据\n", len(tests))
for _, v := range tests {
fmt.Printf("信息Id: %d, 姓名: %s, 邮箱: %s\n", v.Memberid, v.Member_name, v.Member_email)
}

//查询一条数据
member := new(Member)
getm := member
gr, ge := engine.Where("member_name=?", "emma").Desc("member_id").Get(getm)
if ge != nil {
panic(ge)
}
if gr != false {
fmt.Printf("\n姓名: %s\n\n",getm.Member_name)
}

//只查询邮箱
var strings []string
serr := engine.Table("go_member").Cols("member_email").Where("member_id = ?", 1).Find(&strings)
if serr != nil {
panic(serr)
}
fmt.Println(strings[0])

}

 

 

【版权申明】未经博主同意,谢绝转载!(请尊重原创,博主保留追究权) http://www.cnblogs.com/facetwitter/p/7595457.html