<?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="dao.IUserDao">
<!--配置查询-->
<select id="findAll" resultType="domain.User">
select * from vincenttest.user
</select>
<insert id="saveUser" parameterType="domain.User">
insert into user(username,password)values(#{username},#{password})
<selectKey keyProperty="id" keyColumn="id" resultType="java.lang.Integer" order="AFTER">
select last_insert_id();
</selectKey>
</insert>
<update id="updateUser" parameterType="domain.User">
update user set username=#{username},password=#{password} where id=#{id}
</update>
<select id="findMaxId" resultType="java.lang.Integer" >
select MAX(id) id from user
</select>
<delete id="delUser" parameterType="java.lang.Integer">
delete from user where id=#{id};
</delete>
<select id="findUserrById" parameterType="int" resultType="domain.User">
select * from user where id = #{id}
</select>
<select id="findUserByName" resultType="domain.User" parameterType="String">
select * from user where username like #{nae}
</select>
<select id="countAllUser" resultType="int">
select count(id) from user;
</select>
<select id="userVo" parameterType="domain.UserVo" resultType="domain.User">
select * from user where username like #{user.username}
</select>
</mapper>