database.go 965 B

12345678910111213141516171819202122232425262728293031323334353637383940
  1. package database
  2. import (
  3. "bet24.com/log"
  4. _ "github.com/denisenkom/go-mssqldb"
  5. )
  6. type DataBase struct {
  7. sqlServer *SqlServer
  8. }
  9. func NewDataBase(datasource, database, login, password string) *DataBase {
  10. db := new(DataBase)
  11. db.start(datasource, database, login, password)
  12. return db
  13. }
  14. func (this *DataBase) start(datasource, database, login, password string) bool {
  15. this.sqlServer = NewSqlServer(datasource, database, login, password)
  16. if this.sqlServer == nil {
  17. log.Error("连接到数据库[%s : %s]失败\n", datasource, database)
  18. return false
  19. }
  20. log.Debug("datasource=%s database=%s 连接到数据成功...", datasource, database)
  21. return true
  22. }
  23. func (this *DataBase) ExecSql(sql string) [][]interface{} {
  24. return this.sqlServer.execSql(sql)
  25. }
  26. func (this *DataBase) ExecSqlJson(sql string) string {
  27. ret, err := this.sqlServer.execSqlJson(sql)
  28. if err != nil {
  29. log.Release("DataBase.ExecSqlJson error = %v", err)
  30. return ""
  31. }
  32. return ret
  33. }