package com.sf.boot.dao;

import com.sf.boot.entity.userTest;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by mj on 2017/7/17.
 */

@Mapper
public interface UserMapper {
    @Select("select * from springboot")
    List<userTest> query();
    
    @Select("select count(*) from springboot where user=#{user} and password=#{password}")
    int usernameAndpassword(@Param("user")String user,@Param("password")String password);
    
    @Insert("insert into springboot (userid,user,password) values(#{userid},#{user},#{password})")
    int register(@Param("userid")String userid,@Param("user")String user,@Param("password")String password);
    
    /**
     *  下面没啥用  整合的时候 测试使用的
     */
/*   
 *  @Select("SELECT * FROM user WHERE name = #{name}")
    User findByName(@Param("name") String name);
    @Insert("INSERT INTO user(name, age) VALUES(#{name}, #{age})")
    int insert(@Param("name") String name, @Param("age") Integer age);
    @Update("UPDATE user SET age=#{age} WHERE name=#{name}")
    void update(User user);
    @Delete("DELETE FROM user WHERE id =#{id}")
    void delete(Long id);
    */
}