{"id":44825,"date":"2023-12-31T20:20:35","date_gmt":"2022-12-26T23:54:50","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/44825-2\/"},"modified":"2024-05-04T16:12:56","modified_gmt":"2024-05-04T08:12:56","slug":"44825-2","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/44825-2\/","title":{"rendered":""},"content":{"rendered":"

\u6982\u8981<\/h1>\n

\u672c\u8a18\u4e8b\u3067\u306f\u3001Golang\u306b\u304a\u3051\u308bdatabase\/sql\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u7528\u3044\u305fMySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5bfe\u3059\u308b\u51e6\u7406\u4f8b\u3092\u793a\u3059\u3002
\n\u51e6\u7406\u4f8b\u3067\u306f\u3001\u30e6\u30fc\u30b6\u30fc\u30c7\u30fc\u30bf\u3092\u4eee\u5b9a\u3057\u3001\u30a8\u30e9\u30fc\u51e6\u7406\u306b\u3064\u3044\u3066\u3082\u4f8b\u3092\u793a\u3059\u3002<\/p>\n

\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u30c6\u30fc\u30d6\u30eb\u3092\u60f3\u5b9a\u3059\u308b\u3002<\/p>\n

\r\nCREATE<\/span> TABLE<\/span> user_db<\/span>.<\/span>users<\/span> (<\/span>\r\n  id<\/span> INT<\/span> NOT<\/span> NULL<\/span> AUTO_INCREMENT<\/span>,<\/span>\r\n  first_name<\/span> VARCHAR<\/span>(<\/span>45<\/span>)<\/span> NULL<\/span>,<\/span>\r\n  last_name<\/span> VARCHAR<\/span>(<\/span>45<\/span>)<\/span> NULL<\/span>,<\/span>\r\n  email<\/span> VARCHAR<\/span>(<\/span>45<\/span>)<\/span> NOT<\/span> NULL<\/span>,<\/span>\r\n    data_created<\/span> DATETIME<\/span> NULL<\/span> DEFAULT<\/span> CURRENT_TIMESTAMP<\/span>,<\/span>\r\n    status<\/span> TINYINT<\/span>(<\/span>1<\/span>)<\/span> NOT<\/span> NULL<\/span>,<\/span>\r\n  PRIMARY<\/span> KEY<\/span> (<\/span>id<\/span>),<\/span>\r\n    UNIQUE<\/span> INDEX<\/span> email_UNIQUE<\/span> (<\/span>email<\/span> ASC<\/span>));<\/span>\r\n<\/code><\/pre>\n
pkg\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h1>\n
mysql\u306e\u30c9\u30e9\u30a4\u30d0\u30fcpkg\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3002<\/p>\n
go get github.com\/go-sql-driver\/mysql\r\n<\/code><\/pre>\n
\u51e6\u7406\u306e\u6d41\u308c<\/h1>\n
\u5b9f\u884c\u3059\u308b\u51e6\u7406\u306f\u3001\u4ee5\u4e0b\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u901a\u308a\u3067\u3042\u308b\u3002
\n1. \u30e6\u30fc\u30b61\u30c7\u30fc\u30bf\u306e\u633f\u5165
\n2. \u30e6\u30fc\u30b6\u30fc\u30c7\u30fc\u30bf\u53d6\u5f97\u30df\u30b9\u4f8b(\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u793a\u3059\u305f\u3081)
\n3. \u30e6\u30fc\u30b62\u30c7\u30fc\u30bf\u633f\u5165
\n4. Status1\u306e\u30e6\u30fc\u30b6\u30c7\u30fc\u30bf\u3092\u63a2\u7d22\u3001\u53d6\u5f97
\n5. \u30e6\u30fc\u30b6\u30fc\u30c7\u30fc\u30bf\u53d6\u5f97(4\u3067\u53d6\u5f97\u3057\u305f\u304cGET\u306e\u4f8b\u3092\u793a\u3059\u305f\u3081\uff09
\n6. \u30e6\u30fc\u30b6\u30fc\u30c7\u30fc\u30bf\u306e\u66f4\u65b0
\n7. \u30e6\u30fc\u30b6\u30fc\u30c7\u30fc\u30bf\u306e\u524a\u9664<\/p>\n
package<\/span> main<\/span>\r\n\r\nimport<\/span> (<\/span>\r\n    \"fmt\"<\/span>\r\n    \"log\"<\/span>\r\n\r\n    \"github.com\/k-washi\/golang-cookbook\/database\/user_db\/method\"<\/span>\r\n)<\/span>\r\n\r\nfunc<\/span> main<\/span>()<\/span> {<\/span>\r\n\r\n    \/\/\u30e6\u30fc\u30b6\u30c7\u30fc\u30bf\u306e\u633f\u5165<\/span>\r\n    user<\/span> :=<\/span> &<\/span>method<\/span>.<\/span>User<\/span>{<\/span>ID<\/span>:<\/span> 1<\/span>,<\/span> FirstName<\/span>:<\/span> \"Trou\"<\/span>,<\/span> LastName<\/span>:<\/span> \"Tanaka\"<\/span>,<\/span> Email<\/span>:<\/span> \"123s456@test.com\"<\/span>,<\/span> Status<\/span>:<\/span> 1<\/span>}<\/span>\r\n    if<\/span> err<\/span> :=<\/span> user<\/span>.<\/span>Save<\/span>();<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        log<\/span>.<\/span>Println<\/span>(<\/span>err<\/span>)<\/span>\r\n        \/\/2020\/01\/23 03:15:08 email already exist<\/span>\r\n    }<\/span>\r\n    log<\/span>.<\/span>Println<\/span>(<\/span>user<\/span>)<\/span>\r\n    \/\/2020\/01\/23 04:06:32 &{1 Trou Tanaka 123s456@test.com <nil>}<\/span>\r\n\r\n    \/\/\u30e6\u30fc\u30b6\u30fc\u30c7\u30fc\u30bf\u306e\u53d6\u5f97(ID\u30df\u30b9)<\/span>\r\n    user<\/span> =<\/span> &<\/span>method<\/span>.<\/span>User<\/span>{<\/span>ID<\/span>:<\/span> 3<\/span>}<\/span>\r\n    if<\/span> err<\/span> :=<\/span> user<\/span>.<\/span>Get<\/span>();<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        log<\/span>.<\/span>Println<\/span>(<\/span>err<\/span>)<\/span>\r\n        \/\/2020\/01\/23 03:26:24 user not found<\/span>\r\n    }<\/span>\r\n    log<\/span>.<\/span>Println<\/span>(<\/span>user<\/span>)<\/span>\r\n\r\n    \/\/\u30e6\u30fc\u30b6\u30c7\u30fc\u30bf\u633f\u5165<\/span>\r\n    user<\/span> =<\/span> &<\/span>method<\/span>.<\/span>User<\/span>{<\/span>ID<\/span>:<\/span> 2<\/span>,<\/span> FirstName<\/span>:<\/span> \"k\"<\/span>,<\/span> LastName<\/span>:<\/span> \"washi\"<\/span>,<\/span> Email<\/span>:<\/span> \"654321@test.com\"<\/span>,<\/span> Status<\/span>:<\/span> 1<\/span>}<\/span>\r\n    if<\/span> err<\/span> :=<\/span> user<\/span>.<\/span>Save<\/span>();<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        log<\/span>.<\/span>Println<\/span>(<\/span>err<\/span>)<\/span>\r\n    }<\/span>\r\n\r\n    \/\/\u30e6\u30fc\u30b6\u30c7\u30fc\u30bf\u306eStatus:1\u3092Find<\/span>\r\n    res<\/span>,<\/span> err<\/span> :=<\/span> user<\/span>.<\/span>FindByStatus<\/span>(<\/span>1<\/span>)<\/span>\r\n    if<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        log<\/span>.<\/span>Println<\/span>(<\/span>err<\/span>)<\/span>\r\n    }<\/span>\r\n    for<\/span> i<\/span>,<\/span> u<\/span> :=<\/span> range<\/span> res<\/span> {<\/span>\r\n        fmt<\/span>.<\/span>Println<\/span>(<\/span>\"user :\"<\/span>,<\/span> i<\/span>,<\/span> u<\/span>)<\/span>\r\n        \/\/user : 0 {37 Trou Tanaka 123s456@test.com 2020-01-23 05:07:35 +0000 UTC 1}<\/span>\r\n\r\n        \/\/\u30e6\u30fc\u30b6\u30c7\u30fc\u30bf\u306e\u53d6\u5f97(ID\u3092\u4f7f\u7528\u3059\u308b\u305f\u3081\u3001\u30eb\u30fc\u30d7\u5185\u3067\u51e6\u7406)<\/span>\r\n        user<\/span> =<\/span> &<\/span>method<\/span>.<\/span>User<\/span>{<\/span>ID<\/span>:<\/span> u<\/span>.<\/span>ID<\/span>}<\/span>\r\n        if<\/span> err<\/span> :=<\/span> user<\/span>.<\/span>Get<\/span>();<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n            log<\/span>.<\/span>Println<\/span>(<\/span>err<\/span>)<\/span>\r\n        }<\/span>\r\n        log<\/span>.<\/span>Println<\/span>(<\/span>user<\/span>)<\/span>\r\n        \/\/2020\/01\/23 03:03:52 &{1 Trou Tanaka 123s456@test.com 2020-01-23 02:29:56 +0000 UTC}<\/span>\r\n\r\n        \/\/\u30e6\u30fc\u30b6\u30c7\u30fc\u30bf\u66f4\u65b0<\/span>\r\n        user<\/span>.<\/span>FirstName<\/span> =<\/span> \"Taro2\"<\/span>\r\n        user<\/span>.<\/span>LastName<\/span> =<\/span> \"Tanaka2\"<\/span>\r\n        user<\/span>.<\/span>Email<\/span> =<\/span> \"123s456@test.com\"<\/span>\r\n        user<\/span>.<\/span>Status<\/span> =<\/span> 1<\/span>\r\n        if<\/span> err<\/span> :=<\/span> user<\/span>.<\/span>Update<\/span>();<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n            log<\/span>.<\/span>Println<\/span>(<\/span>err<\/span>)<\/span>\r\n        }<\/span>\r\n        log<\/span>.<\/span>Println<\/span>(<\/span>user<\/span>)<\/span>\r\n        \/\/2020\/01\/23 03:54:51 &{1 Taro2 Tanaka2 123s456@test.com 2020-01-23 02:29:56 +0000 UTC}<\/span>\r\n\r\n        \/\/\u30e6\u30fc\u30b6\u30c7\u30fc\u30bf\u306e\u524a\u9664<\/span>\r\n        user<\/span> =<\/span> &<\/span>method<\/span>.<\/span>User<\/span>{<\/span>ID<\/span>:<\/span> u<\/span>.<\/span>ID<\/span>}<\/span>\r\n        if<\/span> err<\/span> :=<\/span> user<\/span>.<\/span>Delete<\/span>();<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n            log<\/span>.<\/span>Println<\/span>(<\/span>err<\/span>)<\/span>\r\n        }<\/span>\r\n        log<\/span>.<\/span>Println<\/span>(<\/span>\"Success Delete\"<\/span>)<\/span>\r\n\r\n    }<\/span>\r\n\r\n}<\/span>\r\n<\/code><\/pre>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u521d\u671f\u8a2d\u5b9a<\/h1>\n
sql.Open\u3067DB\u3068\u63a5\u7d9a\u3092\u78ba\u7acb\u3057\u3001\u63a5\u7d9a\u3092\u78ba\u7acb\u3057\u3066\u3044\u308b\u3002
\n_ “github.com\/go-sql-driver\/mysql”\u3092mysql\u3092\u6271\u3046\u305f\u3081\u3001\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u3066\u3044\u308b\u3002
\n\u8a2d\u5b9a\u306f,user:password@tcp(host:port)\/dbname\u306e\u5f62\u5f0f\u306e\u5f15\u6570\u3092\u3068\u308a\u3001parseTime=true\u306f\u3001\u6642\u523b\u3092\u6271\u3046\u305f\u3081\u306b\u8a2d\u5b9a\u3057\u3066\u3044\u308b\u3002<\/p>\n
Client, err := sql.Open()\u3068\u305b\u305a\u3001\u4e88\u3081\u3001Client,err\u3092\u5b9a\u7fa9\u3057\u3001client, err = sql.Open()\u3068\u3057\u3066\u3044\u308b\u3002\u524d\u8005\u3067\u306f\u3001\u3082\u3057Client\u3092\u95a2\u6570\u5916\u3067\u5b9a\u7fa9\u3057\u3066\u3044\u308b\u5834\u5408\u3001nil\u306b\u306a\u308b\u305f\u3081\u3002<\/p>\n
\u307e\u305f\u3001\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u3057\u3066\u3044\u308b\u304c\u3001\u5b9f\u969b\u306f\u3001\u74b0\u5883\u5909\u6570\u3092\u7528\u3044\u3066\u3001DB\u306e\u8a2d\u5b9a\u3092\u884c\u3046\u307b\u3046\u304c\u826f\u3044\u3002<\/p>\n
package<\/span> user_db<\/span>\r\n\r\nimport<\/span> (<\/span>\r\n    \"database\/sql\"<\/span>\r\n    \"fmt\"<\/span>\r\n    \"log\"<\/span>\r\n\r\n    _<\/span> \"github.com\/go-sql-driver\/mysql\"<\/span>\r\n)<\/span>\r\n\r\nvar<\/span> (<\/span>\r\n    \/\/Client user_id database<\/span>\r\n    Client<\/span> *<\/span>sql<\/span>.<\/span>DB<\/span>\r\n    err<\/span>    error<\/span>\r\n)<\/span>\r\n\r\n\r\n\/*\r\n\/\/\u5b9f\u969b\u306f\u3001\u74b0\u5883\u5909\u6570\u3092\u8aad\u307f\u8fbc\u3093\u3067\u3001DB\u306e\u8a2d\u5b9a\u3092\u884c\u3046\u3002\r\n\/\/export mysql_user_name=\"root\"\r\nconst (\r\n    mysql_user_naem: \"mysql_user_name\"\r\n)\r\n\r\nvar userName := os.Getenv(mysql_user_naem)\r\n*\/<\/span>\r\n\r\nfunc<\/span> init<\/span>()<\/span> {<\/span>\r\n    \/\/user:password@tcp(host:port)\/dbname<\/span>\r\n    dataSourceName<\/span> :=<\/span> fmt<\/span>.<\/span>Sprintf<\/span>(<\/span>\"%s:%s@tcp(%s)\/%s?charset=utf8&parseTime=true\"<\/span>,<\/span>\r\n        \"root\"<\/span>,<\/span> \"\"<\/span>,<\/span> \"127.0.0.1:3306\"<\/span>,<\/span> \"user_db\"<\/span>,<\/span>\r\n    )<\/span>\r\n\r\n    log<\/span>.<\/span>Println<\/span>(<\/span>fmt<\/span>.<\/span>Sprintf<\/span>(<\/span>\"about to connect to %s\"<\/span>,<\/span> dataSourceName<\/span>))<\/span>\r\n    \/\/open db by mysql driver and data source name.<\/span>\r\n    \/\/https:\/\/github.com\/go-sql-driver\/mysql\/issues\/150 (Issue)<\/span>\r\n    Client<\/span>,<\/span> err<\/span> =<\/span> sql<\/span>.<\/span>Open<\/span>(<\/span>\"mysql\"<\/span>,<\/span> dataSourceName<\/span>)<\/span>\r\n    if<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        panic<\/span>(<\/span>err<\/span>)<\/span>\r\n    }<\/span>\r\n\r\n    if<\/span> err<\/span> =<\/span> Client<\/span>.<\/span>Ping<\/span>();<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        panic<\/span>(<\/span>err<\/span>)<\/span>\r\n    }<\/span>\r\n    log<\/span>.<\/span>Println<\/span>(<\/span>\"database successfully configured\"<\/span>)<\/span>\r\n}<\/span>\r\n<\/code><\/pre>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u51e6\u7406<\/h1>\n
GET, POST\u306a\u3069\u306e\u30e1\u30bd\u30c3\u30c9\u3092\u5b9a\u7fa9\u3057\u3066\u3044\u308b\u3002
\n\u3053\u3053\u3067\u5b9a\u7fa9\u3057\u3066\u3044\u308bUser \u69cb\u9020\u4f53\u304c\u672c\u8a18\u4e8b\u3067\u6271\u3063\u3066\u3044\u308b\u30e6\u30fc\u30b6\u30c7\u30fc\u30bf\u3067\u3042\u308b\u3002const\u5185\u306b\u306f\u3001\u3053\u3053\u3067\u6271\u3046SQL\u3092\u5b9a\u7fa9\u3057\u3066\u3044\u308b\u3002<\/p>\n
\u30a8\u30e9\u30fc\u306fparseError\u3068\u3057\u3066\u5b9a\u7fa9\u3057\u3066\u3044\u308b\u3002mysql\u306b\u95a2\u3059\u308b\u30a8\u30e9\u30fc\u306f\u500b\u5225\u306b\u53d6\u308a\u51fa\u305b\u3001switc\u3067\u5834\u5408\u3067\u304d\u308b\u3053\u3068\u3092\u4f8b\u3067\u793a\u3057\u3066\u3044\u308b\u30021062\u306f\u3001Unique\u306b\u5bfe\u3059\u308b\u30a8\u30e9\u30fc\u3067\u3042\u308b\u3002<\/p>\n
GET, SELECT\u306e\u969b\u3001*.Scan\u3092\u5b9f\u884c\u3059\u308b\u5834\u5408\u306f\u3001\u30a2\u30c9\u30ec\u30b9\u3092\u6e21\u3059\u5fc5\u8981\u304c\u3042\u308b\u3053\u3068\u306b\u6ce8\u610f\u3059\u308b\u3002<\/p>\n
package<\/span> method<\/span>\r\n\r\nimport<\/span> (<\/span>\r\n    \"fmt\"<\/span>\r\n    \"log\"<\/span>\r\n    \"strings\"<\/span>\r\n    \"time\"<\/span>\r\n\r\n    \"github.com\/go-sql-driver\/mysql\"<\/span>\r\n\r\n    \"github.com\/k-washi\/golang-cookbook\/database\/user_db\/user_db\"<\/span>\r\n)<\/span>\r\n\r\nconst<\/span> (<\/span>\r\n    queryInsertUser<\/span>         =<\/span> \"INSERT INTO users(first_name, last_name, email, status) VALUES(?, ?, ?, ?);\"<\/span>\r\n    queryGetUser<\/span>            =<\/span> \"SELECT id, first_name, last_name, email, data_created, status FROM users WHERE id=?;\"<\/span>\r\n    queryUpdateUser<\/span>         =<\/span> \"UPDATE users SET first_name=?, last_name=?, email=?, status=? WHERE id=?;\"<\/span>\r\n    queryDeleteUser<\/span>         =<\/span> \"DELETE FROM users WHERE id=?;\"<\/span>\r\n    querySelectUserByStatus<\/span> =<\/span> \"SELECT id, first_name, last_name, email, data_created, status FROM users WHERE status=?;\"<\/span>\r\n    errorNoRow<\/span>              =<\/span> \"no rows in result set\"<\/span>\r\n)<\/span>\r\n\r\n\/\/User info<\/span>\r\ntype<\/span> User<\/span> struct<\/span> {<\/span>\r\n    ID<\/span>        int64<\/span>\r\n    FirstName<\/span> string<\/span>\r\n    LastName<\/span>  string<\/span>\r\n    Email<\/span>     string<\/span>\r\n    Date<\/span>      *<\/span>time<\/span>.<\/span>Time<\/span>\r\n    Status<\/span>    int<\/span>\r\n}<\/span>\r\n\r\nvar<\/span> (<\/span>\r\n\/\/UserDB = make(map[int64]*User)<\/span>\r\n)<\/span>\r\n\r\nfunc<\/span> (<\/span>user<\/span> *<\/span>User<\/span>)<\/span> Get<\/span>()<\/span> error<\/span> {<\/span>\r\n    stmt<\/span>,<\/span> err<\/span> :=<\/span> user_db<\/span>.<\/span>Client<\/span>.<\/span>Prepare<\/span>(<\/span>queryGetUser<\/span>)<\/span>\r\n    if<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        return<\/span> err<\/span>\r\n    }<\/span>\r\n    defer<\/span> stmt<\/span>.<\/span>Close<\/span>()<\/span>\r\n\r\n    result<\/span> :=<\/span> stmt<\/span>.<\/span>QueryRow<\/span>(<\/span>user<\/span>.<\/span>ID<\/span>)<\/span>\r\n    if<\/span> getErr<\/span> :=<\/span> result<\/span>.<\/span>Scan<\/span>(<\/span>&<\/span>user<\/span>.<\/span>ID<\/span>,<\/span> &<\/span>user<\/span>.<\/span>FirstName<\/span>,<\/span> &<\/span>user<\/span>.<\/span>LastName<\/span>,<\/span> &<\/span>user<\/span>.<\/span>Email<\/span>,<\/span> &<\/span>user<\/span>.<\/span>Date<\/span>,<\/span> &<\/span>user<\/span>.<\/span>Status<\/span>);<\/span> getErr<\/span> !=<\/span> nil<\/span> {<\/span>\r\n\r\n        return<\/span> parseError<\/span>(<\/span>getErr<\/span>)<\/span>\r\n    }<\/span>\r\n    return<\/span> nil<\/span>\r\n}<\/span>\r\n\r\nfunc<\/span> (<\/span>user<\/span> *<\/span>User<\/span>)<\/span> Save<\/span>()<\/span> error<\/span> {<\/span>\r\n    stmt<\/span>,<\/span> err<\/span> :=<\/span> user_db<\/span>.<\/span>Client<\/span>.<\/span>Prepare<\/span>(<\/span>queryInsertUser<\/span>)<\/span>\r\n    if<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        return<\/span> err<\/span>\r\n    }<\/span>\r\n    defer<\/span> stmt<\/span>.<\/span>Close<\/span>()<\/span>\r\n\r\n    insertResult<\/span>,<\/span> saveErr<\/span> :=<\/span> stmt<\/span>.<\/span>Exec<\/span>(<\/span>user<\/span>.<\/span>FirstName<\/span>,<\/span> user<\/span>.<\/span>LastName<\/span>,<\/span> user<\/span>.<\/span>Email<\/span>,<\/span> user<\/span>.<\/span>Status<\/span>)<\/span>\r\n    if<\/span> saveErr<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        return<\/span> parseError<\/span>(<\/span>saveErr<\/span>)<\/span>\r\n    }<\/span>\r\n\r\n    userID<\/span>,<\/span> err<\/span> :=<\/span> insertResult<\/span>.<\/span>LastInsertId<\/span>()<\/span>\r\n    if<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        return<\/span> err<\/span>\r\n    }<\/span>\r\n    user<\/span>.<\/span>ID<\/span> =<\/span> userID<\/span>\r\n\r\n    log<\/span>.<\/span>Println<\/span>(<\/span>\"Save user data\"<\/span>)<\/span>\r\n\r\n    return<\/span> nil<\/span>\r\n}<\/span>\r\n\r\nfunc<\/span> (<\/span>user<\/span> *<\/span>User<\/span>)<\/span> Update<\/span>()<\/span> error<\/span> {<\/span>\r\n    stmt<\/span>,<\/span> err<\/span> :=<\/span> user_db<\/span>.<\/span>Client<\/span>.<\/span>Prepare<\/span>(<\/span>queryUpdateUser<\/span>)<\/span>\r\n    if<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        return<\/span> err<\/span>\r\n    }<\/span>\r\n    defer<\/span> stmt<\/span>.<\/span>Close<\/span>()<\/span>\r\n\r\n    if<\/span> _<\/span>,<\/span> updErr<\/span> :=<\/span> stmt<\/span>.<\/span>Exec<\/span>(<\/span>user<\/span>.<\/span>FirstName<\/span>,<\/span> user<\/span>.<\/span>LastName<\/span>,<\/span> user<\/span>.<\/span>Email<\/span>,<\/span> user<\/span>.<\/span>Status<\/span>,<\/span> user<\/span>.<\/span>ID<\/span>);<\/span> updErr<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        return<\/span> parseError<\/span>(<\/span>updErr<\/span>)<\/span>\r\n    }<\/span>\r\n    return<\/span> nil<\/span>\r\n}<\/span>\r\n\r\nfunc<\/span> (<\/span>user<\/span> *<\/span>User<\/span>)<\/span> Delete<\/span>()<\/span> error<\/span> {<\/span>\r\n    stmt<\/span>,<\/span> err<\/span> :=<\/span> user_db<\/span>.<\/span>Client<\/span>.<\/span>Prepare<\/span>(<\/span>queryDeleteUser<\/span>)<\/span>\r\n    if<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        return<\/span> err<\/span>\r\n    }<\/span>\r\n    defer<\/span> stmt<\/span>.<\/span>Close<\/span>()<\/span>\r\n\r\n    if<\/span> _<\/span>,<\/span> delErr<\/span> :=<\/span> stmt<\/span>.<\/span>Exec<\/span>(<\/span>user<\/span>.<\/span>ID<\/span>);<\/span> delErr<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        return<\/span> parseError<\/span>(<\/span>delErr<\/span>)<\/span>\r\n    }<\/span>\r\n\r\n    return<\/span> nil<\/span>\r\n}<\/span>\r\n\r\nfunc<\/span> (<\/span>user<\/span> *<\/span>User<\/span>)<\/span> FindByStatus<\/span>(<\/span>status<\/span> int<\/span>)<\/span> ([]<\/span>User<\/span>,<\/span> error<\/span>)<\/span> {<\/span>\r\n    stmt<\/span>,<\/span> err<\/span> :=<\/span> user_db<\/span>.<\/span>Client<\/span>.<\/span>Prepare<\/span>(<\/span>querySelectUserByStatus<\/span>)<\/span>\r\n    if<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        return<\/span> nil<\/span>,<\/span> err<\/span>\r\n    }<\/span>\r\n    defer<\/span> stmt<\/span>.<\/span>Close<\/span>()<\/span>\r\n\r\n    rows<\/span>,<\/span> err<\/span> :=<\/span> stmt<\/span>.<\/span>Query<\/span>(<\/span>status<\/span>)<\/span>\r\n    if<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n        return<\/span> nil<\/span>,<\/span> parseError<\/span>(<\/span>err<\/span>)<\/span>\r\n    }<\/span>\r\n    defer<\/span> rows<\/span>.<\/span>Close<\/span>()<\/span>\r\n\r\n    res<\/span> :=<\/span> make<\/span>([]<\/span>User<\/span>,<\/span> 0<\/span>)<\/span>\r\n    for<\/span> rows<\/span>.<\/span>Next<\/span>()<\/span> {<\/span>\r\n        var<\/span> user<\/span> User<\/span>\r\n        if<\/span> err<\/span> :=<\/span> rows<\/span>.<\/span>Scan<\/span>(<\/span>&<\/span>user<\/span>.<\/span>ID<\/span>,<\/span> &<\/span>user<\/span>.<\/span>FirstName<\/span>,<\/span> &<\/span>user<\/span>.<\/span>LastName<\/span>,<\/span> &<\/span>user<\/span>.<\/span>Email<\/span>,<\/span> &<\/span>user<\/span>.<\/span>Date<\/span>,<\/span> &<\/span>user<\/span>.<\/span>Status<\/span>);<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n            return<\/span> nil<\/span>,<\/span> parseError<\/span>(<\/span>err<\/span>)<\/span>\r\n        }<\/span>\r\n        res<\/span> =<\/span> append<\/span>(<\/span>res<\/span>,<\/span> user<\/span>)<\/span>\r\n    }<\/span>\r\n\r\n    return<\/span> res<\/span>,<\/span> nil<\/span>\r\n}<\/span>\r\n\r\nfunc<\/span> parseError<\/span>(<\/span>err<\/span> error<\/span>)<\/span> error<\/span> {<\/span>\r\n    sqlErr<\/span>,<\/span> ok<\/span> :=<\/span> err<\/span>.<\/span>(<\/span>*<\/span>mysql<\/span>.<\/span>MySQLError<\/span>)<\/span>\r\n    if<\/span> !<\/span>ok<\/span> {<\/span>\r\n        if<\/span> strings<\/span>.<\/span>Contains<\/span>(<\/span>err<\/span>.<\/span>Error<\/span>(),<\/span> errorNoRow<\/span>)<\/span> {<\/span>\r\n            return<\/span> fmt<\/span>.<\/span>Errorf<\/span>(<\/span>\"user not found\"<\/span>)<\/span>\r\n        }<\/span>\r\n        return<\/span> err<\/span>\r\n    }<\/span>\r\n    \/\/\u4ee5\u4e0b,sql\u4f9d\u5b58\u306e\u30a8\u30e9\u30fc<\/span>\r\n    switch<\/span> sqlErr<\/span>.<\/span>Number<\/span> {<\/span>\r\n    case<\/span> 1062<\/span>:<\/span>\r\n        \/\/email_UNIQUE error<\/span>\r\n        return<\/span> fmt<\/span>.<\/span>Errorf<\/span>(<\/span>\"email already exist\"<\/span>)<\/span>\r\n    }<\/span>\r\n    return<\/span> err<\/span>\r\n}<\/span>\r\n\r\n<\/code><\/pre>\n
\u307e\u3068\u3081<\/h1>\n
Golang\u306b\u3088\u308bMySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5bfe\u3059\u308b\u51e6\u7406\u306e\u4f8b\u3092\u793a\u3057\u307e\u3057\u305f\u3002
\n\u30b3\u30fc\u30c9\u306f\u3001k-washi\/golang-cookbook\/database\/user_db\/\u3092\u53c2\u8003\u306b\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6982\u8981 \u672c\u8a18\u4e8b\u3067\u306f\u3001Golang\u306b\u304a\u3051\u308bdatabase\/sql\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u7528\u3044\u305fMySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5bfe\u3059\u308b […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-44825","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n- Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/44825-2\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:description\" content=\"\u6982\u8981 \u672c\u8a18\u4e8b\u3067\u306f\u3001Golang\u306b\u304a\u3051\u308bdatabase\/sql\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u7528\u3044\u305fMySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5bfe\u3059\u308b […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/44825-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-26T23:54:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-04T08:12:56+00:00\" \/>\n<meta name=\"author\" content=\"\u65b0, \u97f5\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u65b0, \u97f5\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/44825-2\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/44825-2\/\",\"name\":\"- Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2022-12-26T23:54:50+00:00\",\"dateModified\":\"2024-05-04T08:12:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/44825-2\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9\",\"name\":\"\u65b0, \u97f5\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g\",\"caption\":\"\u65b0, \u97f5\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunxin\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/44825-2\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"- Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/44825-2\/","og_locale":"zh_CN","og_type":"article","og_description":"\u6982\u8981 \u672c\u8a18\u4e8b\u3067\u306f\u3001Golang\u306b\u304a\u3051\u308bdatabase\/sql\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u7528\u3044\u305fMySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5bfe\u3059\u308b […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/44825-2\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2022-12-26T23:54:50+00:00","article_modified_time":"2024-05-04T08:12:56+00:00","author":"\u65b0, \u97f5","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u65b0, \u97f5","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"4 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/44825-2\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/44825-2\/","name":"- Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2022-12-26T23:54:50+00:00","dateModified":"2024-05-04T08:12:56+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/44825-2\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9","name":"\u65b0, \u97f5","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g","caption":"\u65b0, \u97f5"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunxin\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/44825-2\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=44825"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44825\/revisions"}],"predecessor-version":[{"id":99349,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44825\/revisions\/99349"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=44825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=44825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=44825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}