package com.example.demo.dao;

import com.example.demo.domain.User;

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 org.springframework.stereotype.Repository;

/**
 * Created by beyondLi on 2017/6/19.
 */
@Mapper // 声明是一个Mapper,与springbootApplication中的@MapperScan二选一写上即可
@Repository
public interface UserMapper {

	@Insert("insert into user(username,age,time) values (#{username},#{age},#{time})")
	public void addUser(User user);

	@Select("select * from user where id = #{id}")
	public User selectUserById(int id);
	@Select("select * from user")
	public List<User> selectUserAll();

	@Update("update user set username=#{userName},age=#{age},time=#{time} where id=#{id}")
	public void updateUser(User user);

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

}