67,513
社区成员
发帖
与我相关
我的任务
分享
<typeAlias alias="vpmnBeanModel" type="com.znwbb.vpmn.bean.Vpmn"/>
<resultMap id="vpmnInfo" class="vpmnBeanModel">
<result property = "callbegintime" column = "callbegintime"/>
<result property = "calltype" column = "calltype"/>
<result property = "callduration" column = "callduration"/>
<result property = "callingpartynumber" column = "callingpartynumber"/>
<result property = "calledpartynumber" column = "calledpartynumber"/>
</resultMap>
<parameterMap id="vpmnSelect" class="java.util.HashMap">
<parameter property="cur_sql" jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" resultMap="vpmnInfo" mode="OUT"/>
<parameter property="v_rowcount" jdbcType="INT" javaType="java.lang.Integer" mode="OUT"/>
<parameter property="in_str_begintime" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="in_str_endtime" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="in_call" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="in_called" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="in_currentpage" jdbcType="INT" javaType="java.lang.Integer" mode="IN"/>
<parameter property="in_pagesize" jdbcType="INT" javaType="java.lang.Integer" mode="IN"/>
<parameter property="in_qrytype" jdbcType="INT" javaType="java.lang.Integer" mode="IN"/>
</parameterMap>
<procedure id="vpmnprom" parameterMap="vpmnSelect">
<![CDATA[{call ireport_vpmn(?,?,?,?,?,?,?,?,?)} ]]>
</procedure>
public List<Vpmn> vpmnBySelect(Vpmn vpmn, int currentPage, int pageSize, int querytype)
{
Map map = new HashMap();
map.put("cur_sql", OracleTypes.CURSOR);
map.put("v_rowcount", java.sql.Types.INTEGER);
map.put("in_str_begintime", vpmn.getStarttime() );
map.put("in_str_endtime", vpmn.getEndtime());
map.put("in_call", vpmn.getCallingpartynumber() );
map.put("in_called", vpmn.getCalledpartynumber());
map.put("in_currentpage", currentPage );
map.put("in_pagesize", pageSize);
map.put("in_qrytype", querytype);
getSqlMapClientTemplate().queryForList("vpmnprom", map);
@SuppressWarnings("unused")
List list = (List) map.get("cur_sql");
int result = (Integer) map.get("v_rowcount");
if (list == null || list.size() == 0 || result == 0)
{
list = new ArrayList();
}
return list;
}