﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>C++博客-icecream</title><link>http://www.cppblog.com/icecream/</link><description>我的代码备份！</description><language>zh-cn</language><lastBuildDate>Tue, 14 Apr 2026 23:08:09 GMT</lastBuildDate><pubDate>Tue, 14 Apr 2026 23:08:09 GMT</pubDate><ttl>60</ttl><item><title>Maximum Flow Algorithms</title><link>http://www.cppblog.com/icecream/archive/2010/05/05/114483.html</link><dc:creator>icecream</dc:creator><author>icecream</author><pubDate>Wed, 05 May 2010 06:15:00 GMT</pubDate><guid>http://www.cppblog.com/icecream/archive/2010/05/05/114483.html</guid><wfw:comment>http://www.cppblog.com/icecream/comments/114483.html</wfw:comment><comments>http://www.cppblog.com/icecream/archive/2010/05/05/114483.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.cppblog.com/icecream/comments/commentRss/114483.html</wfw:commentRss><trackback:ping>http://www.cppblog.com/icecream/services/trackbacks/114483.html</trackback:ping><description><![CDATA[&nbsp;&nbsp;&nbsp;&nbsp; 摘要: &nbsp;&nbsp;1#include&nbsp;&lt;iostream&gt;&nbsp;2#include&nbsp;&lt;cstring&gt;&nbsp;3using&nbsp;namespace&nbsp;std;&nbsp;4&nbsp;5const&nbsp;int&nbsp;MAX&nbsp;=&nbsp;128;&nbsp;6class&nbsp;Network&nb...&nbsp;&nbsp;<a href='http://www.cppblog.com/icecream/archive/2010/05/05/114483.html'>阅读全文</a><img src ="http://www.cppblog.com/icecream/aggbug/114483.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.cppblog.com/icecream/" target="_blank">icecream</a> 2010-05-05 14:15 <a href="http://www.cppblog.com/icecream/archive/2010/05/05/114483.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Suffix Tree</title><link>http://www.cppblog.com/icecream/archive/2009/05/19/83412.html</link><dc:creator>icecream</dc:creator><author>icecream</author><pubDate>Tue, 19 May 2009 13:29:00 GMT</pubDate><guid>http://www.cppblog.com/icecream/archive/2009/05/19/83412.html</guid><wfw:comment>http://www.cppblog.com/icecream/comments/83412.html</wfw:comment><comments>http://www.cppblog.com/icecream/archive/2009/05/19/83412.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.cppblog.com/icecream/comments/commentRss/83412.html</wfw:commentRss><trackback:ping>http://www.cppblog.com/icecream/services/trackbacks/83412.html</trackback:ping><description><![CDATA[&nbsp;&nbsp;&nbsp;&nbsp; 摘要: Data Structures, Algorithms, &amp; Applications in JavaSuffix TreesCopyright 1999  Sartaj SahniHave You Seen This String?The Suffix TreeLet's Find That SubstringOther Nifty Thing...&nbsp;&nbsp;<a href='http://www.cppblog.com/icecream/archive/2009/05/19/83412.html'>阅读全文</a><img src ="http://www.cppblog.com/icecream/aggbug/83412.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.cppblog.com/icecream/" target="_blank">icecream</a> 2009-05-19 21:29 <a href="http://www.cppblog.com/icecream/archive/2009/05/19/83412.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>AC 自动机算法详解（转）</title><link>http://www.cppblog.com/icecream/archive/2009/04/28/81344.html</link><dc:creator>icecream</dc:creator><author>icecream</author><pubDate>Tue, 28 Apr 2009 11:31:00 GMT</pubDate><guid>http://www.cppblog.com/icecream/archive/2009/04/28/81344.html</guid><wfw:comment>http://www.cppblog.com/icecream/comments/81344.html</wfw:comment><comments>http://www.cppblog.com/icecream/archive/2009/04/28/81344.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.cppblog.com/icecream/comments/commentRss/81344.html</wfw:commentRss><trackback:ping>http://www.cppblog.com/icecream/services/trackbacks/81344.html</trackback:ping><description><![CDATA[首先简要介绍一下AC自动机：Aho-Corasick automation，该算法在1975年产生于贝尔实验室，是著名的多模匹配算法之一。一个常见的例子就是给出n个单词，再给出一段包含m个字符的文章，让你找出有多少个单词在文章里出现过。要搞懂AC自动机，先得有模式树（字典树）Trie和KMP模式匹配算法的基础知识。AC自动机算法分为3步：构造一棵Trie树，构造失败指针和模式匹配过程。<br>
&nbsp;&nbsp;&nbsp;&nbsp;   如果你对KMP算法和了解的话，应该知道KMP算法中的next函数（shift函数或者fail函数）是干什么用的。KMP中我们用两个指针i和j分别表示，A[i-j+ 1..i]与B[1..j]完全相等。也就是说，i是不断增加的，随着i的增加j相应地变化，且j满足以A[i]结尾的长度为j的字符串正好匹配B串的前 j个字符，当A[i+1]&#8800;B[j+1]，KMP的策略是调整j的位置（减小j值）使得A[i-j+1..i]与B[1..j]保持匹配且新的B[j+1]恰好与A[i+1]匹配，而next函数恰恰记录了这个j应该调整到的位置。同样AC自动机的失败指针具有同样的功能，也就是说当我们的模式串在Tire上进行匹配时，如果与当前节点的关键字不能继续匹配的时候，就应该去当前节点的失败指针所指向的节点继续进行匹配。<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   看下面这个例子：给定5个单词：say she shr he her，然后给定一个字符串yasherhs。问一共有多少单词在这个字符串中出现过。我们先规定一下AC自动机所需要的一些数据结构，方便接下去的编程。<br>
<div style="border: 1px solid #cccccc; padding: 4px 5px 4px 4px; font-size: 13px; width: 98%; background-color: #eeeeee;"> 1 const int kind = 26; <br>
2 struct node{&nbsp;&nbsp;<br>
3 &nbsp;&nbsp;&nbsp;&nbsp;  node *fail;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//失败指针<br>
4 &nbsp;&nbsp;&nbsp;&nbsp;  node *next[kind]; //Tire每个节点的个子节点（最多个字母）<br>
5 &nbsp;&nbsp;&nbsp;&nbsp;int count;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//是否为该单词的最后一个节点<br>
6 &nbsp;&nbsp;&nbsp;&nbsp;  node(){&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//构造函数初始化<br>
7 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  fail=NULL; <br>
8 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  count=0; <br>
9 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  memset(next,NULL,sizeof(next)); <br>
10 &nbsp;&nbsp;&nbsp;&nbsp;  } <br>
11 }*q[500001];&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//队列，方便用于bfs构造失败指针<br>
12 char keyword[51];&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//输入的单词<br>
13 char str[1000001];&nbsp;&nbsp;&nbsp;&nbsp;//模式串<br>
14 int head,tail;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//队列的头尾指针</div>
<p>有了这些数据结构之后，就可以开始编程了：<br>
&nbsp;&nbsp;&nbsp;   首先，将这<font face="Calibri">5</font>个单词构造成一棵<font face="Calibri">Tire</font>，如图<font face="Calibri">-1</font>所示。<br>
</p>
<div src_cetemp="/images/cppblog_com/mythit/ac1.jpg" align="center"><img src="http://www.cppblog.com/images/cppblog_com/mythit/ac1.jpg" width="611" border="0" height="394"></div>
<p>&nbsp;</p>
<p> </p>
<div style="border: 1px solid #cccccc; padding: 4px 5px 4px 4px; font-size: 13px; width: 98%; background-color: #eeeeee;"> 1 void insert(char *str,node *root){ <br>
2 &nbsp;&nbsp;&nbsp;&nbsp;  node *p=root; <br>
3 &nbsp;&nbsp;&nbsp;&nbsp;int i=0,index;&nbsp;&nbsp;<br>
4 &nbsp;&nbsp;&nbsp;&nbsp;while(str[i]){ <br>
5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  index=str[i]-'a'; <br>
6 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(p-&gt;next[index]==NULL) p-&gt;next[index]=new node();&nbsp;&nbsp;<br>
7 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  p=p-&gt;next[index];<br>
8 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  i++;<br>
9 &nbsp;&nbsp;&nbsp;&nbsp;  } <br>
10 &nbsp;&nbsp;&nbsp;&nbsp;  p-&gt;count++;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//在单词的最后一个节点count+1，代表一个单词<br>
11 }</div>
<p>在构造完这棵<font face="Calibri">Tire</font>之后，接下去的工作就是构造下失败指针。构造失败指针的过程概括起来就一句话：设这个节点上的字母为<font face="Calibri">C</font>，沿着他父亲的失败指针走，直到走到一个节点，他的儿子中也有字母为<font face="Calibri">C</font>的节点。然后把当前节点的失败指针指向那个字母也为<font face="Calibri">C</font>的儿子。如果一直走到了<font face="Calibri">root</font>都没找到，那就把失败指针指向<font face="Calibri">root</font>。具体操作起来只需要：先把<font face="Calibri">root</font>加入队列<font face="Calibri">(root</font>的失败指针指向自己或者<font face="Calibri">NULL)</font>，这以后我们每处理一个点，就把它的所有儿子加入队列，队列为空。</p>
<div style="border: 1px solid #cccccc; padding: 4px 5px 4px 4px; font-size: 13px; width: 98%; background-color: #eeeeee;"> 1 void build_ac_automation(node *root){<br>
2&nbsp;&nbsp;&nbsp;&nbsp;   int i;<br>
3 &nbsp;&nbsp;&nbsp;&nbsp;  root-&gt;fail=NULL; <br>
4 &nbsp;&nbsp;&nbsp;&nbsp;  q[head++]=root; <br>
5 &nbsp;&nbsp;&nbsp;&nbsp;while(head!=tail){ <br>
6 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  node *temp=q[tail++]; <br>
7 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  node *p=NULL; <br>
8 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(i=0;i&lt;26;i++){ <br>
9 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(temp-&gt;next[i]!=NULL){ <br>
10 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(temp==root) temp-&gt;next[i]-&gt;fail=root;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
11 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else{ <br>
12 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  p=temp-&gt;fail; <br>
13 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while(p!=NULL){&nbsp;&nbsp;<br>
14 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(p-&gt;next[i]!=NULL){ <br>
15 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  temp-&gt;next[i]-&gt;fail=p-&gt;next[i]; <br>
16 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break; <br>
17 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  } <br>
18 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  p=p-&gt;fail; <br>
19 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  } <br>
20 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(p==NULL) temp-&gt;next[i]-&gt;fail=root; <br>
21 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  } <br>
22 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  q[head++]=temp-&gt;next[i];&nbsp;&nbsp;<br>
23 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  } <br>
24 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  }&nbsp;&nbsp;&nbsp;<br>
25 &nbsp;&nbsp;&nbsp;&nbsp;  } <br>
26 }</div>
<br>
&nbsp;&nbsp;&nbsp;   从代码观察下构造失败指针的流程：对照图-2来看，首先root的fail指针指向NULL，然后root入队，进入循环。第1次循环的时候，我们需要处理2个节点：root-&gt;next[&#8216;h&#8217;-&#8216;a&#8217;](节点h) 和 root-&gt;next[&#8216;s&#8217;-&#8216;a&#8217;](节点s)。把这2个节点的失败指针指向root，并且先后进入队列，失败指针的指向对应图-2中的(1)，(2)两条虚线；第2次进入循环后，从队列中先弹出h，接下来p指向h节点的fail指针指向的节点，也就是root；进入第13行的循环后，p=p-&gt;fail也就是p=NULL，这时退出循环，并把节点e的fail指针指向root，对应图-2中的(3)，然后节点e进入队列；第3次循环时，弹出的第一个节点a的操作与上一步操作的节点e相同，把a的fail指针指向root，对应图-2中的(4)，并入队；第4次进入循环时，弹出节点h(图中左边那个)，这时操作略有不同。在程序运行到14行时，由于p-&gt;next[i]!=NULL(root有h这个儿子节点，图中右边那个)，这样便把左边那个h节点的失败指针指向右边那个root的儿子节点h，对应图-2中的(5)，然后h入队。以此类推：在循环结束后，所有的失败指针就是图-2中的这种形式。<br>
<div src_cetemp="/images/cppblog_com/mythit/ac2.JPG" align="center"><img src="http://www.cppblog.com/images/cppblog_com/mythit/ac2.JPG" width="611" border="0" height="394"></div>
<br>
<font face="宋体">&nbsp;&nbsp; 最后，我们便可以在AC自动机上查找模式串中出现过哪些单词了。匹配过程分两种情况：(1)当前字符匹配，
表示从当前节点沿着树边有一条路径可以到达目标字符，此时只需沿该路径走向下一个节点继续匹配即可，目标字符串指针移向下个字符继续匹配；(2)当前字符
不匹配，则去当前节点失败指针所指向的字符继续匹配，匹配过程随着指针指向root结束。重复这2个过程中的任意一个，直到模式串走到结尾为止。<br>
</font>
<div style="border: 1px solid #cccccc; padding: 4px 5px 4px 4px; font-size: 13px; width: 98%; background-color: #eeeeee;"> 1 int query(node *root){ <br>
2 &nbsp;&nbsp;&nbsp;&nbsp;int i=0,cnt=0,index,len=strlen(str); <br>
3 &nbsp;&nbsp;&nbsp;&nbsp;  node *p=root;&nbsp;&nbsp;<br>
4 &nbsp;&nbsp;&nbsp;&nbsp;while(str[i]){&nbsp;&nbsp;<br>
5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  index=str[i]-'a';&nbsp;&nbsp;<br>
6 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while(p-&gt;next[index]==NULL &amp;&amp; p!=root) p=p-&gt;fail; <br>
7 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  p=p-&gt;next[index]; <br>
8 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  p=(p==NULL)?root:p; <br>
9 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  node *temp=p; <br>
10 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while(temp!=root &amp;&amp; temp-&gt;count!=-1){ <br>
11 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  cnt+=temp-&gt;count; <br>
12 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  temp-&gt;count=-1; <br>
13 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  temp=temp-&gt;fail; <br>
14 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  } <br>
15 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  i++;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
16 &nbsp;&nbsp;&nbsp;&nbsp;  }&nbsp;&nbsp;&nbsp;&nbsp;<br>
17 &nbsp;&nbsp;&nbsp;&nbsp;return cnt; <br>
18 }</div>
&nbsp;&nbsp;&nbsp;
对照图-2，看一下模式匹配这个详细的流程，其中模式串为yasherhs。对于i=0,1。Trie中没有对应的路径，故不做任何操作；i=2,3,4
时，指针p走到左下节点e。因为节点e的count信息为1，所以cnt+1，并且讲节点e的count值设置为-1，表示改单词已经出现过了，防止重复
计数，最后temp指向e节点的失败指针所指向的节点继续查找，以此类推，最后temp指向root，退出while循环，这个过程中count增加了
2。表示找到了2个单词she和he。当i=5时，程序进入第5行，p指向其失败指针的节点，也就是右边那个e节点，随后在第6行指向r节点，r节点的
count值为1，从而count+1，循环直到temp指向root为止。最后i=6,7时，找不到任何匹配，匹配过程结束。<br>
<br> <img src ="http://www.cppblog.com/icecream/aggbug/81344.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.cppblog.com/icecream/" target="_blank">icecream</a> 2009-04-28 19:31 <a href="http://www.cppblog.com/icecream/archive/2009/04/28/81344.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>c 语言 mysql</title><link>http://www.cppblog.com/icecream/archive/2009/04/14/79935.html</link><dc:creator>icecream</dc:creator><author>icecream</author><pubDate>Tue, 14 Apr 2009 12:05:00 GMT</pubDate><guid>http://www.cppblog.com/icecream/archive/2009/04/14/79935.html</guid><wfw:comment>http://www.cppblog.com/icecream/comments/79935.html</wfw:comment><comments>http://www.cppblog.com/icecream/archive/2009/04/14/79935.html#Feedback</comments><slash:comments>1</slash:comments><wfw:commentRss>http://www.cppblog.com/icecream/comments/commentRss/79935.html</wfw:commentRss><trackback:ping>http://www.cppblog.com/icecream/services/trackbacks/79935.html</trackback:ping><description><![CDATA[<table style="table-layout: fixed;">
    <tbody>
        <tr>
            <td>
            <div id="blog_text" class="cnt">
            <p>像<a href="http://proxy.leezii.com/index.php?q=aHR0cDovL3d3dy5jeWJlcmNpdGkuYml6L2ZhcS9ob3ctdG8tY29ubmVjdC10by1teS1teXNxbC1kYXRhYmFzZS1zZXJ2ZXItdXNpbmctY29tbWFuZC1saW5lLWFuZC1waHAv">PHP</a>和<a href="http://proxy.leezii.com/index.php?q=aHR0cDovL3d3dy5jeWJlcmNpdGkuYml6L2ZhcS9ob3ctdG8tYWNjZXNzLW15c3FsLWRhdGFiYXNlLXVzaW5nLXBlcmwv">perl</a>一样,MySQL也提供的C语言使用的API.</p>
            <p>C代码的API是随MySQL一起发布的. 它包含在mysqlclient库中, 可以使C程序来访问数据库.</p>
            <p>MySQL源码包中的许多客户端都是用C写的.&nbsp;&nbsp; 如果你正在找使用这些C API的例子, 可以看看客户端的写法.你可以在MySQL源码包的clients目录找到这些例子.</p>
            <h3><font size="2">软件包</font></h3>
            <p>请确保你已经安装了必要的开发环境,比如gcc, mysql等等. 下面是编译一个程序所需要安装的软件包的列表 (Ubuntu为例): </p>
            <ul>
                <li><strong> mysql-client</strong>  </li>
                <li><strong> libmysqlclient15-dev</strong> 和libmysqlclient15off </li>
                <li><strong> mysql-server</strong> : <br>
                </li>
                <li><strong> gcc, make and other development libs</strong> </li>
            </ul>
            <h3><font size="2">例子</font></h3>
            <p>下面这个例子,连接本机的MySQL服务器,然后列出mysql数据库中所有的表:</p>
            <table style="border-collapse: collapse;" width="95%" bgcolor="#f1f1f1" border="1" bordercolor="#999999" cellpadding="0" cellspacing="0">
                <tbody>
                    <tr>
                        <td>
                        <p style="margin: 5px; line-height: 150%;"><code><font face="NSimsun">/* Simple C program that connects to MySQL Database server*/<br>
                        #include &lt;mysql.h&gt;<br>
                        #include &lt;stdio.h&gt;<br>
                        <br>
                        main() {<br>
                        &nbsp;&nbsp;&nbsp; MYSQL *conn;<br>
                        &nbsp;&nbsp;&nbsp; MYSQL_RES *res;<br>
                        &nbsp;&nbsp;&nbsp; MYSQL_ROW row;<br>
                        <br>
                        &nbsp;&nbsp;&nbsp;char *server = "localhost";<br>
                        &nbsp;&nbsp;&nbsp;char *user = "root";<br>
                        &nbsp;&nbsp;&nbsp;char *password = ""; /* 此处改成你的密码 */<br>
                        &nbsp;&nbsp;&nbsp;char *database = "mysql";<br>
                        <br>
                        &nbsp;&nbsp;&nbsp; conn = mysql_init(NULL);<br>
                        <br>
                        &nbsp;&nbsp;&nbsp;/* Connect to database */<br>
                        &nbsp;&nbsp;&nbsp;if (!mysql_real_connect(conn, server,<br>
                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; user, password, database, 0, NULL, 0)) {<br>
                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fprintf(stderr, "%s\n", mysql_error(conn));<br>
                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;exit(1);<br>
                        &nbsp;&nbsp;&nbsp;}<br>
                        <br>
                        &nbsp;&nbsp;&nbsp;/* send SQL query */<br>
                        &nbsp;&nbsp;&nbsp;if (mysql_query(conn, "show tables")) {<br>
                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fprintf(stderr, "%s\n", mysql_error(conn));<br>
                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;exit(1);<br>
                        &nbsp;&nbsp;&nbsp;}<br>
                        <br>
                        &nbsp;&nbsp;&nbsp; res = mysql_use_result(conn);<br>
                        <br>
                        &nbsp;&nbsp;&nbsp;/* output table name */<br>
                        &nbsp;&nbsp;&nbsp;printf("MySQL Tables in mysql database:\n");<br>
                        &nbsp;&nbsp;&nbsp;while ((row = mysql_fetch_row(res)) != NULL)<br>
                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;printf("%s \n", row[0]);<br>
                        <br>
                        &nbsp;&nbsp;&nbsp;/* close connection */<br>
                        &nbsp;&nbsp;&nbsp; mysql_free_result(res);<br>
                        &nbsp;&nbsp;&nbsp; mysql_close(conn);<br>
                        }</font></code></p>
                        </td>
                    </tr>
                </tbody>
            </table>
            <br>
            <h3><font size="2">编译和连接程序</font></h3>
            <p>MySQL中有一个特殊的脚本,叫做mysql_config. 它会为你编译MySQL客户端,并连接到MySQL服务器提供有用的信息.你需要使用下面两个选项.<br>
            1. --<strong> libs</strong>  选项 - 连接MySQL客户端函数库所需要的库和选项. </p>
            <p><font face="NSimsun"><code>$ mysql_config --libs</code><br>
            </font>输出:</p>
            <pre>-L/usr/lib64/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -L/usr/lib64 -lssl -lcrypto</pre>
            <p>2. --<strong> cflags</strong>  选项 - 使用必要的include文件的选项等等.<br>
            <font face="NSimsun"><code>$ mysql_config --cflags</code><br>
            </font>输出:</p>
            <pre>-I/usr/include/mysql -g -pipe -m64 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing</pre>
            <p>你需要将上面两个选项加入到对源文件的编译命令中. 所以,要编译上面的程序,要使用下面的命令:<br>
            <font face="NSimsun"><code>$ <strong> gcc -o output-file $(mysql_config --cflags) mysql-c-api.c $(mysql_config --libs)</strong> </code><br>
            </font></p>
            <p>执行编译后的程序:<br>
            <font face="NSimsun"><code>$ ./output.file</code><br>
            </font></p>
            <p>输出为:</p>
            <pre>MySQL Tables in mysql database:<br>columns_priv<br>db<br>func<br>help_category<br>help_keyword<br>help_relation<br>help_topic<br>host<br>tables_priv<br>time_zone<br>time_zone_leap_second<br>time_zone_name<br>time_zone_transition<br>time_zone_transition_type<br>user <br></pre>
            </div>
            </td>
        </tr>
    </tbody>
</table>
转自：http://hi.baidu.com/aresky/blog/item/47ecc6fc0ad73cfffd037f7f.html
<br><br><br><a  href="http://pipal.javaeye.com/blog/288110">http://pipal.javaeye.com/blog/288110</a><br> <img src ="http://www.cppblog.com/icecream/aggbug/79935.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.cppblog.com/icecream/" target="_blank">icecream</a> 2009-04-14 20:05 <a href="http://www.cppblog.com/icecream/archive/2009/04/14/79935.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>dp优化（俞玮）</title><link>http://www.cppblog.com/icecream/archive/2009/04/11/79569.html</link><dc:creator>icecream</dc:creator><author>icecream</author><pubDate>Sat, 11 Apr 2009 02:26:00 GMT</pubDate><guid>http://www.cppblog.com/icecream/archive/2009/04/11/79569.html</guid><wfw:comment>http://www.cppblog.com/icecream/comments/79569.html</wfw:comment><comments>http://www.cppblog.com/icecream/archive/2009/04/11/79569.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.cppblog.com/icecream/comments/commentRss/79569.html</wfw:commentRss><trackback:ping>http://www.cppblog.com/icecream/services/trackbacks/79569.html</trackback:ping><description><![CDATA[&nbsp;&nbsp;&nbsp;&nbsp; 摘要: 基本动态规划问题的扩展应用动态规划可以有效的解决许多问题，其中有许多问题的数学模型，尤其对一些自从57年就开始研究的基本问题所应用的数学模型，都十分精巧。有关这些问题的解法，我们甚至可以视为标准——也就是最优的解法。不过随着问题规模的扩大化，有些模型显出了自身的不足和缺陷。这样，我们就需要进一步优化和改造这些模型。一.&nbsp;&nbsp; 程序上的优化：程序上的优化主要依赖问题的特...&nbsp;&nbsp;<a href='http://www.cppblog.com/icecream/archive/2009/04/11/79569.html'>阅读全文</a><img src ="http://www.cppblog.com/icecream/aggbug/79569.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.cppblog.com/icecream/" target="_blank">icecream</a> 2009-04-11 10:26 <a href="http://www.cppblog.com/icecream/archive/2009/04/11/79569.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>