鏈接mysql
xorm
go get -u github.com/xormplus/xorm
conf
在conf目錄中增加db.go 聲明mysql的鏈接結(jié)構(gòu)體
package conf
import (
"github.com/json-iterator/go"
"io/ioutil"
)
type DbConf struct {
Driver string `json:"DbName"`
Host string `json:"DbHost"`
Port string `json:"DbPort"`
User string `json:"DbUser"`
Pwd string `json:"DbPwd"`
DbName string `json:"DbDbName"`
}
// MasterDbConfig 主庫(kù)配置
var MasterDbConfig = DbConf{
Driver: "mysql",
Host: "192.168.1.1",
Port: "3306",
User: "root",
Pwd: "123456",
DbName: "go",
}
datasource
在datasource目錄中增加dbhelper.go 鏈接數(shù)據(jù)庫(kù)
package datasource
import (
"fmt"
_ "github.com/go-sql-driver/mysql"
"github.com/go-xorm/xorm"
"log"
"myCommunity/conf"
"sync"
)
var (
masterEngine *xorm.Engine
lock sync.Mutex
)
func DbHelper() *xorm.Engine {
// 判斷是否已經(jīng)存在
if masterEngine != nil {
return masterEngine
}
lock.Lock()
defer lock.Unlock()
// 判斷是否已經(jīng)存在 因?yàn)榧渔i 想要重新判斷是否存在
if masterEngine != nil {
return masterEngine
}
c := conf.MasterDbConfig
driverSource := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?charset=utf8",
c.User, c.Pwd, c.Host, c.Port, c.DbName)
log.Println(driverSource)
engine, err := xorm.NewEngine(c.Driver, driverSource)
if err != nil {
log.Fatalf("DbHelper.DbInstanceMaster,", err)
return nil
}
// Debug模式，打印全部的SQL語(yǔ)句阶冈，幫助對(duì)比，看ORM與SQL執(zhí)行的對(duì)照關(guān)系
engine.ShowSQL(true)
masterEngine = engine
return engine
}
測(cè)試jdbc
修改main.go
package main
import (
"log"
"myCommunity/datasource"
)
func main() {
queryString, errr := datasource.DbHelper().QueryString("select * from title")
if errr != nil {
return
}
log.Println(queryString)
....
執(zhí)行 main.go 測(cè)試xorm鏈接mysql是否正常 執(zhí)行后控制臺(tái)輸出
[xorm] [info] 2021/07/06 22:33:50.857913 [SQL] select * from title
2021/07/06 22:33:51 [map[id:1 name:百度] map[id:2 name:谷歌]]
查詢(xún)數(shù)據(jù)庫(kù)成功
數(shù)據(jù)庫(kù)設(shè)計(jì)
在 https://www.yanshisan.cn/Link/Links 中使用博客、留言、日記、友鏈模板聪轿。
根據(jù)這些模塊簡(jiǎn)單設(shè)計(jì)一下數(shù)據(jù)庫(kù)。數(shù)據(jù)庫(kù)表對(duì)應(yīng)models如下
article(博客表)
package models
import "time"
type Article struct {
Id int `form:"id"`
Title string `form:"title"`
Content string `form:"content"`
UserId int `form:"userId"`
CreateTime time.Time `form:"createTime"`
UpdateTime time.Time `form:"updateTime"`
// 訪(fǎng)問(wèn)次數(shù)
Visit int `form:"visit"`
// 分類(lèi)
Types string `form:"types"`
}
diary(日記表)
package models
import "time"
type Diary struct {
Id int `form:"id"`
Content string `form:"content"`
CreateTime time.Time `form:"createTime"`
}
message(留言)
package models
import "time"
type Message struct {
Id int `form:"id"`
Ip string `form:"ip"`
Content string `form:"content"`
// 回復(fù)id
Pid int `form:"pid"`
CreateTime time.Time `form:"createTime"`
}
title(友鏈標(biāo)題)
package models
type Title struct {
Id int `form:"id"`
Name string `form:"name"`
}
link(友鏈)
package models
type Link struct {
Id int `form:"id"`
// 友鏈標(biāo)題id
Pid int `form:"pid"`
Title string `form:"title"`
Path string `form:"path"`
}
數(shù)據(jù)庫(kù)已經(jīng)xorm 搭建完成 下一步開(kāi)始功能開(kāi)發(fā)
