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);
}
