ordersoperation.java

彩铃小项目的原代码 下载

package hibernate.iml;

import java.util.List;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;
import net.sf.hibernate.Transaction;

import common.HibernateSessionFactory;

public class OrdersOperation extends DBOperationParent {
	/**
	 * method update 更新记录
	 * @param object
	 * @param key
	 * @return 是否更新成功
	 * @throws HibernateException 
	 */
	public boolean update(Object objectTmp, String key) throws HibernateException {
		boolean returnCode = true;
		try {
			if(!session.isOpen()) session = HibernateSessionFactory.currentSession();
			Transaction tx = session.beginTransaction();
			Orders object = (Orders) session.load(Orders.class,key);	//这一行要修改
			Orders inObject = (Orders) objectTmp;						//这一行要修改
			if(object==null) returnCode = false;
			else{
				//赋值语句要修改
				object.setMusicname(inObject.getMusicname());
				object.setMusicid(inObject.getMusicid());
				object.setUnitName(inObject.getUnitName());
				object.setUsername(inObject.getUsername());
				object.setTel(inObject.getTel());
				object.setEmail(inObject.getEmail());
				object.setAddress(inObject.getAddress());
				object.setSex(inObject.getSex());
				object.setDetail(inObject.getDetail());
				object.setRegdate(inObject.getRegdate());
				object.setOthers(inObject.getOthers());
				object.setCardno(inObject.getCardno());
				session.update(object);
				tx.commit();
			}
		} catch (HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateSessionFactory.closeSession();
		}
		return returnCode;
	}
	/**
	 * method getPower
	 * @param username
	 * @param tel
	 * @return String
	 * @throws HibernateException
	 */
	public String getPower(String username,String tel) throws HibernateException{
		String returnCode = "";
		try {
			if(!session.isOpen()) session = HibernateSessionFactory.currentSession();
			String sql = " from Orders where username='"+username+"' and tel='"+tel+"' order by inDate desc";
			Query query = session.createQuery(sql);
			query.setMaxResults(5);
			List lists = query.list();
			if((lists!=null)&&lists.size()>0){
				Orders object = (Orders) lists.get(0);
				returnCode = object.getId();
			}
		} catch (HibernateException e) {
			e.printStackTrace();
		} finally {
			HibernateSessionFactory.closeSession();
		}
		return returnCode;
	}

}