net.turnbig.jdbcx.test.JdbcxQueryTest.java Source code

Introduction

Here is the source code for net.turnbig.jdbcx.test.JdbcxQueryTest.java

Source

/*******************************************************************************
 *
 * Copyright 2014-2016 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *******************************************************************************/

package net.turnbig.jdbcx.test;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.junit.Assert;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;

import net.turnbig.jdbcx.H2Env;
import net.turnbig.jdbcx.JdbcxPagingDaoSupport;
import net.turnbig.jdbcx.modal.Member;

/**
 * @author Woo Cupid
 * @date 2016121
 * @version $Revision$
 */
public class JdbcxQueryTest extends H2Env {

    @Autowired
    JdbcxPagingDaoSupport jdbc;

    @Test
    public void testQueryListBean() {
        Member sample = new Member();
        sample.setName("woo");
        List<Member> members = jdbc.queryForListBean("select * from member where name = :name", sample,
                Member.class);
        Assert.assertEquals("name with woo only 1 record", members.size(), 1);

        Map<String, String> params = new HashMap<String, String>();
        params.put("name", "woo");
        List<Member> members2 = jdbc.queryForListBean("select * from member where name = :name", params,
                Member.class);
        Assert.assertEquals("name with woo only 1 record", members2.size(), 1);

        Member member = members.get(0);
        Assert.assertEquals("ip should be 127.0.0.1", member.getRegistIp(), "127.0.0.1");
    }

    @Test
    public void testQueryListMap() {
        List<Map<String, Object>> members = jdbc.queryForListMap("select * from member order by id asc");
        Assert.assertEquals("total records is 2", members.size(), 2);
        Map<String, Object> member = members.get(0);
        Assert.assertEquals("ip should be 127.0.0.1", member.get("name"), "woo");
    }

    @Test
    public void testQueryPrimitiveObject() {
        Integer count = jdbc.queryForObject("select count(0) from member", Integer.class);
        Assert.assertEquals("total records is 2", count.intValue(), 2);

        Long countLong = jdbc.queryForObject("select count(0) from member", Long.class);
        Assert.assertEquals("total records is 2", countLong.intValue(), 2);

        Member m = new Member();
        m.setName("woo");
        Boolean isAdmin = jdbc.queryForObject("select is_admin from member where name = :name", m, Boolean.class);
        Assert.assertTrue(isAdmin);
    }

}