<mapper namespace="(mapper方法類位址)">
<select id="loginByEmail" resultType="(實體類位址)">
select * from 資料庫_表名 where email=#{email} and password=#{password};
</select>
<insert id="saveById">
insert into 資料庫_表名(name,password,email) values(#{name},#{password},#{email});
</insert>
</mapper>`