Mapper File

Use executeStatement and queryStatement on BaseMapper to run SQL defined in mapper files.

Example mapper file
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//dbvisitor.net//DTD Mapper 1.0//EN"
        "https://www.dbvisitor.net/schema/dbvisitor-mapper.dtd">
<mapper namespace="user">
    <select id="listUsers" resultMap="user_resultMap">
        select * from users
    </select>
</mapper>

Example: run a mapped SQL
// "user" is the namespace
// "listUsers" is the statement id in the mapper file
List<User> users = session.queryStatement("user.listUsers");

For mapper file configuration, see:

Mapper files

Paging

Use the queryStatement and pageStatement overloads on Session and pass a Page argument to paginate.

PageObject page = new PageObject();
page.setPageSize(20);

List<User> users = session.queryStatement("user.listUsers", null, page);

PageObject page = new PageObject();
page.setPageSize(20);

PageResult<User> users = session.pageStatement("user.listUsers", null, page);

PageResult also includes the original page info, total count, and total pages.

Paging​

Paging