Mybatis基础_Dao层接口和对应Mapper.xml的关系

模拟原生Dao层开发

(1) DAO接口类UserMapper.java　　

package com.lic.ibatis.dao;

import com.lic.ibatis.entity.User;

public interface UserMapper {
    
  //根据用户ID获取用户信息
  User getUserById(int id);
}

(2) Dao实现类UserMapperImpl.java　

package com.lic.ibatis.dao;

import com.lic.ibatis.entity.User;

import java.sql.*;
import java.util.Date;

public class UserMapperImpl implements UserMapper {
  @Override
  public User getUserById(int id) {
    Connection connection=null;
    PreparedStatement preparedStatement=null;
    ResultSet resultSet=null;
    try {
      //注册驱动
      Class.forName("com.mysql.jdbc.Driver");
      //获取数据连接
      connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/mybatis" , "root" , "m123" ) ;
      //sql语句
      String sql= "select * from user where id = ?";
      //加载预执行对象
      preparedStatement = connection.prepareStatement(sql);
      //添加参数
      preparedStatement.setInt(1,id);
      //执行查询, 获取结果集
      resultSet = preparedStatement.executeQuery();
      User user=null;
      //解析结果集,封装结果
      while(resultSet.next()){
        int userId = resultSet.getInt("id");
        String username = resultSet.getString("username") ;
        Date birthday = resultSet.getDate("birthday");
        String sex = resultSet.getString("sex");
        String address = resultSet.getString("address");
        user = new User(String.valueOf(userId), username, String.valueOf(birthday), sex, address);
      }
      return user;
    } catch (Exception e) {
      e.printStackTrace();
    }finally {
      //关闭相关资源
      try {
        if (resultSet !=null){
            resultSet.close();
        }
        if (preparedStatement !=null){
          preparedStatement.close();
        }
        if (connection !=null){
          connection.close();
        }

      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
    return null;
  }
}

(3) Service层接口及实现类

//service接口
package com.lic.ibatis.service;

import com.lic.ibatis.entity.User;

public interface UserService {
  User query(int id);
}

//service实现类
package com.lic.ibatis.service;

import com.lic.ibatis.dao.UserMapper;
import com.lic.ibatis.dao.UserMapperImpl;
import com.lic.ibatis.entity.User;

public class UserServiceImpl implements UserService{

  UserMapper userMapper=new UserMapperImpl();

  @Override
  public User query(int id) {
    return userMapper.getUserById(id);
  }
}

(4) 测试类

package com.lic.ibatis.test;

import com.lic.ibatis.entity.User;
import com.lic.ibatis.service.UserServiceImpl;

public class MybatisTest {
  public static void main(String[] args) {
    UserServiceImpl userService = new UserServiceImpl();
    User user = userService.query(1);
    System.out.println(user.toString());
  }
}

控制台输出:

User{id='1', username='王五', birthday='2014-07-10', sex='2', address='河南郑州'}

 

分析:

我们在Service层调用Dao层接口中的getUserById()方法, 通过该接口的实现类去数据库中查询, 并封装结果然后返回; 而mybatis也做了类似的事情, 我们只需要编写Dao层的UserMaper.java接口和UserMapper.xml; mybatis会根据UserMapper.xml中配置的信息创建一个实现了UserMaper.java接口的代理类(使用JDK动态代理);

因此在配置UserMapper.xml时会要求:

1. 在UserMapper.xml中namespace等于UserMapper.java接口地址(即UserMapper的全限定名)；
2. UserMapper.java接口中的方法名和UserMapper.xml中的statement(<select>,<update>...标签)的id属性值一致;
3. UserMapper.java接口中的方法输入值参数和UserMapper.xml中statement的parameterType指定的类型一致。
4. UserMapper.java接口中的方法的返回值类型和UserMapper.xml中statement的resultType指定的类型一致。

 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="com.lic.ibatis.dao.UserMapper">
    <select id="getUserById" parameterType="int" resultType="com.lic.ibatis.entity.User">
        select * from user where id = #{id}
    </select>
</mapper>

 

源码角度分析:Mybatis源码解析