List of usage examples for org.apache.ibatis.session SqlSessionFactory openSession
SqlSession openSession();
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);/*from www .ja 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);// ww w. java 2 s . c om 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 av a2 s . c o m*/ 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 {//ww w . j a v a 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 2 s .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 {/* www . java 2 s. c om*/ //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 www .jav a 2s. 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 . jav a2s . 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 asPassenger() 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 om*/ //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 {/* w w w. ja v a 2 s . c om*/ 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(); } }