mysql

Documentation

Index

• type Mysql
  • func New(config MysqlConfig) *Mysql
  • func (db *Mysql) Create(prestring string, parm ...interface{}) (int64, error)
  • func (db *Mysql) Drop(prestring string, parm ...interface{}) (int64, error)
  • func (db *Mysql) Insert(prestring string, parm ...interface{}) (int64, error)
  • func (db *Mysql) Open(maxopen int, maxidle int)
  • func (db *Mysql) Select(prestring string, parm ...interface{}) (returnrows []map[string]interface{}, err error)
• type MysqlConfig
  • func (dbconfig MysqlConfig) CreateDb() error
  • func (dbconfig MysqlConfig) DeleteDb() error

Types

type Mysql

type Mysql struct {
	Config MysqlConfig
	Client *sql.DB
}

a client

func New

func New(config MysqlConfig) *Mysql

func (*Mysql) Create

func (db *Mysql) Create(prestring string, parm ...interface{}) (int64, error)

建表 Create table

func (*Mysql) Drop

func (db *Mysql) Drop(prestring string, parm ...interface{}) (int64, error)

删表

func (*Mysql) Insert

func (db *Mysql) Insert(prestring string, parm ...interface{}) (int64, error)

插入数据 Insert Data

func (*Mysql) Open

func (db *Mysql) Open(maxopen int, maxidle int)

打开数据库连接 open a connecttion

func (*Mysql) Select

func (db *Mysql) Select(prestring string, parm ...interface{}) (returnrows []map[string]interface{}, err error)

查询数据库 Query

type MysqlConfig

type MysqlConfig struct {
	Username string
	Password string
	Ip       string
	Port     string
	Dbname   string
}

Mysql config

func (MysqlConfig) CreateDb

func (dbconfig MysqlConfig) CreateDb() error

create database

func (MysqlConfig) DeleteDb

func (dbconfig MysqlConfig) DeleteDb() error