1.編寫接口

package com.zzqsmile.dao;

import com.zzqsmile.pojo.User;
import org.apache.ibatis.annotations.*;

import java.util.List;

public interface UserMapper {
    @Select("select * from mybatis.user")
    List<User> getUsers();

    //方法存在多個參數(shù)脆炎，所有的參數(shù)前必須要加@Param()
    @Select("select * from mybatis.user where id =#{id}")
    User getUserById(@Param("id") int id);

    //增加用戶
    @Insert("insert into mybatis.user (id,name,pwd) values(#{id},#{name},#{pwd})")
    int userAdd(User user);

    //修改用戶
    @Update("update mybatis.user set name = #{name},pwd = #{pwd} where id = #{id}")
    int userUpd(User user);

    //刪除用戶
    @Delete("delete from mybatis.user where id = #{uid}")
    int userDel(@Param("uid")int id);
}

2.綁定接口

    <!--    綁定接口-->
    <mappers>
        <mapper class="com.zzqsmile.dao.UserMapper"></mapper>
    </mappers>

3.編寫測試類

package com.zzqsmile.dao;

import com.zzqsmile.pojo.User;
import com.zzqsmile.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class UserMapperTest {

    @Test
    public void test(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        List<User> users = mapper.getUsers();
        for (User user : users) {
            System.out.println(user);
        }

        sqlSession.close();
    }

    @Test
    public void getUserById(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        User userById = mapper.getUserById(1);

        System.out.println(userById);

    }

    @Test
    public void userAdd(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        int i = mapper.userAdd(new User(6,"張三豐","123321"));

        if (i>0){
            System.out.println("添加成功");
        }
    }

    @Test
    public void userUpd(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        int i = mapper.userUpd(new User(6,"張三豐","999999"));

        if (i>0){
            System.out.println("修改成功");
        }
    }

    @Test
    public void userDel(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        int i = mapper.userDel(5);

        if (i>0){
            System.out.println("刪除成功");
        }
    }

}

@Param()注意點

• 基本類型或String類型要加上
• 引用類型不需要加
• 如果只有1個基本類型可以省略悠砚，但是建議添加