19. Toad Notes Go language--using MySQL driver

This is a creation in Article, where the information may have evolved or changed.

19. Toad Notes Go language--using MySQL driver

MySQL Driver

Go in support of MySQL driver is more, there are several, some are support database/sql standard, and some are using their own implementation interface, as follows:

Https://github.com/Go-SQL-Driver/MySQL

Download the Mysql-master.zip package and unzip the desired go file.

Creating libraries and tables

Create DATABASE test;

CREATE TABLE ' UserInfo ' (

' UID ' INT (Ten) not NULL auto_increment,

' Username ' VARCHAR (+) null DEFAULT null,

' Departname ' VARCHAR (+) null DEFAULT null,

' Created ' DATE null DEFAULT null,

PRIMARY KEY (' uid ')

);

CREATE TABLE ' Userdetail ' (

' UID ' INT (Ten) not NULL DEFAULT ' 0 ',

' Intro ' TEXT NULL,

' Profile ' TEXT NULL,

PRIMARY KEY (' uid ')

);

Create user

CREATE USER ' astaxie ' @ ' localhost ' identified by ' Astaxie ";

Mysql> Grant all privileges on * * to astaxie@localhost identified by ' Astaxie ';

File

Create Go-sql-driver\mysql in the Github.com folder

The downloaded file is copied to the created Go-sql-driver\mysql folder.

Code

Package Main

Import (

"Database/sql"

"FMT"

_ "Github.com/go-sql-driver/mysql"

"Time"

)

Func Main () {

DB, err:= SQL. Open ("MySQL", "Astaxie:astaxie@/test?charset=utf8")

Checkerr (ERR)

         // Inserting Data

Stmt,err: = db. Prepare ("INSERT userinfo setusername=?,departname=?,created=?")

Checkerr (ERR)

Res,err: = stmt. Exec ("Astaxie", " Research and Development department ", "2012-12-09")

Checkerr (ERR)

ID, err:= Res. Lastinsertid ()

Checkerr (ERR)

Fmt. PRINTLN (ID)

         // Update Data

Stmt,err = db. Prepare ("Update userinfo set username=?") where uid=? ")

Checkerr (ERR)

Res,err = stmt. Exec ("astaxieupdate", id)

Checkerr (ERR)

Affect,err: = Res. Rowsaffected ()

Checkerr (ERR)

Fmt. PRINTLN (Affect)

         // Querying Data

Rows,err: = db. Query ("SELECT * from UserInfo")

Checkerr (ERR)

Forrows. Next () {

Varuid int

Varusername string

Vardepartment string

varcreated string

err= rows. Scan (&uid, &username, &department, &created)

Checkerr (ERR)

Fmt. PRINTLN (UID)

Fmt. PRINTLN (username)

Fmt. PRINTLN (department)

Fmt. PRINTLN (created)

}

         // Delete Data

Stmt,err = db. Prepare ("Delete from userinfo where uid=?")

Checkerr (ERR)

Res,err = stmt. Exec (ID)

Checkerr (ERR)

Affect,err = Res. Rowsaffected ()

Checkerr (ERR)

Fmt. PRINTLN (Affect)

Db. Close ()

}

Func Checkerr (err error) {

If err!= Nil {

Panic (ERR)

}

}

Sql. The open () function is used to turn on a registered database driver, the MySQL database driver is registered in Go-mysql-driver, and the second parameter is the DNS (Data Source Name). It is a database link and configuration information defined by Go-mysql-driver.

The following formats are supported:

User@unix (/path/to/socket)/dbname?charset=utf8user:password@tcp (localhost:5555)/dbname?charset=utf8

User:password@/dbname

USER:PASSWORD@TCP ([de:ad:be:ef::ca:fe]:80)/dbname

Db. The Prepare () function is used to return the SQL operation that is ready to be executed and then return to the ready execution state.

Db. The Query () function is used to directly execute SQL to return the rows result.

stmt. The Exec () function is used to execute stmt prepared SQL statements. We can see that the parameters we pass in are all =? corresponding data, so that the way to do this can prevent SQL injection to some extent.

Execution results

1

1

1

Astaxieupdate

Research and Development Department

2012-12-09

1