mmsactiveprogrammanager.java

MM7彩信对接网关示例

/*
 * Created on 2005-2-25
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package com.rainbow.mms.activeprogram;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.hibernate.Session;

import com.rainbow.util.tools.HibernateUtil;


/**
 * @author Wangzhaonan
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class MMSActiveProgramManager {

	private static MMSActiveProgramManager INSTANCE = new MMSActiveProgramManager();
	private List listPrograms = null;
	
	private MMSActiveProgramManager(){
		
	}
	
	public static MMSActiveProgramManager getInstance(){
		return INSTANCE;
	}
	
	/**
	 *  返回节目列表
	 * @return
	 */
	public List showActivePrograms(){
		Connection dbConnection = null;
		CallableStatement statement = null;
		ResultSet set = null;
		int pContentID = 0;
		listPrograms = null;
		
		try {

			Session sess = HibernateUtil.currentSession();
			dbConnection = sess.connection();
			// 调用存储过程 MMS_PActiveGameShow
			statement = dbConnection
					.prepareCall("{call MMS_PActiveGameShow ()}");

			set = statement.executeQuery();
			
			if (listPrograms == null){
				listPrograms = new ArrayList();
			}
			
			// 组装结果集
			
			while (set.next() != false){
				MMSActiveProgram a = new MMSActiveProgram();
				a.setApID(set.getInt("tnAGID"));
				a.setName(set.getString("tcAGName"));
				a.setMemo(set.getString("tcMemo"));
				
				listPrograms.add(a);
			}
			

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

		} finally {
			
			if (set != null){
				try {
					set.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			
			if (statement != null) {
				try {
					statement.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			
			HibernateUtil.closeSession();
		}

		return listPrograms;
	}
	
	/**
	 * 返回指定节目编号的交互节目信息
	 * @param apID 节目编号
	 * @return 交互节目信息
	 */
	public MMSActiveProgram getProgramByID(final int apID){
		
		if (listPrograms != null){
			for (int i = 0; i < listPrograms.size(); i++){
				MMSActiveProgram tmp = (MMSActiveProgram)listPrograms.get(i);
				if (tmp.getApID() == apID){
					return tmp;
				}
			}
		}
		
		return null;
	}
}