<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.atchina.dao.IUserDao">
<select id="findByName" parameterType="String" resultType="com.atchina.domain.User">
select * from user where username like #{uname}
</select>
</mapper>
import com.atchina.dao.IUserDao;
import com.atchina.domain.User;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import java.io.InputStream;
import java.util.Date;
import java.util.List;
public class MybatisTest {
InputStream in = null;
SqlSessionFactory sessionFactory = null;
SqlSession sqlSession = null;
IUserDao userDao = null;
@Before
public void init() throws Exception{
in = Resources.getResourceAsStream("SqlMapperConfig.xml");
sessionFactory = new SqlSessionFactoryBuilder().build(in);
sqlSession = sessionFactory.openSession();
userDao = sqlSession.getMapper(IUserDao.class);
}
@Test
public void testFindByName(){
List<User> users = userDao.findByName("%天%"); // 模糊查询,要加上%
for (User u : users){
System.out.println(u);
}
}
@After
public void destroy() throws Exception{
// 提交
sqlSession.commit();
// 释放资源
sqlSession.close();
in.close();
}
}