<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                企業??AI智能體構建引擎,智能編排和調試,一鍵部署,支持知識庫和私有化部署方案 廣告
                [TOC] ## 語言使用數據庫的一般步驟 > [sqlx官網](https://github.com/jmoiron/sqlx) ### 引入xxx 1. 第三方包 `import "github.com/jmoiron/sqlx"` 2. 官方驅動 `import _ "github.com/go-sql-driver/mysql"` ### 建立鏈接 ``` //uid:pass@tcp(host:port)/dbname?charset=utf8&parseTime=true //用戶名:密碼@tcp(主機:端口)/數據庫名稱?charset=utf8&parseTime=true db, err = sqlx.Open(`mysql`, `root:root@tcp(127.0.0.1:3306)/news?charset=utf8&parseTime=true`) ``` ### 測試鏈接 ``` err = db.Ping() ``` ### 查詢數據 ![](https://box.kancloud.cn/1b4984ab6b7fbc1090c647d5c8093f51_805x70.png) #### 單個查詢 ``` mod := &Class{} //查詢一條數據 //錯誤信息 = db.Get(要保存數據的變量的指針,`sql語句`,參數...) err = db.Get(mod, `select * from class limit 1`) fmt.Println(mod, err) ``` #### 查詢集合 ``` mods := make([]Class, 0) //查詢多條數據 //錯誤信息 = db.Select(要保存數據的變量的指針,`sql語句`,參數...) err = db.Select(&mods, `select * from class`) fmt.Println(&mods, err) ``` ### 操作數據 #### 添加數據 ``` //操作結果, 錯誤信息 := db.Exec(`sql語句`,參數...) //result, err := db.Exec("insert into class(`name`,`desc`) values(?,?)", `名稱`, `描述description`) result, err := db.Exec("insert into class(`name`,`desc`) values(?,?)", `名稱`, `描述description`) fmt.Println(err) // 如果是insert數據 則LastInsertId 返回插入的 id fmt.Println(result.LastInsertId()) // 修改和刪除 RowsAffected 返回到底影響了多少條數據 fmt.Println(result.RowsAffected()) ``` ![](https://box.kancloud.cn/abe6e535cbdaf81a64fbddcefdedbcf1_773x130.png) ![](https://box.kancloud.cn/ccc66954c08232fed427276742d1f2dc_450x149.png) #### 修改數據 ``` //修改數據 result, err := db.Exec("update class set `desc`= ?", `描述 描述`)//警告 fmt.Println(err) // 如果是insert數據 則LastInsertId 返回插入的 id fmt.Println(result.LastInsertId()) // 修改和刪除 RowsAffected 返回到底影響了多少條數據 fmt.Println(result.RowsAffected()) ``` ![](https://box.kancloud.cn/3ba1caa649a89625687a7faa4b75283e_395x153.png) #### 刪除數據 ``` //刪除數據 result, err := db.Exec("delete from class where id = ?", 4) //警告 fmt.Println(err) // 如果是insert數據 則LastInsertId 返回插入的 id fmt.Println(result.LastInsertId()) // 修改和刪除 RowsAffected 返回到底影響了多少條數據 fmt.Println(result.RowsAffected()) ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看