List of usage examples for org.apache.ibatis.session SqlSession selectList
<E> List<E> selectList(String statement, Object parameter);
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 {/*from www .ja v a 2s . c om*/ 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 . j a v a 2s . com*/ //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 av 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 {/*w ww . j av a 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 asPassenger() throws IOException { 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 va 2s . co 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 ww w. j a va 2s . c o m*/ 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 ww. j ava 2s . 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 asDriver() 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 ava 2 s. c o m*/ email = ActionContext.getContext().getSession().get("email").toString(); System.out.println("driver email in manage=" + email); postlist = session.selectList("selectpostbydriveremail", email); return SUCCESS; } finally { session.close(); } }
From source file:action.managePost.java
public String seepassengers() 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 w w w .j a v a 2 s. com System.out.println("driver postID in manage=" + postID); passengerapplylist = session.selectList("selectpassengerapplybypostID", postID); System.out.println("passengerapplylist size in manage=" + passengerapplylist.size()); size = passengerapplylist.size(); ulist = new ArrayList<user>(); for (int i = 0; i < size; ++i) { u = new user(); passengeremail = passengerapplylist.get(i).getPassengeremail(); finduserlist = session.selectList("selectuserbyemail", passengeremail); passengername = finduserlist.get(0).getName(); passengersex = finduserlist.get(0).getSex(); dob = finduserlist.get(0).getDob(); passengerdriverlicense = finduserlist.get(0).getDriverlicense(); u.setDob(dob); u.setDriverlicense(passengerdriverlicense); u.setEmail(passengeremail); u.setName(passengername); u.setSex(passengersex); ulist.add(u); } return "ok"; } finally { session.close(); } }
From source file:action.managePost.java
public String asPassenger() 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 va 2 s. com email = ActionContext.getContext().getSession().get("email").toString(); System.out.println("passenger email in manage as passenger=" + email); //select all your posts when you post them as passengers postlist = session.selectList("selectpostbypassengeremail", email); return "managepostaspassengerok"; } finally { session.close(); } }