springboot的xml文件的表头 作者:沐沐

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.demo1.dao.peiZhi1Mapper">
<resultMap id="peizhiEntityMap" type="com.demo1.Entity.peiZhi1">
<id column="id" property="id"></id>
<result column="project_type" property="projectType"></result>
<result column="time_typ" property="timeTyp"></result>
</resultMap>
<select id="getData" parameterType="com.demo1.Entity.peiZhi1Param" resultMap="peizhiEntityMap">
select id,energy,`project_type`,`sjlx`,energys,threshold from peizhi1 where 1=1
<if test="id!=null">
AND id like concat ('%',#{id},'%')
</if>
<!-- <if test="energy!=null and energy !='' ">-->
<!-- AND energy like concat ('%',#{energy},'%')-->
<!-- </if>-->
</select>