ÎÒµÄÊý¾Ý½á¹¹ÈçÏÂ:
0-´ó·ÖÀà±àºÅ-¶þ·ÖÀà±àºÅ-Èý·ÖÀà±àºÅ:´ó·ÖÀàÃû-¶þ·ÖÀàÃû-Èý·ÖÀàÃû
ÀýÈç:
0-103-1508:ʱÉмҵç-µçÆ÷¸½¼þ
0-320-1414-1474:³øÎÀÇå½à-Ò»´ÎÐÔÓÃÆ·-À¬»ø´ü1
0-320-1414-1469-1471:³øÎÀÇå½à-Ò»´ÎÐÔÓÃÆ·-±£ÏÊĤ1-±£ÏÊ´ü1
ÏÖÔÚ,ÎÒҪȡ³ö¶þ·ÖÀàÃû(ÀýÈçµÚÒ»ÌõÈ¡³ö:¼Òµç¸½¼þ,µÚ¶þÌõÈ¡³ö:Ò»´Î ......
ÎÒ°ÑÒ»¶ÎxmlÎļþ´æ´¢ÔÚoracleÊý¾Ý¿â long ÀàÐ͵Ä×Ö¶ÎÖУ¬´æ´¢Ê±Ê¹ÓõÄÊÇOracleClient½øÐвÙ×÷£¬´æÈë¿âÖеÄÄÚÈÝÒ²ÕýÈ·£¨ÔÚ¿âÖпÉÒÔÖ±½Ó¿´µ½£©£¬
¿ÉÆæ¹ÖµÄÊÇÈç¹ûʹÓÃOracleClient½øÐжÁÈ¡£¬¶Á³öÀ´µÄÄÚÈÝÖмäÓÐÒ»²¿·Ö»áÍêÈ«´í¿ª£¬±ä³ÉÂÒÂ룬µ¼ÖÂxml¸ñʽ´íÎó¡£
¶øÈç¹û´ËʱÓÃol ......
¶ÔÁ½±í¶¼×öͳ¼Æ²éѯ½á¹ûÈçÏ£¨¶¼¾¹ýÁËÖÁÉÙ10´ÎÒÔÉϵIJâÊÔ£©
±ía ±íb
Êý¾Ý¿âa 0.11~0.125 s 220 Ìõ¼Ç¼ 2.8¡«12 s   ......
ÊÓͼÖÐÓÐcollegeid£¨Ñ§Ôº±àºÅ£©¡¢stuid£¨¿¼Éú±àºÅ£©¡¢¿¼Éú×ܳɼ¨£»ÇëÎÊÕâ¸öÊÓͼÔõôд£¿ÏÂÃæÊÇÎÒ×Ô¼ºÐ´µÄ£¬±¨ ²»ÊÇ group by ±í´ïʽµÄ´í£¬ÇëÎÊÔõô¸ÄÕý£¿
create or replace view view_will as
select college.collegeid,mat.stuid,sum(score.chinese+score.math+score.english+score.complex)
......
ÓÃjdbcÁ¬½Óµ½oracleÊý¾Ý¿â²éѯÊý¾Ý. Á¬½Ó¶¼Õý³£. ´òÓ¡³öÀ´µÄsqlÔÚoracleÒ²Äܲéѯ³öÀ´. µ«ÊÇÔÚeclipseÖÐÈ´Ò»Ö±Ìáʾnull
select * from dual; ¶¼²é²»³öÀ´. Á¬½Ó¿Ï¶¨Õý³£. Èç¹û°ÑÓû§ÃÜÂë»òÇý¶¯ÓÐÒâµÄ¸ü¸Ä»áÕý³£Ìáʾ´íÎó.
Íû¸ßÊÖ¸ø½âÊÍÏ лл1
¼ì²éÏ´úÂ룬ÊDz»ÊÇÓÐÎÊÌ⣬ÓÐûÓеõ½ÕýÈ·µÄ½ ......
hibernate ÔõôÁ¬½ÓoracleÊý¾Ý¿â,ÔÚhibernate.cfg.xml ÀïÔõôÅäÖÃ
XML code:
applicationContext-kpi.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-insta ......