在application中配置:
接下来就可以直接在resource下的mapper中创建xml使用文件形式写sql
<?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.it.mapper.StaffMapper">
<select id="findByAccount" resultType="com.it.pojo.Staff" parameterType="string">
select * from staff where staffAccount = #{account}
</select>
</mapper>