go语言操作数据库(小记录)

package main

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

func main() {
	db, err := sql.Open("mysql", "root:root@tcp(127.0.0.1:3306)/go?charset=utf8")
	if err != nil {
		fmt.Print("测试====")
		fmt.Print(err)
	}
	//插入
	/*stmt, err:= db.Prepare("insert  users  set name=?")
	res,err:=stmt.Exec("李青林");
	id,err:=res.LastInsertId();
	fmt.Print(id)

	//更新
	stmt, err= db.Prepare("update  users  set name=? where  id=?")
	res,err=stmt.Exec("李青林000",1);
	affect,err:=res.RowsAffected();
	fmt.Print(affect)*/

	//删除
	stmt, err:= db.Prepare(" delete from users where id = ? ")
	if err!=nil{
		fmt.Print(err)
	}
	res,err:=stmt.Exec(2);
	if err!=nil{
		fmt.Print(res)
	}
	affect,err:=res.RowsAffected();
	fmt.Print(affect)

	//查询
	/*rows, err := db.Query(" SELECT *FROM users ")
	if err != nil {
		fmt.Print(err)
	}
	for rows.Next()  {
		var id int
		var name string
		err = rows.Scan(&id,&name)
		fmt.Println(id,name)
	}*/
}