golang mysql 简单封装与使用

import (
 "database/sql"
 _ "github.com/go-sql-driver/mysql"
)
 dbtemp, err := sql.Open("mysql", "root:password@/dbname?charset=utf8")
 db = dbtemp
 if err != nil {
 fmt.Println(err)
 }
 stmt, err := db.Prepare("create table if not exists dev(id int UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,uid varchar(64),did varchar(64),name varchar(64),qid varchar(64),status char DEFAULT 'u')")
 if stmt != nil {
 stmt.Exec()
 stmt.Close()
 }
 stmt, err := db.Prepare("alter table dev convert to character set utf8 collate utf8_general_ci") //要修改一下编码
 if stmt != nil {
 stmt.Exec()
 stmt.Close()
 }
 
 _ = err
 

func GetOne(rows *sql.Rows) []string {
 if rows == nil {
 return nil
 }
 
 cols, err := rows.Columns()
 
 rawResult := make([][]byte, len(cols))
 result := make([]string, len(cols))
 dest := make([]interface{}, len(cols))
 for i, _ := range rawResult {
 dest[i] = &rawResult[i]
 }
 
 if rows.Next() {
 err = rows.Scan(dest...)
 
 for i, raw := range rawResult {
 if raw == nil {
 result[i] = ""
 } else {
 result[i] = string(raw)
 }
 }
 
 //fmt.Printf("%#v\n", result)
 
 //break
 } else {
 return nil
 }
 
 _=err
 return result
}

stmt, err := db.Prepare("select did,name from dev where (uid=? and name=?)")
printErr(err)
rows, err := stmt.Query(r.FromUserName, name)
printErr(err)
re := GetOne(rows)
stmt.Close()

stmt, err := db.Prepare("insert into dev(uid,did,name,qid) values(?,?,?,?)")
stmt.Exec(r.FromUserName,r.DeviceID,con,r.ToUserName)
stmt.Close()

有疑问加站长微信联系(非本文作者)

• 请尽量让自己的回复能够对别人有帮助
• 支持 Markdown 格式, **粗体**、~~删除线~~、`单行代码`
• 支持 @ 本站用户;支持表情(输入 : 提示),见 Emoji cheat sheet
• 图片支持拖拽、截图粘贴等方式上传