- 论坛徽章:
- 3
|
而且给你一个我以前写的例子,你研究下是不是哪写错了?- #!/usr/bin/perl
- #set module
- use DBI;
- #scanf the mysqluser
- print "请输入mysql帐号:\n";
- chomp($mysql_n=<STDIN>);
- print "请输入mysql密码:\n";
- chomp($mysql_p=<STDIN>);
- print "请输入需要连接的数据库:\n";
- chomp($mysql_d=<STDIN>);
- print "请输入需要插入的用户数据:\n";
- chomp($user_n=<STDIN>);
- print "请输入需要插入的密码数据:\n";
- chomp($user_p=<STDIN>);
- print "请输入需要插入的电话数据:\n";
- chomp($user_t=<STDIN>);
- print "请输入需要插入的工龄数据:\n";
- chomp($user_y=<STDIN>);
- #connect mysql
- my $in=DBI->connect("DBI:mysql:database=$mysql_d;host=localhost","$mysql_n","$mysql_p") or die "FUCK no do it!!!\n";
- #insert tables
- my $insert=$in->do("insert into people(username,password,number,year)values('$user_n','$user_p',$user_t,$user_y)");
- #select databases;
- my $select=$in->prepare("select username,password from people");
- $select->execute();
- #print the list
- while(my $list=$select->fetchrow_hashref()){
- print "$list->{'username'}\t";
- print "$list->{'password'}\t";
- print "$list->{'number'}\t";
- print "$list->{'year'}\t";
- }
- print "\n";
- #close mysql
- $in->disconnect();
复制代码 |
|