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

HibernateÖÐÔõôдmysqlÓï¾ä£¿

ÎÒÏëдЩselect count(id) from rticle
        select title from article
һЩÀàËÆµÄÓï¾ä
mysqlÓï¾ä£¿ sqlÓï¾ä°É£¿

query ÓÐÕâ¸ö¹¦ÄÜ

Query query= session.createSQLQuery("sqlÓï¾ä");

û´í¡£ÊÇÂ¥Éϵ͍·¨£¬²»¹ý£¬Òª×¢Òâѽ¡£²éѯ³öÀ´µÄÊý¾ÝÊÇObject¶ÔÏóÊý×éÐÎʽµÄ¡£

select * from article where title=?  Õâ¸öÎʺÅÔõô°ì

ÎʺſÉÒÔÕâÑùд
Java code:
createSQLQuery(sql, "ÎʺŵÄÄÚÈÝ", ÄãµÄDAO.class)


ÓÐspringµÄ»°Ò²¿ÉÒÔÕâÑùд
Java code:

getHibernateTemplate().find(queryString,new Object[]{username,password})



ÔÚHibernateÀ²éѯʱhqlÓï¾äÁË£¬ÄãÕÒhqlÓï·¨¾ÍÊÇÁË
Ò²¿ÉÒÔÖ´ÐÐsqlÓï¾äÈç1Â¥ÄÇôЩ

ÒýÓÃ
select * from article where title=?  Õâ¸öÎʺÅÔõô°ì


¿ÉÒÔÓÃHibernateµÄ»Øµ÷º¯Êý°¡

¿ÉÒÔÖ±½ÓдµÄ¡­¡­
²»¹ý±íÃû²»ÄÜд³ÉÊý¾Ý¿âÖеıíÃûµÄд³ÉxmlÖÐÓ³ÉäµÄ¶ÔÏóÃû



Ïà¹ØÎÊ´ð£º

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

MYSQLÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......

MysqlЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

±í
CREATE TABLE `ch1` (
  `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `no` int(10) unsigned DEFAULT NULL,
  `dtime` datetime DEFAULT NULL,
  PRIMARY KEY (`id ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ