嵌入式sql案例

字数 2681阅读 2332评论 0赞 1

<div>一、编辑包含sql代码的源码文件static.sqc</div><div>#include <stdio.h></div><div>#include <string.h></div><div>#include <sql.h></div><div><br></div><div>int main()</div><div>{</div><div><span class="Apple-tab-span" style="white-space:pre">	</span>printf("nnthis is a test programming !nn");</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre">	</span>EXEC SQL INCLUDE SQLCA;</div><div><span class="Apple-tab-span" style="white-space:pre">	</span>EXEC SQL BEGIN DECLARE SECTION;</div><div><span class="Apple-tab-span" style="white-space:pre">		</span>char employeeNO[7];</div><div><span class="Apple-tab-span" style="white-space:pre">		</span>char lastName[16];</div><div><span class="Apple-tab-span" style="white-space:pre">		</span>double salary;</div><div><span class="Apple-tab-span" style="white-space:pre">		</span>short  salaryNI;</div><div><span class="Apple-tab-span" style="white-space:pre">	</span>EXEC SQL END   DECLARE SECTION;</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre">	</span>EXEC SQL CONNECT TO sample user db2inst1 using panpan;</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre">	</span>EXEC SQL DECLARE cursor1 CURSOR for</div><div><span class="Apple-tab-span" style="white-space:pre">		</span>select empno,</div><div><span class="Apple-tab-span" style="white-space:pre">			</span>lastname,</div><div><span class="Apple-tab-span" style="white-space:pre">			</span>double(salary)</div><div><span class="Apple-tab-span" style="white-space:pre">		</span>from db2inst1.employee</div><div><span class="Apple-tab-span" style="white-space:pre">		</span>where job = 'DESIGNER';</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre">	</span>EXEC SQL OPEN cursor1;</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre">	</span>while(sqlca.sqlcode == SQL_RC_OK)</div><div><span class="Apple-tab-span" style="white-space:pre">	</span>{</div><div><span class="Apple-tab-span" style="white-space:pre">		</span>EXEC SQL FETCH cursor1</div><div><span class="Apple-tab-span" style="white-space:pre">			</span>into :employeeNO,</div><div><span class="Apple-tab-span" style="white-space:pre">			</span>     :lastName,</div><div><span class="Apple-tab-span" style="white-space:pre">			</span>     :salary :salaryNI;</div><div><span class="Apple-tab-span" style="white-space:pre">		</span>if (sqlca.sqlcode == SQL_RC_OK)</div><div><span class="Apple-tab-span" style="white-space:pre">		</span>{</div><div><span class="Apple-tab-span" style="white-space:pre">			</span>printf("%-8s %-16s  ",employeeNO,lastName);</div><div><span class="Apple-tab-span" style="white-space:pre">			</span>if (salaryNI >= 0)</div><div><span class="Apple-tab-span" style="white-space:pre">			</span>{</div><div><span class="Apple-tab-span" style="white-space:pre">				</span>printf("%lfnn",salary);</div><div><span class="Apple-tab-span" style="white-space:pre">			</span>}</div><div><span class="Apple-tab-span" style="white-space:pre">			</span>else</div><div><span class="Apple-tab-span" style="white-space:pre">			</span>{</div><div><span class="Apple-tab-span" style="white-space:pre">				</span>printf("unknownn");</div><div><span class="Apple-tab-span" style="white-space:pre">			</span>}</div><div><span class="Apple-tab-span" style="white-space:pre">		</span>}</div><div><span class="Apple-tab-span" style="white-space:pre">	</span>}</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre">	</span>EXEC SQL close cursor1;</div><div><span class="Apple-tab-span" style="white-space:pre">	</span>EXEC SQL commit;</div><div><span class="Apple-tab-span" style="white-space:pre">	</span>exec sql connect reset;</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre">	</span>return 0;</div><div>}</div><div><br></div><div>二、利用db2工具预编译，将sql替换成api函数，生成static.c</div><div>db2 connect to sample user db2inst1 using panpan   --因为需要绑定执行计划，需要连接数据库</div><div>db2 prep static.sqc [bindfile]    --加上bindfile选项，则生成绑定文件，不在数据库中生成执行计划,prep/precompile</div><div>db2 bind static.bnd    --绑定访问计划到数据库</div><div><br></div><div>三、编译、汇编成目标文件</div><div>gcc -c static.c -I /home/db2inst1/sqllib/include -o static.o</div><div><br></div><div>四、将生成的目标文件与其他库链接</div><div>gcc static.o -o static -l db2 -L /home/db2inst1/sqllib/lib</div><div><br></div><div>五、运行可执行文件static</div><div>./static</div><div>结果报错：</div><div> error while loading shared libraries: libdb2.so.1: cannot open shared object file: No such file or directory</div><div><br></div><div>六、查看static运行需要的库文件</div><div>ldd static</div><div>输出:</div><div><div> linux-gate.so.1 =>  (0x00e32000)</div><div>        libdb2.so.1 => <b>not found</b></div><div>        libc.so.6 => /lib/libc.so.6 (0x00adb000)</div><div>        /lib/ld-linux.so.2 (0x00ab8000)</div></div><div><br></div><div>七、查找 libdb2.so.1库文件</div><div>locate libdb2.so.1</div><div>输出：</div><div><div>/opt/ibm/db2/V9.7/lib32/libdb2.so.1</div></div><div>find工具同样可以实现该功能，但是速度慢。</div><div><br></div><div>八、建立软链接</div><div>ln -s /opt/ibm/db2/V9.7/lib32/libdb2.so.1 /lib/libdb2.so.1</div><div><br></div><div>九、再次执行static</div><div>./static</div><div>输出：</div><div><div>this is a test programming !</div><div><br></div><div>000150   ADAMSON           55280.000000</div><div><br></div><div>000160   PIANKA            62250.000000</div><div><br></div><div>000170   YOSHIMURA         44680.000000</div><div><br></div><div>000180   SCOUTTEN          51340.000000</div><div><br></div><div>000190   WALKER            50450.000000</div><div><br></div><div>000200   BROWN             57740.000000</div><div><br></div><div>000210   JONES             68270.000000</div><div><br></div><div>000220   LUTZ              49840.000000</div><div><br></div><div>200170   YAMAMOTO          64680.000000</div><div><br></div><div>200220   JOHN              69840.000000</div></div><div><br></div><div><br></div>

SQL

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论0 条评论

Ctrl+Enter 发表

匿名评论

嵌入式sql案例

添加新评论0 条评论

作者其他文章

相关文章

相关问题

相关资料