package it. ytu. dao ;
import java. util. List ;
import org. apache. ibatis. annotations. Param ;
import org. apache. ibatis. annotations. Select ;
import it. ytu. pojo. User ;
public interface UserMapper {
@Select ( "select *from user" )
List < User > getUsers ( ) ;
@Select ( "select *from user where id=#{id}" )
User getUserById ( @Param ( "id" ) int id) ;
}
<?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>
< properties resource = " db.properties" > </ properties>
< settings>
< setting name = " logImpl" value = " STDOUT_LOGGING" />
</ settings>
< typeAliases>
< package name = " it.ytu.pojo" />
</ 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 = " it.ytu.dao.UserMapper" />
</ mappers>
</ configuration>
package it. ytu. dao ;
import java. util. List ;
import org. apache. ibatis. session. SqlSession ;
import org. junit. Test ;
import it. ytu. pojo. User ;
import it. ytu. utils. MybatisUtils ;
public class UserMapperTest {
@Test
public void test ( ) {
SqlSession sqlSession= MybatisUtils . getSqlSession ( ) ;
UserMapper userMapper= sqlSession. getMapper ( UserMapper . class ) ;
List < User > users= userMapper. getUsers ( ) ;
for ( User user : users) {
System . out. println ( user) ;
}
sqlSession. close ( ) ;
}
@Test
public void test2 ( ) {
SqlSession sqlSession= MybatisUtils . getSqlSession ( ) ;
UserMapper userMapper= sqlSession. getMapper ( UserMapper . class ) ;
User user= userMapper. getUserById ( 1 ) ;
System . out. println ( user) ;
sqlSession. close ( ) ;
}
}