List of usage examples for org.hibernate.cfg Configuration getProperties
public Properties getProperties()
From source file:gestion.GestorKeep.java
public static JSONObject getKeeps(String usuario) { Configuration configuration = new Configuration().configure(); StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()); SessionFactory factory = configuration.buildSessionFactory(builder.build()); Session sesion = factory.openSession(); sesion.beginTransaction();//from w w w . j a v a 2 s .co m String hql = "from Keep where login = :login"; Query q = sesion.createQuery(hql); q.setString("login", usuario); List<Keep> keeps = q.list(); sesion.getTransaction().commit(); sesion.flush(); sesion.close(); //{"r": true} //{"r": false} JSONArray array = new JSONArray(); for (Keep k : keeps) { JSONObject obj = new JSONObject(); obj.put("idan", k.getIdAndroid()); obj.put("cont", k.getContenido()); obj.put("est", k.getEstado()); array.put(obj); } JSONObject obj2 = new JSONObject(); obj2.put("r", array); return obj2; }
From source file:gestion.GestorKeep.java
public static void addKeep(Keep k) { Configuration configuration = new Configuration().configure(); StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()); SessionFactory factory = configuration.buildSessionFactory(builder.build()); Session sesion = factory.openSession(); sesion.beginTransaction();/*from www.java2 s .c om*/ sesion.save(k); sesion.getTransaction().commit(); sesion.flush(); sesion.close(); }
From source file:gestion.GestorKeep.java
public static List<Keep> listKeeps(String usuario) { Configuration configuration = new Configuration().configure(); StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()); SessionFactory factory = configuration.buildSessionFactory(builder.build()); Session sesion = factory.openSession(); sesion.beginTransaction();//from w ww . j av a 2 s .c om String hql = "from Keep where login = :login"; Query q = sesion.createQuery(hql); q.setString("login", usuario); List<Keep> keeps = q.list(); sesion.getTransaction().commit(); sesion.flush(); sesion.close(); return keeps; }
From source file:gestion.GestorUsuario.java
public static JSONObject getLogin(String login, String pass) { Configuration configuration = new Configuration().configure(); StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()); SessionFactory factory = configuration.buildSessionFactory(builder.build()); Session sesion = factory.openSession(); sesion.beginTransaction();/*from w w w. ja v a 2 s . c o m*/ String hql = "from Usuario where login = :login and pass = :pass"; Query q = sesion.createQuery(hql); q.setString("login", login); q.setString("pass", pass); List<Usuario> usuarios = q.list(); sesion.getTransaction().commit(); sesion.flush(); sesion.close(); JSONObject obj = new JSONObject(); if (usuarios.isEmpty()) { obj.put("r", false); } else { obj.put("r", true); } return obj; }
From source file:gestion.GestorUsuario.java
public static Usuario getUserbyName(String login) { Configuration configuration = new Configuration().configure(); StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()); SessionFactory factory = configuration.buildSessionFactory(builder.build()); Session sesion = factory.openSession(); sesion.beginTransaction();//from ww w . j a v a 2 s . co m Usuario u = (Usuario) sesion.get(Usuario.class, login); sesion.getTransaction().commit(); sesion.flush(); sesion.close(); return u; }
From source file:gestor.GestorUser.java
/** * Metodo que guarda en la base de datos a un usuario * /* w ww .j a v a 2s. co m*/ *@param usuario Usuario que se va a registrar en nuestra base de datos */ public static void registerUser(User usuario) { Configuration configuration = new Configuration().configure(); StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()); SessionFactory factory = configuration.buildSessionFactory(builder.build()); Session sesion = factory.openSession(); sesion.beginTransaction(); sesion.save(usuario); sesion.getTransaction().commit(); sesion.flush(); sesion.close(); }
From source file:gestor.GestorUser.java
/** * Metodo para consultar informacion de un usuario a partir de su token * /* w ww .j av a 2s .c o m*/ * @param token Elemento identificador unico de cada usuario * @return Usuario en forma de json, false en caso de no existir */ public static JSONObject getUserByToken(String token) { Configuration configuration = new Configuration().configure(); StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()); SessionFactory factory = configuration.buildSessionFactory(builder.build()); Session sesion = factory.openSession(); sesion.beginTransaction(); String hql = "from User where token = :token"; Query q = sesion.createQuery(hql); q.setString("token", token); List<User> usuarios = q.list(); sesion.getTransaction().commit(); sesion.flush(); sesion.close(); JSONObject obj = new JSONObject(); if (!usuarios.isEmpty()) { obj.put("r", usuarios.get(0).getJSON()); } else { obj.put("r", false); } return obj; }
From source file:gestor.GestorUser.java
/** * Metodo para consultar informacion de un usuario a partir de su telefono * /*from www .j av a 2 s .co m*/ * @param tlf Elemento identificador unico de cada usuario * @return Usuario en forma de json, false en caso de no existir */ public static JSONObject getUserByTlf(String tlf) { Configuration configuration = new Configuration().configure(); StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()); SessionFactory factory = configuration.buildSessionFactory(builder.build()); Session sesion = factory.openSession(); sesion.beginTransaction(); User u = (User) sesion.get(User.class, tlf); sesion.getTransaction().commit(); sesion.flush(); sesion.close(); JSONObject obj = new JSONObject(); if (u != null) { obj = u.getJSON(); } else { obj.put("r", false); } return obj; }
From source file:gestor.GestorUser.java
/** * Metodo para actualizar la informacion en la base de datos de un usuario * //from w w w .java2 s .c om * @param newUser Nuevos datos del usuario * @param tlf Telefono del usuario que vamos a modificar */ public static void updateUser(String tlf, User newUser) { Configuration configuration = new Configuration().configure(); StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()); SessionFactory factory = configuration.buildSessionFactory(builder.build()); Session sesion = factory.openSession(); sesion.beginTransaction(); User user = (User) sesion.get(User.class, tlf); user.setDescripcion(newUser.getDescripcion()); user.setEmail(newUser.getEmail()); user.setFacebook(newUser.getFacebook()); user.setNacimiento(newUser.getNacimiento()); user.setNacionalidad(newUser.getNacionalidad()); user.setNick(newUser.getNick()); user.setPrivacidad(newUser.getPrivacidad()); user.setTwitter(newUser.getTwitter()); user.setVerconexion(newUser.getVerconexion()); user.setUltimaconexion(newUser.getUltimaconexion()); sesion.getTransaction().commit(); sesion.flush(); sesion.close(); }
From source file:gov.nih.nci.security.authorization.instancelevel.InstanceLevelSecurityHelper.java
License:BSD License
/** * This method injects the security filters which are created for this application. It retrieves a list of all the filters which have * been defined for this application from the CSM Database. Now for each filter in the list, it creates a new FilterDefinition object. * It then retrieves the Persistent Class from the passed Configuration Object using the class name for which the filter is defined. * It then adds the filter to the persistent class by setting the filtering query. * @param authorizationManager The CSM AuthorizationManager instance for this application * @param configuration The Hibernate Configuration initialized for this application * /*from w w w . ja v a 2s .c o m*/ */ public static void addFiltersForGroups(AuthorizationManager authorizationManager, Configuration configuration) { boolean needsOptimisation = false; Properties props = configuration.getProperties(); //If using InstanceLevel Query Performance Enhancements of 4.2, then no need to optimize query for MySQL Db. if (!isExistActiveMappingElement(authorizationManager)) needsOptimisation = isMySQLDatabase(props, true); // Inject CSM Filters for Group List list = retriveAllCsmFilterClause(authorizationManager); Iterator iterator = list.iterator(); while (iterator.hasNext()) { HashMap parameters = new HashMap(); parameters.put("GROUP_NAMES", new StringType()); parameters.put("APPLICATION_ID", new LongType()); FilterClause filterClause = (FilterClause) iterator.next(); FilterDefinition filterDefinition = new FilterDefinition( filterClause.getClassName().substring(filterClause.getClassName().lastIndexOf('.') + 1) + filterClause.getId(), "", parameters); configuration.addFilterDefinition(filterDefinition); PersistentClass persistentClass = configuration.getClassMapping(filterClause.getClassName()); persistentClass.addFilter( filterClause.getClassName().substring(filterClause.getClassName().lastIndexOf('.') + 1) + filterClause.getId(), optimiseFilterQuery(needsOptimisation, filterClause.getGeneratedSQLForGroup())); } }