ÔõôÓÃ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);
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡ mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿ ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ ¿ÉÒÔÓÃÈ ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8 ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ ¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ ÓóÌÐòÔ ......