map文件中是这样的:
其中注意,四个问号是有顺序的,因此
parameterMap
也是需要顺序的,
然后java中是这样的,:
- <parameterMap id="postRoadPBParameters" class="map" >
- <parameter property="c_qssj" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
- <parameter property="c_zzsj" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
- <parameter property="n_jgdh" jdbcType="INTEGER" javaType="java.lang.Integer" mode="IN"/>
- <parameter property="n_yhdh" jdbcType="INTEGER" javaType="java.lang.Integer" mode="IN"/>
- </parameterMap>
- <procedure id="postRoadPBResult" parameterMap="postRoadPBParameters" >
- {call p_create_pbjhz(?,?,?,?)}
- </procedure>
然后java中是这样的,:
- Map<String,Object> paraMap= new HashMap<String,Object>();
- paraMap.put("n_jgdh", 30);
- paraMap.put("n_yhdh", 2);
- try {
- DbUtil.getSqlMapClient().queryForList("postRoadPBResult",paraMap);
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }