Named Parameters for PreparedStatementProblems with PreparedStatement syntaxThe problems with PreparedStatement stem from its syntax for parameters. Parameters are anonymous and accessed by index as in the following: PreparedStatement p = con.prepareStatement("select * from people where (first_name = ? or last_name = ?) and address = ?"); p.setString(1, name); p.setString(2, name); p.setString(3, address); For small queries with one o
