package com.mxl.dao;
import java.util.List;
import org.apache.taglibs.standard.tag.el.sql.TransactionTag;
import org.hibernate.LockMode;
import org.hibernate.Query;
import org.hibernate.Transaction;
import org.hibernate.criterion.Example;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import com.mxl.entity.Users;
import com.mxl.hibernate.BaseHibernateDAO;
/**
* A data access object (DAO) providing persistence and search support for Users
* entities. Transaction control of the save(), update() and delete() operations
* can directly support Spring container-managed transactions or they can be
* augmented to handle user-managed Spring transactions. Each of these methods
* provides additional information for how to configure it for the desired type
* of transaction control.
*
* @see com.mxl.entity.Users
* @author MyEclipse Persistence Tools
*/
public class UsersDAO extends BaseHibernateDAO {
private static final Logger log = LoggerFactory.getLogger(UsersDAO.class);
// property constants
public static final String USERNAME = "username";
public static final String PASSWORD = "password";
public static final String ADDRESS = "address";
public void save(Users transientInstance) {
Transaction tx = getSession().beginTransaction();
log.debug("saving Users instance");
try {
getSession().save(transientInstance);
log.debug("save successful");
tx.commit();
} catch (RuntimeException re) {
log.error("save failed", re);
tx.rollback();
throw re;
}
}
public void delete(Users persistentInstance) {
Transaction tx = getSession().beginTransaction();
log.debug("deleting Users instance");
try {
getSession().delete(persistentInstance);
log.debug("delete successful");
tx.commit();
} catch (RuntimeException re) {
log.error("delete failed", re);
tx.rollback();
throw re;
}
}
public Users findById(Long id) {
log.debug("getting Users instance with id: " + id);
try {
Users instance = (Users) getSession().get("com.mxl.entity.Users",
id);
return instance;
} catch (RuntimeException re) {
log.error("get failed", re);
throw re;
}
}
public List findByExample(Users instance) {
log.debug("finding Users instance by example");
try {
List results = getSession().createCriteria("com.mxl.entity.Users")
.add(Example.create(instance)).list();
log.debug("find by example successful, result size: "
+ results.size());
return results;
} catch (RuntimeException re) {
log.error("find by example failed", re);
throw re;
}
}
public List findByProperty(String propertyName, Object value) {
log.debug("finding Users instance with property: " + propertyName
+ ", value: " + value);
try {
String queryString = "from Users as model where model."
+ propertyName + "= ?";
System.out.println("sql=============================================="+queryString);
Query queryObject = getSession().createQuery(queryString);
queryObject.setParameter(0, value);
return queryObject.list();
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}
}
public List findByUsername(Object username) {
return findByProperty(USERNAME, username);
}
public List findByPassword(Object password) {
return findByProperty(PASSWORD, password);
}
public List findByAddress(Object address) {
return findByProperty(ADDRESS, address);
}
public List findAll() {
log.debug("finding all Users instances");
try {
String queryString = "from Users";
Query queryObject = getSession().createQuery(queryString);
return queryObject.list();
} catch (RuntimeException re) {
log.error("find all failed", re);
throw re;
}
}
public Users merge(Users detachedInstance) {
Transaction tx = getSession().beginTransaction();
log.debug("merging Users instance");
try {
Users result = (Users) getSession().merge(detachedInstance);
log.debug("merge successful");
tx.commit();
return result;
} catch (RuntimeException re) {
log.error("merge failed", re);
tx.rollback();
throw re;
}
}
public void attachDirty(Users instance) {
log.debug("attaching dirty Users instance");
try {
getSession().saveOrUpdate(instance);
log.debug("attach successful");
} catch (RuntimeException re) {
log.error("attach failed", re);
throw re;
}
}
public void attachClean(Users instance) {
log.debug("attaching clean Users instance");
try {
getSession().lock(instance, LockMode.NONE);
log.debug("attach successful");
} catch (RuntimeException re) {
log.error("attach failed", re);
throw re;
}
}
}