code

String query = "SELECT * FROM ACCOUNTS WHERE USERNAME ="
  + request.getParameter("username")
  + ";";

becomes...

SELECT * FROM ACCOUNTS WHERE USERNAME = ;