SSH框架开发无错模版(Mysql)

package com.demo.dao.impl; import java.sql.SQLException; import java.util.List; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.hibernate.HibernateException; import org.hibernate.LockMode; import org.hibernate.Query; import org.hibernate.Session; import org.springframework.context.ApplicationContext; import org.springframework.orm.hibernate3.HibernateCallback; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.demo.dao.IUser; import com.demo.domain.User; import com.demo.service.IUserservice; /** * Data access object (DAO) for domain model class User. * * @see com.demo.domain.User * @author MyEclipse Persistence Tools */ public class UserDaoImpl extends HibernateDaoSupport implements IUser { private static final Log log = LogFactory.getLog(UserDaoImpl.class); // property constants public static final String NAME = "name"; public static final String AGE = "age"; public static final String PASSWORD = "password"; protected void initDao() { // do nothing } public void save(User transientInstance) { log.debug("saving User instance"); try { getHibernateTemplate().save(transientInstance); log.debug("save successful"); } catch (RuntimeException re) { log.error("save failed", re); throw re; } } public void delete(User persistentInstance) { log.debug("deleting User instance"); try { getHibernateTemplate().delete(persistentInstance); log.debug("delete successful"); } catch (RuntimeException re) { log.error("delete failed", re); throw re; } } public User findById(java.lang.Integer id) { log.debug("getting User instance with id: " + id); try { User instance = (User) getHibernateTemplate().get( "com.demo.domain.User", id); return instance; } catch (RuntimeException re) { log.error("get failed", re); throw re; } } public List findByExample(User instance) { log.debug("finding User instance by example"); try { List results = getHibernateTemplate().findByExample(instance); 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 User instance with property: " + propertyName + ", value: " + value); try { String queryString = "from User as model where model." + propertyName + "= ?"; return getHibernateTemplate().find(queryString, value); } catch (RuntimeException re) { log.error("find by property name failed", re); throw re; } } public List findByName(Object name) { return findByProperty(NAME, name); } public List findByAge(Object age) { return findByProperty(AGE, age); } public List findByPassword(Object password) { return findByProperty(PASSWORD, password); } public List findAll() { log.debug("finding all User instances"); try { String queryString = "from User"; return getHibernateTemplate().find(queryString); } catch (RuntimeException re) { log.error("find all failed", re); throw re; } } public User merge(User detachedInstance) { log.debug("merging User instance"); try { User result = (User) getHibernateTemplate().merge(detachedInstance); log.debug("merge successful"); return result; } catch (RuntimeException re) { log.error("merge failed", re); throw re; } } public void attachDirty(User instance) { log.debug("attaching dirty User instance"); try { getHibernateTemplate().saveOrUpdate(instance); log.debug("attach successful"); } catch (RuntimeException re) { log.error("attach failed", re); throw re; } } public void attachClean(User instance) { log.debug("attaching clean User instance"); try { getHibernateTemplate().lock(instance, LockMode.NONE); log.debug("attach successful"); } catch (RuntimeException re) { log.error("attach failed", re); throw re; } } public static UserDaoImpl getFromApplicationContext(ApplicationContext ctx) { return (UserDaoImpl) ctx.getBean("UserDAO"); } // /////////////////////////////// public void add(User user) { // TODO Auto-generated method stub this.save(user); } //login public User find(final String name,final String password) { // TODO Auto-generated method stub System.out.println(name+"\t"+password); try { User user =(User)this.getHibernateTemplate().execute(new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub Query query = session.createQuery("From User as user where user.name=? and user.password=? "); query.setString(0, name); query.setString(1, password); return query.uniqueResult(); } }); log.info("执行成功！"); return user; }catch(Exception ex) { log.error("异常："+ex.getMessage()); return null; } } }