Oracle Reports ÖÐÁ½¸öºÏ¼ÆÊý×ö³ý·¨£¬¹«Ê½Ôõôд£¿
±¨±íÖÐÓÐÁ½¸ö×ֶΣ¬AºÍB¡£
±¨±í×îºóÒ»ÐÐÐèÒªºÏ¼ÆÊýºÍ°Ù·ÖÊý£¬ºÏ¼ÆÊýÏñÕâÑù <?sum(G_LINE/A)?>£¬ <?sum(G_LINE/B)?>¡£
ÇëÎʼÆËãBµÄºÏ¼ÆÊýÕ¼AµÄºÏ¼ÆÊý°Ù·Ö±ÈÔõôд¹«Ê½£¿
ÎÒд³ÉÕâ¸öÑù×Ó£¬ <?sum(G_LINE/A)?> / <?sum(G_LINE/B)?>£¬µ«Êµ¼ÊÉÏÊÇûÓÐ×ö³ý·¨£¬Ö»ÊÇÈ¡ÁËAµÄºÏ¼ÆÊý¡£
·Ç³£¸Ðл¡£
UP
£¿£¿
°ï¶¥
Ïà¹ØÎÊ´ð£º
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÏÖÔÚÎÒ±¾µØÃ»Óа²×°oracle, µ«plsqldevÐèÒªsqlplus.exeµÈ£¬ÇëÎÊoracle10gÔÚwindowsÐèÒª
ÄÄЩexeÎļþ£¬ÄÄλ´ó¸çÄÜ˳±ãÌṩһÏÂQQ£º190565390
×°oracleµÄʱºò¿ÉÒÔÑ¡ÔñÖ»×°¿Í»§¶ËµÄ
×îÆðÂëҪװoracle£¬ÄãÖ»Ðè×°¿ ......
ÓÐ500ÍòÌõͨ»°¼Ç¼
±àºÅ ºÅÂë ±»½ÐºÅÂë ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä ͨ»°Ê±³¤
1 10010 20020 12:00 12:01 ......
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......