VIP23/04maven/mybatis/src/main/java/com/sf/mapper/UserMapper2.java

package com.sf.mapper;

import com.sf.entity.User;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

public interface UserMapper2 {
    /**
     * 添加用户
     * @param user
     */
    @Insert("insert into user (user_id,user_name,create_time) values (#{userId},#{userName},#{createTime})")
    void   addUser(User user);

    /**
     * 更新用户
     */
    @Update("update user set user_name=#{userName},create_time=#{createTime} where user_id = #{userId}")
    void  updateUser(User user);

    /**
     * 删除用户根据userId
     */
    @Delete("")
    void deleteUser(Integer userId);

    /**
     * 查询用户的列表
     */
    List<User> getUserList();

    /**
     * 根据用户的id查询的详情
     */

    User getUserInfo(Integer userId);
}