37,721
社区成员
发帖
与我相关
我的任务
分享
my $sql_str = "SELECT `NAME` FROM `benefit` WHERE `SUBJECT` = ? ";
my $subject_value = "PRD";
my $sth = $dbh->prepare($sql_str);
$sth->execute($subject_value);
while (my $row = $sth->fetchrow_hashref){
print $row->{'NAME'}."\n";
}
至于fetchall_arrayref与fetchall_hashref这2个也可以做到,LZ 自己去看下文档 http://search.cpan.org/~timb/DBI-1.631/DBI.pm
还有种方法应该可以
selectcol_arrayref
my $ary_ref = $dbh->selectcol_arrayref($sql_str, undef, $subject_value);
foreach (@$ary_ref){
print $_."\n";
}
解析一下$ary_ref