package com.mapper;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import com.po.User;
public interface UserMapper {
@Insert("insert into t_user (name,sex,age) values(#{name},#{sex},#{age})")
@Options(useGeneratedKeys=true,keyProperty="id")
int addUser(User user);
@Select("select * from t_user where id=#{id}")
User getUserById(Integer id);
@Delete("delete from t_user where id=#{id}")
int deleteUser(@Param("id") Integer id);
@Update("update t_user set name=#{name},sex=#{sex},age=#{age} where id=#{id}")
void updateUser(User user);
}