In this chapter, we learned how to write SQL mapped statements using the Mapper XML files. We discussed how to configure simple statements, statements with one-to-one and one-to-many relationships, and how to map the results using
ResultMap. We also looked into building dynamic queries, paginated results, and custom ResultSet handling. In the next chapter, we will discuss how to write mapped statements using annotations.