EmpMapper.xml

<?xml version="1.0" encoding="UTF-8" ?> 
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"     
 " http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="cn.tedu.cloudnote.dao.UserDao">
 <select id="findUserByName" resultType="cn.tedu.cloudnote.entity.User" parameterType="String">
  select
   cn_user_id as id,
   cn_user_name as name,
   cn_user_password as password,
   cn_user_token as token,
   cn_user_nick as nick
  from cn_user
  where cn_user_name=#{name}
 </select>
 <!--  -->
 <insert id="addUser" parameterType="cn.tedu.cloudnote.entity.User">
  insert into cn_user(
     cn_user_id,
     cn_user_name,
     cn_user_password,
     cn_user_token,
     cn_user_nick
  )values(
   #{id},#{name},#{password},#{token},#{nick}
  )
 </insert>
</mapper>