generating password for all users in the database

I Have a table with almost 500 users user id) and i want to generate a password for each user.
Is it possible to do this on a button click event??
Also is it possible to make the password in a particular format? (ex; I want the password as userid#123) 
...