/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);

}