. 安装DBI模块步骤1:
从TOOLS栏目中下载DBI.zip,下载完后用winzip解开到
个temp目录,共有 3个文件:Readme
DBI.ppd
DBI.tar.gz
步骤2:
在DOS窗口下
temp目录中运行下面
DOS命令:ppm
DBI.ppd如果提示无效命令,可在perl/bin目录下运行
2. 安装DBD-Mysql模块
从软件Software下载中下载DBD-Mysql.zip,安装mysql,首先创建
个数据库mydata,然后创建个表addressmysql> create database mydata;
Query OK, 1 row affected (0.00 sec)
mysql> use mydata;
Database changed
mysql> create table address (
-> id
(5) not null,-> name varchar(40) not null,
-> email varchar(50) not null,
-> telephone
(12) null);Query OK, 0 rows affected (0.05 sec)
输入些数据:
mysql> insert
o address values (-> 1,’Nighthawk’,’[email protected]’,92384092);
Query OK, 1 row affected (0.00 sec)
4. 下面用perl
来插入若干记录并做查询.use DBI;
#连接数据库mydata
my $dbh = DBI->connect(’DBI:mysql:mydata’) or die "无法连接数据库: " . DBI->errstr;
pr
"插入若干记录n";my $sth = $dbh->prepare(q{
INSERT INTO address (id, name,email,telephone) VALUES (?, ?, ?, ?)
}) });
pr
"输入记录,回车结束:";while ($inputdata =<>) {
chop $inputdata;
last unless($inputdata);
my ($id, $name,$email, $tel) = split( /,/, $inputdata);
$sth->execute($id, $name, $email,$tel)
}
# $dbh->commit;
pr
"下面根据输入名字打印出EMAIL地址和电话n";my $sth = $dbh->prepare(’SELECT * FROM address WHERE name=?’)
or die $dbh->errstr;
pr
"请输入姓名,回车结束:";while ($inputname =<>) {
my @data;
chomp $inputname;
last unless($inputname);
$sth->execute($inputname) or die "
: " . $sth->errstr;while (@data = $sth->fetchrow_
) {pr
"Email:$data[2]t Telephone:$data[3]n";}
}
#断开连接
$dbh->disconnect;
最新评论