Wat would be the best way..?

How many way are there to do it? If you can name all the ways, I'll pick the best one

but using DBI'S prepare() ,execute can we do the above operations at once?

What does "at once" mean to you?

If yes how? ..plz answer!

See DBI its full of examples; See also Tutorials->Database Programming->DBI recipes, its like stuff from the DBI docs (the examples)