Example tutorial of sql mapping file

Sql Mapping File

MyBatis The real power is in the mapping statement. Comparing the price with jdbc with equivalent functions, mapping files save a lot of code. MyBatis is built to focus on SQL.

The sql mapping file has the following top-level elements: (in order)

cache configures the cache for a given namespace.

cache-ref references cache configuration from other namespaces.

resultMap The most complex and powerful element, used to describe how to load your objects from the database result set.

parameterMap has been deprecated! Old-school style parameter mapping. Inline parameters are preferred, this element may be removed in the future.

SQL block can be reused and can also be referenced by other statements.

insert mapping insert statement.

update mapping update statement.

delete mapping delete statement.

select mapping query statement.

MyBatis is built to focus on SQL, keeping it away from ordinary methods.

SQL mapping files have a few top-level elements (in the order they should be defined):

>mapper: The root element node of the mapping file, with only one attribute The namespace namespace is used to distinguish different mappers. It is globally unique and the full name of the DAO interface bound to the namespace, that is, interface-oriented programming. The mapper here is equivalent to the implementation class of the interface.

cache - Configure the cache for the given namespace.

cache-ref – Reference cache configuration from other namespaces.

resultMap – The most complex and powerful element, used to describe how to load your objects from the database result set.

parameterMap – has been deprecated! Old-school style parameter mapping. Inline parameters are preferred, this element may be removed in the future. It will not be recorded here.

sql – SQL block that can be reused and referenced by other statements.

insert – Mapping insert statement

update – Mapping update statement

delete – Mapping delete statement

select – Mapping query statement

1: Use select to complete conditional query

Use tool idea and mysql database

Create entity class

public class student {private int stuId;private String  stuName;private grade getGrade;private  int stuAge;public grade getGetGrade() {return getGrade;
    }public void setGetGrade(grade getGrade) {this.getGrade = getGrade;
    }public int getStuAge() {return stuAge;
    }   public student(int id,String name){

   }   public student(){}public void setStuAge(int stuAge) {this.stuAge = stuAge;
    }public int getStuId() {return stuId;
    }public void setStuId(int stuId) {this.stuId = stuId;
    }public String getStuName() {return stuName;
    }public void setStuName(String stuName) {this.stuName = stuName;
    }
}

Use select Complete conditional query

1: First configure mapper to use resultType

<!--模糊查询   使用resultType返回结果集-->    
    <select id="getAllStudentByLike" parameterType="String" resultType="stu">* from student where stuName like CONCAT('%',#{stuName},'%'</select>

Test class

 public  void Test() throws IOException {

        studentDao dao = MyBatis.getSessionTwo().getMapper(studentDao.class);
        List<student> list = dao.getAllStudentByLike("z");for (student item:list) {
            System.out.println("----------"+item.getStuName());
        }
}

In addition, in addition to javaBean, the complex types supported by parameterType also include the Map type

That is, modify the Mapper

 <!--模糊查询-->
    <select id="getAllStudentByLike" parameterType="Map" resultType="stu">select * from student where stuName like CONCAT('%',#{stuName},'%')</select>

and then create one in the test class The HashMap collection can be used directly as a method parameter

studentDao dao = MyBatis.getSessionTwo().getMapper(studentDao.class);
        Map<String,String> userMap = new HashMap<String, String>();
        userMap.put("stuName","z");
        List<student> list = dao.getAllStudentByLike(userMap);for (student item:list) {
            System.out.println("----------"+item.getStuName());
        }

But the key value of the map collection must be the same as the field name in the class.

2: Use resultMap to complete two-table query

For example, if the primary key id of the student table is associated with the class table, if you use resultType, you can only display its id, but in practice, you often focus on Class name, all need to use resultMap to map custom results.

<resultMap id="studentMap" type="entity.student">
<id property="stuId" column="stuId"></id>
        <result property="stuName" column="stuName"></result>
        <result property="gradeName" column="gradeName">
       
    </resultMap>

//sql语句

select * from student,grade

resultType directly represents the return type, including basic types and complex data types

resultMap is a reference to the external resultMap, and the id corresponding to the resultMap indicates that the return result is mapped to Which resultMap. : His application scenarios are: database field information is inconsistent with object attributes or complex joint queries need to be done to freely control the mapping results.

In addition, in the select element of MyBatis, resultType and resultMap are essentially the same, both are Map data structures. But both cannot exist at the same time.

Three: Use the automatic mapping level of resultMap

MyBatis is divided into three mapping levels

>NONE: Automatic matching is prohibited

>PARTIAL :(Default): Automatically match all attributes except those with internal nesting (association, collection)

>FULL: Automatically match all

Set autoMappingBehavior in the large configuration

 <settings>   <!--设置resultMap的自动映射级别为Full（自动匹配所有）--><setting name="autoMappingBehavior" value="FULL" />   <!--FULL要大写··--> </settings>

When setting the value of autoMappingBehavior to FULL, there is no need to configure the nodes under resultMap. It will automatically match according to the database

Four: Use update to complete the modification

 <update id="update">update student set stuName=#{0} where stuId=#{1}</update>

Here we use a relatively simple placeholder as a parameter. Just fill in the parameters directly in the test class

5: Use the attribute association that maps complex types

The previous result can only be mapped to a certain "simple type" attribute of javaBean, basic data type and packaging class, etc./

But when you want to map properties of complex types, you need to use association. Complex classes: that is, there is another javaBean in a javaBean, but association only handles one-to-one relationships.

        stuAge;

   。。。。。省略封装

 <resultMap id="studentMap" type="entity.student">
       <!-- <id property="stuId" column="stuId"></id>
        <result property="stuName" column="stuName"></result>-->
        <!--关联另一个 属性-->
        <association property="getGrade" javaType="grade">
       <!-- <id property="gradeId" javaType="Integer" column="gradeId"></id>
       <result property="gradeName" javaType="String" column="gradeName"></result>-->
        </association>
    </resultMap>
    <!--这里使用了自动匹配-->

<select id="getAllStudent" resultMap="studentMap"> SELECT * FROM student,grade WHERE student.stuGrade=grade.gradeId</select>

测试类里直接调用即可

六：前面说到association仅处理一对一的管理关系

    如果要处理一对多的关系，则需要使用collection，它与 association元素差不多，但它映射的属性是一个集合列表，即javaBean内部嵌套一个复杂数据类型属性。

javaBean

  private int gradeId;private String gradeName;private List<student> gatStudent;

 <resultMap id="gradeMap" type="grade">
        <!--<id property="gradeId" column="gradeId"></id>
        <result property="gradeName" column="gradeName"></result>-->
        <collection property="gatStudent" ofType="stu">
             <!-- <id property="stuId" column="stuId"></id>
              <result property="stuName" column="stuName"></result>-->
        </collection>
    </resultMap>

 <!--查询对应年级的student-->
    <select id="getAll" resultMap="gradeMap">   select * from student,grade where stuGrade = gradeId and gradeId=1
    </select>

The above is the detailed content of Example tutorial of sql mapping file. For more information, please follow other related articles on the PHP Chinese website!