hqlÓësqlµÄÇø±ð
1.hqlÓësqlµÄÇø±ð
sql ÃæÏòÊý¾Ý¿â±í²éѯ
hql ÃæÏò¶ÔÏó²éѯ
hql £º from ºóÃæ¸úµÄ ÀàÃû£«Àà¶ÔÏó where ºó Óà ¶ÔÏóµÄÊôÐÔ×öÌõ¼þ
sql£º from ºóÃæ¸úµÄÊDZíÃû where ºó ÓñíÖÐ×Ö¶Î×öÌõ¼þ
²éѯ
ÔÚHibernateÖÐʹÓòéѯʱ£¬Ò»°ãʹÓÃHql²éѯÓï¾ä¡£
HQL£¨Hibernate Query Language£©£¬¼´HibernateµÄ²éѯÓïÑÔ¸úSQL·Ç³£ÏàÏñ¡£²»¹ýHQLÓëSQLµÄ×î¸ù±¾µÄÇø±ð£¬¾ÍÊÇËüÊÇÃæÏò¶ÔÏóµÄ¡£
ʹÓÃHQLʱÐèҪעÒâÒÔϼ¸µã£º
l ´óСдÃô¸Ð
ÒòΪHQLÊÇÃæÏò¶ÔÏóµÄ£¬¶ø¶ÔÏóÀàµÄÃû³ÆºÍÊôÐÔ¶¼ÊÇ´óСдÃô¸ÐµÄ£¬ËùÒÔHQLÊÇ´óСдÃô¸ÐµÄ¡£
Eg.
HQLÓï¾ä£ºfrom Cat as cat where cat.id > 1;Óëfrom Cat as cat where cat.ID > 1;ÊDz»Ò»ÑùµÄ£¬ÕâµãÓëSQL²»Í¬¡£
l from×Ó¾ä
Eg. from Cat£¬¸Ã¾ä·µ»ØCat¶ÔÏóʵÀý£¬¿ª·¢ÈËÔ±Ò²¿ÉÒÔ¸øÆä¼ÓÉϱðÃû£¬eg. from Cat as cat£¬¶ÔÓÚ¶à±í²éѯµÄÇé¿ö£¬¿É²Î¿¼ÈçÏ£º
from Cat as cat, Dog as dog
ÆäËü·½Ã涼ÓëSQLÀàËÆ£¬Ôڴ˲»ÔÙ׸Êö¡£
½ÓÏÂÀ´½²Ò»¸öÔÚHibernateÖвéѯµÄÀý×Ó¡£
1.1¼òµ¥²éѯ
List list = session.createQuery("from User as user order by user.loginName").list();
1.2´øµ¥¸ö²ÎÊýµÄ²éѯ
List list = session.find("from User as user where user.loginName=?",
loginName,
Hibernate.STRING);
1.3¶à¸ö²ÎÊýµÄ²éѯ
Eg1. ´ËÀý²ÉÓÃ&ldqu
Ïà¹ØÎĵµ£º
Sqlʱ¼äº¯Êý
Ò»¡¢sql serverÈÕÆÚʱ¼äº¯Êý
Sql ServerÖеÄÈÕÆÚÓëʱ¼äº¯Êý
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
Àý ......
Sqlʱ¼äº¯Êý
Ò»¡¢sql serverÈÕÆÚʱ¼äº¯Êý
Sql ServerÖеÄÈÕÆÚÓëʱ¼äº¯Êý
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
Àý ......
¼Ó[ ]ÓÃÓÚ¶¨½çÁÐÃû»ò±íÃûµÈÐÅÏ¢£¬ÒÔÇø±ðһЩÌØÊâµÄ²»ºÏÃüÃû¹æÔòµÄ×Ö´®£¬»òÊÇÓëϵͳ±£Áô×ÖÓгåÍ»¡£
Èç"user"ÊÇSQL Server±£ÁôµÄ¹Ø¼ü×Ö£¬ËùÒÔÓÃ"select * from user"²éѯ»áÌáʾÓï·¨´íÎó¡£¼ÓÉÏÖÐÀ¨ºÅ£¬ÒÔÉùÃ÷Æä²»ÊDZ£Áô×Ö¡£
"select * from [user]"
Èç¹û±íÃû²»Êǹؼü×Ö£¬ÈçCompany£¬ÔòÓÃ"select * from Company"ÊÇûÎÊÌâµ ......
---ÓÃconvertת»»²ÎÊý¶Ô±È
select CONVERT(varchar, getdate(), 120 )
2004-09-12 11:06:08
select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','')
20040912110608
select CONVERT(varchar(12) , getdate(), 111 )
2004/09/12
select CONVERT(varchar(12) , getdate(), 112 )
......
ºó׺ÃûΪ.mdfµÄsqlÊý¾Ý¿âÈçºÎ´ò¿ª£¿
ÓÐ.mdfºÍ.ldfÁ½¸öÎļþ£¬´ò¿ª·½°¸£º
·½·¨Ò»£ºÔÚSql serverÆóÒµ¹ÜÀíÆ÷ÖÐ - Êý¾Ý¿â - ÓÒ¼ü <¸½¼ÓÊý¾Ý¿â
·½·¨¶þ£ºÔÚVS2005ÖÐÏȽ¨Á¢Ò»¸öÓëÄãÒª´ò¿ªµÄmdfÎļþͬÃûµÄÊý¾Ý¿â£¬¼Çס´æ´¢Î»Öã¬È»ºóÓÃÄãÒª´ò¿ªµÄmdfÎļþ½«¸Õ½¨Á¢µÄmdfÊý¾Ý¿âÎļþÌæ»»¼´¿É¡£ ......