go-xorm使用mssql的小实例

来源：互联网发布：软件开发质量管理体系编辑：程序博客网时间：2024/06/05 07:09
package mainimport ("fmt""os""time""github.com/go-xorm/core""github.com/go-xorm/xorm"_ "github.com/lunny/godbc")type NxServerState struct {ID             int       `xorm:"pk not null 'ID'"`GameID         int       `xorm:"not null 'GameID'"`IssuerId       int       `xorm:"not null IssuerId"`ServerID       int       `xorm:"not null ServerID"`ServerName     string    `xorm:"ServerName"`OnlineNum      int       `xorm:"not null OnlineNum"`MaxOnlineNum   int       `xorm:"not null MaxOnlineNum"`ServerIP       string    `xorm:"not null ServerIP"`Port           int       `xorm:"not null Port"`IsRuning       int       `xorm:"not null IsRuning"`ServerStyle    int       `xorm:"ServerStyle"`IsStartIPWhile int       `xorm:"not null IsStartIPWhile"`LogTime        time.Time `xorm:"IsStartIPWhile"`UpdateTime     time.Time `xorm:"UpdateTime"`OrderBy        int       `xorm:"not null OrderBy"`}func main() {File, _ := os.Create("result")defer File.Close()Engine, err := xorm.NewEngine("odbc", "driver={SQL Server};Server=127.0.0.1;Database=fuck;uid=sa;pwd=123456;")if err != nil {fmt.Println("新建引擎", err)return}if err := Engine.Ping(); err != nil {fmt.Println(err)return}Engine.SetTableMapper(core.SameMapper{})Engine.ShowSQL = trueEngine.SetMaxConns(5)Engine.SetMaxIdleConns(5)result := new(NxServerState)lines, _ := Engine.Rows(result)defer lines.Close()lines.Next()r := new(NxServerState)for {err = lines.Scan(r)if err != nil {return}fmt.Println(*r)File.WriteString(fmt.Sprintln(*r))if !lines.Next() {break}}}
0 0