<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>

                ??一站式輕松地調用各大LLM模型接口,支持GPT4、智譜、豆包、星火、月之暗面及文生圖、文生視頻 廣告
                ## 1. 安裝sqlx ~~~go go get github.com/jmoiron/sqlx ~~~ ## 2. 基本使用 連接數據庫 ~~~go var db *sqlx.DB func initDB() (err error) { dsn := "root:123456@tcp(127.0.0.1:3306)/test?charset=utf8mb4&parseTime=True" db, err = sqlx.Connect("mysql", dsn) if err != nil { fmt.Printf("connect DB failed, err:%v\n", err) return } db.SetMaxOpenConns(20) db.SetMaxIdleConns(10) return } func main() { err := initDB() if err != nil { fmt.Printf("init db failed, err:%v\n", err) return } defer db.Close() fmt.Println("connected to db...") } ~~~ ## 3. 插入數據 ~~~ // 插入數據 func insertRowDemo() { sqlStr := "insert into user(name, age) values (?, ?)" result, err := db.Exec(sqlStr, "Cindy", 23) if err != nil { fmt.Printf("insert data failed, err:%v\n", err) return } lastID, err := result.LastInsertId() if err != nil { fmt.Printf("get last id failed, err:%v\n", err) return } fmt.Printf("insert successfully, last id is %d.\n", lastID) } ~~~ ### 4. NamedExec `DB.NamedExec`方法用來綁定SQL語句與結構體或map中的同名字段。 ~~~ func insertUserDemo() { sqlStr := "insert into user(name, age) values(:name, :age)" db.NamedExec(sqlStr, map[string]interface{}{ "name": "ddd", "age": 30, }) fmt.Printf("insert data successfully.") return } ~~~
                  <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>

                              哎呀哎呀视频在线观看