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

1
import (
2
  "database/sql"
3
  "fmt"
4
  "log"
5

6
  //引入驱动
7
  _ "github.com/go-sql-driver/mysql"
8
)

1
db, err := sql.Open("mysql", "root:root@tcp(127.0.0.1:3306)/gorm_new_db")
2
if err != nil {
3
  log.Fatalf("数据库连接失败 %s", err)
4
}
5
  //判断是否连接成功
6
  err = db.Ping()
7
  if err != nil {
8
    log.Fatalf("数据库连接失败 %s", err)
9
  }
10
  fmt.Println(db)

1
  //插入数据
2
  res, err := db.Exec("insert into user(username,age) values ('lier',29)")
3
  if err != nil {
4
    fmt.Println(err)
5
    return
6
  }
7
  fmt.Println(res)

1
  rows, err := db.Query("select id,username from user")
2
  if err != nil {
3
    log.Fatalf("查询失败 %s", err)
4
  }
5
  defer rows.Close()
6
  for rows.Next() {
7
    var id int
8
    var name string
9
    err = rows.Scan(&id, &name)
10
    fmt.Println(id, name, err)
11
  }

1
  //查一行
2
  var id int
3
  var name string
4
  err = db.QueryRow("select id,username from user").Scan(&id, &name)
5
  fmt.Println(id, name)