contactushibernatedao.java~153~

hibernate+spring的相片上传项目

package org.lenovoAC.hibernateDao;

import org.lenovoAC.pojo.ContactUs;
import java.util.List;
import org.lenovoAC.dao.ContactUsDao;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *联系我们
  联系我们表: contact_us

 * @author not attributable
 * @version 1.0
 */
public class ContactUsHibernateDao
    extends BaseDao implements ContactUsDao
{
  /**
   * 添加
   * @param cu ContactUs
   */
  public void insertContactUs(ContactUs cu)
  {
    this.getHibernateTemplate().save(cu);
  }

  /**
   * 修改
   * @param cu ContactUs
   */
  public void updateContactUs(ContactUs cu)
  {
    net.sf.hibernate.Session session=null;
    java.sql.PreparedStatement ps=null;
    java.sql.Connection con=null;
    try
    {
      String sql="update CONTACT_US set Company_name=?,Address=?,Contact_person=?,"+
          "Phone=?,Type=?,e_mail=?,mobile_phone=?,Time=sysdate where id=?";
      session=this.getSession();
      con=session.connection();
      ps=con.prepareStatement(sql);
      ps.setString(1,cu.getCompanyName());
      ps.setString(2,cu.getAddress());
      ps.setString(3,cu.getContactPerson());
      ps.setString(4,cu.getPhone());
      ps.setString(5,cu.getType());
      ps.setString(6,cu.getEMail());
      ps.setString(7,cu.getMobilePhone());
      ps.setString(8,cu.getId());
      ps.executeUpdate();
      ps.close();
      con.close();
      session.close();
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
  }

  /**
   * 删除
   * @param cu ContactUs
   */
  public void delContactUs(ContactUs cu)
  {
    this.getHibernateTemplate().delete(cu);
  }

  /**
   * 得到ID所指定对象
   * @param id String
   * @return ContactUs
   */
  public ContactUs getContactUs(String id)
  {
    return (ContactUs)this.getHibernateTemplate().get(ContactUs.class, id);
  }

  /**
   * 删除ID所指定对象
   * @param id String
   */
  public void delContactUsTwo(String id)
  {
    ContactUs cu = getContactUs(id);
    delContactUs(cu);
  }

  /**
   * 修改ID指定的对象
   * @param id String
   */
  public void updateContactUsTwo(String id, ContactUs cu)
  {
    ContactUs cuT = this.getContactUs(id);
    cuT.setCompanyName(cu.getCompanyName());
    cuT.setAddress(cu.getAddress());
    cuT.setContactPerson(cuT.getContactPerson());
    cuT.setPhone(cu.getPhone());
    cuT.setType(cu.getType());
    cuT.setEMail(cu.getEMail());
    cuT.setMobilePhone(cu.getMobilePhone());
    cuT.setTime(cu.getTime());
    this.updateContactUs(cuT);
  }

  /**
   * 得到所有记录
   * @return List
   */
  public List getAllContactUs()
  {
    return this.getHibernateTemplate().loadAll(ContactUs.class);
  }

  /**
   * 得到所有记录(排序)
   * @return List
   */
  public List getAllContactUsTwo()
  {
    String hql = "from ContactUs as cu order by cu.time desc";
    return this.getHibernateTemplate().find(hql);
  }
  public List getAll(String numOne,String numTwo)
  {
    String hql="from ContactUs as cu where cu.type=? or cu.type=? order by cu.time desc";
    this.getHibernateTemplate().find();
  }
}