Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

hibernate Éú³ÉµÄ sql Óï¾ä £¿ ´úÖµ

ת×Ô£º http://hi.baidu.com/beanchx/blog/item/ed056509d66f65cc3bc763f4.html
p6spyµÄÌæ´úÆ·£ºjdbc logger
2007Äê09ÔÂ13ÈÕ ÏÂÎç 01:07
Ê×ÏȽéÉÜÒ»ÏÂÕâ¸ö¿ªÔ´µÄÏîÄ¿¡£Õâ¸öÊÇÒ»¸ö¶ÔjdbcÖеÄsql½øÐÐloggerµÄÒ»¸ö¹¤¾ß¡£ÈôÔÚÏîÄ¿ÖвÉÓÃÁ˽϶àµÄpreparedStatement£¬ÄÇô´òÓ¡³öÀ´µÄsql»áÓкܶà"?"£¬·Ç³£²»·½±ã¡£ÓÐÒ»¸ö²úƷΪp6spy£¬¿ÉÒÔÍê³ÉÏÔʾ³öÎʺŵÄÄÚÈÝ£¬µ«ÊÇĿǰÒѾ­Í£Ö¹¸üÐÂÁË¡£jdbclogger¾ÍÊÇÒ»¸öp6spyµÄÌæ´úÆ·£¬¶øÇҷdz£ÇáÇÉ£¬½ö½ö22k´óС¡£Ä¿Ç°jdbc loggerÖ§³ÖµÄÊý¾Ý¿âΪ£ºmysql¡¢oracle¡¢hsqldb¡¢postgresql¡£
jdbc loggerµÄ¹Ù·½ÍøÕ¾Îª£ºhttp://jdbclogger.sourceforge.net/index.html
ÏÂÃæ¿´Ò»ÏÂÈçºÎÅäÖÃʹÓÃÕâ¸öjdbc logger¡£
²½Öè1£ºÏÂÔØjdbclogger£¬ÓÐÔ´ÂëÒÔ¼°jarÎļþÏÂÔØ¡£Ä¿Ç°jdbc loggerΪ0.5°æ±¾¡£
ÏÂÔØµØÖ·ÈçÏ£º
http://sourceforge.net/projects/jdbclogger/files
ÓÐËĸöjarÎļþ¿ÉÒÔÏÂÔØ£¬ÈôʹÓÃoracleÊý¾Ý¿âµÄ»°£¬¿ÉÄÜÐèÒªÏÂÔØÏÂÃæµÄÁ½¸öjar°ü¡£
Ìáʾ£º¸ÃÏîÄ¿±ØÐëʹÓÃlog4j£¬ÈôûÓÐʹÓùý£¬Çë²é¿´Ïà¹ØÎÄÕ¡£
²½Öè2£ºÏÂÔØÒԺ󣬰ÑÕâ¸öjar°ü·Åµ½¹¤³ÌµÄclasspathÏÂÃæ¡£ÈôÊÇwebÏîÄ¿£¬Ôò·ÅÔÚweb-inf/libĿ¼ÏÂÃæ¡£
²½Öè3£ºÔÚlog4j.propertiesÎļþÖУ¬Ìí¼ÓÈçÏ´úÂ룺
log4j.logger.net.sourceforge.jdbclogger=DEBUG
²½Öè4£ºÁíÍ⣬ÔÚsrcÎļþ¼ÐÏÂÃæ½¨Á¢Ò»jdbclogger.propertiesÎļþ£¬ÄÚÈÝÈçÏ£º
jdbclogger.driver=org.hsqldb.jdbcDriver
Ìáʾ:²»Í¬µÄÊý¾Ý¿â²ÉÓò»Í¬µÄÊý¾Ý¿âÇý¶¯³ÌÐò£¬ÕâÀïjdbclogger.driverµÄÖµ¾ÍÊÇÄãµÄÊý¾Ý¿âÇý¶¯³ÌÐò¡£
²½Öè5£º×îºóÒ»²½£¬ÔÚÓ¦ÓóÌÐòÖÐʹÓÃjdbc driver classµÄʱºò£¬Ê¹ÓÃÈçÏÂÇý¶¯³ÌÐò£º
net.sourceforge.jdbclogger.JdbcLoggerDriver
Ìáʾ£ºÕâ¸öÊǹ̶¨µÄ£¬Óë¾ßÌåÊý¾Ý¿âÎ޹ء£
OK¡£ÏÂÃæ²âÊÔһϣ¬¾ÍÄÜ¿´µ½jdbc loggerÊä³öµÄÈÕÖ¾ÁË¡£


Ïà¹ØÎĵµ£º

³¹µ×ɾ³ýsql server 2005

1.Stop ËùÓзþÎñ
 
2.Óà Windows Install Clean Up ¹¤¾ßÐ¶ÔØSQL 2005×é¼þ
 
3.ÓÃSrvInstw.exeɾ³ýËùÓÐSQL·þÎñ
 
4.Çå³ý×¢²á±í
   a. ½«HKEY_CURRENT_USER---Software----MicrosoftϵÄMicrosoft SQL ServerÎļþ¼ÐÈ«²¿É¾³ý
   b. ½«HKEY_LOCAL_mACHINE---SOFTWARE---MicrosoftÏ ......

SQL¿ìËÙÓÃÆô¶¯


¿ªÆô¸÷ÖÖ·þÎñ
      @NET stop SQLSERVERAGENT
      @NET stop MSSQLServerOLAPService
      @NET stop msftesql
      @NET stop MsDtsServer
      @NET stop SQLWriter
  ......

select * into ºÍinsert into SQL SERVER

select * into destTbl from srcTbl
insert into destTbl(fld1, fld2) select fld1, 5 from srcTbl
ÒÔÉÏÁ½¾ä¶¼Êǽ« srcTbl µÄÊý¾Ý²åÈëµ½ destTbl£¬µ«Á½¾äÓÖÓÐÇø±ðµÄ£º
µÚÒ»¾ä£¨select into from£©ÒªÇóÄ¿±ê±í£¨destTbl£©²»´æÔÚ£¬ÒòΪÔÚ²åÈëʱ»á×Ô¶¯´´½¨¡£
µÚ¶þ¾ä£¨insert into select from£©ÒªÇóÄ¿±ê±í£¨dest ......

SQL SEVERÓëORACLE µÄsqlÓï¾äÇø±ð

Êýѧº¯Êý£º
1.¾ø¶ÔÖµ
S:SELECT abs(-1) value
O:SELECT abs(-1) value from dual
2.È¡Õû(´ó)
S:SELECT ceiling(-1.001) value
O:SELECT ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:SELECT floor(-1.001) value
O:SELECT floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
S:SELECT cast(-1.002 as int) value
O ......

Sql Server 2005Êý¾Ý¿â±»±ê¼ÇΪ¡°¿ÉÒÉ¡±ÎÊÌâ


ÎÊÌâ±³¾°£º
¡¡¡¡ÈÕ³£¶ÔSql Server 2005¹ØÏµÊý¾Ý¿â½øÐвÙ×÷ʱ£¬ÓÐʱ¶ÔÊý¾Ý¿â£¨È磺SharepointÍøÕ¾ÅäÖÃÊý¾Ý¿âÃû
Sharepoint_Config£©½øÐÐЩ²»Õý³£²Ù×÷ÈçÊý¾Ý¿âÔÚ¶Áдʱ¶øÎÞ¹ÊÍ£Ö¹Êý¾Ý¿â£¬´Ó¶øµ¼ÖÂSql Server 2005Êý¾Ý¿â²»Õý³£
Öжϣ¬µ±Ôٴδò¿ªÊý¾Ý¿âʱ»á·¢ÏÖijЩÊý¾Ý¿â»á±»±ê¼ÇΪ“¿ÉÒÉ”£¨suspect)£¬¼´ÔÚÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ