Example usage for org.apache.ibatis.session SqlSession getMapper

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession getMapper.

Prototype

<T> T getMapper(Class<T> type);

Source Link

Document

Retrieves a mapper.

Usage

From source file:com.quancheng.mybatis.mapper.test.country2.TestInsert.java

License:Open Source License

/**
 * ??//from w ww  .java 2  s .c om
 */
@Test
public void testDynamicInsert() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        Country2Mapper mapper = sqlSession.getMapper(Country2Mapper.class);
        Country2 country = new Country2();
        country.setId(10086);
        country.setCountrycode("CN");
        country.setCountryname("?");
        Assert.assertEquals(1, mapper.insert(country));

        //CN2
        country = new Country2();
        country.setCountrycode("CN");
        List<Country2> list = mapper.select(country);

        Assert.assertEquals(1, list.size());
        //??,??
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(10086));
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.country2.TestInsert.java

License:Open Source License

/**
 * ?codenull?,?HH/*from   w w w  .ja v a 2 s  . co m*/
 */
@Test
public void testDynamicInsertNull() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        Country2Mapper mapper = sqlSession.getMapper(Country2Mapper.class);
        Country2 country = new Country2();
        country.setId(10086);
        country.setCountryname("?");
        Assert.assertEquals(1, mapper.insert(country));

        //CN2
        country = new Country2();
        country.setId(10086);
        List<Country2> list = mapper.select(country);

        Assert.assertEquals(1, list.size());
        Assert.assertNull(list.get(0).getCountrycode());
        //??,??
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(10086));
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.country2.TestInsertSelective.java

License:Open Source License

/**
 * ??,id?null,//  w  w  w . j  a  va 2 s. c o  m
 */
@Test
public void testDynamicInsertAll() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        Country2Mapper mapper = sqlSession.getMapper(Country2Mapper.class);
        Country2 country2 = new Country2();
        country2.setCountrycode("CN");
        Assert.assertEquals(1, mapper.insertSelective(country2));

        country2 = mapper.select(country2).get(0);
        Assert.assertNotNull(country2);

        Assert.assertEquals(1, mapper.deleteByPrimaryKey(country2.getId()));
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.country2.TestInsertSelective.java

License:Open Source License

/**
 * ??null/*from w w w  .  j  av a 2  s.c om*/
 */
@Test(expected = PersistenceException.class)
public void testDynamicInsertSelectiveAllByNull() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        Country2Mapper mapper = sqlSession.getMapper(Country2Mapper.class);
        mapper.insertSelective(null);
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.country2.TestInsertSelective.java

License:Open Source License

/**
 * ??// w w  w  . ja  va  2s  .  com
 */
@Test
public void testDynamicInsertSelective() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        Country2Mapper mapper = sqlSession.getMapper(Country2Mapper.class);
        Country2 country = new Country2();
        country.setId(10086);
        country.setCountrycode("CN");
        country.setCountryname("?");
        Assert.assertEquals(1, mapper.insertSelective(country));

        //CN2
        country = new Country2();
        country.setCountrycode("CN");
        List<Country2> list = mapper.select(country);

        Assert.assertEquals(1, list.size());
        //??,??
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(10086));
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.country2.TestInsertSelective.java

License:Open Source License

/**
 * Country2codeHH/*from  w  w  w .  j a v a  2 s. c  o  m*/
 */
@Test
public void testDynamicInsertSelectiveNull() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        Country2Mapper mapper = sqlSession.getMapper(Country2Mapper.class);
        Country2 country = new Country2();
        country.setId(10086);
        country.setCountryname("?");
        Assert.assertEquals(1, mapper.insertSelective(country));

        //CN2
        country = new Country2();
        country.setId(10086);
        List<Country2> list = mapper.select(country);

        Assert.assertEquals(1, list.size());
        //
        Assert.assertNotNull(list.get(0).getCountrycode());
        Assert.assertEquals("HH", list.get(0).getCountrycode());
        //??,??
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(10086));
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.example.TestDeleteByExample.java

License:Open Source License

@Test
public void testDeleteByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//from  www.j av a  2  s . c  o m
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        Example example = new Example(Country.class);
        example.createCriteria().andGreaterThan("id", 100);
        int count = mapper.deleteByExample(example);
        //
        Assert.assertEquals(83, count);
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.example.TestDeleteByExample.java

License:Open Source License

@Test
public void testDeleteByExample2() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//from   w  ww .j a  va  2  s  .co  m
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        Example example = new Example(Country.class);
        example.createCriteria().andLike("countryname", "A%");
        example.or().andGreaterThan("id", 100);
        example.setDistinct(true);
        int count = mapper.deleteByExample(example);
        //
        Assert.assertEquals(true, count > 83);
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.example.TestDeleteByExample.java

License:Open Source License

@Test
public void testDeleteByExample3() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//from w w w . j  a  v  a  2s  . co  m
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        CountryExample example = new CountryExample();
        example.createCriteria().andCountrynameLike("A%");
        example.or().andIdGreaterThan(100);
        example.setDistinct(true);
        int count = mapper.deleteByExample(example);
        //
        Assert.assertEquals(true, count > 83);
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.example.TestSelectByExample.java

License:Open Source License

@Test
public void testSelectByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//w ww .ja va 2  s.co  m
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        Example example = new Example(Country.class);
        example.createCriteria().andGreaterThan("id", 100).andLessThan("id", 151);
        example.or().andLessThan("id", 41);
        List<Country> countries = mapper.selectByExample(example);
        //
        Assert.assertEquals(90, countries.size());
    } finally {
        sqlSession.close();
    }
}