engagehibernatedao.java

hibernate+spring的相片上传项目

package org.lenovoAC.hibernateDao;

import org.lenovoAC.pojo.Engage;
import java.util.List;
import org.lenovoAC.dao.EngageDao;
import net.sf.hibernate.Query;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *招聘精英
  招聘信息表: engage

 * @author not attributable
 * @version 1.0
 */
public class EngageHibernateDao
    extends BaseDao implements EngageDao
{
  /**
   * 添加
   * @param engage Engage
   */
  public void insertEngage(Engage engage)
  {
    this.getHibernateTemplate().save(engage);
    log.info("添加成功");
  }

  /**
   * 修改
   * @param engage Engage
   */
  public void updateEngage(Engage engage)
  {
    net.sf.hibernate.Session session=null;
    java.sql.Connection con=null;
    java.sql.PreparedStatement ps=null;
    try
    {
      String sql="update ENGAGE set Condition=?,Job=?,Time=sysdate,phone=?,E_mail=?,mobile_phone=?,State=? where id=?";
      session=this.getSession();
      con=session.connection();
      ps=con.prepareStatement(sql);
      ps.setString(1,engage.getCondition());
      ps.setString(2,engage.getJob());
      ps.setString(3,engage.getPhone());
      ps.setString(4,engage.getEMail());
      ps.setString(5,engage.getMobilePhone());
      ps.setString(6,engage.getState());
      ps.setString(7,engage.getId());
      ps.executeUpdate();
      ps.close();
      con.close();
      session.close();
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
  }

  /**
   * 删除
   * @param engage Engage
   */
  public void delEngage(Engage engage)
  {
    this.getHibernateTemplate().delete(engage);
  }

  /**
   * 得到指定实例
   * @param id String
   * @return Engage
   */
  public Engage getEngage(String id)
  {
    return (Engage)this.getHibernateTemplate().get(Engage.class, id);
  }

  /**
   * 删除指定实例
   * @param id String
   */
  public void delEngageTwo(String id)
  {
    Engage engage = getEngage(id);
    delEngage(engage);
    log.info("删除成功");
  }

  /**
   * 取得表中所有记录
   * @return List
   */
  public List getAllEngage()
  {
    return this.getHibernateTemplate().loadAll(Engage.class);
  }

  /**
   * 取得表中所有记录(根据时间排序)
   * @return List
   */
  public List getAllEngageTwo()
  {
    String hql = "from Engage as en order by en.time desc";
    return this.getHibernateTemplate().find(hql);
  }

  /**
   * 得到显示标志
   * @param id String
   * @return String
   */
  public String getState(String id)
  {
    Engage engage = getEngage(id);
    return engage.getState();
  }
  /**
   * 取出表中后十条记录
   * @return List
   */
  public List getEngageLimit(int maxSize)
  {
    List list = null;
    String hql = "from Engage as en order by en.time desc";
    try
    {
      Query query = this.getHibernateTemplate().createQuery(this.getSession(),
          hql);
      query.setFirstResult(0); //从第0条记录开始取出10条记录
      query.setMaxResults(maxSize);
      list = query.list();
    }
    catch (Exception e)
    {
      log.info("方法getEngageLimit()出异常");
      e.printStackTrace();
    }
    return list;
  }
  public List getList()
  {
    String hql = "from Engage as en where en.state='01' order by en.time desc";
    return this.getHibernateTemplate().find(hql);
  }
}