package com.test.demo.dao;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.test.demo.entity.UserEntity;

@Mapper
public interface UserDao {
	
	
	@Select("SELECT * FROM user WHERE id=#{id}")
	UserEntity userFindById(int id);
	
	
	@Select("select * from user where userName = #{userName}")
    public List<UserEntity> selectUserByName(String userName);

    @Insert("insert into user(userName,userAge,userAddress) values (#{userName},#{userAge},#{userAddress})")
    public void addUser(UserEntity user);

    @Update("update user set userName=#{userName},userAge=#{userAge},userAddress=#{userAddress} where id=#{id}")
    public void updateUser(UserEntity user);

    @Delete("delete from user where id=#{id}")
    public void deleteUser(int id);


}