Police officer resigns after accidentally locking himself in back seat while having sex with female suspect.