Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÓÃibatisµ÷ÓÃoracleº¯ÊýµÄÎÊÌâ - Java / Web ¿ª·¢

oracleº¯ÊýÈçÏ£º
create or replace function P_WEB_GETCITYID
(
  p_mobileNumber in VARCHAR2,
  p_cityid out NUMBER
) Return NUMBER
IS
  p_areacode varchar2(20);
v_err VARCHAR2(2000);
begin

  Return 1;
end P_WEB_GETCITYID;

iabtisÅäÖÃÎļþ£º
<parameterMap id="cityIDMap" class="java.util.Map" >
<parameter property="p_mobilenumber" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="p_cityid" jdbcType="NUMBER" javaType="java.lang.Integer" mode="OUT"/>
</parameterMap>

<procedure id="getCityID" parameterMap="cityIDMap">
<![CDATA[
{call P_WEB_GETCITYID(?,?)}
]]>
</procedure>
java´úÂ룺
  Map<String,Object> map = new HashMap<String,Object>();
  map.put("p_mobilenumber", servNumber);
  map.put("p_cityid", new Integer(-1));
  getSqlMapClientTemplate().queryForObject("procedure.getCityID", map);


µ÷ÓõÄʱºò±¨´í£º
--- Check the output parameters (register output parameters failed).  
--- Cause: java.sql.SQLException: ÎÞЧµÄÁÐÀàÐÍ


ÇëÖ¸µ¼Ò»Ï³ö²


Ïà¹ØÎÊ´ð£º

FCKÉÏ´«Îļþµ½linux·þÎñÆ÷ÎÊÌâ - Java / Java EE

ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£

ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......

·ÖÏí×Ô¼ºµÄOracleÅäÖùý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí

Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£» ......

Ä£Äâhref µÄ cssÑùʽ - Java / Web ¿ª·¢

ÏÖÔÚ²»ÏëÓÃ<a> </a> ±êÇ© £¬ÒòΪµã»÷ºó»á³öÏÖÒ³ÃæÖØ¶¨Î»£¬¸øÎÄ×Ö¼ÓÉÏcssÑùʽ¾Í¿ÉÒÔ¿´ÆðÀ´ ÊÇhrefÔõôʵÏÖÕâÑùµÄcss
text-decoration:underline; cursor:hand;

ÒýÓÃ
text-decoration:underline; cur ......

oracle ´æ´¢¹ý³ÌÖÐÓ¦ÓÃÊÂÎñµÄÎÊÌâ - Oracle / ¿ª·¢

SQL code:

CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ