That's not as easy to fix as it is a SMD device. However the board itself could still be used. You can program it through the 6-pin ISP header using something like the USBtinyISP device (around $20). Once you have one of those you can use it to program multiple devices so it is worth owning. Or if you have a second Arduino you can use Arduino as ISP to have it program the first one.