ticketdaoimpl.java

基于Struts+Hibernate+Spring+Ajax技术开发一个简单的影院在线订票系统

package com.accp.dao.impl;

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

import org.hibernate.Hibernate;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.Criterion;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.accp.dao.TicketDao;
import com.accp.entity.Movieinfo;
import com.accp.entity.Ticket;

public class TicketDaoImpl extends BaseDao implements TicketDao {

	@Override
	public List getTicketByMovieId(final Long movieId) {
		// TODO Auto-generated method stub
		return super.getHibernateTemplate().executeFind(new HibernateCallback() {

			@Override
			public Object doInHibernate(Session s)
					throws HibernateException, SQLException {
				// TODO Auto-generated method stub
				Query query = s.createQuery("select t from Ticket t inner join t.movieinfo m where m.id = ?");
				query.setLong(0, movieId);
				List list = query.list();
				return list;
			}});
	}

	@Override
	public List getTicketByAccountId(final Long accountId) {
		// TODO Auto-generated method stub
		return super.getHibernateTemplate().executeFind(new HibernateCallback() {

			@Override
			public Object doInHibernate(Session s)
					throws HibernateException, SQLException {
				// TODO Auto-generated method stub
				Query query = s.createQuery("select t,m from Ticket t inner join t.accountinfo a inner join t.movieinfo m where a.id = ?");
				query.setLong(0, accountId);
				List list = query.list();
				return list;
			}});
	}

	@Override
	public void delTicketById(Long id) {
		// TODO Auto-generated method stub
		super.delete(Ticket.class, id);
	}

	@Override
	public void addTicket(Ticket ticket) {
		// TODO Auto-generated method stub
		super.save(ticket);
	}

}