I am trying to convert this:
"SELECT username,level,email FROM `employees` WHERE `username` = '" +
username + "' AND `password` = PASSWORD('" + password + "') LIMIT 1"
into
JOOQSQL.getInstance().create().select(DSL.fieldByName("username"),
DSL.fieldByName("level"),
DSL.fieldByName("email")).from(DSL.tableByName("employees")).where(DSL.fieldByName("username").equal(username)).and(DSL.fieldByName("password").equal(password)).limit(1).fetchOne();
However the password is not encrypted with mysql function
when i google i found information about using MySQLFactory.password but
that wasnt an option in the 3.1 api
anyone have and clue how to fix this probleM?
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
