go 调用mysql

来源：互联网发布：java截取字符串前两位编辑：程序博客网时间：2024/06/06 09:31

简单的插入、查询

package mainimport (    "database/sql"    _ "github.com/go-sql-driver/mysql"    "log")//插入func insert(db *sql.DB) {    stmt, err := db.Prepare("INSERT INTO user(username, password) VALUES(?, ?)")    defer stmt.Close()    if err != nil {        log.Println(err)        return    }    stmt.Exec("saber", "saber")    stmt.Exec("excalibur", "000000")}func main() {    //打开sql和表    db, err := sql.Open("mysql", "root:root@/test")    if err != nil {        log.Fatalf("Open database error: %s\n", err)    }    defer db.Close()    err = db.Ping()    if err != nil {        log.Fatal(err)    }    insert(db)    //查询    rows, err := db.Query("select id, username from user where id = ?", 1)    if err != nil {        log.Println(err)    }    defer rows.Close()    var id int    var name string    for rows.Next() {        err := rows.Scan(&id, &name)        if err != nil {            log.Fatal(err)        }        log.Println(id, name)    }    err = rows.Err()    if err != nil {        log.Fatal(err)    }}

0 0