DBI-1.634之selectrow_array与fetchrow

　　在DBI-1.634使用手册里有一个selectrow_array函数，该函数具体说明如下：

　　This utility method combines "prepare", "execute" and "fetchrow_array" into a single call. If called in a list context, it returns the first row of data from the statement. The $statement parameter can be a previously prepared statement handle, in which case the prepare is skipped.

　　手册里说明该函数具备与fetchrow_array类似的功能。在实际使用时，确实有区别的。如下例子：

 #!/bin/env perl
 use DBI;

 my $dbh=DBI->connect("dbi:Oracle:gzgldb","nrmdb","nrmoptr123") or die "connect db error!";

 my $sql='select * from router';

 my $sth=$dbh->prepare($sql);

 $sth->execute() or die "execute sql error!";

 my @row1=$sth->fetchrow_array();
 print "@row1 \n";
 @row1=$sth->fetchrow_array();
 print "@row1 num2 \n";

 my @row=$dbh->selectrow_array($sql);
       print "@row\n";

 @row=$dbh->selectrow_array($sql);

       print "@row\n";

 $sth->finish;
 $dbh->disconnect();

以下为输出结果：

由此可以看出fetchrow_array每取一次，行指针会下移一次；而selectrow_array确不会这样做。

巴特西

DBI-1.634之selectrow_array与fetchrow_array的区别

最新文章

热门文章