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

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

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

Introduction

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

Prototype

@Override
void close();

Source Link

Document

Closes the session.

Usage

From source file:PersistenceTest.java

License:Open Source License

@Test
public void CE2() {
    SqlSessionFactory sessionfact = getSqlSessionFactory();
    SqlSession sqlss = sessionfact.openSession();
    PacienteMapper pm = sqlss.getMapper(PacienteMapper.class);
    Paciente p = new Paciente(98796, "TI", "Carmenzo", Date.valueOf("1995-07-10"));
    pm.insertPaciente(p);//ww w .j  a  v  a  2  s .c  o  m
    sqlss.commit();
    Paciente test = pm.loadPacienteById(p.getId(), p.getTipo_id());
    sqlss.close();
    Assert.assertEquals(test.toString(), p.toString());
}

From source file:PersistenceTest.java

License:Open Source License

@Test
public void CE3() {
    SqlSessionFactory sessionfact = getSqlSessionFactory();
    SqlSession sqlss = sessionfact.openSession();
    PacienteMapper pm = sqlss.getMapper(PacienteMapper.class);
    Paciente p1 = new Paciente(123, "CC", "German Lopez", new Date(1994, 10, 10));
    Consulta c1 = new Consulta(new Date(2016, 1, 13), "El paciente presenta fiebre alta");
    Set<Consulta> consultas = new LinkedHashSet<Consulta>();
    consultas.add(c1);/*from  www . java 2s.c om*/
    p1.setConsultas(consultas);
    pm.insertPaciente(p1);
    sqlss.commit();
    for (Consulta c : p1.getConsultas()) {
        pm.insertConsulta(c, p1.getId(), p1.getTipo_id());
        sqlss.commit();
    }
    Paciente test = pm.loadPacienteById(p1.getId(), p1.getTipo_id());
    sqlss.close();
    LinkedList<String> cadenas = new LinkedList<>();
    boolean funciona = p1.getId() == test.getId() && p1.getTipo_id().equals(test.getTipo_id())
            && p1.getNombre().equals(test.getNombre())
            && p1.getFechaNacimiento().equals(test.getFechaNacimiento());
    for (Consulta c : test.getConsultas()) {
        cadenas.add(c.toString().split(",")[1] + c.toString().split(",")[2]);
    }
    for (Consulta c : p1.getConsultas()) {
        funciona = funciona && cadenas.contains(c.toString().split(",")[1] + c.toString().split(",")[2]);
    }
    Assert.assertTrue(funciona);
}

From source file:action.findDriver.java

public List<postasdriver> findlist() 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 {/*from www.java  2s .  co  m*/

        postlist = session.selectList("selectAllPostAsDriver");
        System.out.println("postlist size=" + postlist.size());
        return postlist;

    } finally {
        session.close();
    }

}

From source file:action.findDriver.java

public List<detailsofdriverpost> seedetailslist() 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 {/*  www. j  a  v a 2s .c o  m*/

        postlist = session.selectList("selectPostByID", postID);
        System.out.println("postlist size in seeDetails=" + postlist.size());

        //find driver's name through his email address
        numberofappliedpassengers = postlist.get(0).getNumberofappliedpassengers();
        driveremail = postlist.get(0).getEmail();
        driverlist = session.selectList("selectuserbyemail", driveremail);

        drivername = driverlist.get(0).getName();
        driversex = driverlist.get(0).getSex();
        driverdob = driverlist.get(0).getDob();
        driverlicense = driverlist.get(0).getDriverlicense();

        dd = new detailsofdriverpost();
        detaillist = new ArrayList<detailsofdriverpost>();

        dd.setAvailableseats(postlist.get(0).getAvailableseats());
        dd.setCartype(postlist.get(0).getCartype());
        dd.setDeparture(postlist.get(0).getDeparture());
        dd.setDeparturedate(postlist.get(0).getDeparturedate());
        dd.setDestination(postlist.get(0).getDestination());
        dd.setDob(driverdob);
        dd.setDriverlicense(driverlicense);
        dd.setEmail(driveremail);
        dd.setEstimatedcostperpassenger(postlist.get(0).getEstimatedcostperpassenger());
        dd.setEstimatedleavingtime(postlist.get(0).getEstimatedleavingtime());
        dd.setEstimatedtotalcost(postlist.get(0).getEstimatedtotalcost());
        dd.setMemo(postlist.get(0).getMemo());
        dd.setName(drivername);
        dd.setPostID(postID);
        dd.setSex(driversex);
        dd.setPhone(postlist.get(0).getPhone());
        dd.setNumberofappliedpassengers(numberofappliedpassengers);
        detaillist.add(dd);

        return detaillist;

    } finally {
        session.close();
    }
}

From source file:action.manageParticipatedPost.java

public String asDriver() throws IOException {

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

    try {/* w  ww. j a v a  2s.  co m*/
        //user's email as a driver
        email = ActionContext.getContext().getSession().get("email").toString();
        dlist = session.selectList("selectdriverapplybydriveremail", email);
        System.out.println("selected passengers as a driver=" + dlist.size());

        detaillist = new ArrayList<detailsofpassengerpost>();

        for (int i = 0; i < dlist.size(); ++i) {
            passengerpostID = dlist.get(i).getPassengerpostID();
            passengeremail = dlist.get(i).getPassengeremail();

            //get passenger's basic information like sex, name,dob
            passengerinfolist = session.selectList("selectuserbyemail", passengeremail);

            //get passenger's post detailed information
            paplist = session.selectList("selectPassengerPostByID", passengerpostID);

            detailpassengerpost = new detailsofpassengerpost();

            passengername = passengerinfolist.get(0).getName();
            sex = passengerinfolist.get(0).getSex();
            dob = passengerinfolist.get(0).getDob();
            departure = paplist.get(0).getDeparture();
            destination = paplist.get(0).getDestination();
            departuredate = paplist.get(0).getDeparturedate();
            estimatedleavingtime = paplist.get(0).getEstimatedleavingtime();
            needseats = paplist.get(0).getNeedseats();
            expectedcartype = paplist.get(0).getExpectedcartype();
            expectedcost = paplist.get(0).getExpectedcost();
            phone = paplist.get(0).getPhone();
            memo = paplist.get(0).getMemo();
            numberofapplieddrivers = paplist.get(0).getNumberofapplieddrivers();

            detailpassengerpost.setDeparture(departure);
            detailpassengerpost.setDeparturedate(departuredate);
            detailpassengerpost.setDestination(destination);
            detailpassengerpost.setDob(dob);
            detailpassengerpost.setEmail(passengeremail);
            detailpassengerpost.setEstimatedleavingtime(estimatedleavingtime);
            detailpassengerpost.setExpectedcartype(expectedcartype);
            detailpassengerpost.setExpectedcost(expectedcost);
            detailpassengerpost.setMemo(memo);
            detailpassengerpost.setName(passengername);
            detailpassengerpost.setNeedseats(needseats);
            detailpassengerpost.setNumberofapplieddrivers(numberofapplieddrivers);
            detailpassengerpost.setPhone(phone);
            detailpassengerpost.setPostID(passengerpostID);
            detailpassengerpost.setSex(sex);
            detaillist.add(detailpassengerpost);
        }
        return SUCCESS;

    } finally {
        session.close();
    }

}

From source file:action.manageParticipatedPost.java

public String seedetails() throws IOException {
    String resource = "orm/configuration.xml";
    Reader reader = Resources.getResourceAsReader(resource);
    SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
    SqlSession session = sessionFactory.openSession();
    try {//from   ww w.j  a va  2 s. c  o m

        System.out.println("selected passenger's postID in see details=" + postID);
        paplist = session.selectList("selectPassengerPostByID", postID);
        detaillist = new ArrayList<detailsofpassengerpost>();

        detailpassengerpost = new detailsofpassengerpost();
        passengeremail = paplist.get(0).getEmail();

        passengerinfolist = session.selectList("selectuserbyemail", passengeremail);

        passengername = passengerinfolist.get(0).getName();
        sex = passengerinfolist.get(0).getSex();
        dob = passengerinfolist.get(0).getDob();
        departure = paplist.get(0).getDeparture();
        destination = paplist.get(0).getDestination();
        departuredate = paplist.get(0).getDeparturedate();
        estimatedleavingtime = paplist.get(0).getEstimatedleavingtime();
        needseats = paplist.get(0).getNeedseats();
        expectedcartype = paplist.get(0).getExpectedcartype();
        expectedcost = paplist.get(0).getExpectedcost();
        phone = paplist.get(0).getPhone();
        memo = paplist.get(0).getMemo();
        numberofapplieddrivers = paplist.get(0).getNumberofapplieddrivers();

        detailpassengerpost.setDeparture(departure);
        detailpassengerpost.setDeparturedate(departuredate);
        detailpassengerpost.setDestination(destination);
        detailpassengerpost.setDob(dob);
        detailpassengerpost.setEmail(passengeremail);
        detailpassengerpost.setEstimatedleavingtime(estimatedleavingtime);
        detailpassengerpost.setExpectedcartype(expectedcartype);
        detailpassengerpost.setExpectedcost(expectedcost);
        detailpassengerpost.setMemo(memo);
        detailpassengerpost.setName(passengername);
        detailpassengerpost.setNeedseats(needseats);
        detailpassengerpost.setNumberofapplieddrivers(numberofapplieddrivers);
        detailpassengerpost.setPhone(phone);
        detailpassengerpost.setPostID(postID);
        detailpassengerpost.setSex(sex);
        detaillist.add(detailpassengerpost);
        return "seedetailsok";
    } finally {
        session.close();
    }

}

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   www  . java  2  s  .  co  m
        //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 asPassenger() throws IOException {

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

    try {// w  ww .j a  v  a 2s.  c  o m
        //user's email as a driver
        email = ActionContext.getContext().getSession().get("email").toString();
        //find drivers' post that I have paid attention to from passengerapply table
        plist = session.selectList("selectpassengerapplybypassengeremail", email);
        System.out.println("selected drivers as a passenger=" + plist.size());

        detaillist2 = new ArrayList<detailsofdriverpost>();

        for (int i = 0; i < plist.size(); ++i) {
            driverpostID = plist.get(i).getDriverpostID();
            driveremail = plist.get(i).getDriveremail();

            //get driver's basic information like sex, name,dob
            driverinfolist = session.selectList("selectuserbyemail", driveremail);

            //get driver's post detailed information
            padlist = session.selectList("selectPostByID", driverpostID);

            detaildriverpost = new detailsofdriverpost();

            drivername = driverinfolist.get(0).getName();
            sex = driverinfolist.get(0).getSex();
            dob = driverinfolist.get(0).getDob();
            driverlicense = driverinfolist.get(0).getDriverlicense();
            departure = padlist.get(0).getDeparture();
            destination = padlist.get(0).getDestination();
            departuredate = padlist.get(0).getDeparturedate();
            estimatedleavingtime = padlist.get(0).getEstimatedleavingtime();
            availableseats = padlist.get(0).getAvailableseats();
            cartype = padlist.get(0).getCartype();
            estimatedtotalcost = padlist.get(0).getEstimatedtotalcost();
            estimatedcostperpassenger = padlist.get(0).getEstimatedcostperpassenger();
            phone = padlist.get(0).getPhone();
            memo = padlist.get(0).getMemo();
            numberofappliedpassengers = padlist.get(0).getNumberofappliedpassengers();

            detaildriverpost.setDeparture(departure);
            detaildriverpost.setDeparturedate(departuredate);
            detaildriverpost.setDestination(destination);
            detaildriverpost.setDob(dob);
            detaildriverpost.setEmail(passengeremail);
            detaildriverpost.setEstimatedleavingtime(estimatedleavingtime);
            detaildriverpost.setCartype(cartype);
            detaildriverpost.setEstimatedcostperpassenger(estimatedcostperpassenger);
            detaildriverpost.setEstimatedtotalcost(estimatedtotalcost);
            detaildriverpost.setMemo(memo);
            detaildriverpost.setName(passengername);
            detaildriverpost.setAvailableseats(availableseats);
            detaildriverpost.setNumberofappliedpassengers(numberofappliedpassengers);
            detaildriverpost.setPhone(phone);
            detaildriverpost.setPostID(driverpostID);
            detaildriverpost.setSex(sex);
            detaildriverpost.setDriverlicense(driverlicense);
            detaillist2.add(detaildriverpost);
        }
        return "success2";

    } finally {
        session.close();
    }

}

From source file:action.manageParticipatedPost.java

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

    try {/*from   w w  w  . ja  v a2s.  com*/

        System.out.println("selected driver's postID in see details2=" + postID);
        padlist = session.selectList("selectPostByID", postID);
        detaillist2 = new ArrayList<detailsofdriverpost>();

        detaildriverpost = new detailsofdriverpost();
        driveremail = padlist.get(0).getEmail();

        driverinfolist = session.selectList("selectuserbyemail", driveremail);

        drivername = driverinfolist.get(0).getName();
        sex = driverinfolist.get(0).getSex();
        dob = driverinfolist.get(0).getDob();
        driverlicense = driverinfolist.get(0).getDriverlicense();
        departure = padlist.get(0).getDeparture();
        destination = padlist.get(0).getDestination();
        departuredate = padlist.get(0).getDeparturedate();
        estimatedleavingtime = padlist.get(0).getEstimatedleavingtime();
        availableseats = padlist.get(0).getAvailableseats();
        cartype = padlist.get(0).getCartype();
        estimatedtotalcost = padlist.get(0).getEstimatedtotalcost();
        estimatedcostperpassenger = padlist.get(0).getEstimatedcostperpassenger();
        phone = padlist.get(0).getPhone();
        memo = padlist.get(0).getMemo();
        numberofappliedpassengers = padlist.get(0).getNumberofappliedpassengers();

        detaildriverpost.setDeparture(departure);
        detaildriverpost.setDeparturedate(departuredate);
        detaildriverpost.setDestination(destination);
        detaildriverpost.setDob(dob);
        detaildriverpost.setEmail(driveremail);
        detaildriverpost.setEstimatedleavingtime(estimatedleavingtime);
        detaildriverpost.setCartype(cartype);
        detaildriverpost.setEstimatedtotalcost(estimatedtotalcost);
        detaildriverpost.setEstimatedcostperpassenger(estimatedcostperpassenger);
        detaildriverpost.setMemo(memo);
        detaildriverpost.setName(drivername);
        detaildriverpost.setAvailableseats(availableseats);
        detaildriverpost.setNumberofappliedpassengers(numberofappliedpassengers);
        detaildriverpost.setPhone(phone);
        detaildriverpost.setPostID(postID);
        detaildriverpost.setSex(sex);
        detaildriverpost.setDriverlicense(driverlicense);
        detaillist2.add(detaildriverpost);
        return "seedetailsok2";
    } 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 {// w w  w. j a  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();
    }

}