@Override public void updateThing(String type) throws SQLException { if (type.equals("BannerCount")) { SqlMapClient ibatis = Mapper.getSqlMapper(); ibatis.update("updateBannerCount", bid); } if (type.equals("BannerImage")) { try { uploadFile(); } catch (IOException e) { e.printStackTrace(); } bb = new BannerBean(); bb.setBanner_num(bid); bb.setAdmin_num(Integer.parseInt(session.get("admin_num"))); bb.setBanner_image_url(uploadFileName); SqlMapClient ibatis = Mapper.getSqlMapper(); ibatis.update("updateBannerImage", bb); } if (type.equals("BannerInfo")) { bb.setAdmin_num(Integer.parseInt(session.get("admin_num"))); SqlMapClient ibatis = Mapper.getSqlMapper(); ibatis.update("updateBannerInfo", bb); } }
@Override public void viewList(String type) throws SQLException { if (type.equals("Banner")) { SqlMapClient ibatis = Mapper.getSqlMapper(); bannerList = ibatis.queryForList("selectBannerList"); } }
@Override public void insertThing(String type) throws SQLException { if (type.equals("Banner")) { try { uploadFile(); } catch (IOException e) { e.printStackTrace(); } bb.setAdmin_num(Integer.parseInt(session.get("admin_num"))); bb.setBanner_image_url(uploadFileName); SqlMapClient ibatis = Mapper.getSqlMapper(); ibatis.insert("insertBanner", bb); } if (type.equals("BannerLog")) { SqlMapClient ibatis = Mapper.getSqlMapper(); ibatis.insert("insertBannerLog", blb); } }