## 部分代码
### 数据库链接
```
Db, err = sqlx.Connect(`mysql`, `user:password@tcp(host:port)/database?charset=utf8&parseTime=true&loc=Local`)
```
### utils
```
package utils
//standard format
type result struct {
State stat `json:"state"`
Msg string `json:"msg"`
Data interface{} `json:"data"`
}
//page format
//Message
type list struct {
Count int `json:"count"`
Item interface{} `json:"item"`
}
type stat int
const (
StSucc stat = 200 //正常
StFail stat = 300 //失败
StErrIpt stat = 310 //输入数据有误
StErrOpt stat = 320 //无数据返回
)
const (
FormatTime = "15:04:05"
FormatDate = "2006-01-02"
FormatDateTime = "2006-01-02 15:04:05"
)
func newRes(st stat, msg string, data ...interface{}) *result {
if len(data) > 0 {
return &result{
State: st,
Msg: msg,
Data: data[0],
}
}
return &result{
State: st,
Msg: msg,
}
}
func NewSucc(msg string, data ...interface{}) *result {
return newRes(StSucc, msg, data...)
}
func NewFail(msg string, data ...interface{}) *result {
return newRes(StFail, msg, data...)
}
func NewErr(st stat, msg string, data ...interface{}) *result {
return newRes(st, msg, data...)
}
func NewList(msg string, item interface{}, count int) *result {
return &result{
State: StSucc,
Msg: msg,
Data: list{
Item: item,
Count: count,
},
}
}
```
