nfine框架访问mysql

package main

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

func main() {
 // 连接数据库
 db, err := sql.Open("mysql", "user:password@tcp(localhost:3306)/dbname")
 if err != nil {
 fmt.Println("Failed to connect to database:", err)
 return
 }
 defer db.Close()

 // 执行查询
 rows, err := db.Query("SELECT * FROM users")
 if err != nil {
 fmt.Println("Failed to execute query:", err)
 return
 }
 defer rows.Close()

 // 处理查询结果
 for rows.Next() {
 var id int
 var name string
 err = rows.Scan(&id, &name)
 if err != nil {
 fmt.Println("Failed to scan row:", err)
 continue
 }
 fmt.Println("ID:", id, "Name:", name)
 }
}