fileuploadimpl.java

详细的建站源码 详细的建站源码 详细的建站源码 详细的建站源码

/* 
 * Created on 2007-4-17
 * Last modified on 2007-4-17
 * Powered by YeQiangWei.com
 */
package com.yeqiangwei.club.fileUpload.dao.hibernate;

import java.util.List;

import com.yeqiangwei.club.dao.hibernate.support.HibernateFacade;
import com.yeqiangwei.club.fileUpload.FileUploadParameter;
import com.yeqiangwei.club.fileUpload.dao.FileUpload;
import com.yeqiangwei.club.fileUpload.dao.FileUploadDAO;

public class FileUploadImpl implements FileUploadDAO {
	
	private static final String FIND_ALL = "from FileUpload order by fileUploadId desc";
	
	private static final String COUNT_ALL = "select count(fileUploadId) from FileUpload";
	
	private static final String FIND_FILEUPLOADID = "from FileUpload where fileUploadId=?";
	
	private static final String DELETE_FILEUPLOADID = "delete from FileUpload where fileUploadId=?";
	
	private static final String DELETES_FILEUPLOADID = "delete from FileUpload where fileUploadId in (:ids)";

	public FileUpload create(FileUpload item) {
		HibernateFacade<FileUpload> facade = new HibernateFacade<FileUpload>();
		item = facade.save(item);	
		return item;
	}

	public FileUpload update(FileUpload item) {
		HibernateFacade<FileUpload> facade = new HibernateFacade<FileUpload>();
		item = facade.update(item);
		return item;
	}

	public int delete(FileUpload item) {
		HibernateFacade<FileUpload> facade = new HibernateFacade<FileUpload>();
		facade.createQuery(DELETE_FILEUPLOADID);
		facade.setInt(0, item.getFileUploadId());
		int c = facade.executeUpdate();
		return c;
	}

	public int delete(List ids) {
		HibernateFacade<FileUpload> facade = new HibernateFacade<FileUpload>();
		facade.createQuery(DELETES_FILEUPLOADID);
		facade.setParameterList("ids",ids);
		int c = facade.executeUpdate();
		return c;
	}

	public FileUpload findById(int id) {
		HibernateFacade<FileUpload> facade = new HibernateFacade<FileUpload>();
		facade.createQuery(FIND_FILEUPLOADID);
		facade.setInt(0, id);
		facade.setMaxResults(1);
		FileUpload item = facade.uniqueResult();
		return item;
	}

	public List<FileUpload> findByParameter(FileUploadParameter param) {
		HibernateFacade<FileUpload> facade = new HibernateFacade<FileUpload>();
		facade.createQuery(FIND_ALL);
		facade.setFirstResult(param.getPagination().getStartRow());
		facade.setMaxResults(param.getPagination().getEndRow());
		List<FileUpload> list = facade.executeQuery();
		return list;
	}

	public long countByParameter(FileUploadParameter param) {
		HibernateFacade<FileUpload> facade = new HibernateFacade<FileUpload>();
		facade.createQuery(COUNT_ALL);
		long c = facade.resultTotal();
		return c;
	}

	public List<FileUpload> findAll(FileUploadParameter param) {
		HibernateFacade<FileUpload> facade = new HibernateFacade<FileUpload>();
		facade.createQuery(FIND_ALL);
		facade.setFirstResult(param.getPagination().getStartRow());
		facade.setMaxResults(param.getPagination().getEndRow());
		List<FileUpload> list = facade.executeQuery();
		return list;
	}

	public long countAll(FileUploadParameter param) {
		HibernateFacade<FileUpload> facade = new HibernateFacade<FileUpload>();
		facade.createQuery(COUNT_ALL);
		long c = facade.resultTotal();
		return c;
	}

}