public boolean delete(int messageno) throws SQLException { // TODO Auto-generated method stub // 메세지 삭제 int t = sqlSession.delete("user.messagedelete", messageno); if (t == 1) return true; return false; }
@Override public void deleteBook(String booknum) { session.delete(NAMESPACE + "deleteBook", booknum); // TODO Auto-generated method stub }
@Override public void deletemv(List<Map<String, Object>> mapList) { // TODO Auto-generated method stub for (Map<String, Object> map : mapList) { sqlSession.delete("Test.deletemv", map); } }
private int aplicarOperacion(String nombreSQL, BaseBean bean, String comando) { SqlSession sqlSession = this.sqlSessionFactory.openSession(); int rowAffected = 0; try { switch (comando) { case "INSERT": rowAffected = sqlSession.insert(nombreSQL, bean); break; case "UPDATE": rowAffected = sqlSession.update(nombreSQL, bean); break; case "DELETE": rowAffected = sqlSession.delete(nombreSQL, bean); break; default: LOGGER_INFO.info("No se reconoce el comando " + comando); } if (rowAffected > 0) sqlSession.commit(); } catch (Exception e) { LOGGER_ERROR.error( "Se ha presentando el siguiente error a la hora de ejecutar el comando " + comando + " " + nombreSQL, e); } finally { sqlSession.close(); } return rowAffected; }
@Override public <T> void batchDelete(String mapperId, List<T> t) { SqlSession session = sqlSessionFactory.openSession(ExecutorType.BATCH, true); session.delete(mapperId, t); session.commit(); }
/** * 根據id刪除主專案 * * @return boolean 成功或失敗 */ public boolean deletePrjInfo(long id) { SqlSession session = null; boolean status = false; int cnt = 0; try { session = getSession(false); Project_subsetVo psVo = new Project_subsetVo(); ProjectSubsetDao psDao = new ProjectSubsetDao(getDataSourceEnvironment()); List<Project_subsetVo> psList = null; // 根據主專案id先取得所屬子專案資料 psList = psDao.findByPrjId(id); Project_aggregateVo paVo = new Project_aggregateVo(); ProjectAggregateDao paDao = new ProjectAggregateDao(getDataSourceEnvironment()); if (!NullTK.isNull(psList)) { for (Project_subsetVo d : psList) { List<Project_aggregateVo> paList = null; View_project_aggregateVo rvo = new View_project_aggregateVo(); // 根據子專案id取得所屬銷售組合之資料 paList = paDao.findBySubsetId(d.getId()); for (Project_aggregateVo dd : paList) { // 根據銷售組合資料刪除所屬的費率與佣金資料 cnt = session.delete("rates.deleteById", dd.getRateid()); cnt = session.delete("commission.deleteById", dd.getComissionid()); } // 根據子專案id刪除所屬隻銷售組合資料 cnt = session.delete("projectAggregate.deleteBySubsetId", d.getId()); } cnt = session.delete("projectSubset.deleteByPrjId", id); } cnt = session.delete("project.deleteById", id); session.commit(); if (cnt > 0) { status = true; } } catch (Exception e) { e.printStackTrace(); logger.error(e.getMessage()); session.rollback(); } finally { closeCoonnection(session); } return status; }
protected void delete(String sqlKey, Object object) { SqlSession session = sqlSessionFactory.openSession(); try { session.delete(sqlKey, object); } finally { session.close(); } }
@Test public void deleteUser() throws IOException { InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml"); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream); SqlSession sqlSession = sessionFactory.openSession(); sqlSession.delete("test.deleteUserById", 26); sqlSession.close(); }
private void removeTranscriptions(final String selector, final Sid sid) { final SqlSession session = sessions.openSession(); try { session.delete(selector, sid.toString()); session.commit(); } finally { session.close(); } }
@Override public boolean deleteAll() { SqlSession session = util.getSqlsession(); if (session.delete("log.deleteAll") > 0) { session.commit(); return true; } return false; }
@Override public boolean delete(String authId) { try { sqlSession.delete("delete", authId); } catch (Exception e) { e.printStackTrace(); return false; } return true; }
public int delete(int no) throws Exception { SqlSession sqlSession = sqlSessionFactory.openSession(); try { sqlSession.delete("net.bitacademy.java41.dao.ProjectMapper.deleteProjectMember", no); sqlSession.delete("net.bitacademy.java41.dao.ProjectMapper.delete", no); sqlSession.commit(); return 1; } catch (Exception e) { sqlSession.rollback(); throw e; } finally { try { sqlSession.close(); } catch (Exception e) { } } }
public int delete(int no) throws Exception { SqlSession sqlSession = sqlSessionFactory.openSession(); try { int count = sqlSession.delete("spms.dao.MemberDao.delete", no); sqlSession.commit(); return count; } finally { sqlSession.close(); } }
public void deleteGood(long good_id) { SqlSession session = SessionFactory.getSessionFactory().openSession(); try { session.delete("UserMapper.deleteGood", good_id); session.commit(); } catch (Exception e) { e.printStackTrace(); } finally { session.close(); } }
public int deleteRegionById(String id) throws Exception { int delete = 0; SqlSession session = sqlMapper.openSession(); try { delete = session.delete("deleteRegionById", id); session.commit(); } finally { if (session != null) session.close(); } return delete; }
public void del(HotelDirectoryServicios hotelDirectoryServicios) { SqlSession session = sql.openSession(); try { session.delete("SqlMapHotelDirectoryServicios.delete", hotelDirectoryServicios); session.commit(); } catch (Exception e) { Logger.getLogger(this.getClass()).error(e.getMessage()); } finally { session.close(); } }
public Object execute(SqlSession sqlSession, Object[] args) { Object result; switch (command.getType()) { case INSERT: { Object param = method.convertArgsToSqlCommandParam(args); result = rowCountResult(sqlSession.insert(command.getName(), param)); break; } case UPDATE: { Object param = method.convertArgsToSqlCommandParam(args); result = rowCountResult(sqlSession.update(command.getName(), param)); break; } case DELETE: { Object param = method.convertArgsToSqlCommandParam(args); result = rowCountResult(sqlSession.delete(command.getName(), param)); break; } case SELECT: if (method.returnsVoid() && method.hasResultHandler()) { executeWithResultHandler(sqlSession, args); result = null; } else if (method.returnsMany()) { result = executeForMany(sqlSession, args); } else if (method.returnsMap()) { result = executeForMap(sqlSession, args); } else if (method.returnsCursor()) { result = executeForCursor(sqlSession, args); } else { Object param = method.convertArgsToSqlCommandParam(args); result = sqlSession.selectOne(command.getName(), param); } break; case FLUSH: result = sqlSession.flushStatements(); break; default: throw new BindingException("Unknown execution method for: " + command.getName()); } if (result == null && method.getReturnType().isPrimitive() && !method.returnsVoid()) { throw new BindingException( "Mapper method '" + command.getName() + " attempted to return null from a method with a primitive return type (" + method.getReturnType() + ")."); } return result; }
@Override public Object eliminarUsuario(UsuarioDTO objUsuario) throws Exception { Boolean result = false; SqlSession session = sqlMapper.openSession(); try { session.delete("usuario.SQL_deleteUsuario", objUsuario.getCod_usuario()); session.commit(); result = true; } finally { session.close(); } return result; }
/** * 删除用户 * * @param user * @return 删除id */ public int deleteUser(User user) { int i = 0; SqlSession session = getSession(); try { i = session.delete("user.deleteUser", user); session.commit(); } catch (Exception e) { System.out.println("userDao层deleteUser发生异常....."); e.printStackTrace(); } finally { session.close(); } return i; }
@Override public int removeNotice(String code) { // TODO Auto-generated method stub SqlSession session = factory.openSession(); int result = 0; try { result = session.delete("com.fantastic.web.dao.NoticeDao.removeNotice", code); session.commit(); } finally { session.rollback(); session.close(); } return result; }
@Test public void testDeleteUser() { // 通过sqlSessionFactory创建sqlSession SqlSession sqlSession = sqlSessionFactory.openSession(); // 通过sqlSession操作数据库 // 第一个参数:statement位置,等于namespace+statement的id // 第二个参数:传入的参数 try { sqlSession.delete("test.deleteUser", 38); sqlSession.commit(); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } finally { sqlSession.close(); } }
/** * 根據id刪除主專案 * * @return boolean 成功或失敗 */ public boolean delete(long id) { SqlSession session = null; boolean status = false; try { session = getSession(false); int cnt = session.delete("project.deleteById", id); session.commit(); if (cnt > 0) { status = true; } } catch (Exception e) { e.printStackTrace(); logger.error(e.getMessage()); session.rollback(); } finally { closeCoonnection(session); } return status; }
public Object execute(SqlSession sqlSession, Object[] args) { Object result; if (SqlCommandType.INSERT == command.getType()) { Object param = method.convertArgsToSqlCommandParam(args); result = rowCountResult(sqlSession.insert(command.getName(), param)); } else if (SqlCommandType.UPDATE == command.getType()) { Object param = method.convertArgsToSqlCommandParam(args); result = rowCountResult(sqlSession.update(command.getName(), param)); } else if (SqlCommandType.DELETE == command.getType()) { Object param = method.convertArgsToSqlCommandParam(args); result = rowCountResult(sqlSession.delete(command.getName(), param)); } else if (SqlCommandType.SELECT == command.getType()) { if (method.returnsVoid() && method.hasResultHandler()) { executeWithResultHandler(sqlSession, args); result = null; } else if (method.returnsMany()) { result = executeForMany(sqlSession, args); } else if (method.returnsMap()) { result = executeForMap(sqlSession, args); } else { Object param = method.convertArgsToSqlCommandParam(args); result = sqlSession.selectOne(command.getName(), param); } } else { throw new BindingException("Unknown execution method for: " + command.getName()); } if (result == null && method.getReturnType().isPrimitive() && !method.returnsVoid()) { throw new BindingException( "Mapper method '" + command.getName() + " attempted to return null from a method with a primitive return type (" + method.getReturnType() + ")."); } return result; }
@Override public int deleteArticle_career(int user_history_id) { return sqlSession.delete("User.deleteArticle_career", user_history_id); }
@Override public int deleteArticle_introduce(int user_history_id) { return sqlSession.delete("User.deleteArticle_introduce", user_history_id); }
public int delete(String statement, Object parameter) { increment(); return session.delete(statement, parameter); }
public int delete(String statement) { increment(); return session.delete(statement); }
@Override public int removeBoardAttachments(String boardCode) { return session.delete("removeBoardAttachments", boardCode); }
@Override public int removeBoardAttachment(String code) { return session.delete("removeBoardAttachment", code); }
@Override public void deleteBzmc(String YWXH) { sqlSession.delete("com.rongda.model.cmsbzmc.delete_bzmc", YWXH); }