go数据库操作

package main
import (
 "database/sql"
 _ "github.com/go-sql-driver/mysql"
)
func main() {
 /*
 //打开数据库
 db, err := sql.Open("mysql", "root:123@/tsong")
 if err != nil {
 panic("open database fail")
 }
 //链接数据库
 err = db.Ping()
 if err != nil {
 panic("connect database fail")
 }
 //链接数据库成功,就可以正确的操作数据库了,执行数据库语句
 data, err := db.Query("select * from tsong where count < 10", data)
 var str interface{}
 str1 := "hello"
 str = str1
 a := str.(int)
 fmt.Println(a, str)
 type NotKnowType struct {
 s1, s2, s3 string
 }
 var secret interface{} = NotKnowType{"a", "b", "c"}
 value := reflect.ValueOf(secret)
 el := value.Elem()
 fmt.Println(el)
 for i := 0; i < value.NumField(); i++ {
 fmt.Println(value.Field(i))
 }
 var c io.Reader
 fmt.Println(reflect.TypeOf(c))
 c = os.Stdout
 fmt.Println(reflect.TypeOf(c))
 c = bufio.NewReader(c)
 fmt.Println(reflect.TypeOf(c))
 boring("boring")
 time.Durati
 func boring(msg string) {
 for i := 0; ; i++ {
 fmt.Println(msg, i)
 time.Sleep(time.Duration(rand.Intn(1e3)) * time.Millisecond)
 }
 */
 db, err := sql.Open("mysql", "root:1@tcp(localhost:3306)/student")
 if err != nil {
 panic("open database fail")
 }
 err = db.Ping()
 if err != nil {
 panic("linked database fail")
 }
 data, err := db.Query("select *from tb_student")
 if err != nil {
 panic("operation database fail")
 }
 //println(data)
 for data.Next() {
 var name string
 var id int
 var phoneNumber string
 data.Scan(&name, &id, &phoneNumber)
 println(name, id, phoneNumber)
 }
}

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

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