java Annotation Æ´×°SQLÓï¾ä
ÉùÃ÷×Ö¶ÎÓ³Éä
@Target(ElementType.FIELD)
@Retention(RetentionPolicy.RUNTIME)
public @interface FiledRef
{
String fieldName();
}
ÉùÃ÷±íÓ³Éä
@Target(ElementType.TYPE)
@Retention(RetentionPolicy.RUNTIME)
public @interface TableRef
{
String tableName();
}
²âÊÔÀà
@TableRef(tableName = "MobDevice")
public class ReflectTest
{
@FiledRef(fieldName = "ID")
private Long id;
@FiledRef(fieldName = "DEVICE_NAME")
private String name;
@FiledRef(fieldName = "DEVICE_CODE")
private String code;
public ReflectTest(Long id, String name, String code)
{
this.id = id;
this.name = name;
this.code = code;
}
public Long getId()
{
return id;
}
public void setId(Long id)
{
this.id = id;
}
public String getName()
{
return name;
}
public void setName(String name)
{
this.name = name;
}
public String getCode()
{
return code;
}
public void setCode(String code)
{
this.code = code;
}
/**
* @description
* @author zhangml
 
Ïà¹ØÎĵµ£º
¡¡JavaµÄClassLoader¾ÍÊÇÓÃÀ´¶¯Ì¬×°ÔØclassµÄ£¬ClassLoader¶ÔÒ»¸öclassÖ»»á×°ÔØÒ»´Î£¬JVMʹÓõÄClassLoaderÒ»¹²ÓÐ4ÖÖ£º
¡¡¡¡Æô¶¯Àà×°ÔØÆ÷£¬±ê×¼À©Õ¹Àà×°ÔØÆ÷£¬Àà·¾¶×°ÔØÆ÷ºÍÍøÂçÀà×°ÔØÆ÷¡£
¡¡¡¡Õâ4ÖÖClassLoaderµÄÓÅÏȼ¶ÒÀ´Î´Ó¸ßµ½µÍ£¬Ê¹ÓÃËùνµÄ“Ë«Ç×ίÅÉÄ£ÐÍ”¡£È·ÇеØËµ£¬¼ÙÈçÒ»¸öÍøÂçÀà×°ÔØÆ÷±»ÇëÇó×°ÔØÒ ......
µ±Á½¸ö½ø³ÌÔÚ½øÐÐÔ¶³ÌͨÐÅʱ£¬±Ë´Ë¿ÉÒÔ·¢Ë͸÷ÖÖÀàÐ͵ÄÊý¾Ý¡£ÎÞÂÛÊǺÎÖÖÀàÐ͵ÄÊý¾Ý£¬¶¼»áÒÔ¶þ½øÖÆÐòÁеÄÐÎʽÔÚÍøÂçÉÏ´«ËÍ¡£·¢ËÍ·½ÐèÒª°ÑÕâ¸öjava¶ÔÏóת»»Îª×Ö½ÚÐòÁУ¬¼´java¶ÔÏóÐòÁкţ¬²ÅÄÜÔÚÍøÂçÉÏ´«ËÍ£»½ÓÊÕ·½ÔòÐèÒª°Ñ×Ö½ÚÐòÁÐÔÙ»Ö¸´ÎªJava¶ÔÏ󣬼´·´ÐòÁл¯¡£
¡¡¡¡°ÑJava¶ÔÏóת»»Îª×Ö½ÚÐòÁеĹý³Ì³ÆÎª¶ÔÏóµÄÐòÁл¯¡£
¡¡ ......
½ñÌì¸øÎÒÃÇÉϿεÄÊÇ·ëÍþÀÏʦ£¬ÀÏʦÒÔǰ¹¤×÷µÄ¹«Ë¾ÊǶÔÈÕÈí¼þ¿ª·¢µÄ£¬Óн«½üÊ®ÄêµÄ¹¤×÷¾ÑéÁË£¬ÖÚËùÖÜÖª£¬ÈÕ±¾È˶Թ¤×÷ÒªÇóÊÇÊ®·ÖÑϽ÷µÄ£¬¾ÝÀÏʦËù˵£¬ÒÔǰÔÚ¹«Ë¾±àÂëµÄʱºòÒªÇóÊÇÒ»ÐдúÂëÒ»ÐÐ×¢ÊÍ£¬Èç¹ûûÓÐ×¢Ê͵ϰÔÚÉóºËµÄʱºòÊDz»»áͨ¹ýµÄ£¬Ã»ÓÐ×¢ÊÍÊǻᱻ°´ÕÕbug´¦ÀíµÄ£¬ËùÒÔÏÖÔÚÀÏʦÉÏ¿ÎÏÖ³¡±àÂëµÄʱºòÒ²ÊÇÐÐÐÐдעÊÍ£ ......
select sql_text, spid, v$session.program, process
from v$sqltext, v$session, v$process
where v$sqltext.address = v$session.sql_address
and v$sqltext.hash_value = v$session.sql_hash_value
and v$session.paddr = v$process.addr
and v$process.spid in (4335);
×¢Ò ......
Èç¹ûÔÚSQL Server ÀïÐèÒª¶¨Ê±»òÕßÿ¸ôÒ»¶Îʱ¼äÖ´ÐÐij¸ö´æ´¢¹ý³Ì»ò3200×Ö·ûÒÔÄÚµÄSQLÓï¾äʱ, ¿ÉÒÔÓùÜÀí->SQL Server´úÀí->×÷ÒµÀ´ÊµÏÖ¡£
¡¡¡¡1¡¢¹ÜÀí->SQL Server´úÀí->×÷Òµ(°´Êó±êÓÒ¼ü)->н¨×÷Òµ
¡¡¡¡2¡¢Ð½¨×÷ÒµÊôÐÔ(³£¹æ)->Ãû³Æ[×Ô¶¨Òå±¾´Î×÷ÒµµÄÃû³Æ]->ÆôÓõķ½¿òÄÚÊǹ´ºÅ->
·ÖÀà´¦¿ ......