Example usage for org.apache.ibatis.session SqlSession delete

List of usage examples for org.apache.ibatis.session SqlSession delete

  1. HOME
  2. Java
  3. org.apache.ibatis
  4. org.apache.ibatis.session.*
  5. SqlSession
  6. delete

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession delete.

Prototype

int delete(String statement, Object parameter);

Source Link

Document

Execute a delete statement.

Usage

From source file:action.manageParticipatedPost.java

public String exitparticipation() throws IOException {

    String resource = "orm/configuration.xml";
    Reader reader = Resources.getResourceAsReader(resource);
    SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
    SqlSession session = sessionFactory.openSession();

    da = new driverapply();

    System.out.println("selected passenger's postID in exit=" + postID);
    System.out.println("Driver's email in exit=" + postID);

    try {//from w w w  .  j  a va 2 s.  c om
        //user's email as a driver
        email = ActionContext.getContext().getSession().get("email").toString();
        int res;
        res = JOptionPane.showConfirmDialog(null, "Are you sure you want to exit the participation?", "Confirm",
                JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE);
        if (res == JOptionPane.YES_OPTION) {
            //select record from postaspassenger table, get its numberofapplieddrivers
            paplist = session.selectList("selectPassengerPostByID", postID);
            numberofapplieddrivers = paplist.get(0).getNumberofapplieddrivers();

            //delete participation record from driverapply table
            da.setDriveremail(email);
            da.setPassengerpostID(postID);
            session.delete("deleteparticipation", da);
            session.commit();

            //update attribute of numberofapplieddrivers in postaspassenger table 
            pap = new postaspassenger();
            pap.setPostID(postID);
            pap.setNumberofapplieddrivers(String.valueOf(Integer.parseInt(numberofapplieddrivers) - 1));
            session.update("updatenumberofapplieddrivers", pap);
            session.commit();

            return "deleteandupdateok";
        } else {
            return "nodeleteandupdate";
        }
    } finally {
        session.close();
    }

}

From source file:action.manageParticipatedPost.java

public String exitparticipation2() throws IOException {

    String resource = "orm/configuration.xml";
    Reader reader = Resources.getResourceAsReader(resource);
    SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
    SqlSession session = sessionFactory.openSession();

    pa = new passengerapply();

    System.out.println("selected driver's postID in exit2=" + postID);
    System.out.println("passenger's email in exit2=" + postID);

    try {/*from   w ww. ja v a2  s. co m*/
        //user's email as a passenger
        email = ActionContext.getContext().getSession().get("email").toString();
        int res;
        res = JOptionPane.showConfirmDialog(null, "Are you sure you want to exit the participation?", "Confirm",
                JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE);
        if (res == JOptionPane.YES_OPTION) {
            //select record from postasdriver table, get its numberofappliedpassengers
            padlist = session.selectList("selectPostByID", postID);
            numberofappliedpassengers = padlist.get(0).getNumberofappliedpassengers();

            //delete participation record from passengerapply table
            pa.setPassengeremail(email);
            pa.setDriverpostID(postID);
            ;
            session.delete("deleteparticipation2", pa);
            session.commit();

            //update attribute of numberofapplieddrivers in postaspassenger table 
            pad = new postasdriver();
            pad.setPostID(postID);
            pad.setNumberofappliedpassengers(String.valueOf(Integer.parseInt(numberofappliedpassengers) - 1));
            session.update("updatenumberofappliedpassengers", pad);
            session.commit();

            JOptionPane.showMessageDialog(null, "You have exited the participation successfully!", "Message",
                    JOptionPane.INFORMATION_MESSAGE);

            return "deleteandupdateok2";
        } else {

            return "nodeleteandupdate2";
        }
    } finally {
        session.close();
    }

}

From source file:action.managePost.java

public String deletepost() throws IOException {
    //connect database
    String resource = "orm/configuration.xml";
    Reader reader = Resources.getResourceAsReader(resource);
    SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
    SqlSession session = sessionFactory.openSession();

    try {// w w  w.j a  v a2s .c  o  m
        System.out.println("postID in delete as driver=" + postID);
        passengerapplylist = session.selectList("selectpassengerapplybypostID", postID);
        int res = JOptionPane.showConfirmDialog(null, "Are you sure you want to delete this post?", "Confirm",
                JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE);
        if (res == JOptionPane.YES_OPTION) {
            if (passengerapplylist.size() > 0) {
                session.delete("deletepost", postID);
                session.commit();

                session.delete("deletedriverpost", postID);
                session.commit();
                JOptionPane.showMessageDialog(null, "Post is deleted!", "Message",
                        JOptionPane.INFORMATION_MESSAGE);
                return "deletepostok";
            }

            else {
                session.delete("deletedriverpost", postID);
                session.commit();
                JOptionPane.showMessageDialog(null, "Post is deleted!", "Message",
                        JOptionPane.INFORMATION_MESSAGE);
                return "deletepostok";
            }
        } else {
            return "nodeletepost";
        }
    } finally {
        session.close();
    }
}

From source file:action.managePost.java

public String deletepostaspassenger() throws IOException {
    //connect database
    String resource = "orm/configuration.xml";
    Reader reader = Resources.getResourceAsReader(resource);
    SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
    SqlSession session = sessionFactory.openSession();

    try {/* w w w  . j  av a 2  s.  c  o m*/
        System.out.println("postID in delete as passenger=" + postID);
        driverapplylist = session.selectList("selectdriverapplybypostID", postID);
        int res = JOptionPane.showConfirmDialog(null, "Are you sure you want to delete this post?", "Confirm",
                JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE);
        if (res == JOptionPane.YES_OPTION) {
            if (driverapplylist.size() > 0) {
                session.delete("deletepostindriverapply", postID);
                session.commit();

                session.delete("deletepassengerpost", postID);
                session.commit();
                JOptionPane.showMessageDialog(null, "Post is deleted!", "Message",
                        JOptionPane.INFORMATION_MESSAGE);
                return "deletepostok2";
            }

            else {
                session.delete("deletepassengerpost", postID);
                session.commit();
                JOptionPane.showMessageDialog(null, "Post is deleted!", "Message",
                        JOptionPane.INFORMATION_MESSAGE);
                return "deletepostok2";
            }
        } else {
            return "nodeletepost2";
        }
    } finally {
        session.close();
    }
}

From source file:com.beginner.core.dao.DaoSupport.java

License:Apache License

/** 
 * {@inheritDoc}/*from   www.j  a  v a 2  s . co m*/
 */
@Override
public void batchDelete(String str, List objs) throws Exception {
    SqlSessionFactory sqlSessionFactory = sqlSessionTemplate.getSqlSessionFactory();
    //?
    SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH, false);
    try {
        if (objs != null) {
            for (int i = 0, size = objs.size(); i < size; i++) {
                sqlSession.delete(str, objs.get(i));
            }
            sqlSession.flushStatements();
            sqlSession.commit();
            sqlSession.clearCache();
        }
    } finally {
        sqlSession.close();
    }
}

From source file:com.company.project.service.UserMapperImpl.java

License:Apache License

public int delete(String username) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from   w  w  w. jav a 2  s .c  o  m
        return session.delete("com.company.project.persistence.UserMapper.delete", username);
    } catch (Exception e) {
        e.printStackTrace();
        session.rollback();
    } finally {
        session.close();
    }

    return 0;
}

From source file:com.gordcorp.jira2db.persistence.JiraCustomFieldDao.java

License:Open Source License

public int deleteAllByJiraKey(String jiraKey) throws PersistenceException {
    SqlSession session = sf.openSession();
    int status = 0;
    try {/*  ww  w  .  j ava2  s.  c  o  m*/
        String query = NAMESPACE + "." + PREFIX_DELETE_QUERY + this.type.getSimpleName() + "ByJiraKey";
        status = session.delete(query, jiraKey);
        session.commit();
    } finally {
        session.close();
    }
    return status;
}

From source file:com.gordcorp.jira2db.persistence.JiraIssueDao.java

License:Open Source License

public int deleteByJiraKey(String jiraKey) throws PersistenceException {
    SqlSession session = sf.openSession();
    int status = 0;
    try {/*from  w w w. j  a va2 s. c o  m*/
        String query = NAMESPACE + "." + PREFIX_DELETE_QUERY + this.type.getSimpleName() + "ByJiraKey";
        status = session.delete(query, jiraKey);
        session.commit();
    } finally {
        session.close();
    }
    return status;
}

From source file:com.gordcorp.jira2db.persistence.MyBatisDao.java

License:Open Source License

/**
 * Method deletes the object by id. </br></br> Example: </br> If your DAO
 * object is called CarInfo.java, the corresponding mapper query id should
 * be: &lt;delete id="deleteCarInfo" ... </br></br> SQL Executed (example):
 * update [tablename] set fieldname1 = value1 where id = #{id}
 * //from   w  w w .  java  2s. c o  m
 */
@Override
public int delete(PK id) throws PersistenceException {
    SqlSession session = sf.openSession();
    int status = 0;
    try {
        String query = NAMESPACE + "." + PREFIX_DELETE_QUERY + this.type.getSimpleName();
        status = session.delete(query, id);
        session.commit();
    } finally {
        session.close();
    }
    return status;
}

From source file:com.inform.project.dao.MyBatisAdminImpl.java

@Override
public void deleteObject(int id) {
    SqlSession session = null;
    try {//from w  w w .  j a  v  a 2 s.com
        session = MyBatisSession.getInst().getSession().openSession();
        session.delete("GetUsersMapper.deleteOne", id);
        session.commit();
    } catch (IOException ex) {
        Logger.getLogger(MyBatisAdminImpl.class.getName()).log(Level.SEVERE, null, ex);
    } finally {
        if (session != null) {
            session.close();
        }
    }

}