golang mysql in ?_Golang与MySQL

1. 在golib下载go-sql-driver/mysql

go get github.com/go-sql-driver/mysql

2. 代码引入

import (

"database/sql"

"github.com/go-sql-driver/mysql"

)

3. 创建DB?

db, err := sql.Open("mysql", "user:password@/dbname")

注意: sql.DB是封装driver包提供高级API, 提供了安全,多连接的操作.

4. 文档:

http://localhost:8080/pkg/database/sql/#DB

5. 总结:

database/sql的主要interface

sql.Register{

}

database/sql/driver的主要interface

type Driver interface {

}

type Conn interface { Prepare(query string) (Stmt, error) Close() error Begin() (Tx, error)}

type Stmt interface { Close() error NumInput() int Exec(args []Value) (Result, error) Query(args []Value) (Rows, error)}

type Tx interface { Commit() error Rollback() error}type Result interface { LastInsertId() (int64, error) Ro