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

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

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

Introduction

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

Prototype

void commit();

Source Link

Document

Flushes batch statements and commits database connection.

Usage

From source file:PersistenceTest.java

License:Open Source License

@Test
public void CE1() {
    SqlSessionFactory sessionfact = getSqlSessionFactory();

    SqlSession sqlss = sessionfact.openSession();
    PacienteMapper pm = sqlss.getMapper(PacienteMapper.class);
    //Deberia registrar paciente nuevo con mas de una consulta
    Paciente p4 = new Paciente(124567890, "TI", "Pepito Perez", Date.valueOf("1996-07-09"));
    Consulta c5 = new Consulta(Date.valueOf("2009-10-12"), "El paciente tiene fiebre");
    Consulta c6 = new Consulta(Date.valueOf("2009-10-13"), "El paciente sigue con fiebre");
    Set<Consulta> consultas4 = new HashSet<>();
    consultas4.add(c5);// w w w .j a v a 2s.  c om
    consultas4.add(c6);
    p4.setConsultas(consultas4);
    pm.insertPaciente(p4);
    sqlss.commit();
    for (Consulta c : p4.getConsultas()) {
        pm.insertConsulta(c, p4.getId(), p4.getTipo_id());
        sqlss.commit();
    }
    Paciente test = pm.loadPacienteById(p4.getId(), p4.getTipo_id());
    LinkedList<String> cadenas = new LinkedList<>();
    boolean funciona = p4.getId() == test.getId() && p4.getTipo_id().equals(test.getTipo_id())
            && p4.getNombre().equals(test.getNombre())
            && p4.getFechaNacimiento().equals(test.getFechaNacimiento());
    for (Consulta c : test.getConsultas()) {
        cadenas.add(c.toString().split(",")[1] + c.toString().split(",")[2]);
    }
    for (Consulta c : p4.getConsultas()) {
        funciona = funciona && cadenas.contains(c.toString().split(",")[1] + c.toString().split(",")[2]);
    }
    Assert.assertTrue(funciona);

}

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);// w w  w  .j  ava  2s  .co 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   w  w w.j  ava2s. 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.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 {/* www . j a va  2  s  .  c o 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 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  a  2 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  ww.j  a  v  a 2  s  .  co  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 {//from  ww  w  .ja v a2  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:action.postAsDriver.java

public String post() 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  ww  w.  j  a v a 2  s .co m*/
        email = (String) (ActionContext.getContext().getSession().get("email"));
        numberofappliedpassengers = "0";
        System.out.println("email in pad=" + email);
        System.out.println("departure in pad=" + departure);
        System.out.println("destination in pad=" + destination);
        System.out.println("ddate in pad=" + departuredate);
        System.out.println("time in pad=" + estimatedleavingtime);
        System.out.println("seats in pad=" + availableseats);
        System.out.println("car in pad=" + cartype);
        System.out.println("estimatedtotalcost in pad=" + estimatedtotalcost);
        System.out.println("estimatedcostperpassenger in pad=" + estimatedcostperpassenger);
        System.out.println("phone in pad=" + phone);
        System.out.println("memo in pad=" + memo);

        //check whether this driver has entered his driver license when registering. If not, forbid posting as driver!
        driverlist = session.selectList("selectuserbyemail", email);
        driverlicense = driverlist.get(0).getDriverlicense();

        if (driverlicense.equals("")) {
            JOptionPane.showMessageDialog(null,
                    "As a driver, you didn't type your driver license when you registered. Please complete information fristly and then come back to post as driver. Thanks for your understanding!",
                    "Message", JOptionPane.ERROR_MESSAGE);
            return "nopost";
        }

        else {
            //check estimated total cost
            String checkcost = "[0-9]+";
            Pattern regex = Pattern.compile(checkcost);
            java.util.regex.Matcher matcher = regex.matcher(estimatedtotalcost);
            boolean isMatched = matcher.matches();

            //check estimated cost per passengre
            java.util.regex.Matcher matcher2 = regex.matcher(estimatedcostperpassenger);
            boolean isMatched2 = matcher2.matches();

            //check phone number
            String checkphone = "[1-9][0-9]{9}";
            Pattern regex2 = Pattern.compile(checkphone);
            java.util.regex.Matcher matcher3 = regex2.matcher(phone);
            boolean isMatched3 = matcher3.matches();

            if (departuredate.equals("") || estimatedtotalcost.equals("")
                    || estimatedcostperpassenger.equals("")) {
                JOptionPane.showMessageDialog(null, "Please fill required information!", "Message",
                        JOptionPane.ERROR_MESSAGE);
            } else if (departure.equals(destination)) {
                JOptionPane.showMessageDialog(null, "Departure and Destination can't be the same city!",
                        "Message", JOptionPane.ERROR_MESSAGE);
            }

            else if (!isMatched) {
                JOptionPane.showMessageDialog(null, "Estimated Total Cost should be numbers!", "Message",
                        JOptionPane.ERROR_MESSAGE);

            }

            else if (!isMatched2) {
                JOptionPane.showMessageDialog(null, "Estimated cost per passenger should be numbers!",
                        "Message", JOptionPane.ERROR_MESSAGE);

            }

            else if (!phone.equals("")) {
                if (!isMatched3) {
                    JOptionPane.showMessageDialog(null, "Phone Number should be 10 numeric digits!", "Message",
                            JOptionPane.ERROR_MESSAGE);
                    return "retype";
                } else {
                    int res;
                    res = JOptionPane.showConfirmDialog(null, "Are you sure you want to post this message?",
                            "Confirm", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE);
                    if (res == JOptionPane.YES_OPTION) {

                        //search table of postasdriver to set postID
                        postlist = new ArrayList<postasdriver>();
                        postlist = session.selectList("selectAllPostAsDriver");
                        if (postlist.size() == 0) {
                            i = 0;
                        } else {
                            String s = postlist.get(postlist.size() - 1).getPostID();
                            i = Integer.parseInt(s);
                        }

                        //insert new post as driver
                        newpost = new postasdriver();
                        newpost.setPostID(String.valueOf(i + 1));
                        ;
                        newpost.setEmail(email);
                        newpost.setAvailableseats(availableseats);
                        newpost.setCartype(cartype);
                        newpost.setDeparture(departure);
                        newpost.setDestination(destination);
                        newpost.setDeparturedate(departuredate);
                        newpost.setEstimatedcostperpassenger(estimatedcostperpassenger);
                        newpost.setEstimatedtotalcost(estimatedtotalcost);
                        newpost.setPhone(phone);
                        newpost.setMemo(memo);
                        newpost.setEstimatedleavingtime(estimatedleavingtime);
                        newpost.setNumberofappliedpassengers(numberofappliedpassengers);

                        session.insert("insertpostasdriver", newpost);
                        session.commit();
                        JOptionPane.showMessageDialog(null, "Posted Successfully!", "Message",
                                JOptionPane.INFORMATION_MESSAGE);
                        return SUCCESS;
                    } else {
                        return "nopost";
                    }
                }
            }

            else {
                //insert new post as driver
                int res;
                res = JOptionPane.showConfirmDialog(null, "Are you sure you want to post this message?",
                        "Confirm", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE);
                if (res == JOptionPane.YES_OPTION) {

                    //search table of postasdriver to set postID
                    postlist = new ArrayList<postasdriver>();
                    postlist = session.selectList("selectAllPostAsDriver");
                    if (postlist.size() == 0) {
                        i = 0;
                    } else {
                        String s = postlist.get(postlist.size() - 1).getPostID();
                        i = Integer.parseInt(s);
                    }

                    //insert new post as driver
                    newpost = new postasdriver();
                    newpost.setPostID(String.valueOf(i + 1));
                    ;
                    newpost.setEmail(email);
                    newpost.setAvailableseats(availableseats);
                    newpost.setCartype(cartype);
                    newpost.setDeparture(departure);
                    newpost.setDestination(destination);
                    newpost.setDeparturedate(departuredate);
                    newpost.setEstimatedcostperpassenger(estimatedcostperpassenger);
                    newpost.setEstimatedtotalcost(estimatedtotalcost);
                    newpost.setPhone(phone);
                    newpost.setMemo(memo);
                    newpost.setEstimatedleavingtime(estimatedleavingtime);

                    session.insert("insertpostasdriver", newpost);
                    session.commit();
                    JOptionPane.showMessageDialog(null, "Posted Successfully!", "Message",
                            JOptionPane.INFORMATION_MESSAGE);
                    return SUCCESS;
                } else {
                    return "nopost";
                }
            }
            return "retype";
        }

    } finally {
        session.close();
    }

}

From source file:action.register.java

public String userregistration() throws IOException {
    System.out.println("name in reg=" + name);
    System.out.println("email in reg=" + email);
    System.out.println("sex in reg=" + sex);
    System.out.println("pw in reg=" + password);
    System.out.println("cpw in reg=" + confirmpassword);
    System.out.println("dob in reg=" + dob);
    System.out.println("dl in reg=" + driverlicense);

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

    try {/*ww  w .  j ava 2s .c  o  m*/

        String check = "\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*";
        Pattern regex = Pattern.compile(check);
        java.util.regex.Matcher matcher = regex.matcher(email);
        boolean isMatched = matcher.matches();

        String checkdl = "[0-9]{8}";
        Pattern regex2 = Pattern.compile(checkdl);
        java.util.regex.Matcher matcher2 = regex2.matcher(driverlicense);
        boolean isMatched2 = matcher2.matches();

        userlist = session.selectList("selectuserbyemail", email);

        //check whether the email address is valid

        if (email.equals("") || name.equals("") || password.equals("") || confirmpassword.equals("")
                || sex.equals("") || dob.equals("")) {

            JOptionPane.showMessageDialog(null, "Please fill required information!", "Message",
                    JOptionPane.WARNING_MESSAGE);
        } else if (!confirmpassword.equals(password)) {
            JOptionPane.showMessageDialog(null, "Two passwords don't match, please type again!", "Message",
                    JOptionPane.WARNING_MESSAGE);
        } else if (!isMatched) {
            JOptionPane.showMessageDialog(null, "This email address is invalid!", "Message",
                    JOptionPane.WARNING_MESSAGE);
        }

        else if (!(userlist.isEmpty())) {
            JOptionPane.showMessageDialog(null, "This email address has been registered!", "Message",
                    JOptionPane.WARNING_MESSAGE);
        }

        else if (!driverlicense.equals("")) {
            if (!isMatched2) {
                JOptionPane.showMessageDialog(null, "Driver License should only be 8 numeric numbers!",
                        "Message", JOptionPane.WARNING_MESSAGE);
            }

            else {
                //insert new user
                newuser = new user();
                newuser.setEmail(email);
                newuser.setName(name);
                newuser.setPassword(password);
                newuser.setDob(dob);
                newuser.setDriverlicense(driverlicense);
                newuser.setSex(sex);
                session.insert("insertuserinfo", newuser);
                session.commit();
                JOptionPane.showMessageDialog(null, "Registered Successfully!", "Message",
                        JOptionPane.INFORMATION_MESSAGE);
                return SUCCESS;
            }
        }

        else {
            //insert new user
            newuser = new user();
            newuser.setEmail(email);
            newuser.setName(name);
            newuser.setPassword(password);
            newuser.setDob(dob);
            newuser.setDriverlicense(driverlicense);
            newuser.setSex(sex);
            session.insert("insertuserinfo", newuser);
            session.commit();
            JOptionPane.showMessageDialog(null, "Registered Successfully!", "Message",
                    JOptionPane.INFORMATION_MESSAGE);
            return SUCCESS;
        }

    } finally {
        session.close();
    }

    return "registerfail";

}

From source file:action.register.java

public String change() throws IOException {

    String resource = "orm/configuration.xml";
    Reader reader = Resources.getResourceAsReader(resource);
    SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
    SqlSession session = sessionFactory.openSession();
    System.out.println("original pw=" + originalpassword);
    System.out.println("pw=" + password);
    System.out.println("confirm pw=" + confirmpassword);

    try {//from w w w .  j  a v a2  s. c o  m
        if (originalpassword.equals("") || password.equals("") || confirmpassword.equals("")) {
            JOptionPane.showMessageDialog(null, "No Empty!", "Message", JOptionPane.INFORMATION_MESSAGE);
            return "fail";
        } else {
            //get user's email address
            email = ActionContext.getContext().getSession().get("email").toString();
            userlist = session.selectList("selectuserbyemail", email);
            if (!userlist.get(0).getPassword().equals(originalpassword)) {
                JOptionPane.showMessageDialog(null, "Your original password is incorrect!", "Message",
                        JOptionPane.INFORMATION_MESSAGE);
                return "fail";
            } else if (!password.equals(confirmpassword)) {
                JOptionPane.showMessageDialog(null, "Two passwords don't match, please type it agian!",
                        "Message", JOptionPane.INFORMATION_MESSAGE);
                return "fail";
            } else {
                newuser = new user();
                newuser.setEmail(email);
                newuser.setPassword(password);
                session.update("updatepassword", newuser);
                session.commit();
                JOptionPane.showMessageDialog(null, "Updated Successfully!", "Message",
                        JOptionPane.INFORMATION_MESSAGE);
                return SUCCESS;

            }
        }

    } finally {
        session.close();
    }
}