- 论坛徽章:
- 0
|
没必要过度追求精简~~
不过Ray的code的确可以简化一些,偶稍微修改一下:- use strict;
- use DBI;
- my ($user,$password,$sid) = ("CREDIT2","PASS","CMIS");
- my $dbh = DBI->connect( "DBI:Oracle:$sid", $user, $password ) or die $DBI::errstr;
- open CFG_FILE, "ycloansaccreg.prp" or die $!;
- while (<CFG_FILE>) {
- my ($func_id,undef,$amt_typ) = /(^LN..)(.*),([A-Z]0[0-9][A-Z]?)=/;
- my $sth = $dbh->prepare("SELECT amt_typ FROM p_loan_typ_gl_dtl WHERE func_id=? AND amt_typ=?");
- $sth->execute($func_id,$amt_typ);
- print "$func_id $amt_typ not found in p_loan_typ_gl_dtl\n" unless $sth->fetchrow_array();
- $sth->finish();
- }
- $dbh->disconnect();
复制代码 最后强调一下:
没有use strict的code不是好code。 |
|