这么几行代码居然有BUG，请大家帮看看啊(页 1) - 技术沙龙 - 中国共享软件联盟 - CNSW - 论坛

wsg1212 发表于 2008-5-8 23:19

这么几行代码居然有BUG，请大家帮看看啊

for (int i=0; i<=m_param.maxLayer; i++)
{
char qry [MAX_SQL_STATEMENT] = {0};
SQLRETURN c;
SQLAllocHandle(SQL_HANDLE_STMT, m_hDbc, &(m_h1[i]));

SQLAllocHandle(SQL_HANDLE_STMT, m_hDbc, &(m_h2[i]));

SQLAllocHandle(SQL_HANDLE_STMT, m_hDbc, &(m_h3[i]));

SQLAllocHandle(SQL_HANDLE_STMT, m_hDbc, &(m_h4[i]));

SQLAllocHandle(SQL_HANDLE_STMT, m_hDbc, &(m_h5[i]));

SQLAllocHandle(SQL_HANDLE_STMT, m_hDbc, &(m_h6[i]));

SQLAllocHandle(SQL_HANDLE_STMT, m_hDbc, &(m_h7[i]));

SQLAllocHandle(SQL_HANDLE_STMT, m_hDbc, &(m_h8[i]));

SQLAllocHandle(SQL_HANDLE_STMT, m_hDbc, &(m_h9[i]));
}
//上面的执行没有问题，下面的运行时一场，报告JETDLL的什么一场
for (i=0; i<=m_param.maxLayer; i++)
{
SQLFreeHandle(SQL_HANDLE_STMT, m_h1[i]);

SQLFreeHandle(SQL_HANDLE_STMT, m_h2[i]);

SQLFreeHandle(SQL_HANDLE_STMT, m_h3[i]);

SQLFreeHandle(SQL_HANDLE_STMT, m_h4[i]);

SQLFreeHandle(SQL_HANDLE_STMT, m_h5[i]);

SQLFreeHandle(SQL_HANDLE_STMT, m_h6[i]);

SQLFreeHandle(SQL_HANDLE_STMT, m_h7[i]);

SQLFreeHandle(SQL_HANDLE_STMT, m_h8[i]);

SQLFreeHandle(SQL_HANDLE_STMT, m_h9[i]);
}

wandou 发表于 2008-5-8 23:52

:lol

w1984721 发表于 2008-5-9 00:56

大家认真一点!:@

yiyuan 发表于 2008-5-9 01:35

:lol

vender 发表于 2008-5-9 08:03

天下第一的程序怎么会”一场“呢

这是为什么呢:lol

5bxb 发表于 2008-5-9 08:44

:lol

远帆发表于 2008-5-9 09:45

[quote]原帖由 [i]w1984721[/i] 于 2008-5-9 00:56 发表 [url=http://www.cnsw.org/bbs/redirect.php?goto=findpost&pid=355263&ptid=80944][img]http://www.cnsw.org/bbs/images/common/back.gif[/img][/url]
大家认真一点!:@ [/quote]

哈哈~路线了

aalii 发表于 2008-5-9 11:17

这是为什么呢~~~;P

微硬发表于 2008-5-9 11:55

微硬发表于 2008-5-9 11:57

vender 发表于 2008-5-9 13:17

天下第一很生气，后果很严重

:L :L :L

aprin 发表于 2008-5-9 13:48

[quote]原帖由 [i]wsg1212[/i] 于 2008-5-8 23:19 发表 [url=http://www.cnsw.org/bbs/redirect.php?goto=findpost&pid=355220&ptid=80944][img]http://www.cnsw.org/bbs/images/common/back.gif[/img][/url]
for (int i=0; i [/quote]
没有用c++搞过sql，但这个错误很明显吧，用一个循环分配句柄，对应变量只会保存最一次的，后面又用循环重复释放同一个句柄，这能不出错么？

还有，不知c++里的sql代码要不要处理异常，java是必须处理的，c++也应该要吧。

浅释发表于 2008-5-9 15:24

我看行

CodeCoolie 发表于 2008-5-10 12:27

[img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img]
[img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img]
[img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img]
[img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img]
[img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img][img]http://www.cnsw.org/bbs/images/smilies/default/lol.gif[/img]

temc 发表于 2008-5-10 16:00

漏了:lol

kevin 发表于 2008-5-10 19:43

应该把SQLAllocHandle实现代码贴出来。

wsg1212 发表于 2008-5-11 14:02

直到了，数组楼了。
arr[MAY_LAYER+1]才对，
结果成了arr[MAX_LAYER]

兰兰发表于 2008-5-11 14:08

有错别字!果然是天下第一!:lol

wdlfellow 发表于 2008-6-10 18:08

:Q 貌似不是这里的问题哦

页: [1]

中国共享软件联盟's Archiver