mysql

Documentation

Index

• Constants
• Variables
• func CloseDB() error
• func InsertBlock(block common.Block)
• type User

Constants

const (
	USERNAME = "root"
	PASSWORD = "passwd"
	NETWORK  = "tcp"
	SERVER   = "192.168.31.135"
	PORT     = 3306
	DATABASE = "SSBC"
)

Variables

var DB *sql.DB

Functions

func CloseDB

func CloseDB() error

func InsertBlock

func InsertBlock(block common.Block)

Types

type User

type User struct {
	ID   int64          `db:"id"`
	Name sql.NullString `db:"name"` //由于在mysql的users表中name没有设置为NOT NULL,所以name可能为null,在查询过程中会返回nil，如果是string类型则无法接收nil,但sql.NullString则可以接收nil值
	Age  int            `db:"age"`
}