clubactionimp.java

自己制作的联通CRM,支持客户分类,管理,升级,积分管理等等..

package com.jn0801.clubmanage.dao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;

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.jn0801.clubmanage.Clubaction;
import com.jn0801.clubnetinfo.ClubManageBean;
import com.jn0801.tools.DBConnection;
import com.jn0801.tools.PageDAO;

/**
 * 俱乐部活动管理的实现类
 * 
 * @author jzh
 * 
 */
public class ClubActionImp extends HibernateDaoSupport implements ClubActionInf {

	/**
	 * 删除俱乐部活动
	 * 
	 * @param nid
	 *            俱乐部活动编号
	 * @return 是否成功
	 */
	public boolean deleteClubaction(Long nid) {

		Clubaction clubaction = (Clubaction) this.getHibernateTemplate().get(
				Clubaction.class, nid);

		boolean tag = false;

		try {
			this.getHibernateTemplate().delete(clubaction);
			tag = true;
		} catch (Exception e) {
			e.printStackTrace();
		}

		return tag;
	}

	/**
	 * 添加俱乐部活动
	 * 
	 * @param clubaction
	 *            俱乐部活动
	 * @return 是否成功
	 */
	public boolean saveClubaction(Clubaction clubaction) {

		boolean tag = false;

		try {
			this.getHibernateTemplate().save(clubaction);
			tag = true;

		} catch (Exception e) {
			e.printStackTrace();
		}

		return tag;
	}

	/**
	 * 查找所有俱乐部活动
	 * 
	 * @param request
	 *            请求
	 * @return 俱乐部活动列表
	 */
	public List<Clubaction> searchClubaction(HttpServletRequest request) {

		String hql = null;
		Session session = null;
		Query query = null;
		List<Clubaction> list = new ArrayList<Clubaction>();

		try {

			// 开始分页
			PageDAO pageDao = new PageDAO(request);
			pageDao.setPagesize(10);

			// 获取每页多少条
			int pagesize = pageDao.getPagesize();

			// 获取记录总数
			hql = "select count(c.nid) from Clubaction c";
			session = this.getSession();
			query = session.createQuery(hql);

			// 总记录数
			int rscount = (Integer) query.uniqueResult();
			pageDao.setRscount(rscount);

			// 获取总页数
			int pagecount = pageDao.getPageCount();

			// 获取当前页
			int currentpage = pageDao.getCurrentPage();

			// 构建工具栏
			String pagetool = pageDao.pagetool(PageDAO.BbsText);
			request.setAttribute("pagetool", pagetool);

			hql = "select c from Clubaction c order by c.nid";

			query = session.createQuery(hql);
			query.setFirstResult((currentpage - 1) * pagesize);
			query.setMaxResults(pagesize);

			list = query.list();
			session.flush();

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			// this.closeSessionIfNecessary(session);
			if (session != null)
				session.close();
		}

		// List<Clubaction> list = this.getHibernateTemplate().find(hql);

		return list;
	}

	/**
	 * 修改俱乐部活动
	 * 
	 * @param clubaction
	 *            俱乐部活动
	 * @return 是否成功
	 */
	public boolean updateClubaction(Clubaction clubaction) {

		boolean tag = false;

		try {
			this.getHibernateTemplate().update(clubaction);
			tag = true;
		} catch (Exception e) {
			// TODO: handle exception
		}

		return tag;
	}

	/**
	 * 查找所有俱乐部活动
	 * 
	 * @return 俱乐部活动的集合
	 */
	public List<Clubaction> searchClubaction() {

		String hql = "select c from Clubaction c order by c.nid";

		return this.getHibernateTemplate().find(hql);
	}

	/**
	 * 根据编号查找俱乐部活动
	 * 
	 * @param nid
	 *            活动编号
	 * @return 俱乐部活动
	 */
	public Clubaction searchClubactionById(Long nid) {

		Clubaction clubaction = (Clubaction) this.getHibernateTemplate().get(
				Clubaction.class, nid);

		return clubaction;
	}

	/**
	 * 审核俱乐部活动
	 * 
	 * @param nid
	 *            活动编号
	 * @param ispass
	 *            是否通过
	 * @param opinion
	 *            审核意见
	 * @return 是否成功
	 */
	public boolean updateClubactionForcheck(final Long nid,
			final String ispass, final String opinion) {

		int i = (Integer) this.getHibernateTemplate().execute(
				new HibernateCallback() {

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

						String hql = "update Clubaction set "
								+ "ischecked = :ischecked, ispass = :ispass, opinion = :opinion "
								+ "where nid = " + nid;

						Query query = session.createQuery(hql);
						query.setString("ischecked", "已");
						query.setString("ispass", ispass);
						query.setString("opinion", opinion);

						int i = query.executeUpdate();

						return i;
					}
				});

		if (i > 0) {
			return true;
		} else {
			return false;
		}

	}

	/**
	 * 查找所有联盟俱乐部
	 * @return  联盟俱乐部的集合类
	 */
	public List<ClubManageBean> searchAllClub() {
		
		List<ClubManageBean> list = new ArrayList<ClubManageBean>();
		
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		
		String sql = "select clubname from clubInfoManage";
		
		try {
			conn = DBConnection.getConnection();
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			
			while(rs.next()){
				
				ClubManageBean cmb = new ClubManageBean();
				cmb.setClubname(rs.getString("clubname"));
				list.add(cmb);
				
			}
			
		} catch (Exception e) {
			e.printStackTrace();
			
		}finally {
			try {
				if (rs != null)
					rs.close();
				if (stmt != null)
					stmt.close();
				if (conn != null)
					conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		
		return list;
	}

}