asksuggesthibernatedao.java

hibernate+spring的相片上传项目

package org.lenovoAC.hibernateDao;

import org.lenovoAC.pojo.AskSuggest;
import java.util.List;
import org.lenovoAC.dao.AskSuggestDao;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 * 咨询投诉表:Ask_suggest
 * @author not attributable
 * @version 1.0
 */
public class AskSuggestHibernateDao
    extends BaseDao implements AskSuggestDao
{
  /**
   * 添加
   * @param as AskSuggest
   */
  public void insertAskSuggest(AskSuggest as)
  {
    this.getHibernateTemplate().save(as);
  }

  /**
   * 修改
   * @param as AskSuggest
   */
  public void updateAskSuggest(AskSuggest as)
  {
    this.getHibernateTemplate().update(as);
  }

  /**
   * 删除
   * @param as AskSuggest
   */
  public void delAskSuggest(AskSuggest as)
  {
    this.getHibernateTemplate().delete(as);
  }
  /**
   * 得到单个实例
   * @param id String
   * @return AskSuggest
   */
  public AskSuggest getAskSuggest(String id)
  {
    return (AskSuggest)this.getHibernateTemplate().load(AskSuggest.class,id);
  }
  /**
   * 删除指定ID对象
   * @param id String
   */
  public void delAskSuggestTwo(String id)
  {
    AskSuggest as=this.getAskSuggest(id);
    this.delAskSuggest(as);
    log.info("删除成功!");
  }
  /**
   * 修改指定ID对象的值为asOld对应的值
   * @param id String
   * @param asOld AskSuggest
   */
  public void updateAskSuggestTwo(String id,AskSuggest asOld)
  {
    AskSuggest asNew=this.getAskSuggest(id);
    asNew.setTitle(asOld.getTitle());
    asNew.setContext(asOld.getContext());
    asNew.setTime(asOld.getTime());
    asNew.setState(asOld.getState());
    asNew.setSolveState(asOld.getSolveState());
    this.updateAskSuggest(asNew);
  }
  /**
   * 得到所有记录
   * @return List
   */
  public List getAllAskSuggest()
  {
    return this.getHibernateTemplate().loadAll(AskSuggest.class);
  }
  /**
   * 得到提有记录,按时间排序
   * @return List
   */
  public List getAllAskSuggestTwo()
  {
    String hql="from AskSuggest as ask order by ask.time desc";
    return this.getHibernateTemplate().find(hql);
  }
  /**
   * 得到类型标志
   * @param id String
   * @return String
   */
  public String getState(String id)
  {
    return this.getAskSuggest(id).getState();
  }
  /**
   * 得到解决标志
   * @param id String
   * @return String
   */
  public String getSoveState(String id)
  {
   return this.getAskSuggest(id).getSolveState();
  }
  /**
   * 修改问题解决标志
   * @param id String
   */
  public void updateSolveState(String id)
  {
    net.sf.hibernate.Session session=null;
    java.sql.PreparedStatement ps=null;
    java.sql.Connection con=null;
    try
    {
      String sql = "update ASK_SUGGEST set solve_state=? where id=?";
      session=this.getSession();
      con=session.connection();
      ps=con.prepareStatement(sql);
      ps.setString(1,"01");
      ps.setString(2,id);
      ps.executeUpdate();
      ps.close();
      con.close();
      session.close();
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
  }
  /**
   * 修改显示标志为显示
   * @param id String
   */
  public void setDisState(String id)
  {
    AskSuggest ask=getAskSuggest(id);
    ask.setTitle(ask.getTitle());
    ask.setContext(ask.getContext());
    ask.setTime(ask.getTime());
    ask.setState(ask.getState());
    ask.setDisState("01");
    ask.setSolveState(ask.getSolveState());
    getHibernateTemplate().update(ask);
  }
}