��ҳ > �� >Debian��Golang��ݿ�ָ��

Debian��Golang��ݿ�ָ��

��Դ�� 2026-08-01 06:48:13

��Debian��ʹ��Golang��ݿ⣬��Ȱ�װGo��黷��ٰ�װ��Ӧ��ݿ��MySQL��PostgreSQL��SQLite��MongoDB��Ȼ��д��ݿ⣬��gorunmain.go��֤��ӳɹ��ɽ��ݲ��

��Debian��ʹ��Golang��ݿ⣬��ʵ��ӡ��ľͼ��װ��Go��װ�ö�Ӧ��ݿ��д��ӡ�Ȼ��һ��һ��˵��

Debian��Golang��ݿ�ָ��

��һ��װGo��Ի��

��㻹û�а�װGo��ȥ��ض�Ӧ�汾��С�װ��֮�󣬱��˼��һ��$GOPATH��$GOROOT��û��ȷ��ܶ��ֿ��һ��ʵ��ն��һ��go version��汾�ţ��˵��㶨�ˡ�

�ڶ��װ��ݿ��

�ؼ��һ��ǰ�װ��Ӧ��ݿ��ͬ��ݿ��в�ͬ��м��ģ�

MySQL
��ȶ��µ��ܾ��Դ�� >>>��鿴<<<
```
go get -u github.com/go-sql-driver/mysql
```
PostgreSQL
```
go get -u github.com/lib/pq
```
SQLite
```
go get -u github.com/mattn/go-sqlite3
```

MongoDB

go get -u go.mongodb.org/mongo-driver/mongo
go get -u go.mongodb.org/mongo-driver/mongo/options

��дGo��

��װ��֮�󣬾Ϳ��д��ˡ��½�һ��ļ��main.go��Ȼ��Ҫ��ݿ⣬ѡ��Ӧ�Ĵ��ģ�塣

MySQLʾ��

package main

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

func main() {
    db, err := sql.Open("mysql", "username:password@tcp(localhost:3306)/dbname")
    if err != nil {
        panic(err)
    }
    defer db.Close()

    err = db.Ping()
    if err != nil {
        panic(err)
    }
    fmt.Println("Connected to the database!")
}

PostgreSQLʾ��

package main

import (
    "database/sql"
    "fmt"
    _ "github.com/lib/pq"
)

func main() {
    db, err := sql.Open("postgres", "user=username dbname=dbname password=password sslmode=disable")
    if err != nil {
        panic(err)
    }
    defer db.Close()

    err = db.Ping()
    if err != nil {
        panic(err)
    }
    fmt.Println("Connected to the database!")
}

SQLiteʾ��

package main

import (
    "database/sql"
    "fmt"
    _ "github.com/mattn/go-sqlite3"
)

func main() {
    db, err := sql.Open("sqlite3", "./test.db")
    if err != nil {
        panic(err)
    }
    defer db.Close()

    err = db.Ping()
    if err != nil {
        panic(err)
    }
    fmt.Println("Connected to the database!")
}

MongoDBʾ��

package main

import (
    "context"
    "fmt"
    "go.mongodb.org/mongo-driver/bson"
    "go.mongodb.org/mongo-driver/mongo"
    "go.mongodb.org/mongo-driver/mongo/options"
    "log"
)

func main() {
    clientOptions := options.Client().ApplyURI("mongodb://username:password@localhost:27017")
    client, err := mongo.Connect(context.TODO(), clientOptions)
    if err != nil {
        log.Fatal(err)
    }
    defer client.Disconnect(context.TODO())

    err = client.Ping(context.TODO(), nil)
    if err != nil {
        log.Fatal(err)
    }
    fmt.Println("Connected to the MongoDB!")
}

��Ĳ��г��

��д��֮��ն��л��ĿĿ¼��ֱ��У�