Golang读取Rows到map[string]interface{}中

<svg xmlns="http://www.w3.org/2000/svg" style="display: none;"><path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"/></svg>

<pre><code class="lang-shell hljs">func DoQuery<span class="token punctuation">(</span>db *sql.DB, sqlInfo string, args <span class="token punctuation">..</span>.interface<span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">)</span> <span class="token punctuation">(</span><span class="token punctuation">[</span><span class="token punctuation">]</span>map<span class="token punctuation">[</span>string<span class="token punctuation">]</span>interface<span class="token punctuation">{</span><span class="token punctuation">}</span>, error<span class="token punctuation">)</span> <span class="token punctuation">{</span> rows, err :<span class="token operator">=</span> db.Query<span class="token punctuation">(</span>sqlInfo, args<span class="token punctuation">..</span>.<span class="token punctuation">)</span> <span class="token keyword">if</span> err <span class="token operator">!=</span> nil <span class="token punctuation">{</span> <span class="token keyword">return</span> nil, err <span class="token punctuation">}</span> columns, _ :<span class="token operator">=</span> rows.Columns<span class="token punctuation">(</span><span class="token punctuation">)</span> columnLength :<span class="token operator">=</span> len<span class="token punctuation">(</span>columns<span class="token punctuation">)</span> cache :<span class="token operator">=</span> make<span class="token punctuation">(</span><span class="token punctuation">[</span><span class="token punctuation">]</span>interface<span class="token punctuation">{</span><span class="token punctuation">}</span>, columnLength<span class="token punctuation">)</span> <span class="token keyword">for</span> index, _ :<span class="token operator">=</span> range cache <span class="token punctuation">{</span> var a interface<span class="token punctuation">{</span><span class="token punctuation">}</span> cache<span class="token punctuation">[</span>index<span class="token punctuation">]</span> <span class="token operator">=</span> <span class="token operator">&</span>a <span class="token punctuation">}</span> var list <span class="token punctuation">[</span><span class="token punctuation">]</span>map<span class="token punctuation">[</span>string<span class="token punctuation">]</span>interface<span class="token punctuation">{</span><span class="token punctuation">}</span> <span class="token keyword">for</span> rows.Next<span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> _ <span class="token operator">=</span> rows.Scan<span class="token punctuation">(</span>cache<span class="token punctuation">..</span>.<span class="token punctuation">)</span> item :<span class="token operator">=</span> make<span class="token punctuation">(</span>map<span class="token punctuation">[</span>string<span class="token punctuation">]</span>interface<span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">)</span> <span class="token keyword">for</span> i, data :<span class="token operator">=</span> range cache <span class="token punctuation">{</span> item<span class="token punctuation">[</span>columns<span class="token punctuation">[</span>i<span class="token punctuation">]</span><span class="token punctuation">]</span> <span class="token operator">=</span> *data.<span class="token punctuation">(</span>*interface<span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">)</span> <span class="token punctuation">}</span> list <span class="token operator">=</span> append<span class="token punctuation">(</span>list, item<span class="token punctuation">)</span> <span class="token punctuation">}</span> _ <span class="token operator">=</span> rows.Close<span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token keyword">return</span> list, nil <span class="token punctuation">}</span> </code></pre>

到此这篇关于“Golang读取Rows到map[string]interface{}中”的文章就介绍到这了,更多文章或继续浏览下面的相关文章，希望大家以后多多支持JQ教程网！

您可能感兴趣的文章：
Golang开发实践:把数据库数据保存到map[string]interface{}中
golang使用json格式实现增删查改
Golang读取Rows到map[string]interface{}中
Golang从入门到放弃200618--Map(1)Map的初始化和基本操作
golang读取接口数据interface{}
go interface类型转换_Golang系列5 | Interface接口&amp;map类型
golang map 读写锁与深度拷贝的坑
# golang 数据结构 2
Golang线程安全Map:sync.Map使用小结
Golang Study 三 map的顺序输出