List of usage examples for org.apache.ibatis.session SqlSession getMapper
<T> T getMapper(Class<T> type);
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); }