moviefilmdaoimpl.java

j2ee,struts2 hibernate spring2.5的电影系统简单的

package com.movie.dao.impl;

import java.sql.SQLException;
import java.util.Iterator;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.movie.dao.MoviefilmDao;
import com.movie.dojo.Moviefilm;
import com.movie.dojo.Movieurl;
import com.movie.manager.MovieurlManager;

public class MoviefilmDaoImpl extends HibernateDaoSupport implements
		MoviefilmDao {
	private MovieurlManager movieurlManager;

	public MovieurlManager getMovieurlManager() {
		return movieurlManager;
	}

	public void setMovieurlManager(MovieurlManager movieurlManager) {
		this.movieurlManager = movieurlManager;
	}

	public void delMoviefilm(Moviefilm moviefilm) {
		getHibernateTemplate().delete(moviefilm);
	}

	public void addMoviefilm(Moviefilm moviefilm, List<Movieurl> movieurl) {

		for (Iterator iterator = movieurl.iterator(); iterator.hasNext();) {
			Movieurl itMovieurl = (Movieurl) iterator.next();
			moviefilm.getMovieUrl().add(itMovieurl);
			itMovieurl.setMoviefilm(moviefilm);
		}
		getHibernateTemplate().save(moviefilm);

	}

	public List getMovieFilm(String searchName, String searchValue,
			int pageSize, int startRow) {
		final int pageSize1 = pageSize;
		final int startRow1 = startRow;
		final String queryName = searchName;
		final String queryValue = searchValue;
		String sqlString = "";
		if (queryName == null || queryName.equals("") || queryValue == null
				|| queryValue.equals("")) {
			sqlString = "from Moviefilm";
		} else {
			sqlString = "from Moviefilm where " + queryName + "like '%"
					+ queryValue + "%' order by m.movieTime desc";
		}
		final String sql = sqlString;
		return this.getHibernateTemplate().executeFind(new HibernateCallback() {

			public List doInHibernate(Session session)
					throws HibernateException, SQLException {

				Query query = session.createQuery(sql);
				query.setFirstResult(startRow1);
				query.setMaxResults(pageSize1);
				return query.list();
			}

		});
	}

	public List getMovieFilm(int pageSize, int startRow) {
		final int pageSize1 = pageSize;
		final int startRow1 = startRow;

		return this.getHibernateTemplate().executeFind(new HibernateCallback() {

			public List doInHibernate(Session session)
					throws HibernateException, SQLException {

				Query query = session
						.createQuery("from Moviefilm m order by m.movieTime desc");
				query.setFirstResult(startRow1);
				query.setMaxResults(pageSize1);
				return query.list();
			}

		});
	}

	public int getRows() {
		String sqlString = "from Moviefilm";
		List list = getHibernateTemplate().find(sqlString);
		return list.size();
	}

	public int getRows(String searchName, String searchValue) {
		String sql = "from Moviefilm where " + searchName
				+ "like '% order by m.movieTime desc" + searchValue + "%'";
		List list = getHibernateTemplate().find(sql);
		return list.size();
	}

	public List queryMoviefilm(String searchName, String searchValue) {
		String sql = "from Moviefilm where " + searchName
				+ "like '% order by m.movieTime desc" + searchValue + "%'";

		return getHibernateTemplate().find(sql);
	}

	public List getFiveMovieFilm(int pageSize, int startRow, String movieType) {
		final int pageSize1 = pageSize;
		final int startRow1 = startRow;
		final String movieTypeString = movieType;
		String sqlString = "";
		if (movieTypeString == null || movieTypeString.equals("")) {
			sqlString = "from Moviefilm";
		} else {
			sqlString = "from Moviefilm m where m.movieType=? order by m.movieTime desc";

		}
		final String sql = sqlString;

		return this.getHibernateTemplate().executeFind(new HibernateCallback() {

			public List doInHibernate(Session session)
					throws HibernateException, SQLException {

				Query query = session.createQuery(sql);
				query.setString(0, movieTypeString);
				query.setFirstResult(startRow1);
				query.setMaxResults(pageSize1);
				return query.list();
			}

		});
	}

	public int getMovieFilmRows(String movieType) {
		String sqlString = "";
		if (movieType == null || movieType.equals("")) {
			sqlString = "from Moviefilm";
		} else {
			sqlString = "from Moviefilm m where m.movieType='" + movieType
					+ "'";
		}
		List list = getHibernateTemplate().find(sqlString);
		return list.size();

	}

	public Moviefilm getThisMoviefilm(int id) {
		return (Moviefilm) getHibernateTemplate().get(Moviefilm.class, id);
	}

	public void modifyMoviefilm(Moviefilm moviefilm, List<Movieurl> movieurl) {
		for (Iterator iterator = movieurl.iterator(); iterator.hasNext();) {
			Movieurl itMovieurl = (Movieurl) iterator.next();
			itMovieurl.setMoviefilm(moviefilm);
			movieurlManager.modifyMovieurl(itMovieurl);
		}
		getHibernateTemplate().update(moviefilm);
	}

	public Moviefilm getTopMoviefilm(String movieType) {
		String sqlString = "from Moviefilm m where m.movieType='" + movieType
				+ "' order by m.movieTime desc";
		List list = getHibernateTemplate().find(sqlString);
		Moviefilm moviefilm = null;
		if (list.size() > 0) {
			moviefilm = (Moviefilm) list.get(0);
		}
		return moviefilm;
	}

	public List getMovieFilmTop(int pageSize, int startRow) {
		final int pageSize1 = pageSize;
		final int startRow1 = startRow;

		return this.getHibernateTemplate().executeFind(new HibernateCallback() {

			public List doInHibernate(Session session)
					throws HibernateException, SQLException {

				Query query = session
						.createQuery("from Moviefilm m where m.movieLeval='★★★★★' order by m.movieTime desc");
				query.setFirstResult(startRow1);
				query.setMaxResults(pageSize1);
				return query.list();
			}

		});
	}

	public List getMovieFilmTop(int pageSize, int startRow, String movieType) {
		final int pageSize1 = pageSize;
		final int startRow1 = startRow;
		String sqlString = "";
		if (movieType == null || movieType.equals("")) {
			sqlString = "from Moviefilm m  order by m.movieTime desc";
		} else {
			sqlString = "from Moviefilm m where m.movieType='" + movieType
					+ "' order by m.movieTime desc";
		}
		final String sql = sqlString;
		return this.getHibernateTemplate().executeFind(new HibernateCallback() {

			public List doInHibernate(Session session)
					throws HibernateException, SQLException {

				Query query = session.createQuery(sql);
				query.setFirstResult(startRow1);
				query.setMaxResults(pageSize1);
				return query.list();
			}

		});
	}

	public List getMovieFilmNum(int pageSize, int startRow, String movieType) {
		final int pageSize1 = pageSize;
		final int startRow1 = startRow;
		String sqlString = "";
		if (movieType == null || movieType.equals("")) {
			sqlString = "from Moviefilm m  order by m.movieNum desc";
			
		} else {
			sqlString = "from Moviefilm m where m.movieType='" + movieType
					+ "' order by m.movieNum desc";
		}
		final String sql = sqlString;
		return this.getHibernateTemplate().executeFind(new HibernateCallback() {

			public List doInHibernate(Session session)
					throws HibernateException, SQLException {

				Query query = session
						.createQuery(sql);
				query.setFirstResult(startRow1);
				query.setMaxResults(pageSize1);
				return query.list();
			}

		});
	}


}