https://blog.csdn.net/a19352226/article/details/50814900@H_403_4@
package main@H_403_4@@H_403_4@import (@H_403_4@ "database/sql"@H_403_4@ "fmt"@H_403_4@ _ "github.com/go-sql-driver/MysqL"@H_403_4@)@H_403_4@@H_403_4@var (@H_403_4@ dbhostsip = "127.0.0.1:3306"//IP地址@H_403_4@ dbusername = "root"//用户名@H_403_4@ dbpassword = "123456"//密码@H_403_4@ dbname = "Test"//表名@H_403_4@)@H_403_4@@H_403_4@func main() {@H_403_4@ db,err := sql.Open("MysqL","root:123456@tcp(127.0.0.1:3306)/Test?charset=utf8")@H_403_4@ checkErr(err)@H_403_4@ //插入数据@H_403_4@ stmt,err := db.Prepare("INSERT userinfo SET username=?,departname=?,created=?")@H_403_4@ checkErr(err)@H_403_4@ res,err := stmt.Exec("码农","研发部门","2016-03-06")@H_403_4@ checkErr(err)@H_403_4@ id,err := res.LastInsertId()@H_403_4@ checkErr(err)@H_403_4@@H_403_4@@H_403_4@ fmt.Println(id)@H_403_4@ //更新数据@H_403_4@ stmt,err = db.Prepare("update userinfo set username=? where uid=?")@H_403_4@ checkErr(err)@H_403_4@@H_403_4@@H_403_4@ res,err = stmt.Exec("码农二代",id)@H_403_4@ checkErr(err)@H_403_4@@H_403_4@ affect,err := res.RowsAffected()@H_403_4@ checkErr(err)@H_403_4@ fmt.Println(affect)@H_403_4@@H_403_4@@H_403_4@ //查询数据@H_403_4@ rows,err := db.Query("SELECT * FROM userinfo")@H_403_4@ checkErr(err)@H_403_4@ for rows.Next() {@H_403_4@ var uid int@H_403_4@ var username string@H_403_4@ var department string@H_403_4@ var created string@H_403_4@ err = rows.Scan(&uid,&username,&department,&created)@H_403_4@ checkErr(err)@H_403_4@ fmt.Println(uid)@H_403_4@ fmt.Println(username)@H_403_4@ fmt.Println(department)@H_403_4@ fmt.Println(created)@H_403_4@ }@H_403_4@@H_403_4@ //删除数据@H_403_4@ stmt,err = db.Prepare("delete from userinfo where uid=?")@H_403_4@ checkErr(err)@H_403_4@@H_403_4@@H_403_4@ res,err = stmt.Exec(id)@H_403_4@ checkErr(err)@H_403_4@@H_403_4@@H_403_4@ affect,err = res.RowsAffected()@H_403_4@ checkErr(err)@H_403_4@ fmt.Println(affect)@H_403_4@ db.Close()@H_403_4@}@H_403_4@func checkErr(err error) {@H_403_4@ if err != nil {@H_403_4@ panic(err)@H_403_4@ }@H_403_4@}@H_403_4@
