2016 年 3月 1 日随笔档案 - huey2672

2016年3月1日

MyBatis(3.2.3) - Custom ResultSet processing using ResultSetHandler

摘要： MyBatis provides great support with plenty of options for mapping the query results to JavaBeans. But sometimes, we may come across scenarios where we 阅读全文

posted @ 2016-03-01 17:52 huey2672 阅读(2480) 评论(0) 推荐(0)

MyBatis(3.2.3) - Paginated ResultSets using RowBounds

摘要： Sometimes, we may need to work with huge volumes of data, such as with tables with millions of records. Loading all these records may not be possible 阅读全文

posted @ 2016-03-01 17:10 huey2672 阅读(647) 评论(0) 推荐(0)

MyBatis(3.2.3) - Multiple results as a map

摘要： If we have a mapped statement that returns multiple rows and we want the results in a HashMap with some property value as the key and the resulting ob 阅读全文

posted @ 2016-03-01 17:05 huey2672 阅读(517) 评论(0) 推荐(0)

MyBatis(3.2.3) - Passing multiple input parameters

摘要： MyBatis's mapped statements have the parameterType attribute to specify the type of input parameter. If we want to pass multiple input parameters to a 阅读全文

posted @ 2016-03-01 17:00 huey2672 阅读(587) 评论(0) 推荐(0)

MyBatis(3.2.3) - Handling the CLOB/BLOB types

摘要： MyBatis provides built-in support for mapping CLOB/BLOB type columns. Assume we have the following table to store the Students and Tutors photographs 阅读全文

posted @ 2016-03-01 16:45 huey2672 阅读(1250) 评论(0) 推荐(0)

MyBatis(3.2.3) - Handling enumeration types

摘要： MyBatis supports persisting enum type properties out of the box. Assume that the STUDENTS table has a column gender of the type varchar to store eithe 阅读全文

posted @ 2016-03-01 16:33 huey2672 阅读(392) 评论(0) 推荐(0)

MyBatis(3.2.3) - Dynamic SQL

摘要： Sometimes, static SQL queries may not be sufficient for application requirements. We may have to build queries dynamically, based on some criteria.For 阅读全文

posted @ 2016-03-01 16:05 huey2672 阅读(1442) 评论(0) 推荐(0)

MyBatis(3.2.3) - One-to-many mapping

摘要： In the sample domain model, a tutor can teach one or more courses. This means that there is a one-to-many relationship between the tutor and course. W 阅读全文

posted @ 2016-03-01 14:30 huey2672 阅读(1589) 评论(0) 推荐(1)

MyBatis(3.2.3) - One-to-one mapping using nested Select

摘要： We can get Student along with the Address details using a nested Select query as follows: <resultMap type="Address" id="AddressResult"> <id property=" 阅读全文

posted @ 2016-03-01 14:13 huey2672 阅读(382) 评论(0) 推荐(0)

MyBatis(3.2.3) - One-to-one mapping using nested ResultMap

摘要： We can get Student along with the Address details using a nested ResultMap as follows: <resultMap type="Address" id="AddressResult"> <id property="add 阅读全文

posted @ 2016-03-01 11:51 huey2672 阅读(952) 评论(0) 推荐(0)

MyBatis(3.2.3) - ResultMaps: Extending ResultMaps

摘要： ResultMaps are used to map the SQL SELECT statement's results to JavaBeans properties. We can define ResultMaps and reference this resultMap query fro 阅读全文

posted @ 2016-03-01 11:07 huey2672 阅读(325) 评论(0) 推荐(0)

MyBatis(3.2.3) - Mapped statements: The INSERT statement, Autogenerated keys

摘要： We can use the useGeneratedKeys and keyProperty attributes to let the database generate the auto_increment column value and set that generated value i 阅读全文

posted @ 2016-03-01 10:19 huey2672 阅读(361) 评论(0) 推荐(0)