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

ÔõôÓÃHQLÓï¾ä²éѯmysqlÖеÄ×îºóNÌõ¼Ç¼

ÔõôÓÃHQLÓï¾ä²éѯmysqlÖеÄ×îºóNÌõ¼Ç¼£¬Ö÷¼ü×ÔÔö£¬×îºóÒªÇó½µÐòÊä³ö
  ·Ö²¼²»ÊÇÓÐÒ»¸öº¯ÊýÂð£¿ÄãÓÃÄǸöº¯Êý¾Í¿ÉÒÔ ²éѯÁË¡£

²Î¿¼£º
http://school.itzcn.com/special-spid-50.html
ÉÏÃæ½²½âµÄ±È½ÏÏêϸ£¬Ï£Íû¶ÔÄãÓÐËù°ïÖú¡£

hql²»»á¾ÍÓÃsql
ÓÃJava code:
createSQLQuery


ÒýÓÃ
ÔõôÓÃHQLÓï¾ä²éѯmysqlÖеÄ×îºóNÌõ¼Ç¼£¬Ö÷¼ü×ÔÔö£¬×îºóÒªÇó½µÐòÊä³ö


¿ÉÒÔ¾ßÌåµãÂð

ÒýÓÃ
  ·Ö²¼²»ÊÇÓÐÒ»¸öº¯ÊýÂð£¿ÄãÓÃÄǸöº¯Êý¾Í¿ÉÒÔ ²éѯÁË¡£


Äĸö·Ö²¼º¯Êý°¡£¿


ÄãÏÈÉýÐòÅÅÁÐÈ¡µÃǰNÌõ¼Ç¼ ÔÙ½«ÕâNÌõ¼Ç¼½µÐòÅÅÁв»¾ÍÊÇÄãÒªµÄ½á¹ûÂð

ÒýÓÃ
ÒýÓà 1 Â¥ greatmind829 µÄ»Ø¸´:
  ·Ö²¼²»ÊÇÓÐÒ»¸öº¯ÊýÂð£¿ÄãÓÃÄǸöº¯Êý¾Í¿ÉÒÔ ²éѯÁË¡£


Äĸö·Ö²¼º¯Êý°¡£¿


ÎÒÊÇÕâô×öµÄ£¬¿ÉÊDz»ÐУ¬Äã¿´¿´ÓÐʲôÎÊÌâ
private static final String QUERYPERPAGEHQL = "from Solution solution order by solutionId desc";

public List queryPerPage(int page) {
List <Solution> listResult = new ArrayList <Solution>();
Session session = HibernateSessionFactory.getSession();
int startRow = this.getTotalCount()-page*countPerPage;
Query query = session.createQuery(this.QUERYPERPAGEHQL);
query.setFirstResult(startRow);


Ïà¹ØÎÊ´ð£º

c#¿ØÖÆMysql ʵÏÖ×Ô¶¯É¾³ý¹¦ÄÜ - .NET¼¼Êõ / C#

Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......

mysqlÖÐÎÄÂÒÂë - C/C++ / C++ ÓïÑÔ

mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......

mysql²éѯÎÊÌâ

bas_car ±í ÓÐÁÐcarname £¬Òª½øÐÐÊý¾Ýͳ¼Æ£¬ 
select count(a.carname),a.carname from bas_car a,bas_car b where a.carid>=b.carid and a.carname=b.carname
group by a.carname  
ÈçÉϲéѯ½á ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ