ibatis²éѯoracle·ÖÒ³ÅäÖÃ
×î½ü×öÒ»¸öjavaÏîÄ¿£¬Ê¹ÓÃibatisÓëÊý¾Ý¿âÁ¬½Ó£¬ÎÒÏÖÔÚÖªµÀÔÚmysqlÊý¾Ý¿âµÄʱºò£¬ÅäÖÃsql·ÖÒ³ÊÇÓÃ
XML code:
<sql id="pageSql">
<dynamic>
<isNotNull property="startIndex">
<isNotNull property="pageSize">
limit #startIndex# , #pageSize#
</isNotNull>
</isNotNull>
</dynamic>
</sql>
ÎÒÏÖÔÚÓõÄÊÇoracleÊý¾Ý¿â£¬ÇëÎÊÓ¦¸ÃÔõôÅäÖÃÕâ¸ö·Öҳѽ£¿
×Ô¼º½â¾öÁË£¬ºÇºÇ
Ìù³öÀ´¿´¿´
select * from (select rownum as minRownum, u.* from ( select * from user)
) u
<dynamic prepend="where">
<isGreaterThan prepend="and" property="maxRownum" compareValue="0">
<![CDATA[ rownum <=#maxRownum# ]]>
</isGreaterThan>
</dynamic>
) t where
<![CDATA[t.minRownum>#minRownum#]]>
¹§Ï²Ò»Ï£¬°Ñ½â¾ö·½·¨Ìù³öÀ´·ÖÏíÒ»ÏÂ
XML code:
[code=XML]
<sql id="paginationStart">select b.* from (select a.*,rownum as linenum from (</sql>
- <sql id="paginationEnd">
- <dynamic>
- <isNotNull property="startIndex&
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html
Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..
cm ......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......