ÓÃ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: ÎÞЧµÄÁÐÀàÐÍ
ÇëÖ¸µ¼Ò»Ï³ö²
Ïà¹ØÎÊ´ð£º
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
ÎÒÔÚ javaºËÐļ¼ÊõÉÏ ¿´ÁËÒ»¸ö ÀûÓà Java socket emailµÄÀý×Ó ¿ÉÊÇÔõôҲ ²»³É¹¦ Ϊʲô£¿
Ô´Âë
Java code:
package cn.com.test.email;
import java.awt.GridBagLayout;
import java.awt.event.Action ......
ÏÖÔÚ²»ÏëÓÃ<a> </a> ±êÇ© £¬ÒòΪµã»÷ºó»á³öÏÖÒ³ÃæÖØ¶¨Î»£¬¸øÎÄ×Ö¼ÓÉÏcssÑùʽ¾Í¿ÉÒÔ¿´ÆðÀ´ ÊÇhrefÔõôʵÏÖÕâÑùµÄcss
text-decoration:underline; cursor:hand;
ÒýÓÃ
text-decoration:underline; cur ......
SQL code:
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......