mmsactiveprogramstep.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 MMSActiveProgramStep {
	private int apID;
	private int stepNo;
	private int contentID;
	private String memo;
	private List listElement;	
	
	public final int getApID() {
		return apID;
	}
	public final void setApID(int agID) {
		this.apID = agID;
	}
	public final int getContentID() {
		return contentID;
	}
	public final void setContentID(int contentID) {
		this.contentID = contentID;
	}
	public final int getStepNo() {
		return stepNo;
	}
	public final void setStepNo(int stepNo) {
		this.stepNo = stepNo;
	}
	public final String getMemo() {
		return memo;
	}
	public final void setMemo(String memo) {
		this.memo = memo;
	}
	
	/**
	 * 添加交互节目里步骤中的线索
	 * @param element 交互节目里步骤中的线索
	 */
	public void addElement(MMSActiveProgramStepElement element){
		Connection dbConnection = null;
		CallableStatement statement = null;
		
		try {
			Session sess = HibernateUtil.currentSession();
			dbConnection = sess.connection();
			
			// 调用存储过程 MMS_PActiveGameAddStepElement
			statement = dbConnection
					.prepareCall("{call MMS_PActiveGameAddStepElement (?, ?, ?, ?)}");
			statement.setInt(1, apID);
			statement.setInt(2, stepNo);
			statement.setString(3, element.getReponseText());
			statement.setInt(4, element.getNextStepNo());
			
			statement.execute();
			dbConnection.commit();
			
		} catch (Exception ex) {
			ex.printStackTrace();

		} finally {
			
			if (statement != null) {
				try {
					statement.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			
			HibernateUtil.closeSession();
		}
	}
	
	/**
	 * 删除交互节目里步骤中的线索
	 * @param element 交互节目里步骤中的线索
	 */
	public void removeElement(MMSActiveProgramStepElement element){
		Connection dbConnection = null;
		CallableStatement statement = null;
		
		try {
			Session sess = HibernateUtil.currentSession();
			dbConnection = sess.connection();
			// 调用存储过程 MMS_PActiveGameRemoveStepElement
			statement = dbConnection
					.prepareCall("{call MMS_PActiveGameRemoveStepElement (?)}");
			statement.setInt(1, element.getElementID());
						
			statement.execute();
			dbConnection.commit();			
			
		} catch (Exception ex) {
			ex.printStackTrace();
			return;
		} finally {
			
			if (statement != null) {
				try {
					statement.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			
			HibernateUtil.closeSession();
		}
	}
	
	/**
	 * 返回该环节的所有线索
	 * @return 该环节的所有线索
	 */
	public List getStepElements(){
		Connection dbConnection = null;
		CallableStatement statement = null;
		ResultSet set = null;
		int pContentID = 0;
		listElement = null;
		
		try {
			Session sess = HibernateUtil.currentSession();
			dbConnection = sess.connection();
			// 调用存储过程 MMS_PActiveGameShowStepElements
			statement = dbConnection
					.prepareCall("{call MMS_PActiveGameShowStepElements (?, ?)}");
			statement.setInt(1, apID);
			statement.setInt(2, stepNo);

			set = statement.executeQuery();
			
			if (listElement == null){
				listElement = new ArrayList();
			}
			
			// 组装结果集
			while (set.next() != false){
				MMSActiveProgramStepElement s = new MMSActiveProgramStepElement();
				s.setApID(apID);
				s.setElementID(stepNo);
				s.setElementID(set.getInt("tnElementID"));
				s.setReponseText(set.getString("tcSelect"));
				s.setNextStepNo(set.getInt("tnNextStep"));
				
				listElement.add(s);
			}

		} 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 listElement;
	}
	
	/**
	 * 获得该环节中指定线索编号的线索
	 * @param elementID 线索编号
	 * @return 该环节中指定线索编号的线索
	 */
	public MMSActiveProgramStepElement getStepElementByID(final int elementID){
		List tmp = getStepElements();
		for (int i = 0; i < tmp.size(); i++){
			MMSActiveProgramStepElement e = (MMSActiveProgramStepElement)tmp.get(i);
			if (e.getElementID() == elementID){
				return e;
			}
		}
		
		return null;
	}
}