/p>
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
SELECT
* FROM USER WHERE id =#{id}
SELECT
LAST_INSERT_ID()
INSERT INTO USER
(username,birthday,sex,address)
VALUES(#{username},#{birthday},#{sex},#{address})
AND username LIKE '%${user.username}%'
AND sex = #{user.sex}
AND id IN
separator=",">
#{id}
resultType="user">
SELECT * FROM user
resultType="int">
SELECT count(*) FROM user
Select id id_,username username_,sex sex_ from user where id = #{id}
public interface UserMapper {
// 1、 根据用户ID查询用户信息
public User findUserById(int id) throws Exception;
// 3、 添加用户
public void insertUser(User user) throws Exception;
//综合查询
public List findUserList(UserQueryVO vo);
//综合查询用户总数
public int findUserCount(UserQueryVO vo);
//resultMap入门
public User findUserRstMap(int id);
}