Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

hql ¹ØÁª²éѯÎÊÌ⣨mysql)

±íCreditCardBasicInformation  ±íCustomerInformation  £¬±íA Ò»¶Ô¶à ±íB 

HQL£º from CreditCardBasicInformation cr left join cr.customerInformation c
ÓÃHQL¹ØÏµ²éѯʱ±¨´í£º Unknown column 'customerin1_.customerIdentifier' in 'on clause'

Ö÷Òª¾ÍÊǹØÁª²éѯ³ö´í£¬²éѯʱÐèÒªÓõIJéѯ·Ö²¼ÔÚÁ½ÕűíÀ
Èç¹û²»Äܽâ¾öÕâ¸öÎÊÌ⣬¿ÉÒÔÓÐʲôÆäËû°ì·¨ÈÅ¿ªÃ´¡£¡£¡£

Çë¸÷λ¶à¶àÖ¸µã¡£
×Ô¼º¶¥ÆðÀ´ÏÈ¡£¡£¡£¡£

Unknown column 'customerin1_.customerIdentifier' in 'on clause'

customerIdentifieûÓÐÕâ¸öÁа¡

¹ØÁªÓ¦¸ÃÔÚÓ³ÉäÎļþÀïÓÃone-to-many£¬¶ø²»ÊÇ×Ô¼ºÐ´hqlÀ´²é

¾ßÌå¿ÉÒԲο¼
http://blog.csdn.net/wx123456wx/archive/2009/09/11/4542713.aspx

дÉÏone-to-manyºó£¬²éAʱ£¬hibernate×Ô¶¯»á°ïÄã²éB£¬È»ºó°ÑÖµÌîµ½AµÄ³ÉÔ±±äÁ¿ÀïµÄ


3# £º
    ÎÒÒѾ­ÓÐÓ³Éäone-to-many,Ò²¿ÉÒÔÄõ½Êý¾Ý£¬µ«ÊÇÕâÑùµÄ»°²éѯµÄÌõ¼þÖ»ÄÜÊÇA±íÀïÃæµÄ£¬ÎÒÒªÇóµÄ²éѯÌõ¼þÒ»²¿·Ö»¹ÔÚBÀïÃæ£¬ÎÒÓÐÏë¹ýÏÈÄÃA£¬ÔÙ´ÓAÀïÃæÉ¸Ñ¡BÌõ¼þ£¬µ«ÊǸоõÕâÑùÌ«ÂýÁË

2#£º
    ÄãËù˵µÄÁÐÊÇÓеģ¬ÎÒÓò»¹ØÁªµÄÓï¾äÊÇ¿ÉÒԲ鵽Êý¾ÝµÄ¡£¡£¡£
HQL£ºfrom CreditCardBasicInformation cr,CustomerInformation c where c.customerIdentifier='002'



ÒýÓÃ
3# £º
    ÎÒÒѾ­ÓÐÓ³Éäone-to-many,Ò²¿ÉÒÔÄõ½Êý¾Ý£¬µ«ÊÇÕâÑùµÄ»°²éѯµÄÌõ¼þÖ»ÄÜÊÇA±íÀïÃæµÄ£¬ÎÒÒªÇóµÄ²éѯÌõ¼þÒ»²¿·Ö»¹ÔÚBÀïÃæ£¬ÎÒÓÐÏë¹ýÏÈÄÃA£


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

MYSQL ÈçºÎÐÞ¸ÄBLOBÀàÐ͵ÄÊý¾Ý?

ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿

¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......

ÐèÒªÊÓÆµ½Ì³ÌµÄÐÂÊÖ½ø php + mysql + apache ÅäÖÃ

Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´


......

MYSQLÊÂÎñ»Ø¹öµÄÎÊÌâ

SQL code:

CREATE PROCEDURE A()
BEGIN
DECLARE 'Constraint Violation'
CONDITION FOR sqlexception;
DECLARE EXIT HANDLER FOR
'Constraint Violation' ROLLBACK;
BEGIN TRAN ......

MYSQLÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ