mybatis输入映射和输出映射实例详解

<?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>  <environments default="devlelopment">    <environment id="devlelopment">      <transactionManager type="JDBC"></transactionManager>      <dataSource type="POOLED">        <property name="driver" value="com.mysql.jdbc.Driver"></property>        <property name="url" value="jdbc:mysql://localhost:3306/mysql04"></property>        <property name="username" value="root"></property>        <property name="password" value="123"></property>      </dataSource>    </environment>  </environments>  <!--（6）在核心配置文件加载映射文件-->  <mappers>    <mapper resource="com/sgl/demo2/User.xml"></mapper>    <mapper resource="com/sgl/demo3/mapper/UserMapper.xml"></mapper>    <mapper resource="com/sgl/demo5/mapper/UserMapper.xml"></mapper>  </mappers></configuration>

package com.sgl.demo5.mapper;import com.sgl.demo5.pojo.User;import com.sgl.demo5.vo.UserQueryVo;import java.util.List;public interface UserMapper {//  根据返回类型选择selectOne或者selectList  public List<User> findUserList(UserQueryVo userQueryVo);}

<?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"><!--namespace :命名空间,对Sql进行分类管理，SQL分离--><mapper namespace="com.sgl.demo5.mapper.UserMapper">  <!--  id:表示配置文件中的SQL，称为statement 的Id  parameterType：参数的类型  resultType:返回值的类型，      如果返回值是一个集合，那么类型就写集合中元素的类型  -->  <!--查询用户列表，主键查询-->  <select id="findUserList" parameterType="com.sgl.demo5.vo.UserQueryVo"      resultType="com.sgl.demo5.pojo.User">    select username,id from user where username like "%"#{user.username}"%" and sex=#{user.sex}  </select></mapper>

package com.sgl.demo5.vo;import com.sgl.demo5.pojo.User;public class UserQueryVo {  private User user;  public User getUser() {    return user;  }  public void setUser(User user) {    this.user = user;  }}

package com.sgl.demo5.test;import com.sgl.demo5.mapper.UserMapper;import com.sgl.demo5.pojo.User;import com.sgl.demo5.vo.UserQueryVo;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.Before;import org.junit.Test;import java.io.IOException;import java.io.InputStream;import java.util.List;public class Test1 {  private SqlSessionFactory sqlSessionFactory;  @Before  public void fun0() throws IOException {    InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapconfig.xml");    this.sqlSessionFactory= new SqlSessionFactoryBuilder().build(resourceAsStream);  }  @Test  public void fun1()  {    SqlSession sqlSession = this.sqlSessionFactory.openSession();    UserMapper userMapper = sqlSession.getMapper( UserMapper.class );    UserQueryVo userQueryVo=new UserQueryVo();    User user=new User();    user.setUsername("小");    user.setSex("1");    userQueryVo.setUser(user);    List<User> userList = userMapper.findUserList(userQueryVo);    for ( User u:userList       ) {      System.out.println(u);    }  }}