Database locking in a multithreaded application prevents data corruption by ensuring that only one thread can modify a particular piece of data at a time. The main types of locks are shared locks, which allow multiple threads to read data, and exclusive locks, which allow only one thread to write data.