学习目标:
MyBatis的注解开发
学习内容:
MyBatis使用注解开发
学习时间:
学习产出:
MyBatis使用注解开发
UserMapper
package com.mybatis.mapper;
import com.mybatis.pojo.User;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import java.util.List;
public interface UserMapper {
//Limit分页
@Select("select * from user limit 0,5")
@Results(id = "getUserList",
value = {//前两个可以省略
@Result(column = "id", property = "id"),
@Result(column = "name", property = "name"),
@Result(column = "pwd", property = "password")})
List<User> getUserList();
}
XML
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<!--configuration核心配置文件-->
<configuration>
<!--引入外部配置文件-->
<properties resource="db.properties">
<property name="username" value="root"/>
<property name="password" value="tmj20000509"/>
</properties>
<settings>
<setting name="logImpl" value="LOG4J"/>
</settings>
<typeAliases>
<typeAlias type="com.mybatis.pojo.User" alias="User"/>
</typeAliases>
<!--修改默认环境即可更换环境-->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<!--需要绑定到相应的类-->
<mappers>
<mapper class="com.mybatis.mapper.UserMapper"/>
</mappers>
</configuration>
Test
package com.mybatis.mapper;
import com.mybatis.pojo.User;
import com.mybatis.util.MyBatisUtil;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.List;
/**
* @ClassName UserMapperTest
* @Author $童一
* @Description $
* @Param $
* @return $
* @Date $ $
**/
public class UserMapperTest {
@Test
//使用注解
public void TestAutoWire(){
SqlSession sqlSession = MyBatisUtil.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List<User> userList = mapper.getUserList();
for (User user : userList) {
System.out.println(user);
}
}
}