Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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);


Ïà¹ØÎÊ´ð£º

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

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

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

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

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

MySQL´íÎó - PHP / »ù´¡±à³Ì

ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿

ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ

¿ÉÒÔÓÃÈ ......

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

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

mysql Îļþ¶ÁÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ 
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ