MyBatis series two database column name inconsistent with field names in program entity classes

MyBatis Series two database column name inconsistent with field names in program entity classes

Scenario: When a column name in a database does not match the name of a field in our program entity class

Using RESULTMAP node configuration information

Configure Resultmap node information in the mapping file under the Mapper root node

<type= "Student"  ID= "Studentmapper">         <column= "sname"  Property= "Stuname"/>
</ Resultmap >

Parse: Type is the full class name of the entity class in the program (I used the alias configuration in this case to use student directly)

The ID is our custom name for use below

The result child node is a non-primary key field column named property in the database is the field name of the entity class in the program

Replace Resulttype with Resultmap on the queried node and Resulttype and Resultmap cannot coexist

<!-- Find all students    -    <  ID= "GetAll"  resultmap= "Studentmapper">         SELECT * from Student    </Select>

MyBatis series two database column name inconsistent with field names in program entity classes