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

List of usage examples 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.aol.one.patch.examples.persistence.service.CartService.java

License:Open Source License

public void replaceProductInfo(SqlSession sqlSession, CartProductInfo info) {
    sqlSession.getMapper(CartProductsMapper.class).replaceCartProduct(info);
}

From source file:com.aol.one.patch.examples.persistence.service.CartService.java

License:Open Source License

public void deleteCartProductInfo(SqlSession sqlSession, CartProductInfo info) {
    sqlSession.getMapper(CartProductsMapper.class).deleteCartProduct(info);
}

From source file:com.aol.one.patch.examples.persistence.service.CartService.java

License:Open Source License

private CartMapper getCartMapper(SqlSession sqlSession) {
    return sqlSession.getMapper(CartMapper.class);
}

From source file:com.aol.one.patch.examples.persistence.service.CartService.java

License:Open Source License

private CartProductsMapper getCartProductsMapper(SqlSession sqlSession) {
    return sqlSession.getMapper(CartProductsMapper.class);
}

From source file:com.aol.one.patch.examples.persistence.service.ProductService.java

License:Open Source License

private ProductMapper getProductMapper(SqlSession sqlSession) {
    return sqlSession.getMapper(ProductMapper.class);
}

From source file:com.baomidou.mybatisplus.test.GlobalConfigurationTest.java

License:Apache License

/**
 * ?//from w  ww. java 2s . c o m
 */
@SuppressWarnings("unchecked")
public static void main(String[] args) {
    GlobalConfiguration global = GlobalConfiguration.defaults();
    global.setAutoSetDbType(true);
    // FieldStrategy.Empty
    global.setFieldStrategy(2);
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://127.0.0.1:3306/mybatis-plus?characterEncoding=UTF-8");
    dataSource.setUsername("root");
    dataSource.setPassword("521");
    dataSource.setMaxTotal(1000);
    GlobalConfiguration.setMetaData(dataSource, global);
    // ?
    InputStream inputStream = GlobalConfigurationTest.class.getClassLoader()
            .getResourceAsStream("mysql-config.xml");
    MybatisSessionFactoryBuilder factoryBuilder = new MybatisSessionFactoryBuilder();
    factoryBuilder.setGlobalConfig(global);
    SqlSessionFactory sessionFactory = factoryBuilder.build(inputStream);
    SqlSession session = sessionFactory.openSession(false);
    TestMapper testMapper = session.getMapper(TestMapper.class);
    /*Wrapper type = Condition.instance().eq("id",1).or().in("type", new Object[]{1, 2, 3, 4, 5, 6});
    List list = testMapper.selectList(type);
    System.out.println(list.toString());*/
    Test test = new Test();
    test.setCreateTime(new Date());
    // ?
    test.setType("");
    testMapper.insert(test);

    SqlSession sqlSession = sessionFactory.openSession(false);
    NotPKMapper pkMapper = sqlSession.getMapper(NotPKMapper.class);
    NotPK notPK = new NotPK();
    notPK.setUuid(UUID.randomUUID().toString());
    int num = pkMapper.insert(notPK);
    Assert.assertTrue(num > 0);
    NotPK notPK1 = pkMapper.selectOne(notPK);
    Assert.assertNotNull(notPK1);
    pkMapper.selectPage(RowBounds.DEFAULT, Condition.create().eq("type", 12121212));
    NotPK notPK2 = null;
    try {
        notPK2 = pkMapper.selectById("1");
    } catch (Exception e) {
        System.out.println(",");
    }
    Assert.assertNull(notPK2);
    int count = pkMapper.selectCount(Condition.EMPTY);
    Assert.assertTrue(count > 0);
    int deleteCount = pkMapper.delete(null);
    Assert.assertTrue(deleteCount > 0);
    session.rollback();
    sqlSession.commit();
}

From source file:com.baomidou.mybatisplus.test.MybatisMapperRefreshTest.java

License:Apache License

/**
 *  Mybatis XML /*from www  .j av a  2  s . c  o  m*/
 */
public static void main(String[] args) throws IOException, InterruptedException {
    InputStream in = UserMapperTest.class.getClassLoader().getResourceAsStream("mysql-config.xml");
    MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();
    mf.setGlobalConfig(new GlobalConfiguration(new MySqlInjector()));
    Resource[] resource = new ClassPathResource[] { new ClassPathResource("mysql/UserMapper.xml") };
    SqlSessionFactory sessionFactory = mf.build(in);
    new MybatisMapperRefresh(resource, sessionFactory, 0, 5, true);
    boolean isReturn = false;
    SqlSession session = null;
    while (!isReturn) {
        try {
            session = sessionFactory.openSession();
            UserMapper userMapper = session.getMapper(UserMapper.class);
            userMapper.selectListRow(new Pagination(1, 10));
            resource[0].getFile().setLastModified(SystemClock.now());
            session.commit();
            session.close();
            Thread.sleep(5000);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (session != null) {
                session.close();
            }
            Thread.sleep(5000);
        }
    }
    System.exit(0);
}

From source file:com.baomidou.mybatisplus.test.mysql.CircularLabelsTest.java

License:Apache License

/**
 *  //  w w w  . j  a  va2s.co  m
 */
public static void main(String[] args) {

    // ?
    InputStream in = CircularLabelsTest.class.getClassLoader().getResourceAsStream("mysql-config.xml");
    MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();
    SqlSessionFactory sessionFactory = mf.build(in);
    SqlSession session = sessionFactory.openSession();
    UserMapper userMapper = session.getMapper(UserMapper.class);
    Page<User> page = new Page<>(1, 6);
    List<User> users = userMapper.forSelect(page, Arrays.asList("1", "2", "3"));
    System.out.println(users.toString());
    System.out.println(page);
    User user = new User();
    user.setId(1L);
    User users1 = userMapper.selectOne(user);
    System.out.println(users1);
    TestMapper mapper = session.getMapper(TestMapper.class);
    Test test = new Test();
    test.setCreateTime(new Date());
    test.setType("11111");
    mapper.insert(test);
    session.rollback();
}

From source file:com.baomidou.mybatisplus.test.mysql.LogicDeleteTest.java

License:Apache License

public static void main(String[] args) {
    // ?/*w w w .  j  a  v  a  2  s.c  o  m*/
    InputStream in = UserMapperTest.class.getClassLoader().getResourceAsStream("mysql-config.xml");
    MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();
    GlobalConfiguration gc = new GlobalConfiguration(new LogicSqlInjector());// ?
    gc.setLogicDeleteValue("-1");//  -1  type
    mf.setGlobalConfig(gc);
    SqlSessionFactory sessionFactory = mf.build(in);
    SqlSession session = sessionFactory.openSession();
    UserMapper userMapper = session.getMapper(UserMapper.class);
    System.err.println(" debug run  user ??? ");
    long id = IdWorker.getId();
    int rlt = userMapper.insert(new User(id, "logic-delete-1", 18, 1));
    System.err.println("??" + rlt);
    rlt = userMapper.deleteById(id);
    System.err.println("? ID ?" + rlt);
    User user = userMapper.selectById(id);
    System.out.println("" + user.getTestType());

    User uu = new User();
    uu.setId(user.getId());
    uu.setTestType(1);
    rlt = userMapper.updateById(user);
    System.err.println("testType  1 ?" + rlt);
    rlt = userMapper.insert(new User(IdWorker.getId(), "logic-delete-2", 28, 2));
    System.err.println("????" + rlt);
    rlt = userMapper.delete(null);
    System.err.println("?" + rlt);
    List<User> userList = userMapper.selectList(null);
    for (User u : userList) {
        System.out.println(" ( id= " + u.getId() + " ) " + u.getTestType());
    }

    rlt = userMapper.updateById(uu);
    System.err.println("testType  1 ?" + rlt);
    Map<String, Object> map = new HashMap<>();
    map.put("test_id", id);
    rlt = userMapper.deleteByMap(map);
    System.err.println(" ByMap ?" + rlt);
    userList = userMapper.selectList(null);
    for (User u : userList) {
        System.out.println(" ( id= " + u.getId() + " ) " + u.getTestType());
    }
}

From source file:com.baomidou.mybatisplus.test.mysql.NoXMLTest.java

License:Apache License

public static void main(String[] args) {
    /*// w w w .ja  v a2 s  .c o m
    * ?
    */
    InputStream in = NoXMLTest.class.getClassLoader().getResourceAsStream("mysql-config.xml");
    MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();
    SqlSessionFactory sessionFactory = mf.build(in);
    SqlSession sqlSession = sessionFactory.openSession();
    /**
     * ?
     */
    TestMapper testMapper = sqlSession.getMapper(TestMapper.class);
    testMapper.insert(new Test(IdWorker.getId(), "Caratacus"));
    List<Map<String, Object>> list = testMapper.selectMaps(null);
    List<Map<String, Object>> list1 = testMapper.selectMapsPage(RowBounds.DEFAULT, null);
    List<Map<String, Object>> list2 = testMapper.selectMapsPage(new Page<>(1, 5), null);
    System.out.println(list);
    System.out.println(list1);
    System.out.println(list2);
    Map<String, Object> map = new HashMap<>();
    map.put("type", null);
    map.put("id", null);
    List<Test> tests = testMapper.selectByMap(map);
    if (null != tests) {
        for (Test test : tests) {
            System.out.println("id:" + test.getId() + " , type:" + test.getType());
        }
    } else {
        System.err.println(" tests is null. ");
    }
    testMapper.delete(null);

}