ibatis中调用如下:
<typeAlias alias="corp" type="com.wes.model.Corp" />
<resultMap id="corp-map" class="corp">
<result property="corpNo" column="ORGANCODE" />
</resultMap>
<parameterMap id="test" class="java.util.HashMap" >
<parameter property="result" jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT" resultMap="corp-map" />
<parameter property="param1" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="param2" jdbcType="Date" javaType="java.util.Date" mode="IN"/>
</parameterMap>
<procedure id="testCur" parameterMap="test">
{? = call GetCurTest(?, ?)}
</procedure>
java中调用如下:
String resource = "SqlMapConfig.xml";
SqlMapClient client = null;
try...{
Reader reader = Resources.getResourceAsReader(resource);
client = SqlMapClientBuilder.buildSqlMapClient(reader);
}catch (Throwable e)...{}
Map p = new HashMap();
p.put("param1","a");
p.put("param2","b");
client.queryForObject(mapid, p);
List list = (List) p.get("result");
if (list == null || list.size() == 0)
list = new ArrayList();
return list;
list存放的就是我们要的结果集.
ibatis 调用存储过程 ibatis 调用存储过程
<typeAlias alias="corp" type="com.wes.model.Corp" />
<resultMap id="corp-map" class="corp">
<result property="corpNo" column="ORGANCODE" />
</resultMap>
<parameterMap id="test" class="java.util.HashMap" >
<parameter property="result" jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT" resultMap="corp-map" />
<parameter property="param1" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="param2" jdbcType="Date" javaType="java.util.Date" mode="IN"/>
</parameterMap>
<procedure id="testCur" parameterMap="test">
{? = call GetCurTest(?, ?)}
</procedure>
java中调用如下:
String resource = "SqlMapConfig.xml";
SqlMapClient client = null;
try...{
Reader reader = Resources.getResourceAsReader(resource);
client = SqlMapClientBuilder.buildSqlMapClient(reader);
}catch (Throwable e)...{}
Map p = new HashMap();
p.put("param1","a");
p.put("param2","b");
client.queryForObject(mapid, p);
List list = (List) p.get("result");
if (list == null || list.size() == 0)
list = new ArrayList();
return list;
list存放的就是我们要的结果集.
ibatis 调用存储过程 ibatis 调用存储过程
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货