您现在的位置是：首页 > 个人日记个人日记

mybatis-04-输入输出映射

2019-02-02 15:57:14【个人日记】228人已围观

简介将数据库与JavaBean相对于,映射为对象

输入输出映射

输入映射

配置Mapper.xml文件

    <!--多条件查询-->
    <select id="find" parameterType="java.util.Map" resultType="com.huangxin.model.ProductCategory">
        SELECT * FROM product WHERE supplier LIKE '%${brand}%' AND id <![CDATA[< #{id}]]><!--原样输出-->
    </select>
        <!--查询所有-->
    <select id="All" resultType="java.util.Map">
        SELECT * FROM product
    </select>

对应的Junit规范

    private SqlSessionFactory factory;
    /**
     * 初始化SqlSession工厂
     *
     * @throws IOException
     */
    @Before
    public void init() throws IOException {
        //将全局配置文件读取
        InputStream in = Resources.getResourceAsStream("mybatis-config.xml");
        factory = new SqlSessionFactoryBuilder().build(in);
    }
    @Test
    public void find() {
        Map<String, Object> map = new HashMap<String, Object>();
        map.put("brand", "未知");
        map.put("id", 5);
        SqlSession sqlSession = factory.openSession();
        //通过mybatis的动态代理机制,生成了一个ProductCategory接口实现类
        ProductCategoryMapper mapper = sqlSession.getMapper(ProductCategoryMapper.class);
        System.out.println(mapper.find(map));
    }
    @Test
    public void All() {
        SqlSession sqlSession = factory.openSession();
        ProductCategoryMapper mapper = sqlSession.getMapper(ProductCategoryMapper.class);
        List<Map<String, Object>> lists = mapper.All();
        sqlSession.close();
        for (Map<String, Object> map : lists) {
            for (String key: map.keySet()){
                System.out.println(key+"-->"+map.get(key));
            }
        }
    }