Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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: ÎÞЧµÄÁÐÀàÐÍ


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


Ïà¹ØÎÊ´ð£º

C/SÏîÄ¿¼Ü¹¹Éè¼Æ----ÇóÖú - Java / Java SE

±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬ 
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£ 
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......

javaÖеÄ×¢½â¿ÉÒÔÓÐÄÄЩ£¿ - Java / Java EE

È磺 @superwaring("unchecked");
Õâ¸öÀïÃæ¶¼¿ÉÒÔÈ¡ÄÄЩֵ°¡£¬»¹ÓÐÀàËÆµÄ @superwaring±êÇ©ÓÐÄÄЩ°¡
ûÓùý¡£¡£

¿´jeeµÄapi
javax.persistenceÀï
@superwaring("unchecked");Ö»ÊǺöÂÔ ......

java ÇóÖú - Java / Java EE

insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......

jspºÍtomcatÎÊÌ⣬¿ì·èÁË - Java / Java EE

ÎÒдÁ˸öjspÒ³Ãæ£¬È»ºó¸Ä¶¯ÁËһϣ¬¸Ä¶¯µÄÄÚÈݾÍÊÇÔÚjspÒ³ÃæµÄjsº¯ÊýÀï¼ÓÁ˸öalert()Óï¾ä£¬µ«ÊÇÎÒ·ÃÎÊÕâ¸öÒ³ÃæÊ±£¬ËÀ»î¶¼ÊÇÔ­À´Ò³ÃæµÄÄÚÈÝ£¬ÎÒ¼ÓÁ˺ܶàalertº¯Êý»¹ÊÇû¸Ä¶¯Ç°µÄÒ³ÃæÄÚÈÝ£»tomcatÖØÆôÁË£¬Ò²ÖØÐ²¿ÊðÕâ ......

oracle ´æ´¢¹ý³Ì¸Ä³É ÊÂÎï Ôõôд°¡ - Oracle / ¿ª·¢

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