逍遥阁

go语言操作mysql数据库的代码

关键词: go

go语言操作mysql数据库的代码

```
package main

import (
    "log"
    "database/sql"
    _ "github.com/go-sql-driver/mysql"
)

func main() {
    db, err := sql.Open("mysql", "用户名:密码@tcp(ip地址:端口)/数据库?charset=utf8")
    if err != nil {
        log.Println(err.Error())
    }
    defer db.Close()
    err = db.Ping()
    if err != nil {
        log.Println(err.Error())
    }

/*
    stmt, err := db.Prepare("select * from test where id = ?")
    if err != nil {
        log.Println(err.Error())
    }
    defer stmt.Close()
    rows, err := stmt.Query(1)
    if err != nil {
        log.Println(err.Error())
    }
    defer rows.Close()
    for rows.Next() {
        var id int
        var name string
        var weight int
        err = rows.Scan(&id, &name, &weight)
        if err != nil {
            log.Println(err.Error())
        }
        log.Println(id)
        log.Println(name)
        log.Println(weight)
    }
    err = rows.Err()
    if err != nil {
        log.Println(err.Error())
    }
    */

/*
    result, err := db.Exec("insert into test(id, name, weight) values(?, ?, ?)", "5", "e", "26")
    if err != nil {
        log.Println(err.Error())
    }
    theLastInsertId, _ := result.LastInsertId()
    theRowsAffected, _ := result.RowsAffected()
    log.Println(theLastInsertId)
    log.Println(theRowsAffected)
    */

/*
    var id int
    var name string
    var weight int
    err = db.QueryRow("select * from test where id = ?", 2).Scan(&id, &name, &weight)
    if err != nil {
        log.Println(err.Error())
    }
    log.Println(id)
    log.Println(name)
    log.Println(weight)
    */

/*
    type data struct {
        id int
        name string
        weight int
    }
    rows, _ := db.Query("select * from test where id = ?", 2)
    for rows.Next() {
        line := data{}
        rows.Scan(&line.id, &line.name, &line.weight)
        log.Println(line)
    }
    */

/*
    rows, _ := db.Query("select * from test where id = ?", 2)
    columns, _ := rows.Columns()
    length := len(columns)
    values := make([]sql.RawBytes, length)
    scans := make([]interface{}, length)
    for i:=0;i<length;i++ {
        scans[i] = &values[i]
    }
    var result []map[string]string
    for rows.Next() {
        rows.Scan(scans...)
        each := make(map[string]string)
        for i:=0;i<length;i++ {
            each[columns[i]] = string(values[i])
        }
        result = append(result, each)
    }
    log.Println(result)
    */

/*
    func (db *DB) Prepare(query string) (*Stmt, error)
    func (db *DB) Exec(query string, args ...interface{}) (Result, error)
    func (db *DB) Query(query string, args ...interface{}) (*Rows, error)
    func (db *DB) QueryRow(query string, args ...interface{}) *Row
    func (s *Stmt) Exec(args ...interface{}) (Result, error)
    func (s *Stmt) Query(args ...interface{}) (*Rows, error)
    func (s *Stmt) QueryRow(args ...interface{}) *Row
    */
}
```

admin
2017-07-14 16:23:43
go

文章分类

文章标签

文章归档

友情链接

go语言操作mysql数据库的代码