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ÖÐÓ³ÉäµÄ¶ÔÏóÃû
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
±í
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 ......