¡¾×ª¡¿²ÉÓÃp6spyÍêÕûÏÔʾhibernateµÄSQLÓï¾ä
×÷ÕߣºÇñÑó
QQ£º1964477
ËäÈ»ÔÚhibernateÖÐÓÐshow_sqlÑ¡Ïµ«ÊÇÏÔʾ³öÀ´µÄÓï¾ä´ó¶àÀàËÆ
select * from xxx where value=?
µ«ÊÇÓÐʱºòÎÒÃÇÐèÒªµÃµ½ÍêÕûµÄSQLÓï¾ä£¬Ôõô°ìÄØ£¿Ê¹ÓÃP6SPY¾Í¿ÉÒÔÍê³ÉÕâ¸öÈÎÎñ
p6spyÊÇÒ»¸ö¿ªÔ´Èí¼þ£¬Ëü¿ÉÒÔ¸ú×ÙÈκÎʹÓÃjdbcµÄÓ¦ÓòúÉúµÄÊý¾Ý¿â²Ù×÷¡£ÌرðÊʺÏÓÚ¼à¿Øejb·þÎñÆ÷²úÉúµÄ sql statements¡£
¹Ù·½ÍøÖ·£ºhttp://www.p6spy.com/
Ä¿Ç°p6spy ÊÊÓõÄÓ¦Ó÷þÎñÆ÷°üÀ¨jboss, atg, orion, jonas, iplanet, weblogic, websphere, resin and tomcat.
ÏÂÃæÎÒ½éÉÜÒ»ÏÂp6spyÔÚtomcatÓ¦ÓóÌÐòÉÏ°²×°µÄ²½Ö裺
£¨1£©http://www.p6spy.com/download.html£¬ÏÂÔØzip°ü
£¨2£©½âѹ³öp6spy.jar spy.propertiesÁ½¸öÎļþ
£¨3£©½«p6spy.jar ·ÅÈëÓ¦ÓóÌÐòµÄWEB-INF/libĿ¼£¬½«spy.properties·ÅÈëWEB-INF/classesĿ¼
£¨4£©ÐÞ¸Äspy.properties
realdriver =com.mysql.jdbc.Driver ½«ÕâÐÐÇ°ÃæµÄ#È¥µô
logfile = c:/spy.log ÐÞ¸ÄÒ»¸öÄãÐèÒªµÄÈÕÖ¾ÎļþÃû
£¨5£©ÐÞ¸Ähibernate.xml£¬ÐÞ¸Äconnection.driver_classµÄֵΪcom.p6spy.engine.spy.P6SpyDriver
£¨6£©ÖØÆôtomcat
£¨7£©ÕâÑùÔÚc:/ϵÄspy.log¼Ç¼ÁËÊý¾Ý¿âµÄ·ÃÎÊÇé¿ö¡£
ÔÎĵØÖ·£ºhttp://www.blogjava.net/qclass/archive/2006/08/21/64692.html
Ïà¹ØÎĵµ£º
ÆôÓÃc2ÉóºËÃüÁîÈçÏ£º
EXEC sp_configure 'c2 audit mode', '1' RECONFIGURE
SQL ServerÒÔ128KB´óСµÄ¿éΪµ¥Î»°ÑÊý¾ÝдÈë¸ú×ÙÎļþ¡£Òò´Ë£¬µ±SQL Server·ÇÕý³£Í£Ö¹Ê±£¬×î¶à¿ÉÄܶªÊ§128
......
SQL Server 2005 Express µ¼Èë/µ¼³öÊý¾Ý
°²×°ºÃSQL Server 2005 Expressºó£¬ÔÙ°²×°
http://download.microsoft.com/download/1/1/0/110d908f-c445-4523-b939-220c7d135f3d/SQLServer2005_SSMSEE.msi
¾Í¿ÉÒÔʹÓÿØÖÆ̨½øÐÐÊý¾Ý¿âµÄ¹ÜÀí¡£
µ«SQL Server Management Studio Express ²¢Ã»Óе¼Èë/µ¼³öÊý¾ÝµÄ¹¦ÄÜ£¬ÎÒÃÇ¿ÉÒÔ ......
SELECT tagid, tagname from uchome_mtag WHERE tagname IN (SELECT tagname from uchome_mtag GROUP BY tagname HAVING (COUNT(tagname) > 1)) ORDER BY tagname ......
SQL ½Ì³Ì
1£©SQL ¼ò½é
SQL(Structured Query Language£¬½á¹¹²éѯÓïÑÔ)ÊÇÒ»¸ö¹¦ÄÜÇ¿´óµÄÊý¾Ý¿âÓïÑÔ¡£SQLͨ³£Ê¹ÓÃÓÚÊý¾Ý¿âµÄͨѶ¡£ANSI£¨ÃÀ¹ú¹ú¼Ò±ê׼ѧ»á£©Éù³Æ£¬SQLÊǹØϵÊý¾Ý¿â¹ÜÀíϵͳµÄ±ê×¼ÓïÑÔ¡£SQLÓï¾äͨ³£ÓÃÓÚÍê³ÉһЩÊý¾Ý¿âµÄ²Ù×÷ÈÎÎñ£¬±ÈÈçÔÚÊý¾Ý¿âÖиüÐÂÊý¾Ý£¬»òÕß´ÓÊý¾Ý¿âÖмìË÷Êý¾Ý¡£Ê¹ÓÃSQLµÄ³£¼û¹ØϵÊý¾Ý¿â¹ ......