Configure resultMap in Mybatis to query all SQL statements.

Ing configuration file

<! -- Type: id of the Data type of the ing object class: Unique Identifier of resultMap --> <resultMap type = "person" id = "BaseResultMap"> <! -- Column: Field Name property of the database table: property name in the object 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>

Ing configuration query statement

<! -- When querying a set, resultMap refers to the generic type in the set --> <select id = "selectPersonAll" resultMap = "BaseResultMap"> select * from person </select>

Ing Management Library and table files

<! -- Centrally manage the ing files of database tables --> <mappers> <mapper resource = "com/hao947/SQL/mapper/PersonMapper. xml"/> </mappers>

Test File

// <! -- When querying a set, resultMap refers to the generic type in the set --> // 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 ();}}