List of usage examples for org.apache.ibatis.session SqlSession getMapper
<T> T getMapper(Class<T> type);
From source file:com.mmj.app.biz.base.BaseDao.java
License:Open Source License
private Integer batchOptByMapper(Collection<T> objList, String methodName) { SqlSession session = getSqlSession(); Class[] paramTypes = new Class[1]; M mapper = (M) session.getMapper(mapperClass); try {/* w w w . j a v a2 s. co m*/ paramTypes[0] = Class.forName(entityClass.getName()); Method method = mapperClass.getMethod(methodName, Serializable.class); for (Object obj : objList) { method.invoke(mapper, obj); } } catch (Exception e) { log.error("BaseDao batchOptByMapper:error()"); } session.flushStatements(); return new Integer(1); }
From source file:com.mybatisX.test.MybatisMapperRefreshTest.java
License:Apache License
/** * Mybatis XML // w w w . ja v a 2s. 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.setSqlInjector(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.mybatisX.test.mysql.NoXMLTest.java
License:Apache License
public static void main(String[] args) { /*//from w w w .ja v a2 s.c om * ? */ 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")); 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. "); } }
From source file:com.mybatisX.test.mysql.TransactionalTest.java
License:Apache License
/** * <p>/*from w w w.j a v a 2s. c o m*/ * * </p> */ public static void main(String[] args) { /* * ? */ InputStream in = TransactionalTest.class.getClassLoader().getResourceAsStream("mysql-config.xml"); MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder(); SqlSessionFactory sessionFactory = mf.build(in); SqlSession sqlSession = sessionFactory.openSession(); /** * ? */ UserMapper userMapper = sqlSession.getMapper(UserMapper.class); int rlt = userMapper.insert(new User(IdWorker.getId(), "1", 1, 1)); System.err.println("--------- insertInjector --------- " + rlt); //session.commit(); sqlSession.rollback(); sqlSession.close(); }
From source file:com.mybatisX.test.mysql.URPTest.java
License:Apache License
public static void main(String[] args) { // ?/*from w ww . j a v a 2s .c om*/ InputStream in = UserMapperTest.class.getClassLoader().getResourceAsStream("mysql-config.xml"); MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder(); mf.setSqlInjector(new MySqlInjector()); mf.setMetaObjectHandler(new MyMetaObjectHandler()); SqlSessionFactory sessionFactory = mf.build(in); SqlSession session = sessionFactory.openSession(); UserMapper userMapper = session.getMapper(UserMapper.class); RoleMapper roleMapper = session.getMapper(RoleMapper.class); /** * sjy @TableFieldel, ?resultMap */ Role role = new Role(); role.setId(IdWorker.getId()); role.setName("admin"); int rlt = roleMapper.insert(role); System.err.println("--------- insert role --------- " + rlt); PhoneNumber phone = new PhoneNumber("81", "0576", "82453832"); User userA = new User(); userA.setId(IdWorker.getId()); userA.setName("junyu_shi"); userA.setAge(15); userA.setTestType(1); userA.setRole(role); userA.setPhone(phone); rlt = userMapper.insert(userA); System.err.println("--------- insert user --------- " + rlt); User whereUser = userMapper.selectOne(userA); System.err.println("--------- select user --------- " + whereUser.toString()); // ?el?, User??roleIdUser, // Role?resultmap?. ?, ?user.setRoleId(), ?updateUser. role = new Role(); role.setId(IdWorker.getId()); role.setName("root"); roleMapper.insert(role); userA.setRole(role); userMapper.updateById(userA); System.err.println("--------- upadte user's role --------- " + rlt); whereUser = userMapper.selectOne(userA); System.err.println("--------- select user --------- " + whereUser.toString()); userMapper.delete(new EntityWrapper<User>(userA)); System.err.println("--------- delete user --------- " + rlt); }
From source file:com.mybatisX.test.mysql.UserMapperTest.java
License:Apache License
/** * RUN /* w w w .ja va 2 s. c o m*/ * <p> * <p> * MybatisPlus SQL ? * </p> * 1?XMLSQL<br> * 2?sqlProviderSQL<br> * 3?xmlSql sqlProvider???SQL<br> * <br> * ?SQLxmlSql > sqlProvider > crudSql <br> */ public static void main(String[] args) { // ? InputStream in = UserMapperTest.class.getClassLoader().getResourceAsStream("mysql-config.xml"); /* * MybatisSessionFactoryBuilder * SqlSessionFactoryBaseMapper */ MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder(); /* * 1?????? 2????? 3????? * ?? @TableId(value = "test_id") */ // mf.setDbColumnUnderline(true); /** * SQL */ mf.setSqlInjector(new MySqlInjector()); /** * */ mf.setMetaObjectHandler(new MyMetaObjectHandler()); SqlSessionFactory sessionFactory = mf.build(in); SqlSession session = sessionFactory.openSession(); UserMapper userMapper = session.getMapper(UserMapper.class); System.err.println(" debug run user ??? "); userMapper.deleteAll(); /** * sjy @TableFieldel */ Role role = new Role(); role.setId(IdWorker.getId()); role.setName("admin"); User userA = new User(); userA.setId(IdWorker.getId()); userA.setName("junyu_shi"); userA.setAge(1); userA.setDesc(""); userA.setTestType(1); userA.setRole(role); int rlt = userMapper.insert(userA); User whereUser = userMapper.selectOne(userA); print(whereUser); userA.setAge(18); userMapper.updateById(userA); userMapper.delete(new EntityWrapper<User>(userA)); System.err.println("--------- @TableField el() --------- " + rlt); /** * ? */ rlt = userMapper.insertInjector(new User(1L, "1", 1, 1)); System.err.println("--------- insertInjector --------- " + rlt); /** * ehcache */ User cacheUser = userMapper.selectOne(new User(1L, 1)); print(cacheUser); cacheUser = userMapper.selectOne(new User(1L, 1)); print(cacheUser); /** * ? */ long id = IdWorker.getId(); rlt = userMapper.insert(new User(id, "abc", 18, 1)); System.err.println("\n--------------insert-------" + rlt); sleep(); rlt = userMapper.insert(new User(18)); System.err.println("\n---------- name ?----insert-------" + rlt); sleep(); List<User> ul = new ArrayList<User>(); /* ID */ ul.add(new User(11L, "1", 1, 0)); ul.add(new User(12L, "2", 2, 1)); ul.add(new User(13L, "3", 3, 1)); ul.add(new User(14L, "delname", 4, 0)); ul.add(new User(15L, "5", 5, 1)); ul.add(new User(16L, "6", 6, 0)); /* name test_type */ ul.add(new User(17L, 7)); ul.add(new User(18L, 8)); ul.add(new User(19L, 9)); ul.add(new User(7)); ul.add(new User(20L, "deleteByMap", 7, 0)); /* ID_WORKER ? ID */ ul.add(new User("8", 8, 1)); ul.add(new User("9", 9, 1)); for (User u : ul) { rlt = userMapper.insert(u); } System.err.println("\n--------------insertBatch----------------" + rlt + "\n\n"); /** * ?????? */ session.commit(); /* * */ rlt = userMapper.deleteById(id); System.err.println("---------deleteById------- delete id=" + id + " ,result=" + rlt + "\n\n"); sleep(); Map<String, Object> columnMap = new HashMap<String, Object>(); columnMap.put("name", "deleteByMap"); columnMap.put("age", null); rlt = userMapper.deleteByMap(columnMap); System.err.println("---------deleteByMap------- result=" + rlt + "\n\n"); sleep(); List<Long> il = new ArrayList<Long>(); il.add(16L); il.add(17L); rlt = userMapper.deleteBatchIds(il); System.err.println("---------deleteBatchIds------- delete id=" + id + " ,result=" + rlt + "\n\n"); sleep(); rlt = userMapper.delete(new EntityWrapper<User>(new User(14L, "delname"))); System.err.println("--------------delete------------------ result=" + rlt + "\n\n"); sleep(); /* * <p> </p> * * updateById BaseMapper ?UserMapper.xmlsql */ rlt = userMapper.updateById(new User(12L, "MybatisPlus")); System.err.println("------------------updateById---------------------- result=" + rlt + "\n\n"); sleep(); rlt = userMapper.updateById(new User(12L, "update all column", 12, 12)); System.err.println("------------------updateById---------------------- result=" + rlt + "\n\n"); sleep(); rlt = userMapper.update(new User("55", 55, 5), new EntityWrapper<User>(new User(15L, "5"))); System.err.println("------------------update---------------------- result=" + rlt + "\n\n"); sleep(); EntityWrapper<User> ew1 = new EntityWrapper<User>(); ew1.addFilter("test_id={0} AND name={1}", 15L, "55"); rlt = userMapper.update(new User("00"), ew1); System.err.println("------------------update---------------------- result=" + rlt + "\n\n"); sleep(); /* ? */ // userMapper.update(new User("11"), null); List<User> userList = new ArrayList<User>(); userList.add(new User(11L, "updateBatchById-1", 1, 1)); userList.add(new User(12L, "updateBatchById-2", 2, 1)); userList.add(new User(13L, "updateBatchById-3", 3, 1)); for (User u : userList) { rlt = userMapper.updateById(u); } System.err.println("------------------updateBatchById---------------------- result=" + rlt + "\n\n"); sleep(); /* * <p> </p> */ System.err.println("\n------------------selectById----------------------"); User user = userMapper.selectById(12L); print(user); System.err.println("\n------------------selectBatchIds----------------------"); List<Long> idList = new ArrayList<Long>(); idList.add(11L); idList.add(12L); List<User> ul0 = userMapper.selectBatchIds(idList); for (User anUl0 : ul0) { print(anUl0); } System.err.println("\n------------------selectByMap----- map ??----"); Map<String, Object> cm = new HashMap<String, Object>(); cm.put("test_type", 1); List<User> ul1 = userMapper.selectByMap(cm); for (User anUl1 : ul1) { print(anUl1); } System.err.println("\n------------------selectOne----------------------"); User userOne = userMapper.selectOne(new User("abc")); print(userOne); System.err.println("\n------------------selectCount----------------------"); System.err.println( " type=1 " + userMapper.selectCount(new EntityWrapper<User>(new User(1)))); System.err.println("" + userMapper.selectCount(null)); System.err.println("\n------------------selectList-----?----id--DESC--?----"); List<User> ul2 = userMapper.selectList(new EntityWrapper<User>(null, "age,name")); for (User anUl2 : ul2) { print(anUl2); } System.err.println( "\n------------------list ---- testType = 1 ?--id--DESC--?--------"); Page<User> page = new Page<User>(1, 2); EntityWrapper<User> ew = new EntityWrapper<User>(new User(1)); /* * */ ew.setSqlSelect("age,name"); /* * ?SQL (?SQL?????) */ ew.where("name like {0}", "'%dateBatch%'").and("age={0}", 3).orderBy("age,name", true); List<User> paginList = userMapper.selectPage(page, ew); page.setRecords(paginList); for (int i = 0; i < page.getRecords().size(); i++) { print(page.getRecords().get(i)); } System.err.println(" " + page.toString()); System.err.println( "\n---------------xml---selectListRow ?? count ----?--------------"); // TODO Page ?? List<User> rowList = userMapper.selectListRow(new Pagination(0, 2, false)); for (User aRowList : rowList) { print(aRowList); } /* * */ System.err.println(" selectList EntityWrapper == null \n"); paginList = userMapper.selectList(null); for (User aPaginList : paginList) { print(aPaginList); } /* * <p> * SQL ??? * </p> * <p> * ?/mybatis-plus/src/test/java/com/baomidou/mybatisplus/test/SqlBuilderTest.java * </p> */ SQL sql = new SQL() { { SELECT("a.test_id as id, a.name, a.age"); FROM("user a"); WHERE("a.test_type=1"); } }; // SQL ? System.err.println(" insertSql SQL \n"); rlt = userMapper.insertSql(new SQL() { { INSERT_INTO("user"); VALUES("test_id, name, age, test_type", IdWorker.getId() + ", 'testInsertSql', 5, 1"); } }.toString()); System.err.println("???" + rlt); // SQL System.err.println(" selectListSql SQL \n"); List<Map<String, Object>> ul3 = userMapper.selectListSql(sql.toString()); for (Map<String, Object> u : ul3) { System.err.println(u); } // SQL System.err.println(" selectPageSql SQL \n"); Page<Map<String, Object>> page3 = new Page<Map<String, Object>>(0, 10); List<Map<String, Object>> ml = userMapper.selectPageSql(page3, sql.toString()); for (Map<String, Object> map : ml) { System.err.println(" map " + map); } System.err.println("" + page3.toString()); // SQL System.err.println(" deleteSql SQL \n"); rlt = userMapper.deleteSql(new SQL() { { DELETE_FROM("user"); WHERE("name='testInsertSql'"); } }.toString()); System.err.println("??" + rlt); // SQL System.err.println(" updateSql SQL \n"); rlt = userMapper.updateSql(new SQL() { { UPDATE("user"); SET("age=6"); WHERE("test_type=1"); } }.toString()); System.err.println("???" + rlt); /** * ? */ rlt = userMapper.deleteAll(); System.err.println("?? rlt=" + rlt); /** * ?? */ session.commit(); }
From source file:com.mybatisX.test.oracle.TestUserMapperTest.java
License:Apache License
/** * /* w ww. j a v a 2 s . c o m*/ * RUN MySql * */ public static void main(String[] args) { //? InputStream in = TestUserMapperTest.class.getClassLoader().getResourceAsStream("oracle-config.xml"); /* * MybatisSessionFactoryBuilder * SqlSessionFactoryBaseMapper */ MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder(); /** ? oracle */ mf.setDbType("oracle"); /* * 1?????? * 2????? * 3????? * ?? @TableId(value = "test_id") */ //mf.setDbColumnUnderline(true); SqlSessionFactory sessionFactory = mf.build(in); SqlSession session = sessionFactory.openSession(); TestUserMapper testUserMapper = session.getMapper(TestUserMapper.class); System.err.println(" debug run test_user ??? "); session.delete("deleteAll"); /** * ? */ int rlt = testUserMapper.insert(new TestUser("10", "abc", 18, 1)); System.err.println("\n--------------insert-------" + rlt); sleep(); /** * ?? */ List<TestUser> ul = new ArrayList<TestUser>(); ul.add(new TestUser("11", "1a", 11, 1)); ul.add(new TestUser("12", "2a", 12, 2)); ul.add(new TestUser("a", 1, 1)); ul.add(new TestUser("b", 2, 2)); ul.add(new TestUser("c", 3, 1)); for (TestUser u : ul) { rlt = testUserMapper.insert(u); } System.err.println("\n--------------insertBatch-------" + rlt); sleep(); /** * ? */ List<TestUser> ul1 = new ArrayList<TestUser>(); ul1.add(new TestUser("10", "update-0a", 11, 1)); ul1.add(new TestUser("11", "update-1a", 11, 1)); ul1.add(new TestUser("12", "update-2a", 12, 2)); for (TestUser u : ul1) { rlt = testUserMapper.updateById(u); } System.err.println("\n--------------updateBatchById-------" + rlt); sleep(); System.err.println( "\n------------------list ---- testType = 1 ?--id--DESC--?--------"); Page<TestUser> page = new Page<TestUser>(1, 2); EntityWrapper<TestUser> ew = new EntityWrapper<TestUser>(new TestUser(1), "TEST_ID DESC"); List<TestUser> paginList = testUserMapper.selectPage(page, ew); page.setRecords(paginList); for (int i = 0; i < page.getRecords().size(); i++) { print(page.getRecords().get(i)); } System.err.println(" " + page.toString()); /* ? */ rlt = session.delete("deleteAll"); System.err.println("?? rlt=" + rlt); /** * ?? */ session.commit(); }
From source file:com.oneops.cms.service.OneopsCmsManager.java
License:Apache License
/** * Test it./* w w w . j av a2 s .c om*/ * * @param id the id * @return the string */ public String testIt(int id) { SqlSession session = sqlSessionFactory.openSession(); String clazzName; try { ClazzMapper mapper = session.getMapper(ClazzMapper.class); CmsClazz cl = mapper.getClazz("CI"); clazzName = cl.getClassName(); } finally { session.close(); } return clazzName; }
From source file:com.oneops.cms.service.OneopsCmsManager.java
License:Apache License
/** * Gets the clazzes./* www . j a v a2s .c o m*/ * * @return the clazzes */ public List<CmsClazz> getClazzes() { SqlSession session = sqlSessionFactory.openSession(); List<CmsClazz> clazzes; try { ClazzMapper mapper = session.getMapper(ClazzMapper.class); clazzes = mapper.getClazzes(); for (CmsClazz clazz : clazzes) { clazz.setMdAttributes(mapper.getClazzAttrs(clazz.getClassId())); clazz.setFromRelations(mapper.getFromClazzRelations(clazz.getClassId())); clazz.setToRelations(mapper.getToClazzRelations(clazz.getClassId())); } } finally { session.close(); } return clazzes; }
From source file:com.oneops.cms.test.CmsTest.java
License:Apache License
/** * @param args//from w w w. jav a 2 s .c om * @throws IOException * @throws SQLException */ public static void _main(String[] args) throws IOException, SQLException { String resource = "mybatis-config.xml"; Reader reader = Resources.getResourceAsReader(resource); SqlSessionFactory sqlsf = new SqlSessionFactoryBuilder().build(reader); SqlSession session = sqlsf.openSession(); CIMapper ciMapper = session.getMapper(CIMapper.class); ClazzMapper clMapper = session.getMapper(ClazzMapper.class); NSMapper nsMapper = session.getMapper(NSMapper.class); RelationMapper rlMapper = session.getMapper(RelationMapper.class); CmsCmProcessor cmProcessor = new CmsCmProcessor(); cmProcessor.setCiMapper(ciMapper); cmProcessor.setCmValidator(cmValidator); cmProcessor.setCmsNsProcessor(nsMan); cmValidator.setCmsMdProcessor(mdMan); cmValidator.setCmsNsProcessor(nsMan); nsMan.setNsMapper(nsMapper); CmsMdProcessor mdProcessor = new CmsMdProcessor(); mdProcessor.setClazzMapper(clMapper); mdProcessor.setRelationMapper(rlMapper); try { testQueryAttrs(ciMapper); //testState(sqlsf); //testClazzes(sqlsf); //testCreateOrg(); //testCreateAssembly(); //testCreatPlatform(sqlsf); //int newRelId = testCreateRelation(sqlsf, 1048, 1052); //testGetRelation(sqlsf, newRelId); //testGetToFromRelation(sqlsf, 1048); //testUpdateCI(sqlsf); //testDeleteCi(sqlsf); //testGetCiById(sqlsf); //testGetCi(sqlsf); //testCreateClazz(sqlsf); //testGetClazz(sqlsf); session.commit(); } finally { session.close(); } }