mybatis有没有annotation的动态SQL语句？

软件工程师和算法工程师速来！正在直播：如何使用英特尔oneAPI工具实现PyTorch 优化>>>

最近做系统需要用到mybatis
由于过去用了太多的xml配置框架，这次想摒弃以前那些配置太多的缺点，使用annotation的方法。
使用mybatisGenerator的工具，生成annotation的mapper
参见代码

@Insert({
        "insert into contactinfo (idcontactinfo, contact_idcontact, ",
        "firstname, secondname, ",
        "address, state, ",
        "country, city, email, ",
        "telephone, mobile)",
        "values (#{idcontactinfo,jdbcType=INTEGER}, #{contactIdcontact,jdbcType=INTEGER}, ",
        "#{firstname,jdbcType=VARCHAR}, #{secondname,jdbcType=VARCHAR}, ",
        "#{address,jdbcType=VARCHAR}, #{state,jdbcType=VARCHAR}, ",
        "#{country,jdbcType=VARCHAR}, #{city,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, ",
        "#{telephone,jdbcType=VARCHAR}, #{mobile,jdbcType=VARCHAR})"
    })
    int insert(ContactInfo record);

<select id="findActiveBlogLike"
     resultType="Blog">
  SELECT * FROM BLOG WHERE state = ‘ACTIVE’
  <if test="title != null">
    AND title like #{title}
  </if>
  <if test="author != null and author.name != null">
    AND author_name like #{author.name}
  </if>
</select>

ContactExample example = new ContactExample();
		ContactExample.Criteria cri = example.createCriteria();
		System.out.println(contact.getUsername() + ":" + contact.getPassword());

		if (null != contact.getUsername() || !"".equals(contact.getUsername())) {
			cri.andUsernameLike(contact.getUsername() + "%");
		}
		if (null != contact.getPassword() || !"".equals(contact.getPassword())) {
			cri.andPasswordEqualTo(contact.getPassword());
		}
		ContactMapper vcontactMapper = sqlSession
				.getMapper(ContactMapper.class);
		List<Contact> returnList = vcontactMapper.selectByExample(example);
		return returnList;