1、接口
package com.wt.dao; import com.wt.pojo.User; import org.apache.ibatis.annotations.Select; import java.util.List; public interface UserMapper { @Select("select * from user") List<User> getUserList(); }
2、xml 配置文件
<mappers> <mapper class="com.wt.dao.UserMapper"/> </mappers>
3、测试使用
package com.wt.dao; import com.wt.pojo.User; import com.wt.utils.MyBatisUtil; import org.apache.ibatis.session.SqlSession; import org.junit.Test; import java.util.List; public class UserMapperTest { @Test public void getUserList(){ SqlSession sqlSession = MyBatisUtil.getSession(); UserMapper userMapper = sqlSession.getMapper(UserMapper.class); List<User> userList = userMapper.getUserList(); for (User user : userList) { System.out.println(user); } sqlSession.close(); } }
局限性
注解不是适用于复杂的sql语句(官网原话),没有resultMap 数据库字段名和javaBean的字段名不同
原文:https://www.cnblogs.com/wt7018/p/13332790.html