勿以浮沙筑高台
左上角Seetings,输入Template,找到File and Code Templates,配置模板
File | Settings | Editor | File and Code Templates
__
<?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的命名空间-->
<!--在mapper配置文件对应的inster,delete,select,元素里基本都是TSQL语句-->
<mapper namespace="test">
<!--映射resultMap-->
<resultMap id="UserMap" type="org.example.mvc.model.User">
<result property="name" column="name"></result>
<result property="age" column="age"></result>
</resultMap>
<!--resulttype=查询后的结果-->
<select id="selecteUserByName" parameterType="java.lang.String"
resultMap="UserMap">
select name,age from user where name = #{name}
</select>
</mapper>