fig15_20.pl

来自「PERL语言资料 可以用于PERL程序设计」· PL 代码 · 共 69 行

#!/usr/bin/perl
# Fig. 15.20: fig15_20.pl
# Program to insert a new record into the database.

use warnings;
use strict;
use DBI;
use DBD::ODBC;

my $dbh = DBI->connect( "dbi:ODBC:employeeDB", "", "", 
                        { RaiseError => 1 } );
 
print( "Please enter your employee ID: " );
chomp( my $newemploy = <STDIN> );
print( "Please enter your first name: " );
chomp( my $newfirst = <STDIN> );
print( "Please enter your last name: " );
chomp( my $newlast = <STDIN> );
print( "Please enter your year of birth: " );
chomp( my $newbirthyr = <STDIN> );
print( "Please enter your social security number: " );
chomp( my $newsoc = <STDIN> );

my $querystring = "INSERT INTO employee VALUES 
      ( '$newemploy','$newfirst','$newlast',
        '$newbirthyr','$newsoc' );";

# Execute the statement
$dbh->do( $querystring );

# Now print the updated database
my $sth = $dbh->prepare( q{ SELECT * FROM employee  } );

$sth->execute();

print( "\n" );

my @array;

while ( @array = $sth->fetchrow_array() ) {
   write();
}

# Clean up
warn( $DBI::errstr ) if $DBI::err;
$sth->finish();
$dbh->disconnect();

format STDOUT = 
@<<<<<<@<<<<<<<<<@<<<<<<<<<<@<<<<<@<<<<<<<<<<<
$array[ 0 ], $array[ 1 ], $array[ 2 ], $array[ 3 ], $array[ 4 ]
.



###########################################################################
#  (C) Copyright 2001 by Deitel & Associates, Inc. and Prentice Hall.     #
#  All Rights Reserved.                                                   #
#                                                                         #
#  DISCLAIMER: The authors and publisher of this book have used their     #
#  best efforts in preparing the book. These efforts include the          #
#  development, research, and testing of the theories and programs        #
#  to determine their effectiveness. The authors and publisher make       #
#  no warranty of any kind, expressed or implied, with regard to these    #
#  programs or to the documentation contained in these books. The authors #
#  and publisher shall not be liable in any event for incidental or       #
#  consequential damages in connection with, or arising out of, the       #
#  furnishing, performance, or use of these programs.                     #
###########################################################################