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Â¥ÄÇôЩ
¿ÉÒÔÓÃHibernateµÄ»Øµ÷º¯Êý°¡
¿ÉÒÔÖ±½ÓдµÄ¡¡
²»¹ý±íÃû²»ÄÜд³ÉÊý¾Ý¿âÖеıíÃûµÄд³ÉxmlÖÐÓ³ÉäµÄ¶ÔÏóÃû
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
±í
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 ......