一、传统开发方式
1、编写UserDao接口
package xyz.nchu200462.dao;
import xyz.nchu200462.pojo.User;
import java.io.IOException;
import java.util.List;
public interface UserDao {
List<User> findAll() throws IOException;
}
2、编写UserDaoImpl实现
package xyz.nchu200462.dao.impl;
import com.mysql.jdbc.interceptors.SessionAssociationInterceptor;
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 xyz.nchu200462.dao.UserDao;
import xyz.nchu200462.pojo.User;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class UserDaoImpl implements UserDao {
public List<User> findAll() throws IOException {
InputStream resourceAsStream = Resources.getResourceAsStream("SqlMapConfig.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
List<User> userList = sqlSession.selectList("userMapper.findAll");
sqlSession.close();
for (User user : userList) {
System.out.println(user.toString());
}
return userList;
}
}
3、编写UserMapper.xml
<?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="userMapper">
<select id="findAll" resultType="xyz.nchu200462.pojo.User">
select * from user
</select>
</mapper>
4、编写SqlMapConfig.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>
<properties resource="jdbc.properties"/>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="url" value="${jdbc.url}"/>
<property name="driver" value="${jdbc.driver}"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mapper/UserMapper.xml"/>
</mappers>
</configuration>
5、编写测试方法
import org.junit.Test;
import xyz.nchu200462.dao.impl.UserDaoImpl;
import xyz.nchu200462.pojo.User;
import java.io.IOException;
import java.util.List;
public class UserDaoImplTest {
@Test
public void testFindAll() throws IOException {
UserDaoImpl userDao = new UserDaoImpl();
List<User> userList = userDao.findAll();
for (User user : userList) {
System.out.println(user.toString());
}
}
}
二、代理开发方式
1、介绍
采用 Mybatis 的代理开发方式实现 DAO 层的开发,这种方式是我们后面进入企业的主流。
Mapper 接口开发方法只需要程序员编写Mapper 接口(相当于Dao 接口),由Mybatis 框架根据接口定义创建接口的动态代理对象,代理对象的方法体同上边Dao接口实现类方法。
Mapper 接口开发需要遵循以下规范:
1、 Mapper.xml文件中的namespace与mapper接口的全限定名相同
2、 Mapper接口方法名和Mapper.xml中定义的每个statement的id相同
3、 Mapper接口方法的输入参数类型和mapper.xml中定义的每个sql的parameterType的类型相同
4、 Mapper接口方法的输出参数类型和mapper.xml中定义的每个sql的resultType的类型相同
2、实现
1. 创建UserMapper接口
package xyz.nchu200462.dao;
import xyz.nchu200462.pojo.User;
import java.util.List;
public interface UserMapper {
public List<User> findAll();
public User findById(int id);
}
2. 配置UserMapper到UserMapper.xml中
<mapper namespace="xyz.nchu200462.dao.UserMapper">
<select id="findAll" resultType="user">
select * from user
</select>
<select id="findById" parameterType="int" resultType="user">
select * from user where id=#{id}
</select>
</mapper>
3. 测试
@Test
public void testProxyDao() throws IOException {
InputStream resourceAsStream = Resources.getResourceAsStream("SqlMapConfig.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
List<User> all = userMapper.findAll();
for (User user : all) {
System.out.println(user.toString());
}
System.out.println("----------------------");
User byId = userMapper.findById(3);
System.out.println(byId.toString());
}