13_ Output Mapping 1_resulttype

There are two main types of output mappings: Resulttype and Resultmap

"Resulttype"

There are three types of return

Pojo object: For example, select * from user where id=?

Pojo Object list: For example, select * from user

Normal type: For example select COUNT (*) from user

Minor problem:

Using Resulttype for the output mapping, only the queried column name and the Pojo attribute name match, the column can be successfully loaded!

For example, the data table is like this:

Usermapper.xml configuration file (one "sex" column less than the data table)

Debug look at the results of the query, you can see, in addition to sex=null, other conditions are normal query.

Now modify the query criteria in the usermapper.xml, such as the query alias

There will be some errors in the query

13_ Output Mapping 1_resulttype