mapper.java_MyBatis实践之DAO与Mapper

MyBatis简介

MyBatis前身是iBatis,是一个基于Java的数据持久层/对象关系映射(ORM)框架.

MyBatis是对JDBC的封装,使开发人员只需关注SQL本身,而不需花费过多的精力去处理如注册驱动、设置参数、创建Connection/Statement、解析结果集等JDBC过程性代码.MyBatis基于XML/注解的方式配置Statement,执行SQL,并将执行结果映射成Java对象, 大大降低了数据库开发的难度.

MyBatis is a first class persistence framework with support for custom SQL, stored procedures and advanced mappings. MyBatis eliminates almost all of the JDBC code and manual setting of parameters and retrieval of results. MyBatis can use simple XML or Annotations for configuration and map primitives, Map interfaces and Java POJOs (Plain Old Java Objects) to database records.

– MyBatis项目地址/在线文档.

初识MyBatis

使用MyBatis需要在pom.xml中添加如下依赖:

org.mybatis

mybatis

3.3.0

mysql

mysql-connector-java

5.1.36

Select

配置mybatis/mybatis-configuration.xml

作为MyBatis的全局配置文件,其配置了MyBatis的运行环境信息(如数据源/mapper文件等).

书写UserDAO(mapper映射)

最为MyBatis最核心的部分,配置了操作数据库的SQL语句:

SELECT * FROM user WHERE id = #{id};

SELECT * FROM user WHERE name LIKE '%${value}%';

属性 描述

namespace 命名空间,用于隔离SQL语句

parameterType 定义SQL输入映射类型,MyBatis通过OGNL从输入对象中获取参数传入SQL语句.

resultType 定义SQL输出映射类型,MyBatis将SQL查询结果的一行记录映射为resultType指定的类型.

mapper映射文件名有UserDAO.xml/UserMapper.xml/User.xml等几种形式, 其一般存放在与mybatis-configuration.xml同级的mapper目录下,由于其主要作用为定义SQL语句与映射关系, 因此一般统称为mapper映射文件.

定义PO类

PO类主要作用为SQL(输入/输出)映射,通常与数据库表对应:

/**

* @author jifang

* @since 15/12/31 下午2:27.

*/

public class User {

private Integer id;

private String name;

private String password;

public User() {

}

public User(Integer id, String name, String password) {

this.id = id;

this.name = name;

this.password = password;

}

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

@Override

public String toString() {

return "User{" +

"id=" + id +

", name='" + name + '\'' +

", password='" + password + '\'' +

'}';

}

}

UserDAO(Java对象)

获得SqlSession,执行SQL语句, 得到映射结果:

/**

* @author jifang

* @since 16/2/24 下午6:15.

*/

public class UserDAO {

private SqlSessionFactory factory;

@Before

public void setUp() throws IOException {

String resource = "mybatis/mybatis-configuration.xml";

factory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream(resource));

}

@Test

public void selectUserById() {

try (SqlSession session = fact