Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

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

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

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

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

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

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

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

ÔõôÔÚeclipseÏÂÏòmysql²åÈë±äÁ¿°¡ - Java / JavaÏà¹Ø

String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡­¡­µ½µ×¸Ãզд°¡

Íò·Ö¸Ðл£¡

String SQL=&q ......

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

mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ