beego api

最新推荐文章于 2024-01-19 23:46:10 发布

gnicky

最新推荐文章于 2024-01-19 23:46:10 发布

阅读量1.1k

点赞数

分类专栏： go

go 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

bee api apiproject -tables="" -driver=mysql -conn="root:@(127.0.0.1:3306)/test?charset=utf8"

create app folder: /Users/mycode/golang/src/bi /apiproject

create conf: /Users/b/mycode/golang/src/bi /apiproject/conf

create controllers: /Users/b/mycode/golang/src/bi u/apiproject/controllers

create docs: /Users/b/mycode/golang/src/ lu/apiproject/docs

create tests: /Users/bi u/mycode/golang/src/b /apiproject/tests

create conf app.conf: /Users/bi /mycode/golang/src/bi u/apiproject/conf/app.conf

create main.go: /Users/bi lu/mycode/golang/src/b u/apiproject/main.go

2016/04/26 20:51:19 [INFO] Using 'mysql' as 'driver'

2016/04/26 20:51:19 [INFO] Using 'root:@(127.0.0.1:3306)/test?charset=utf8' as 'conn'

2016/04/26 20:51:19 [INFO] Using '' as 'tables'

2016/04/26 20:51:19 [INFO] Analyzing database tables...

2016/04/26 20:51:19 [INFO] Creating model files...

2016/04/26 20:51:19 [INFO] model => /Users/b u/mycode/golang/src/b u/apiproject/models/product.go

2016/04/26 20:51:19 [INFO] model => /Users/ u/mycode/golang/src/bi /apiproject/models/users.go

插入操作

 
        stmt, err := db.Prepare(`INSERT user (user_name,user_age,user_sex) values (?,?,?)`) 
       
        checkErr(err) 
       
        res, err := stmt.Exec( 
        "tony" 
        ,  
        20 
        ,  
        1 
        ) 
       
        checkErr(err) 
       
        id, err := res.LastInsertId() 
       
        checkErr(err) 
       
        fmt.Println(id)

这里使用结构化操作，不推荐使用直接拼接sql语句的方法。

查询操作

 
        rows, err := db.Query( 
        "SELECT * FROM user" 
        ) 
       
        checkErr(err) 
       
        for 
        rows.Next() { 
       
        var 
        userId int 
       
        var 
        userName string 
       
        var 
        userAge int 
       
        var 
        userSex int 
       
        rows.Columns() 
       
        err = rows.Scan(&userId, &userName, &userAge, &userSex) 
       
        checkErr(err) 
       
        fmt.Println(userId) 
       
        fmt.Println(userName) 
       
        fmt.Println(userAge) 
       
        fmt.Println(userSex) 
       
        }