Mybatis Construction Resultmap Search SQL

Mapping configuration Files

<!--type: The unique identifier of the entity class for the mapped data type Id:resultmap-<resultmap type= "person" id= "Baseresultmap" >  <!-- Column: Field name of Library Table property: attribute name in entity class---  <id column= "person_id" property= "PersonId"/>  <result column = "name" property= "name"/>  <result column= "gender" property= "gender"/> <result  column= "Person_ Addr "property=" personaddr "/>  <result column=" Birthday "property=" Birthday "/> </resultMap>

Mapping Configuration Query statements

<!--when querying a collection Resultmap refers to generics in the collection--<select id= "Selectpersonall" resultmap= "Baseresultmap" >  SELECT * From person  </select>

Map Management Library Table files

<!--centrally manage map files for library tables--<mappers>  <mapper resource= "Com/hao947/sql/mapper/personmapper.xml"/> </mappers>

Test file

<!--when querying a collection resultmap refers to the generic in the collection--//query all @Test public void Selectpersonall () {  //create a sqlsession  sqlsession session = Sqlsessionfactory.opensession ();  try {   List<person> List = Session     . SelectList ("Com.hao947.sql.mapper.PersonMapper.selectPersonAll");   for (person p:list) {    System.out.println (p);}}  finally {   session.close ()  }}

Copyright notice: This article Bo Master original article. Blog, not reproduced without consent.

Mybatis Construction Resultmap Search SQL