Go language How to manipulate an Access database through ODBC _golang

The example in this article describes how the go language operates an Access database through ODBC. Share to everyone for your reference. Specifically as follows:

Here you need to use the GO-ODBC library, download the address: HTTPS://GITHUB.COM/WEIGJ/GO-ODBC

Copy Code code as follows:

Package main;
Import (
"FMT"
"Database/sql"
_ "Odbc/driver"
)
Func Main () {
Conn,err: = sql. Open ("ODBC", "Driver={microsoft Access driver (*.mdb)};d Bq=d:\\test.mdb");
if (Err!=nil) {
Fmt. PRINTLN ("Connecting Error");
Return
}
Defer Conn. Close ();
Stmt,err: = conn. Prepare ("SELECT * from Test");
if (Err!=nil) {
Fmt. Println ("Query Error");
Return
}
Defer stmt. Close ();
Row,err: = stmt. Query ();
If Err!=nil {
Fmt. Println ("Query Error");
Return
}
Defer row. Close ();
For row. Next () {
var id int;
var name string;
If err: = row. Scan (&id,&name); Err==nil {
Fmt. Println (Id,name);
}
}
Fmt. Printf ("%s\n", "Finish");
Return
}

I hope this article will help you with your go language program.