golang连接mysql操作示例增删改查(已经测试)

曾经终败给现在 2023-10-17 18:21 67阅读 0赞

golang本身没有提供连接mysql的驱动，但是定义了标准接口供第三方开发驱动。这里连接mysql可以使用第三方库，第三方库推荐使用https://github.com/Go-SQL-Driver/MySQL这个驱动，更新维护都比较好。下面演示下具体的使用，完整代码示例可以参考最后。

### 下载驱动 ###

sudo go get github.com/go-sql-driver/mysql

如果提示这样的失败信息：cannot download, $GOPATH not set. For more details see: go help gopath，可以使用如下命令解决

sudo env GOPATH=/Users/chenjiebin/golang go get github.com/go-sql-driver/mysql

GOPATH的值根据自行环境进行替换。

### 创建测试表 ###

在mysql test库中创建测试表

CREATE TABLE IF NOT EXISTS `test`.`user` (
     `user_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户编号',
     `user_name` VARCHAR(45) NOT NULL COMMENT '用户名称',
     `user_age` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户年龄',
     `user_sex` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户性别',
     PRIMARY KEY (`user_id`))
     ENGINE = InnoDB
     AUTO_INCREMENT = 1
     DEFAULT CHARACTER SET = utf8
     COLLATE = utf8_general_ci
     COMMENT = '用户表'

### 数据库连接 ###

数据库连接使用datebase/sql Open函数进行连接

<table style="max-width:100%;border-spacing:0px;width:816px;background:none;border:0px;margin:0px;float:none;height:auto;line-height:1.1em;padding:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;"> 
 <tbody style="background:none;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"> 
  <tr style="background:none;border-top:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"> 
   <td style="border-width:0px;padding:0px;background:none;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(120,120,120);"> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      1 
    </div></td> 
   <td style="width:780px;border-width:0px;padding:0px;background:none;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;"> 
    <div style="min-width:320px;width:auto;margin:0px;background:none;border:0px;float:none;height:auto;line-height:1.1em;padding:0px;vertical-align:baseline;font-size:1em;"> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">db, err := sql.Open(</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"mysql"</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">,&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"user:password@tcp(localhost:5555)/dbname?charset=utf8"</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">)</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

其中连接参数可以有如下几种形式：

> user@unix(/path/to/socket)/dbname?charset=utf8  
> user:password@tcp(localhost:5555)/dbname?charset=utf8  
> user:password@/dbname  
> user:password@tcp(\[de:ad:be:ef::ca:fe\]:80)/dbname

通常我们都用第二种。

### 插入操作 ###

<table style="max-width:100%;border-spacing:0px;width:798.667px;background:none;border:0px;margin:0px;float:none;height:auto;line-height:1.1em;padding:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;"> 
 <tbody style="background:none;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"> 
  <tr style="background:none;border-top:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"> 
   <td style="border-width:0px;padding:0px;background:none;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(120,120,120);"> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      1 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      2 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      3 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      4 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      5 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      6 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      7 
    </div></td> 
   <td style="width:762.667px;border-width:0px;padding:0px;background:none;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;"> 
    <div style="min-width:320px;width:auto;margin:0px;background:none;border:0px;float:none;height:auto;line-height:1.1em;padding:0px;vertical-align:baseline;font-size:1em;"> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">stmt, err := db.Prepare(`INSERT user (user_name,user_age,user_sex) values (?,?,?)`)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">res, err := stmt.Exec(</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"tony"</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">,&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,153,0);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">20</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">,&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,153,0);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">1</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">id, err := res.LastInsertId()</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">fmt.Println(id)</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

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

### 查询操作 ###

<table style="max-width:100%;border-spacing:0px;width:790px;background:none;border:0px;margin:0px;float:none;height:auto;line-height:1.1em;padding:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;"> 
 <tbody style="background:none;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"> 
  <tr style="background:none;border-top:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"> 
   <td style="border-width:0px;padding:0px;background:none;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(120,120,120);"> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      1 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      2 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      3 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      4 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      5 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      6 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      7 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      8 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      9 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      10 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      11 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      12 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      13 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      14 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      15 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      16 
    </div></td> 
   <td style="width:745.333px;border-width:0px;padding:0px;background:none;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;"> 
    <div style="min-width:320px;width:auto;margin:0px;background:none;border:0px;float:none;height:auto;line-height:1.1em;padding:0px;vertical-align:baseline;font-size:1em;"> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">rows, err := db.Query(</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"SELECT * FROM user"</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">for</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">rows.Next() { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">var</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">userId int</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">var</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">userName string</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">var</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">userAge int</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">var</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">userSex int</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">rows.Columns()</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">err = rows.Scan(&amp;userId, &amp;userName, &amp;userAge, &amp;userSex)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">fmt.Println(userId)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">fmt.Println(userName)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">fmt.Println(userAge)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">fmt.Println(userSex)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

这里查询的方式使用声明4个独立变量userId、userName、userAge、userSex来保存查询出来的每一行的值。在实际开发中通常会封装数据库的操作，对这样的查询通常会考虑返回字典类型。

<table style="max-width:100%;border-spacing:0px;width:790px;background:none;border:0px;margin:0px;float:none;height:auto;line-height:1.1em;padding:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;"> 
 <tbody style="background:none;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"> 
  <tr style="background:none;border-top:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"> 
   <td style="border-width:0px;padding:0px;background:none;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(120,120,120);"> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      1 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      2 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      3 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      4 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      5 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      6 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      7 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      8 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      9 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      10 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      11 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      12 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      13 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      14 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      15 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      16 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      17 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      18 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      19 
    </div></td> 
   <td style="width:745.333px;border-width:0px;padding:0px;background:none;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;"> 
    <div style="min-width:320px;width:auto;margin:0px;background:none;border:0px;float:none;height:auto;line-height:1.1em;padding:0px;vertical-align:baseline;font-size:1em;"> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//构造scanArgs、values两个数组，scanArgs的每个值指向values相应值的地址</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">columns, _ := rows.Columns()</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">scanArgs := make([]</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">interface</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">{}, len(columns))</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">values := make([]</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">interface</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">{}, len(columns))</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">for</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">i :=&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">range</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">values { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">scanArgs[i] = &amp;values[i]</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">for</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">rows.Next() { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//将行数据保存到record字典</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">err = rows.Scan(scanArgs...)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">record := make(</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">map</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">[string]string)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">for</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">i, col :=&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">range</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">values { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">if</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">col != nil { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">record[columns[i]] = string(col.([]byte))</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">fmt.Println(record)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

### 修改操作 ###

### 删除操作 ###

修改和删除操作都比较简单，同插入数据类似，只是使用RowsAffected来获取影响的数据行数。

### 完整代码 ###

<table style="max-width:100%;border-spacing:0px;width:851.333px;background:none;border:0px;margin:0px;float:none;height:auto;line-height:1.1em;padding:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;"> 
 <tbody style="background:none;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"> 
  <tr style="background:none;border-top:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;"> 
   <td style="border-width:0px;padding:0px;background:none;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(120,120,120);"> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      1 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      2 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      3 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      4 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      5 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      6 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      7 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      8 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      9 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      10 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      11 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      12 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      13 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      14 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      15 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      16 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      17 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      18 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      19 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      20 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      21 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      22 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      23 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      24 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      25 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      26 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      27 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      28 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      29 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      30 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      31 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      32 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      33 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      34 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      35 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      36 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      37 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      38 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      39 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      40 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      41 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      42 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      43 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      44 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      45 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      46 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      47 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      48 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      49 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      50 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      51 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      52 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      53 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      54 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      55 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      56 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      57 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      58 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      59 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      60 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      61 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      62 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      63 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      64 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      65 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      66 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      67 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      68 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      69 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      70 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      71 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      72 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      73 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      74 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      75 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      76 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      77 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      78 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      79 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      80 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      81 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      82 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      83 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      84 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      85 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      86 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      87 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      88 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      89 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      90 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      91 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      92 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      93 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      94 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      95 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      96 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      97 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      98 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      99 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      100 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      101 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      102 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      103 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      104 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      105 
    </div> 
    <div style="background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(212,208,200);float:none;height:auto;line-height:1.1em;margin:0px;padding:0px .5em 0px 1em;text-align:right;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
      106 
    </div></td> 
   <td style="width:797.333px;border-width:0px;padding:0px;background:none;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;"> 
    <div style="min-width:320px;width:auto;margin:0px;background:none;border:0px;float:none;height:auto;line-height:1.1em;padding:0px;vertical-align:baseline;font-size:1em;"> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">package</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">main</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">import</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">(</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"database/sql"</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"fmt"</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">_&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"github.com/go-sql-driver/mysql"</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">func</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">main() { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">insert()</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//插入demo</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">func</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">insert() { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">db, err := sql.Open(</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"mysql"</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">,&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"root:@/test?charset=utf8"</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">stmt, err := db.Prepare(`INSERT user (user_name,user_age,user_sex) values (?,?,?)`)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">res, err := stmt.Exec(</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"tony"</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">,&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,153,0);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">20</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">,&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,153,0);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">1</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">id, err := res.LastInsertId()</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">fmt.Println(id)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//查询demo</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">func</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">query() { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">db, err := sql.Open(</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"mysql"</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">,&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"root:@/test?charset=utf8"</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">rows, err := db.Query(</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"SELECT * FROM user"</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//普通demo</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//for rows.Next() { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//&nbsp;&nbsp;&nbsp; var userId int</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//&nbsp;&nbsp;&nbsp; var userName string</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//&nbsp;&nbsp;&nbsp; var userAge int</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//&nbsp;&nbsp;&nbsp; var userSex int</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//&nbsp;&nbsp;&nbsp; rows.Columns()</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//&nbsp;&nbsp;&nbsp; err = rows.Scan(&amp;userId, &amp;userName, &amp;userAge, &amp;userSex)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//&nbsp;&nbsp;&nbsp; checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//&nbsp;&nbsp;&nbsp; fmt.Println(userId)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//&nbsp;&nbsp;&nbsp; fmt.Println(userName)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//&nbsp;&nbsp;&nbsp; fmt.Println(userAge)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//&nbsp;&nbsp;&nbsp; fmt.Println(userSex)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//}</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//字典类型</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//构造scanArgs、values两个数组，scanArgs的每个值指向values相应值的地址</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">columns, _ := rows.Columns()</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">scanArgs := make([]</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">interface</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">{}, len(columns))</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">values := make([]</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">interface</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">{}, len(columns))</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">for</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">i :=&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">range</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">values { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">scanArgs[i] = &amp;values[i]</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">for</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">rows.Next() { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//将行数据保存到record字典</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">err = rows.Scan(scanArgs...)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">record := make(</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">map</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">[string]string)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">for</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">i, col :=&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">range</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">values { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">if</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">col != nil { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">record[columns[i]] = string(col.([]byte))</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">fmt.Println(record)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//更新数据</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">func</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">update() { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">db, err := sql.Open(</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"mysql"</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">,&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"root:@/test?charset=utf8"</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">stmt, err := db.Prepare(`UPDATE user SET user_age=?,user_sex=? WHERE user_id=?`)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">res, err := stmt.Exec(</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,153,0);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">21</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">,&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,153,0);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">2</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">,&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,153,0);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">1</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">num, err := res.RowsAffected()</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">fmt.Println(num)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(63,95,191);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">//删除数据</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">func</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">remove() { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">db, err := sql.Open(</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"mysql"</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">,&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(42,0,255);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">"root:@/test?charset=utf8"</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">stmt, err := db.Prepare(`DELETE FROM user WHERE user_id=?`)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">res, err := stmt.Exec(</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(0,153,0);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">1</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">num, err := res.RowsAffected()</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">fmt.Println(num)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;">
       &nbsp; 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">func</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">checkErr(err error) { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:rgb(127,0,85);background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;font-weight:bold;">if</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">err != nil { </code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">panic(err)</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="color:rgb(221,17,68);white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
     <div style="background-image:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px 1em;vertical-align:baseline;width:auto;font-size:1em;white-space:pre;"> 
      <code style="white-space:nowrap;padding:0px;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;color:#000000;background:none;border:0px;float:none;height:auto;line-height:1.1em;margin:0px;vertical-align:baseline;width:auto;">}</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

### 小结 ###

整体上来说都比较简单，就是查询那边使用字典来存储返回数据比较复杂一些。既然说到数据库连接，通常应用中都会使用连接池来减少连接开销，关于连接池下次整理一下再放上来。

来源:http://www.01happy.com/golang-mysql-demo/