<?
xml?version="1.0"
?>
<! DOCTYPE?hibernate-mapping?PUBLIC
????"-//Hibernate/Hibernate?Mapping?DTD//EN"
????"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd"? >
< hibernate-mapping? package ="gov.cfte.object.hibernate.model" >
???? < class? name ="ObjectLog" ?table ="OBJECT_LOG" >
???????? < id? column ="ID" ?name ="Id" ?type ="string" ?length ="32" >
???????????? < generator? class ="net.sf.hibernate.id.UUIDHexGenerator" ? />
???????? </ id > ?
???????? < property
???????????? column ="TYPE_ID"
????????????length ="32"
????????????name ="TypeId"
????????????not-null ="false"
????????????type ="string"
????????? />
???????? < property
???????????? column ="OPTIME"
????????????length ="26"
????????????name ="Optime"
????????????not-null ="false"
????????????type ="timestamp"
????????? />
???????? < property
???????????? column ="USER_ID"
????????????length ="32"
????????????name ="UserId"
????????????not-null ="false"
????????????type ="string"
????????? />
???????? < property
???????????? column ="OPINFO"
????????????length ="32"
????????????name ="Opinfo"
????????????not-null ="false"
????????????type ="string"
????????? />
???????? < property
???????????? column ="RECORDINFO"
????????????length ="1024"
????????????name ="Recordinfo"
????????????not-null ="false"
????????????type ="string"
????????? />
???????? < property
???????????? column ="IP"
????????????length ="32"
????????????name ="Ip"
????????????not-null ="false"
????????????type ="string"
????????? />
???? </ class >
</ hibernate-mapping >
<! DOCTYPE?hibernate-mapping?PUBLIC
????"-//Hibernate/Hibernate?Mapping?DTD//EN"
????"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd"? >
< hibernate-mapping? package ="gov.cfte.object.hibernate.model" >
???? < class? name ="ObjectLog" ?table ="OBJECT_LOG" >
???????? < id? column ="ID" ?name ="Id" ?type ="string" ?length ="32" >
???????????? < generator? class ="net.sf.hibernate.id.UUIDHexGenerator" ? />
???????? </ id > ?
???????? < property
???????????? column ="TYPE_ID"
????????????length ="32"
????????????name ="TypeId"
????????????not-null ="false"
????????????type ="string"
????????? />
???????? < property
???????????? column ="OPTIME"
????????????length ="26"
????????????name ="Optime"
????????????not-null ="false"
????????????type ="timestamp"
????????? />
???????? < property
???????????? column ="USER_ID"
????????????length ="32"
????????????name ="UserId"
????????????not-null ="false"
????????????type ="string"
????????? />
???????? < property
???????????? column ="OPINFO"
????????????length ="32"
????????????name ="Opinfo"
????????????not-null ="false"
????????????type ="string"
????????? />
???????? < property
???????????? column ="RECORDINFO"
????????????length ="1024"
????????????name ="Recordinfo"
????????????not-null ="false"
????????????type ="string"
????????? />
???????? < property
???????????? column ="IP"
????????????length ="32"
????????????name ="Ip"
????????????not-null ="false"
????????????type ="string"
????????? />
???? </ class >
</ hibernate-mapping >
return
?
this
.getHibernateTemplate().find(
"
from?ObjectLog
"
);
return ? this .getHibernateTemplate().find( " from?ObjectLog?c?where?c.Opinfo?=?? " ,?queryCondition); // 根據操作方式來精確查詢(已測試通過)
return ? this .getHibernateTemplate().find( " from?ObjectLog?c?where?c.Opinfo?like?? " ,? " % " + queryCondition + " % " ); // 根據操作方式來模糊查詢(已測試通過)
return ? this .getHibernateTemplate().find( " from?ObjectLog?c?where?c.TypeId=??and?c.Opinfo?like?? " , new ?Object[]{typeId, " % " + queryCondition + " % " });
return ? this .getHibernateTemplate().find( " from?ObjectLog?c?where?c.Opinfo?=?? " ,?queryCondition); // 根據操作方式來精確查詢(已測試通過)
return ? this .getHibernateTemplate().find( " from?ObjectLog?c?where?c.Opinfo?like?? " ,? " % " + queryCondition + " % " ); // 根據操作方式來模糊查詢(已測試通過)
return ? this .getHibernateTemplate().find( " from?ObjectLog?c?where?c.TypeId=??and?c.Opinfo?like?? " , new ?Object[]{typeId, " % " + queryCondition + " % " });