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ÖÐÓ³ÉäµÄ¶ÔÏóÃû
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
±í
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 ......
ÔÚmysqlµÄ½Å±¾Ä£Ê½Ï£¬-t±íʾÒÔ±í¸ñµÄÐÎʽÊä³ö½á¹û£¬Èç¹ûÐèÒªÖÆ±í·û¶¨½çµÄÊä³ö¿ÉÒÔÊ¡ÂÔ´ËÑ¡Ïî¡£ ÕâÑùµÄÊä³öÊǾßÓбí¸ñÐÎʽµÄÊä³ö£¬
Õâ¸öÊÇÊéÉÏ˵µÄ£¬Õâ¾ä»°ÊDz»ÊÇÓÐʲôÎÊÌ⣿
ÊDz»ÊÇÖÆ±í·ûºÍ±í¸ñÐÎʽ£¬²»ÊÇÒ»»ØÊ ......