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ÖÐÓ³ÉäµÄ¶ÔÏóÃû
Ïà¹ØÎÊ´ð£º
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡ Íò·Ö¸Ðл£¡ String SQL=&q ......
±í 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±í ·ÖÇø È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ ¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ ÓóÌÐòÔ ......
¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬ Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ a ......