regarding database transation

Hi friends:

I'd like to use database transaction in one program, that is say, when there is an exception the transation would

be rollback.

what you is your way to do this ? can you please give me an example with more than one db interation including

update , insert , delete?

thank you very much