@Override public List<Object> getProductByShop(int shopId) throws Exception { List<Object> list = new ArrayList<Object>(); SqlSession sqlSession = null; try { sqlSession = SessionUtils.getSession(); StockMapper stockMapper = sqlSession.getMapper(StockMapper.class); ProductMapper productMapper = sqlSession.getMapper(ProductMapper.class); List<Stock> stocks = stockMapper.selectByshopId(shopId); for (Stock stock : stocks) { Map<String, Object> map = new HashMap<String, Object>(); Product product = productMapper.selectByPrimaryKey(stock.getpId()); map.put("name", product.getpName()); map.put("num", stock.getsNum()); map.put("pid", stock.getpId()); map.put("price", product.getpPrice()); list.add(map); } } catch (Exception e) { throw e; } finally { SessionUtils.closeSession(sqlSession); } return list; }
public String deptuserDetailsLoad() throws Exception { SqlSession sqlSession = null; try { sqlSession = DbSessionFactory.getOracleSession(); allPermission = "*"; C_T_Sys_Dept_UserMapper mapper = sqlSession.getMapper(C_T_Sys_Dept_UserMapper.class); C_T_Sys_UserMapper usermapper = sqlSession.getMapper(C_T_Sys_UserMapper.class); // 根据主键取得流程基本信息 c_T_Sys_Dept_User = (C_T_Sys_Dept_User) mapper.selectByPrimaryKey(uuid); C_T_Sys_User user = null; if (c_T_Sys_Dept_User != null) { user = (C_T_Sys_User) usermapper.selectByPrimaryKey(c_T_Sys_Dept_User.getUserSysName()); userName = user.getUserName(); } // 取得部门基本信息 listDept = GetBaseInfor.getDepartmentBaseInfor("sort", sqlSession); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); return ERROR; } finally { if (sqlSession != null) { sqlSession.close(); sqlSession = null; } } return SUCCESS; }
@Before public void setUp() throws Exception { sqlSession = MybatisConnectionFactory.getSqlSessionFactory().openSession(); productMapper = sqlSession.getMapper(ProductMapper.class); priceMapper = sqlSession.getMapper(PriceMapper.class); setUpAppleJuice(); productMapper.createProduct(new Product("orange juice", "bad")); }
@Override public void getSubjectList( String searchType, int pageSize, int pageNum, String searchKey, Model model, String contextPath) { Subject2 subject2 = new Subject2(); subject2.setPageNum(pageNum); subject2.setPageSize(pageSize); subject2.setSearchKey(searchKey); subject2.setSearchType(searchType); if (searchKey.equals("[noKeyword]")) { subject2.setSearchKey(""); } if (pageNum == 0) subject2.setPageNum(1); if (pageSize == 0) subject2.setPageSize(8); if (searchType == null || searchType.equals("")) subject2.setSearchType("subject"); if (searchKey == null || searchKey.equals("")) subject2.setSearchKey(""); // 현 페이지 정보 int NowpageNum = subject2.getPageNum(); int NowpageSize = subject2.getPageSize(); int start = NowpageNum * NowpageSize - (NowpageSize - 1) - 1; subject2.setStartNum(start); List<Subject2> SubjectList = sqlSession.getMapper(SubjectDAO.class).getSubjectList(subject2); int SubjectListCount = sqlSession.getMapper(SubjectDAO.class).getSubjectListCount(subject2); model.addAttribute("SubjectListCount", SubjectListCount); // 페이징 처리 하단! int visiblePageNum = 10; int pagecount = 0; int beginPage = 0; int endPage = 0; if (SubjectListCount != 0) { // 게시물이 없는 경우 pagecount = SubjectListCount / NowpageSize; // 115건 = 11page if (SubjectListCount % NowpageSize > 0) { // 115건 = 나머지 5 true pagecount++; // 11page++ = 12page } beginPage = (NowpageNum - 1) / visiblePageNum * visiblePageNum + 1; // 10단위 계산 endPage = beginPage + (visiblePageNum - 1); if (endPage > pagecount) { endPage = pagecount; } } // view에 보낼 데이터 model.addAttribute("pagecount", pagecount); model.addAttribute("beginpage", beginPage); model.addAttribute("endpage", endPage); model.addAttribute("pageNum", NowpageNum); model.addAttribute("pageSize", NowpageSize); model.addAttribute("searchType", subject2.getSearchType()); // 검색어가 없는경우 재처리 if (subject2.getSearchKey().equals("")) subject2.setSearchKey("[noKeyword]"); model.addAttribute("searchKey", subject2.getSearchKey()); model.addAttribute("SubjectList", SubjectList); }
@Override public int sell(Map<Integer, Integer> sells, Date date, String bz, String uId, int shopId) throws Exception { int ret = 0; SqlSession sqlSession = null; try { sqlSession = SessionUtils.getSession(); SellMapper sellMapper = sqlSession.getMapper(SellMapper.class); SellDetailMapper sellDetailMapper = sqlSession.getMapper(SellDetailMapper.class); StockMapper stockMapper = sqlSession.getMapper(StockMapper.class); Sell sell = new Sell(); sell.setsBz(bz); sell.setsDate(date); sell.setShopId(shopId); sell.setuId(uId); sellMapper.insert(sell); Iterator<Integer> iterator = sells.keySet().iterator(); List<Stock> stocks = stockMapper.selectAll(); while (iterator.hasNext()) { SellDetail sellDetail = new SellDetail(); sellDetail.setSellId(sell.getsId()); sellDetail.setpId(iterator.next()); sellDetail.setsNum(sells.get(sellDetail.getpId())); sellDetailMapper.insert(sellDetail); for (Stock stock : stocks) { if (stock.getShopId() == shopId && stock.getpId() == sellDetail.getpId()) { if (stock.getsNum() >= sellDetail.getsNum()) { stock.setsNum(stock.getsNum() - sellDetail.getsNum()); stockMapper.updateByPrimaryKey(stock); } else { throw new Exception(); } } } } sqlSession.commit(); ret = 1; } catch (Exception e) { sqlSession.rollback(); throw e; } finally { SessionUtils.closeSession(sqlSession); } return ret; }
public long saveProduct(Product product) { ProductDaoIf productDao = session.getMapper(ProductDaoIf.class); long id = productDao.insertProduct(product); session.commit(); logger.debug("Product Insert Count:" + id); return id; }
public long savePhoto(Photo photo) { PhotoDaoIf photoDao = session.getMapper(PhotoDaoIf.class); int id = photoDao.insertPhoto(photo); session.commit(); logger.debug("Photo Insert Count:" + id); return id; }
public String filedutyofficerDelete() throws Exception { SqlSession sqlSession = null; try { sqlSession = DbSessionFactory.getOracleSession(); if (!"".equals(checkedIds)) { String[] arrUuids; arrUuids = checkedIds.split("%2C"); C_T_SYS_FiledutyofficerExample example = new C_T_SYS_FiledutyofficerExample(); C_T_SYS_FiledutyofficerMapper mapper = sqlSession.getMapper(C_T_SYS_FiledutyofficerMapper.class); for (String tempUuid : arrUuids) { example.or().andFiledutyofficerIdEqualTo(tempUuid); } mapper.deleteByExample(example); } jsonResult = Constants.DISP_OPERATION_SUCCESSFUL; sqlSession.commit(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); return ERROR; } finally { if (sqlSession != null) { sqlSession.close(); sqlSession = null; } } allPermission = "*"; return SUCCESS; }
@Override public int projectCount() { // TODO Auto-generated method stub MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class); int totalCount = memberMapper.projectCount(); return totalCount; }
@Override public int insertSubject(Subject subject, String start, String end) { subject.setCapacity(Integer.parseInt(subject.getCapacity_String().replace(",", ""))); subject.setLecture_totalday( Integer.parseInt(subject.getLecture_totalday_String().replace(",", ""))); subject.setTuition_fee(Integer.parseInt(subject.getTuition_fee_String().replace(",", ""))); Time start1 = Time.valueOf(start + ":00"); Time end1 = Time.valueOf(end + ":00"); long a = (end1.getTime() - start1.getTime()) / 1000; int time3 = (int) (subject.getLecture_totalday() * a); Subject subject2 = new Subject( subject.getSubject_id(), subject.getSubject_name(), subject.getCapacity(), subject.getSubject_explanation(), subject.getInstructional_objectives(), subject.getSubject_point(), subject.getLecture_target(), subject.getLecture_totalday(), subject.getTuition_fee(), subject.getLecture_content(), subject.getCenter_id(), start1, end1, time3 / 3600); return sqlSession.getMapper(SubjectDAO.class).insertSubject(subject2); }
private double calculatePriceProgress() { Price price = new Price(); price.setEntityid(propertyId); ArrayList<Price> prices = sqlSession.getMapper(PriceMapper.class).readByEntityId(price); int numDaysAhead = 0; if (!prices.isEmpty()) { Date earliestDate = prices.get(0).getDate(); Date latestDate = prices.get(0).getTodate(); for (int i = 1; i < prices.size(); i++) { Date fromDate = prices.get(i).getDate(); Date toDate = prices.get(i).getTodate(); /* Determine earliest date*/ if (fromDate.before(earliestDate)) { earliestDate = fromDate; } /* Determine latest date*/ if (toDate.after(latestDate)) { latestDate = toDate; } } numDaysAhead = Model.getDuration(earliestDate, latestDate); } double progress = numDaysAhead < 180 ? numDaysAhead * 100.0 / 180.0 : 100.0; return progress * priceWeightage; }
@Override public int add(String userid, String bookId, String price) { logger.info("PurchaseServiceImpl : add 진입"); SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd"); SimpleDateFormat sdf2 = new SimpleDateFormat("HHmmss"); Calendar c1 = Calendar.getInstance(); String purToday = sdf.format(c1.getTime()); String var = "-"; String strToday2 = sdf2.format(c1.getTime()); String result = purToday + var + strToday2; logger.info("넘어온 책 아이디 : " + bookId); logger.info("넘어온 유저 아이디 : " + userid); logger.info("넘어온 책 가격 : " + price); logger.info("생성된 주문번호 : " + result); int price_int = TypeChange(price); logger.info("형 변환된 책 가격 : " + price_int); purchase.setPurNum(result); purchase.setSum(price_int); purchase.setAccNum(purToday); purchase.setUserid(userid); purchase.setBookid(bookId); PurchaseMapper mapper = sqlSession.getMapper(PurchaseMapper.class); return mapper.add(purchase); }
public List<Map<String, Object>> list(Map<String, Object> params) { List<Map<String, Object>> list = new ArrayList<Map<String, Object>>(); SqlSession session = DbConnectionFactory.getSqlSessionFactory(dataSource).openSession(); try { MainAccountActivityGroupDAO dao = session.getMapper(MainAccountActivityGroupDAO.class); List<Map<String, Object>> tmpList = dao.list(params); String name = MainAccountActivityGroupConstant.TFN_NAME + params.get("lang"); for (Map<String, Object> tmpMap : tmpList) { Map<String, Object> map = new HashMap<String, Object>(); map.put( JsonConstant.COMBOBOX_ID, (Integer) tmpMap.get(MainAccountActivityGroupConstant.TFN_ID)); map.put(JsonConstant.COMBOBOX_NAME, (String) tmpMap.get(name.toUpperCase())); tmpMap = CommonUtil.removeThElement(tmpMap); map.put(JsonConstant.COMBOBOX_DATA, tmpMap); list.add(map); } } catch (Exception ex) { log.error(ex); } finally { session.close(); } return list; }
public void serialize(SqlSession sql, JsonGenerator jg) throws JsonGenerationException, IOException, IllegalTypeException { Map<String, GroupBean> sortedGroups = GroupsIE.getSortedGroups(sql, groupResolver); GroupsMapper mapper = sql.getMapper(GroupsMapper.class); jg.writeStartArray(); for (Map.Entry<String, GroupBean> entry : sortedGroups.entrySet()) { List<GroupElementBean> members = mapper.getMembers(entry.getValue().getId()); jg.writeStartObject(); jg.writeStringField("groupPath", entry.getKey()); jg.writeFieldName("members"); jg.writeStartArray(); for (GroupElementBean member : members) { jg.writeStartObject(); jg.writeNumberField("entity", member.getElementId()); jg.writeNumberField("groupId", member.getGroupId()); jg.writeBinaryField("contents", member.getContents()); jg.writeEndObject(); } jg.writeEndArray(); jg.writeEndObject(); } jg.writeEndArray(); }
@Override public Member getMember(String uid) { MemberDao dao = session.getMapper(MemberDao.class); return dao.getMember(uid); }
public Pedido getPedidoDAO(final String idPedido) { final SqlSession session = ConnectionFactory.getSqlSessionFactory().openSession(); final PedidoDAO pedidoDao = session.getMapper(PedidoDAO.class); final Pedido pedido = pedidoDao.getPedidoDAO(idPedido); session.close(); return pedido; }
public void atualizarStatusPedidoDAO(final Pedido pedido) { final SqlSession session = ConnectionFactory.getSqlSessionFactory().openSession(); final PedidoDAO pedidoDao = session.getMapper(PedidoDAO.class); pedidoDao.atualizarStatusPedidoDAO(pedido); session.commit(); session.close(); }
public long saveProductCategory(ProductCategory productCategory) { ProductCategoryDaoIf productCategoryDao = session.getMapper(ProductCategoryDaoIf.class); long id = productCategoryDao.insertProductCategory(productCategory); session.commit(); logger.debug("Product Category Insert Count:" + id); return id; }
public long saveProductTagScope(Long productId, Long tagId) { ProductTagScopeDaoIf productTagScopeDao = session.getMapper(ProductTagScopeDaoIf.class); long id = productTagScopeDao.insertProductTagScope(new ProductTagScope(productId, tagId)); session.commit(); logger.debug("Product Tag Scope Insert Count:" + id); return id; }
/* (non-Javadoc) * @see mx.com.bbva.bancomer.commons.business.BbvaIBusinessObject#createCommand(mx.com.bbva.bancomer.commons.model.dto.BbvaAbstractDataTransferObject) */ @Override public <T extends BbvaAbstractDataTransferObject> T createCommand( T bbvaAbstractDataTransferObject) { logger.debug("Entrada createCommand -- OK"); logger.debug("Datos de Entrada createCommand -- " + bbvaAbstractDataTransferObject.toString()); UsuarioVO usuarioVO = ((UsuarioDTO) bbvaAbstractDataTransferObject).getUsuarioVO(); String userName = usuarioVO.getNombreUsuario(); int idPerfil = usuarioVO.getIdPerfil(); int idEstatus = usuarioVO.getEstatusUsuario(); usuarioVO = readCommand(usuarioVO); ((UsuarioDTO) bbvaAbstractDataTransferObject).getUsuarioVO().setIdPerfil(idPerfil); ((UsuarioDTO) bbvaAbstractDataTransferObject).getUsuarioVO().setNombreUsuario(userName); ((UsuarioDTO) bbvaAbstractDataTransferObject).getUsuarioVO().setEstatusUsuario(idEstatus); if (usuarioVO == null) { SqlSession session = MapeadorSessionFactory.getSqlSessionFactory().openSession(); MapUsuario mapUsuario = session.getMapper(MapUsuario.class); try { mapUsuario.crearUsuario(((UsuarioDTO) bbvaAbstractDataTransferObject).getUsuarioVO()); session.commit(); } catch (Exception ex) { session.rollback(); ex.printStackTrace(); bbvaAbstractDataTransferObject.setErrorCode("SQL-001"); bbvaAbstractDataTransferObject.setErrorDescription(ex.getMessage()); } finally { session.close(); } logger.debug("Datos de Salida invoke -- " + bbvaAbstractDataTransferObject.toString()); logger.debug("Salida invoke -- OK"); } else { bbvaAbstractDataTransferObject.setErrorCode("0001"); bbvaAbstractDataTransferObject.setErrorDescription("El usuario ya existe"); } return bbvaAbstractDataTransferObject; }
/** * Read command. * * @param usuarioVO the usuario vo * @return the usuario vo */ private UsuarioVO readCommand(UsuarioVO usuarioVO) { logger.debug("Entrada createCommand -- OK"); usuarioVO.setIdPerfil(null); usuarioVO.setNombreUsuario(null); usuarioVO.setEstatusUsuario(null); logger.debug("Datos de Entrada createCommand -- " + usuarioVO.toString()); UsuarioVO result = null; try { SqlSession session = MapeadorSessionFactory.getSqlSessionFactory().openSession(); MapUsuario mapUsuario = session.getMapper(MapUsuario.class); if (usuarioVO != null && usuarioVO.getIdCveUsuario() != null) { logger.debug(":::::::::::::::::::::" + usuarioVO.getIdCveUsuario()); } try { result = mapUsuario.obtenerUsuarios(usuarioVO).get(0); } catch (Exception ex) { result = null; } finally { session.close(); } logger.debug("result: " + result + " -- **fin**"); logger.debug("Salida invoke -- OK"); return result; } catch (Exception ex) { ex.printStackTrace(); return result; } }
@Override public ArrayList<Member> userAssignList(int PRO_ID) { // TODO Auto-generated method stub MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class); ArrayList<Member> result = memberMapper.userAssignList(PRO_ID); return result; }
@Override public Project selectNewProject(Project project) { // TODO Auto-generated method stub MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class); Project p = memberMapper.selectNewProject(project); return p; }
/** 测试新增 */ @Test public void insert() { SqlSession session = null; try { CalculationRecordModel model = new CalculationRecordModel(); model.setCreatedTime(new Date()); model.setCurrentNumber(1.0); model.setPreNumber(2.0); model.setOperator("*"); model.setResult(3.0); model.setStatus(1); model.setMacAddress("pc1"); session = sessionFactory.openSession(); CalculationDao calculationDao = session.getMapper(CalculationDao.class); // calculationDao.insertCalculationRecord(model); List<Integer> Ids = new ArrayList<Integer>(); Ids.add(3); Ids.add(4); // int[] Ids = {1,2}; List<CalculationRecordModel> modelList = calculationDao.getCalculationRecordByID(Ids); for (CalculationRecordModel calculationRecordModel : modelList) { System.out.println(calculationRecordModel); } session.commit(); } catch (Exception e) { e.printStackTrace(); } finally { session.close(); } }
@Override public ArrayList<Member> selectJoinMember(int PRO_ID) { // TODO Auto-generated method stub MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class); ArrayList<Member> member = memberMapper.selectJoinMember(PRO_ID); return member; }
public int countProductCaptures(int status) { ProductCaptureDaoIf productCaptureDao = session.getMapper(ProductCaptureDaoIf.class); Integer count = productCaptureDao.countProductCaptures(status); session.commit(); logger.debug("Count product capture list:" + count); return count; }
/** @param args */ public static void main(String[] args) { // TODO Auto-generated method stub CompositeConfiguration config = new CompositeConfiguration(); config.addConfiguration(new SystemConfiguration()); try { config.addConfiguration(new PropertiesConfiguration("storage.properties")); } catch (ConfigurationException e) { // TODO Auto-generated catch block logger.error(e.getMessage()); } String rootFolder = config.getString("bp.root.folder"); String altpartyid = args[0]; SqlSession sqlSession = RazorServer.openSession(); try { if (StringUtils.isBlank(altpartyid)) { // altpartyid = "231051"; //NextPax partner GA altpartyid = "179795"; } Partner partner = sqlSession.getMapper(PartnerMapper.class).exists(altpartyid); if (partner == null) { throw new ServiceException(Error.party_id, altpartyid); } A_Handler handler = new A_Handler(partner); handler.downloadImages(rootFolder); } catch (Exception e) { logger.error(e.getMessage()); } }
public ProductCapture selectOneProductCapture(long id) { ProductCaptureDaoIf productCaptureDao = session.getMapper(ProductCaptureDaoIf.class); ProductCapture captureProduct = productCaptureDao.selectOneProductCapture(id); session.commit(); logger.debug("Select product capture Count:" + captureProduct); return captureProduct; }
public String fileDutyOfficerUpdate() throws Exception { SqlSession sqlSession = null; try { sqlSession = DbSessionFactory.getOracleSession(); C_T_SYS_Filedutyofficer record = new C_T_SYS_Filedutyofficer(); C_T_SYS_FiledutyofficerMapper mapper = sqlSession.getMapper(C_T_SYS_FiledutyofficerMapper.class); if (null == c_T_SYS_Filedutyofficer.getFiledutyofficerId() || "".equals(c_T_SYS_Filedutyofficer.getFiledutyofficerId().trim())) { c_T_SYS_Filedutyofficer.setFiledutyofficerId((new GUID().toString())); DbSetData.setPerporyData(c_T_SYS_Filedutyofficer, record, 2); mapper.insertSelective(record); } else { DbSetData.setPerporyData(c_T_SYS_Filedutyofficer, record, 1); mapper.updateByPrimaryKey(record); } jsonResult = Constants.DISP_OPERATION_SUCCESSFUL; sqlSession.commit(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); return ERROR; } finally { if (sqlSession != null) { sqlSession.close(); sqlSession = null; } } allPermission = "*"; return SUCCESS; }
public long saveResource(FileData fileData) { FileDataDaoIf fileDataDao = session.getMapper(FileDataDaoIf.class); int id = fileDataDao.insertFileData(fileData); session.commit(); logger.debug("Resource Insert Count:" + id); return id; }