加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 大数据 > 正文

perl select count(*) 返回0条,为假判断

发布时间:2020-12-15 23:53:32 所属栏目:大数据 来源:网络整理
导读:#!/usr/bin/perl use strict;use DBI;my $dbName = 'orcl';my $dbUser = 'test';my $dbUserPass = 'test';my $dbh = DBI-connect("dbi:Oracle:$dbName",$dbUser,$dbUserPass) or die "can't connect to database " ;my $sql = "select count(*) from a11";pr
#!/usr/bin/perl 
use strict;
use DBI;
my $dbName = 'orcl';
my $dbUser = 'test';
my $dbUserPass = 'test';
my $dbh = DBI->connect("dbi:Oracle:$dbName",$dbUser,$dbUserPass) or die "can't connect to database " ;
my $sql = "select count(*) from a11";
print "$sql is $sql..n";
my $sth = $dbh->prepare($sql);
print "$sth is $sth..n";

$sth->execute();
my $count = $sth->fetchrow_array();
print "$count is $count....n";
if ( $count  ){
print "not empty";}
else {print "emptyn"}
$sth->finish;

$dbh->disconnect;
[oracle@jhoa ~]$ perl dbi.pl 
$sql is select count(*) from a11..
$sth is DBI::st=HASH(0x2df1db0)..
$count is 0....
empty


0在perl里为假:
[oracle@jhoa ~]$ cat a2.pl 
my $count = 0;
if ( $count  ){
print "not emptyn";}
else {print "emptyn"}

[oracle@jhoa ~]$ perl a2.pl 
empty

[oracle@jhoa ~]$ cat a2.pl 
my $count = 2;
if ( $count  ){
print "not emptyn";}
else {print "emptyn"}

[oracle@jhoa ~]$ perl a2.pl 
not empty

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读