Is the select with named parameter query correct?

Is the select with named parameter query correct?

References

Reference NO 1

http://stackoverflow.com/questions/15198811/is-the-select-with-named-parameter-query-correct

Reference NO 2

http://docs.oracle.com/javaee/6/tutorial/doc/bnbrg.html

Reference NO 3

http://docs.doctrine-project.org/projects/doctrine1/en/latest/en/manual/dql-doctrine-query-language.html

Reference NO 4

http://docs.jboss.org/hibernate/orm/3.3/reference/en-US/html/queryhql.html

Reference NO 5

http://en.wikibooks.org/wiki/Java_Persistence/Querying

Reference NO 6

http://www.objectdb.com/java/jpa/query/parameter

Reference NO 7

http://forum.springsource.org/showthread.php?77861-not-work-simple-sql-SELECT-query-with-using-named-parameters-on-MySql

Reference NO 8

http://www.jooq.org/doc/3.0/manual/sql-building/bind-values/named-parameters/