sql2o is a small library, which makes it easy to convert the result of your sql-statements into objects. No resultset hacking required. Kind of like an orm, but without the sql-generation capabilities. Supports named parameters.
Support for @Transaction or @Rollback is not implemented in sql2o. If you want to roll back from a JUnit test, you need to do it manually in your code.
I try with @Transaction and @Rollback,but none of them is work.