@SuppressWarnings("unchecked") @Override public List<UsuarioDTO> buscarUsuarioPaginados(UsuarioDTO usuario, Integer inicio, Integer tamano) throws Exception { SqlSession sesion = sqlMapper.openSession(); List<UsuarioDTO> lstUsuario = new ArrayList<UsuarioDTO>(); try { if (usuario == null) { UsuarioDTO provee = new UsuarioDTO(); provee.setInicio(inicio); provee.setTamano(tamano); lstUsuario = (List<UsuarioDTO>) sesion.selectList("usuario.SQL_listaUsuarioPaginados", provee); } else { if (!usuario.getNom_usuario().isEmpty()) { usuario.setNom_usuario("%" + usuario.getNom_usuario() + "%"); usuario.setInicio(inicio); usuario.setTamano(tamano); lstUsuario = (List<UsuarioDTO>) sesion.selectList("usuario.SQL_listaUsuarioNom_usuarioPaginados", usuario); } } } finally { sesion.close(); } return lstUsuario; }
public void testInsert() { // session.commit(); List<Student> lists = sqlSession.selectList("com.ldl.mybatis.dataobject.Student.findAllStudents"); for (Student student : lists) { System.out.println( "学生id:" + student.getId() + " name:" + student.getName() + " 班级名称:" + student.getClasses().getName()); } System.out.println( "--------------------------------------------------------------------------"); List<Classes> listc = sqlSession.selectList("com.ldl.mybatis.dataobject.Student.findAllClasses"); for (Classes classes : listc) { System.out.println("班级id:" + classes.getId() + " name:" + classes.getName()); for (Student student : classes.getStudentList()) { System.out.println( "--学生id:" + student.getId() + " name:" + student.getName() + " 班级名称:" + student.getClasses().getName()); } } }
@Test public void learnToUseStoredProcWithDomainObjects() { FilmInStockParam param = new FilmInStockParam(); param.setFilmId(12); param.setStoreId(1); List<FilmInStockId> results = session.selectList("callFilmInStock", param); // TODO: remove this line if your database does not use OUT params // in which case MyBatis won't populate the count entry in this hash assertEquals(3, param.getCount()); assertEquals(3, results.size()); FilmInStockId f = results.get(0); assertNotNull(f); assertEquals(60, f.getFilmId().intValue()); f = results.get(1); assertNotNull(f); assertEquals(61, f.getFilmId().intValue()); f = results.get(2); assertNotNull(f); assertEquals(62, f.getFilmId().intValue()); }
/** * 获取permission数据集合 * * @author 尹逊志 * @throws JsonProcessingException * @time 2015年4月13日下午10:29:36 */ @ResponseBody @RequestMapping(value = "/user/permissionList", method = RequestMethod.POST) public String getPermissonData(HttpServletRequest request, HttpServletResponse response) throws JsonProcessingException { String rows = request.getParameter("rows"); String page = request.getParameter("page"); if (rows == null) { rows = "20"; } if (page == null) { page = "1"; } String resource = "/mybatis-config-test.xml"; InputStream is = UserController.class.getResourceAsStream(resource); SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is); SqlSession session = factory.openSession(); String statement = "com.myproject.mybatis.user.permissionMapper.getAll"; Map<String, Integer> map = new HashMap<String, Integer>(); map.put("pageNum", Integer.parseInt(page)); map.put("pageSize", Integer.parseInt(rows)); PageHelper.startPage(Integer.parseInt(page), Integer.parseInt(rows)); List<Permission> permissList = session.selectList(statement); PageInfo<Permission> pageInfo = new PageInfo<Permission>(permissList); session.commit(); session.close(); ResponseResult result = new ResponseResult(); result.setTotal(pageInfo.getTotal()); result.setRows(permissList); ObjectMapper mapper = new ObjectMapper(); return mapper.writeValueAsString(result); }
/** * 根据查询参数获取一页的数据 * * @return */ public List<CellMenuList> getCellMenuListsByQueryCriteria( int start, int pageSize, CellMenuListQuery query) { RowBounds rowBounds = new RowBounds(start, pageSize); List<CellMenuList> rows = sqlSession.selectList("getCellMenuListsByQueryCriteria", query, rowBounds); return rows; }
@Override public List<log> getLogs(Map mp) { List usr = null; SqlSession session = util.getSqlsession(); usr = session.selectList("log.selectListByPage", mp); return usr; }
@Override public Map getAllInfo() { SqlSession session = util.getSqlsession(); company cp = new company(); cp.setId("1"); company cy = (company) session.selectOne("company.selectOneById", cp); Map mp = new HashMap(); mp.put("company", cy); List pc = session.selectList("productClass.selectList"); mp.put("productclass", pc); List tm = session.selectList("team.selectList"); List bc = session.selectList("brochure.selectList"); mp.put("team", tm); mp.put("brochure", bc); return mp; }
/** * Update communication Medium * * @param ag * @throws PersistenceException */ public void updateCommMedium(AssertionGroup ag) throws PersistenceException { SqlSession session = sf.openSession(); try { session.selectList("com.cockpitconfig.objects.CommunicationMapper.updateCommID", ag); } finally { session.close(); } }
public List<Member> selectList() throws Exception { SqlSession sqlSession = sqlSessionFactory.openSession(); try { return sqlSession.selectList("spms.dao.MemberDao.selectList"); } finally { sqlSession.close(); } }
@Override public ArrayList<User> userLsit() { // TODO Auto-generated method stub SqlSession session = getSession(); List<User> list = session.selectList("hooni.userList"); close(session); return (ArrayList<User>) list; }
@SuppressWarnings("unchecked") protected <E> List<E> list(Class<E> type, String sqlKey, int count) { SqlSession session = sqlSessionFactory.openSession(); try { return (List<E>) session.selectList(sqlKey, count); } finally { session.close(); } }
@Test public void findUserByName() throws IOException { InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml"); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream); SqlSession sqlSession = sessionFactory.openSession(); List<User> list = sqlSession.selectList("test.findUserByName", "小"); System.out.println(list); sqlSession.close(); }
@Override public List<Comment> getComments(int page, String boardCode) { HashMap<String, Object> params = new HashMap<String, Object>(); params.put("page", page); params.put("boardCode", boardCode); return session.selectList("getComments", params); }
public void testMyBaits() { SqlSession session = DbManager.getSqlFactory().openSession(); String statement = "com.zyxr.repair.missionLoansMap.getMissionLoans"; List<MissionLoans> loans = session.selectList(statement); for (MissionLoans loan : loans) { System.out.println(loan); } System.out.println(loans.size()); }
public List<User> getAllUserByEmail(String email) { SqlSession session = SessionFactory.getSessionFactory().openSession(); List<User> users = new ArrayList<User>(); try { users = session.selectList("UserMapper.selectUser", email); } finally { session.close(); } return users; }
private <E> Object executeForMany(SqlSession sqlSession, Object[] args) { List<E> result; Object param = method.convertArgsToSqlCommandParam(args); if (method.hasRowBounds()) { RowBounds rowBounds = method.extractRowBounds(args); result = sqlSession.<E>selectList(command.getName(), param, rowBounds); } else { result = sqlSession.<E>selectList(command.getName(), param); } // issue #510 Collections & arrays support if (!method.getReturnType().isAssignableFrom(result.getClass())) { if (method.getReturnType().isArray()) { return convertToArray(result); } else { return convertToDeclaredCollection(sqlSession.getConfiguration(), result); } } return result; }
public List<Goods> getGoods() { SqlSession session = SessionFactory.getSessionFactory().openSession(); List<Goods> goods; try { goods = session.selectList("UserMapper.selectGoods"); } finally { session.close(); } return goods; }
public List<User> getCouriers() { SqlSession session = SessionFactory.getSessionFactory().openSession(); List<User> users; try { users = session.selectList("UserMapper.getCouriers"); } finally { session.close(); } return users; }
@SuppressWarnings("unchecked") public List<Q_skill_modelBean> select() { SqlSession session = sqlMapper.openSession(); try { List<Q_skill_modelBean> list = (List<Q_skill_modelBean>) session.selectList("q_skill_model.select"); return list; } finally { session.close(); } }
@SuppressWarnings("unchecked") @Override public List<UsuarioDTO> buscarUsuario(UsuarioDTO usuario) throws Exception { SqlSession sesion = sqlMapper.openSession(); List<UsuarioDTO> lstUsuario = new ArrayList<UsuarioDTO>(); try { if (usuario == null) { lstUsuario = (List<UsuarioDTO>) sesion.selectList("usuario.SQL_listaUsuario"); } else { if (!usuario.getNom_usuario().isEmpty()) { lstUsuario = (List<UsuarioDTO>) sesion.selectList( "usuario.SQL_listaNom_usuario", "%" + usuario.getNom_usuario() + "%"); } } } finally { sesion.close(); } return lstUsuario; }
/** 获取部门 */ public List<Department> getDepart() { List<Department> list = null; SqlSession session = getSession(); try { list = session.selectList("user.getDepart", null); } catch (Exception e) { System.out.println("userDao层getDepart发生异常......"); e.printStackTrace(); } finally { session.close(); } return list; }
public List<ServerInfo> queryListById(int serverId) { String smtpId = "ServerInfo.queryById"; List<ServerInfo> list = null; try { session = sessionFactory.openSession(); list = session.selectList(smtpId, serverId); session.close(); } catch (Exception e) { session.rollback(); e.printStackTrace(); } return list; }
/** * Returns the list of all Contact instances from the database. * * @return the list of all Contact instances from the database. */ @SuppressWarnings("unchecked") public List<Blog> select() { SqlSessionFactory sqlSessionFactory = MyBatisConnectionFactory.getSqlSessionFactory(); SqlSession session = sqlSessionFactory.openSession(); try { List<Blog> list = session.selectList("Blog.selectBlog"); return list; } finally { session.close(); } }
/** * 获取用户list * * @param user * @return */ public List<User> getUserList(User user) { List<User> list = null; SqlSession session = getSession(); try { list = session.selectList("user.queryUser", user); } catch (Exception e) { System.out.println("userDao层getUserList发生异常....."); e.printStackTrace(); } finally { session.close(); } return list; }
/** * 抓取特定修改狀態所屬清單 * * @param id 上層的ID * @return List<TeleratesVo> */ public List<View_teleratesVo> listViewByUpdateStatus(TeleratesVo vo) { SqlSession session = null; List<View_teleratesVo> objs = null; try { session = getSession(); objs = session.selectList("teleRates.findViewByUpdateStatus", vo); } catch (Exception e) { e.printStackTrace(); logger.error(e.getMessage()); } finally { closeCoonnection(session); } return objs; }
@SuppressWarnings("unchecked") @Override public List<MenuDTO> obtenerMenu(Integer codCargo) { SqlSession sesion = sqlMapper.openSession(); List<MenuDTO> listaMenu = new ArrayList<MenuDTO>(); try { listaMenu = (List<MenuDTO>) sesion.selectList("menu.SQL_listaMenuXCargo", codCargo); } catch (Exception e) { System.out.println(e); } finally { sesion.close(); } return listaMenu; }
/** * 根據狀態值取得遠傳訂單資料 * * @param itemno String * @return FetorderVo */ public List<FetorderVo> listByBcode(String bcode) { SqlSession session = null; List<FetorderVo> objs = null; try { session = getSession(); objs = session.selectList("fetOrder.listByBcode", bcode); } catch (Exception e) { e.printStackTrace(); logger.error(e.getMessage()); } finally { closeCoonnection(session); } return objs; }
/** * 抓取指定電信系統商 * * @param long id * @return List<ProjectVo> */ public List<ProjectVo> findProjectByTeleCom(ProjectVo vo) { SqlSession session = null; List<ProjectVo> objs = null; try { session = getSession(); objs = session.selectList("project.findProjectByTeleId", vo); } catch (Exception e) { e.printStackTrace(); logger.error(e.getMessage()); } finally { closeCoonnection(session); } return objs; }
@Override protected List<Message> getItems(int offset, int limit) throws Exception { List<Map<String, Object>> maps; SqlSession session = SqlConfig.getSqlSessionManager().openSession(); params.put("offset", offset); params.put("limit", limit); try { maps = session.selectList("Message.getMessagesToPrune", params); } finally { session.close(); } List<Message> messages = new ArrayList<Message>(); DonkeyDao dao = daoFactory.getDao(); try { for (Map<String, Object> map : maps) { Long messageId = (Long) map.get("id"); long connectorReceivedDateMillis = ((Calendar) map.get("mm_received_date")).getTimeInMillis(); Map<Integer, ConnectorMessage> connectorMessages = null; connectorMessages = dao.getConnectorMessages(channelId, messageId); Message message = new Message(); message.setMessageId(messageId); message.setChannelId(channelId); message.setReceivedDate((Calendar) map.get("received_date")); message.setProcessed((Boolean) map.get("processed")); message.setServerId((String) map.get("server_id")); message.setImportId((Long) map.get("import_id")); message.getConnectorMessages().putAll(connectorMessages); messages.add(message); contentMessageIds.add(messageId); if (messageDateThreshold != null && connectorReceivedDateMillis < messageDateThreshold.getTimeInMillis()) { messageIds.add(messageId); } } return messages; } finally { dao.close(); } }
public static List<SolutionBin> getSolutions(String level_key) { SqlSession session = sqlSessionFactory.openSession(); List<SolutionBin> solutionList = null; System.out.println(level_key); try { solutionList = session.selectList("selectSolution", level_key); } catch (NullPointerException e) { System.out.println("error null list"); } finally { session.commit(); session.close(); } return solutionList; }