Example usage for org.hibernate.cfg Configuration Configuration

Introduction

In this page you can find the example usage for org.hibernate.cfg Configuration Configuration.

Prototype

public Configuration()

Source Link

Usage

From source file:com.collaborativeclouds.workers.ParkingData.java

public String removeSlotofUser(String username, String code) {
    try {/*from   ww w.  j ava2s  . c  o m*/
        SessionFactory sessFact = new Configuration().configure().buildSessionFactory();
        mSession = sessFact.openSession();
        mTransaction = mSession.beginTransaction();
        String status = "Failed";
        JSONObject mObject = new JSONObject(code);
        String mCode = mObject.getString("code");

        List<Parking> mPark = null;
        Query getParkData = mSession
                .createQuery("from Parking where username='" + username + "' and code='" + mCode + "'");
        mPark = (List<Parking>) getParkData.list();

        if (mPark.size() > 0) {
            mSession.delete(mPark.get(0));
            mTransaction.commit();
            status = "Success";
        }
        return status;
    } catch (Exception ex) {
        return "Failed";
    }
}

From source file:com.collaborativeclouds.workers.ParkingData.java

public String bookSlot(String Slotnum, String username) throws JSONException {

    try {/* www. j  a v a2 s .  c o m*/
        SessionFactory sessFact = new Configuration().configure().buildSessionFactory();
        mSession = sessFact.openSession();
        mTransaction = mSession.beginTransaction();
        JSONUtils mUtils = new JSONUtils();
        if (mUtils.isJSONValid(Slotnum)) {
            JSONObject mObject = new JSONObject(Slotnum);
            String mSlot = mObject.getString("slotnumber");
            //UUID sess_id = UUID.randomUUID();
            Random mRandom = new Random();
            int sess_id_ = mRandom.nextInt(100000 - 100 + 1) + 100;
            String sess_id = "" + sess_id_;
            Parking mParkData = new Parking();
            mParkData.setSlotno(mSlot);
            mParkData.setStatus("booked");
            mParkData.setCode("" + sess_id);
            mParkData.setUsername(username);
            mSession.save(mParkData);
            mTransaction.commit();

            return "" + sess_id;
        } else {
            return "Failed";
        }
    } catch (Exception e) {
        return "Failed";
    }
}

From source file:com.collaborativeClouds.workers.PayTax.java

public String addTaxData(String taxdata) {
    try {//from ww w.  jav a  2 s.c o  m
        SessionFactory sessFact = new Configuration().configure().buildSessionFactory();
        mSession = sessFact.openSession();
        mTransaction = mSession.beginTransaction();
        JSONObject mObject = new JSONObject(taxdata);

        return taxdata;
    } catch (Exception ex) {
        return "Error";
    }
}

From source file:com.collaborativeClouds.workers.RegisterVehicle.java

public String Register(String JSONData) throws JSONException {
    try {//ww w  . j a v a 2s  . c  om
        SessionFactory sessFact = new Configuration().configure().buildSessionFactory();
        mSession = sessFact.openSession();
        mTransaction = mSession.beginTransaction();

        JSONObject mObject = new JSONObject(JSONData);

        String registration = mObject.get("registration").toString();
        String description = mObject.get("description").toString();
        String dealer_name = mObject.get("dealer_name").toString();
        String dealer_address = mObject.get("dealer_address").toString();
        String maker_name = mObject.get("maker_name").toString();
        String owner_name = mObject.get("owner_name").toString();
        String owner_guide = mObject.get("owner_guide").toString();
        String owner_relation = mObject.get("owner_relation").toString();
        String owner_perm_address = mObject.get("owner_perm_address").toString();
        String owner_temp_address = mObject.get("owner_temp_address").toString();
        int duration = Integer.parseInt(mObject.get("duration").toString());
        String pan = mObject.get("pan").toString();
        String birth_place = mObject.get("birth_place").toString();
        String migrated_date = mObject.get("migrated_date").toString();
        String exarmy = mObject.get("exarmy").toString();
        String vehicle_class = mObject.get("vehicle_class").toString();
        String vehicle_is = mObject.get("vehicle_is").toString();
        String body_type = mObject.get("body_type").toString();
        String vehicle_type = mObject.get("vehicle_type").toString();
        String manufactured_month = mObject.get("manufactured_month").toString();
        String manufactured_year = mObject.get("manufactured_year").toString();
        int cylinders = Integer.parseInt(mObject.get("cylinders").toString());
        int hp = Integer.parseInt(mObject.get("hp").toString());
        int cubic_capacity = Integer.parseInt((String) mObject.get("cubic_capacity"));
        String classification = mObject.get("classification").toString();
        String chassis = mObject.get("chassis").toString();
        String engine = mObject.get("engine").toString();
        int seating = Integer.parseInt(mObject.get("seating").toString());
        String fuel = mObject.get("fuel").toString();
        int unladen_weight = Integer.parseInt(mObject.get("unladen_weight").toString());
        String prev_registration = mObject.get("prev_registration").toString();
        String color = mObject.get("color").toString();
        String wheel = mObject.get("wheel").toString();

        TblVehicleRegistration mRegister = new TblVehicleRegistration();
        mRegister.setRegistrationNumber(registration);
        mRegister.setBirthPlace(birth_place);
        mRegister.setBodyType(body_type);
        mRegister.setChassisNumber(chassis);
        mRegister.setColor(color);
        mRegister.setCubicCapacity(cubic_capacity);
        mRegister.setCylinders(cylinders);
        mRegister.setDealerAddress(dealer_address);
        mRegister.setDealerName(dealer_name);
        mRegister.setDescription(description);
        mRegister.setDurationOfStay(duration);
        mRegister.setEngineNumber(engine);
        mRegister.setExarmyImportedVehicle(exarmy);
        mRegister.setFuel(fuel);
        mRegister.setHp(hp);
        mRegister.setMakerClassification(classification);
        mRegister.setMakerName(maker_name);
        mRegister.setManufactureMonth(manufactured_month);
        mRegister.setManufactureYear(manufactured_year);
        mRegister.setMigratedDate(migrated_date);
        mRegister.setOwnerGuide(owner_guide);
        mRegister.setOwnerGuideRelation(owner_relation);
        mRegister.setOwnerName(owner_name);
        mRegister.setOwnerPermAddress(owner_perm_address);
        mRegister.setOwnerTempAddress(owner_temp_address);
        mRegister.setPanNumber(pan);
        mRegister.setPrevRegistration(prev_registration);
        mRegister.setSeating(seating);
        mRegister.setUnladenWeight(unladen_weight);
        mRegister.setVehicleClass(vehicle_class);
        mRegister.setVehicleIs(vehicle_is);
        mRegister.setVehicleType(vehicle_type);
        mRegister.setWheelBase(wheel);

        mSession.save(mRegister);
        mTransaction.commit();
        return "Success";
    } catch (Exception e) {
        Logger.getLogger(RegisterVehicle.class.getName()).log(Level.SEVERE, null, e);
        return "Failed";
    }
}

From source file:com.collaborativeClouds.workers.RegisterVehicle.java

public String getRegisterInfo(String vehicleInfo) {
    try {//from   w w w.  j  a  v  a  2  s .  c  om
        SessionFactory sessFact = new Configuration().configure().buildSessionFactory();
        mSession = sessFact.openSession();
        mTransaction = mSession.beginTransaction();
        List<TblVehicleRegistration> mVehicleInfo = null;

        JSONObject mObject = new JSONObject(vehicleInfo);
        String registration_no = mObject.get("registration_no").toString();

        Query mVehicleData = mSession
                .createQuery("from TblVehicleRegistration where registration_number='" + registration_no + "'");
        mVehicleInfo = (List<TblVehicleRegistration>) mVehicleData.list();
        if (mVehicleInfo.size() > 0) {
            String json = new Gson().toJson(mVehicleInfo);
            return json;
        } else {
            return "No Data Found";
        }

    } catch (Exception ex) {
        return "Failed";
    }
}

From source file:com.collaborativeClouds.workers.RegisterVehicle.java

public String getVehicleRegistrationNumber() {
    try {//from  w ww.  ja  v a  2  s  .c  om
        SessionFactory sessFact = new Configuration().configure().buildSessionFactory();
        mSession = sessFact.openSession();
        mTransaction = mSession.beginTransaction();
        List<TblVehicleRegistration> mVehicleInfo = null;
        Query mVehicleData = mSession.createQuery("select registrationNumber from TblVehicleRegistration");
        mVehicleInfo = (List<TblVehicleRegistration>) mVehicleData.list();
        if (mVehicleInfo.size() > 0) {
            String json = new Gson().toJson(mVehicleInfo);
            return json;
        } else {
            return "No Data Found";
        }

    } catch (Exception ex) {
        return "Failed";
    }
}

From source file:com.collaborativeClouds.workers.SessionOperator.java

public String setSession(String username, String session_id) {
    try {//from   www.  ja va2  s .c o m
        SessionFactory sessFact = new Configuration().configure().buildSessionFactory();
        mSession = sessFact.openSession();
        mTransaction = mSession.beginTransaction();

        TblOnline mOnline = new TblOnline();
        mOnline.setSessionId(session_id);
        mOnline.setUsername(username);
        mSession.save(mOnline);
        mTransaction.commit();
        return session_id;
    } catch (Exception exception) {
        return "Failed";
    }
}

From source file:com.collaborativeClouds.workers.SessionOperator.java

public int checkValidSession(String username, String sessionid) {
    try {//from  w w w.j  a v a2  s  .  co m
        SessionFactory sessFact = new Configuration().configure().buildSessionFactory();
        mSession = sessFact.openSession();
        mTransaction = mSession.beginTransaction();

        List<TblOnline> mOnline = null;
        Query checkOnline = mSession.createQuery(
                "from TblOnline where username='" + username + "' and session_id='" + sessionid + "'");
        mOnline = (List<TblOnline>) checkOnline.list();

        if (mOnline.size() > 0) {
            return 1;
        } else {
            return 0;
        }
    } catch (Exception exception) {
        return 0;
    }
}

From source file:com.collaborativeClouds.workers.SessionOperator.java

public int removeSession(String username, String session_id) {
    try {//  w  w w .ja v a2 s . c  om
        SessionFactory sessFact = new Configuration().configure().buildSessionFactory();
        mSession = null;
        mSession = sessFact.openSession();
        mTransaction = mSession.beginTransaction();
        //JSONObject mObject = new JSONObject(userdata);
        //String username = mObject.getString("username");
        //System.err.println("USER: "+username);
        Query deleteOnline = mSession.createQuery(
                "delete from TblOnline where username='" + username + "' and sessionId='" + session_id + "'");
        int status = deleteOnline.executeUpdate();
        mTransaction.commit();
        if (status == 1) {
            return 1;
        } else {
            return 0;
        }
    } catch (Exception exception) {
        return 0;
    }
}

From source file:com.collaborativeclouds.workers.UserOperations.java

public boolean validateLogin(String userdata) throws JSONException {
    try {/*  w w  w  . j a va2 s  .c  om*/
        SessionFactory sessFact = new Configuration().configure().buildSessionFactory();
        mSession = sessFact.openSession();
        mTransaction = mSession.beginTransaction();
        JSONUtils mUtils = new JSONUtils();
        if (mUtils.isJSONValid(userdata)) {

            JSONObject mObject = new JSONObject(userdata);
            String mUsername = mObject.getString("username");
            String mPassword = mObject.getString("password");
            List<Users> mUserInfo = null;
            Query mUserData = mSession.createQuery("select username from Users where username='" + mUsername
                    + "' and password='" + mPassword + "'");
            mUserInfo = (List<Users>) mUserData.list();
            if (mUserInfo.size() > 0) {
                return true;
            } else {
                return false;
            }
        } else {
            return false;
        }
    } catch (Exception e) {
        return false;
    }
}