xorm向MySQL中一次添加多条数据

package main

import (
"crypto/md5"
"fmt"
_ "github.com/go-sql-driver/mysql"
"github.com/go-xorm/core"
"github.com/go-xorm/xorm"
"io"
"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"`
}

type Delinfo struct {
Del_id int64 `xorm:"int(10) pk not null autoincr 'del_id'"`
Del_info string `xorm:"char(50) not null"`
}

var (
engine *xorm.Engine
getmd5 = md5.New()
t = time.Now()
)

func (m *Member) SetTime() {
m.Member_createtime = t.Unix()
m.Member_updatetime = t.Unix()
}

func (m *Member) SetIp() {
m.Member_ip = "127.0.0.1"
}

func (m *Member) SetPwd(pwd string) {
io.WriteString(getmd5, pwd)
m.Member_pwd = fmt.Sprintf("%x", getmd5.Sum(nil))
}

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()

m := make([]*Member, 3)
m[0] = new(Member)
m[0].Member_name = "jock"
m[0].Member_count = 1
m[0].Member_ok = "bbb"
m[0].Member_del = 2
m[0].Member_email = "jock@gmail.com"
//获取unix时间戳
m[0].SetTime()
//获取ip
m[0].SetIp()
//获得MD5加密后的密码
m[0].SetPwd("123456")

m[1] = new(Member)
m[1].Member_name = "tom"
m[1].Member_count = 1
m[1].Member_ok = "ccc"
m[1].Member_del = 3
m[1].Member_email = "tom@gmail.com"
//获取unix时间戳
m[1].SetTime()
//获取ip
m[1].SetIp()
//获得MD5加密后的密码
m[1].SetPwd("123123")

m[2] = new(Member)
m[2].Member_name = "kevin"
m[2].Member_count = 1
m[2].Member_ok = "ddd"
m[2].Member_del = 4
m[2].Member_email = "kevin@gmail.com"
//获取unix时间戳
m[2].SetTime()
//获取ip
m[2].SetIp()
//获得MD5加密后的密码
m[2].SetPwd("123456")
//将数据添加到数据库
adr, ade := engine.Insert(m)
if ade != nil {
panic(ade)
}
fmt.Printf("成功在 go_member 表创建 %d 条数据\n", adr)

di := make([]*Delinfo, 4)
di[0] = new(Delinfo)
di[0].Del_info = "用户正常"

di[1] = new(Delinfo)
di[1].Del_info = "用户自己注销账户"

di[2] = new(Delinfo)
di[2].Del_info = "发表不当言论，账户被禁用"

di[3] = new(Delinfo)
di[3].Del_info = "账户未激活"

r, e := engine.Insert(di)
if e != nil {
panic(e)
}
fmt.Printf("成功在 go_delinfo 表创建 %d 条数据\n", r)
}

 

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

转载于:https://www.cnblogs.com/facetwitter/p/7595417.html