- 浏览: 11987 次
- 来自: ...
最新评论
-
magician007:
刚刚接触tapestry,觉得很多东西的实现上很别扭,正在纠结 ...
Struts2/webwork与tapestry的区别(二) -
andilyliao:
天津也这样 还不如深圳了 天津程序员更廉价 但是房子同样天价 ...
如果有下辈子绝对不会当程序员 -
liuwenbo200285:
这个速度是快还是慢啊,感觉速度可以了。
Mysql 5.0 hibernate 五百万数据查询 -
downpour:
引用 tapestry支持多个properties文件 w ...
Struts2/webwork与tapestry的区别(二)
(support.XmlWebApplicationContext 412 ) Refreshing org.springframework.web.context.support.XmlWebApplicationContext@1581593: display name [Root WebApplicationContext]; startup date [Tue Mar 27 01:33:55 CST 2007]; root of context hierarchy
(xml.XmlBeanDefinitionReader 323 ) Loading XML bean definitions from file [G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\test\util\applicationContext-dao.xml]
(xml.XmlBeanDefinitionReader 323 ) Loading XML bean definitions from file [G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\test\util\applicationContext-hibernate.xml]
(xml.XmlBeanDefinitionReader 323 ) Loading XML bean definitions from file [G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\test\util\applicationContext-index.xml]
(xml.XmlBeanDefinitionReader 323 ) Loading XML bean definitions from file [G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\test\util\applicationContext-indexService.xml]
(xml.XmlBeanDefinitionReader 323 ) Loading XML bean definitions from file [G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\test\util\applicationContext-resources.xml]
(xml.XmlBeanDefinitionReader 323 ) Loading XML bean definitions from file [G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\test\util\applicationContext-service.xml]
(xml.XmlBeanDefinitionReader 323 ) Loading XML bean definitions from file [G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\test\util\applicationContext-userDao.xml]
(xml.XmlBeanDefinitionReader 323 ) Loading XML bean definitions from file [G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\test\util\applicationContext-userService.xml]
(xml.XmlBeanDefinitionReader 323 ) Loading XML bean definitions from URL [file:/G:/haiwooo/workspace/sky/WebRoot/WEB-INF/classes/test/util/action-servlet.xml]
(support.XmlWebApplicationContext 427 ) Bean factory for application context [org.springframework.web.context.support.XmlWebApplicationContext@1581593]: org.springframework.beans.factory.support.DefaultListableBeanFactory@458f41
(config.PropertyPlaceholderConfigurer 178 ) Loading properties file from class path resource [mail.properties]
(support.DefaultListableBeanFactory 414 ) Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@458f41: defining beans [dao,orderTaskDao,orderDao,userCountDao,sessionFactory,transactionManager,indexDao,bookDao,companyDao,indexManager,companyManager,propertyConfigurer,dataSource,baseManager,userDao,org.springframework.aop.config.internalAutoProxyCreator,userManagerTx,userManagerSecurity,managerTx,orderManagerTx,txAdvice,userManagerTxAdvice,userSecurityAdvice,manager,userManager,userCache,orderManager,userCountManager,orderOpration,orderManagerTxAdvice,loginAction,registAction,fileDownLoadAction,commandIndexAction,adminIndexAction,indexAction,companyAction,mergeAction,orderAction,eventAction,eventCrimeAction]; root of factory hierarchy
(cfg.Environment 514 ) Hibernate 3.2.6
(cfg.Environment 547 ) hibernate.properties not found
(cfg.Environment 681 ) Bytecode provider name : cglib
(cfg.Environment 598 ) using JDK 1.4 java.sql.Timestamp handling
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\common\CarForumDetail.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.common.CarForumDetail -> test
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\common\ForumRole.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.common.ForumRole -> Forum_Role
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\Company.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.Company -> company
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\Count.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.Count -> count
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\CrimeEvent.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.CrimeEvent -> crime_event
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\GoodsStorage.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.GoodsStorage -> goods_storage
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\hainan\HaiKouCarForum.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.hainan.HaiKouCarForum -> Hai_Kou_Car_Forum
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\hainan\HaiKouCarForumDetail.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.hainan.HaiKouCarForumDetail -> Hai_Kou_Car_Forum_Detail
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\hainan\HaiKouCarForumReply.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.hainan.HaiKouCarForumReply -> Hai_Kou_Car_Forum_Reply
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\hainan\TestTable.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.hainan.TestTable -> test_table
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\index\Book.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.index.Book -> book
(cfg.HbmBinder 873 ) Mapping joined-subclass: com.sky.model.pojo.index.NewsBook -> news_book
(cfg.HbmBinder 873 ) Mapping joined-subclass: com.sky.model.pojo.index.CommandBook -> command_book
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\index\BookAddress.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.index.BookAddress -> book_address
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\index\BookCatalog.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.index.BookCatalog -> book_catalog
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\Industry.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.Industry -> industry
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\MergerCompany.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.MergerCompany -> merger_company
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\Order.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.Order -> orders
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\Role.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.Role -> role
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\SystemInfo.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.SystemInfo -> system_info
(cfg.Configuration 305 ) Reading mappings from file: G:\haiwooo\workspace\sky\WebRoot\WEB-INF\classes\com\sky\xml\hibernate\com\sky\model\pojo\User.hbm.xml
(cfg.HbmBinder 300 ) Mapping class: com.sky.model.pojo.User -> user
(cfg.HbmBinder 1419) Mapping collection: com.sky.model.pojo.User.roles -> user_role
(cfg.HbmBinder 2382) Mapping collection: com.sky.model.pojo.hainan.HaiKouCarForum.list -> Hai_Kou_Car_Forum_Reply
(cfg.HbmBinder 2382) Mapping collection: com.sky.model.pojo.index.Book.catalogList -> book_catalog
(cfg.HbmBinder 2382) Mapping collection: com.sky.model.pojo.index.Book.bookAddressList -> book_address
(cfg.HbmBinder 2382) Mapping collection: com.sky.model.pojo.MergerCompany.crimeEventList -> crime_event
(hibernate3.LocalSessionFactoryBean 730 ) Building new Hibernate SessionFactory
(connection.ConnectionProviderFactory 72 ) Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@63b2e6)
LogAbandoned: false
RemoveAbandoned: true
RemoveAbandonedTimeout: 60
(cfg.SettingsFactory 89 ) RDBMS: MySQL, version: 5.0.27-community-nt
(cfg.SettingsFactory 90 ) JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.3 ( $Date: 2006-07-26 17:26:47 +0200 (Wed, 26 Jul 2006) $, $Revision: 5553 $ )
(dialect.Dialect 152 ) Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
(transaction.TransactionFactoryFactory 34 ) Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory
(transaction.TransactionManagerLookupFactory 33 ) No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
(cfg.SettingsFactory 143 ) Automatic flush during beforeCompletion(): disabled
(cfg.SettingsFactory 147 ) Automatic session close at end of transaction: disabled
(cfg.SettingsFactory 154 ) JDBC batch size: 2000
(cfg.SettingsFactory 157 ) JDBC batch updates for versioned data: disabled
(cfg.SettingsFactory 162 ) Scrollable result sets: enabled
(cfg.SettingsFactory 170 ) JDBC3 getGeneratedKeys(): enabled
(cfg.SettingsFactory 178 ) Connection release mode: auto
(cfg.SettingsFactory 202 ) Maximum outer join fetch depth: 2
(cfg.SettingsFactory 205 ) Default batch fetch size: 1
(cfg.SettingsFactory 209 ) Generate SQL with comments: disabled
(cfg.SettingsFactory 213 ) Order SQL updates by primary key: disabled
(cfg.SettingsFactory 217 ) Order SQL inserts for batching: disabled
(cfg.SettingsFactory 386 ) Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
(ast.ASTQueryTranslatorFactory 24 ) Using ASTQueryTranslatorFactory
(cfg.SettingsFactory 225 ) Query language substitutions: {}
(cfg.SettingsFactory 230 ) JPA-QL strict compliance: disabled
(cfg.SettingsFactory 235 ) Second-level cache: enabled
(cfg.SettingsFactory 239 ) Query cache: disabled
(cfg.SettingsFactory 373 ) Cache provider: org.hibernate.cache.NoCacheProvider
(cfg.SettingsFactory 254 ) Optimize cache for minimal puts: disabled
(cfg.SettingsFactory 263 ) Structured second-level cache entries: disabled
(cfg.SettingsFactory 283 ) Echoing all SQL to stdout
(cfg.SettingsFactory 290 ) Statistics: disabled
(cfg.SettingsFactory 294 ) Deleted entity synthetic identifier rollback: disabled
(cfg.SettingsFactory 309 ) Default entity-mode: pojo
(cfg.SettingsFactory 313 ) Named query checking : enabled
(impl.SessionFactoryImpl 161 ) building session factory
(impl.SessionFactoryObjectFactory 82 ) Not binding factory to JNDI, no JNDI name configured
(hibernate3.HibernateTransactionManager 390 ) Using DataSource [org.apache.commons.dbcp.BasicDataSource@1cec874] of Hibernate SessionFactory for HibernateTransactionManager
(ehcache.EhCacheManagerFactoryBean 100 ) Initializing EHCache CacheManager
(config.ConfigurationFactory 127 ) No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/G:/haiwooo/workspace/sky/lib/ehcache-1.3.0.jar!/ehcache-failsafe.xml
===
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?
0 select to 1000=4829
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
1 select to 1000=3890
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
4 select to 1000=3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
9 select to 1000=3985
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
16 select to 1000=3953
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
25 select to 1000=3953
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
36 select to 1000=3984
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
49 select to 1000=3938
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
64 select to 1000=3922
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
81 select to 1000=3968
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
100 select to 1000=3922
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
121 select to 1000=3906
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
144 select to 1000=3922
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
169 select to 1000=3922
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
196 select to 1000=3938
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
225 select to 1000=3937
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
256 select to 1000=4016
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
289 select to 1000=4015
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
324 select to 1000=3907
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
361 select to 1000=3937
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
400 select to 1000=3891
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
441 select to 1000=3906
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
484 select to 1000=3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
529 select to 1000=3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
576 select to 1000=3906
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
625 select to 1000=3907
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
676 select to 1000=3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
729 select to 1000=3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
784 select to 1000=3890
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
841 select to 1000=3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
900 select to 1000=3922
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
961 select to 1000=3984
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
1024 select to 1000=3891
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
1089 select to 1000=3953
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
1156 select to 1000=3953
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
1225 select to 1000=3922
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
1296 select to 1000=3906
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
1369 select to 1000=3844
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
1444 select to 1000=3953
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
1521 select to 1000=3844
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
1600 select to 1000=3844
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
1681 select to 1000=3969
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
1764 select to 1000=4000
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
1849 select to 1000=3968
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
1936 select to 1000=3860
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
2025 select to 1000=3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
2116 select to 1000=3890
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
2209 select to 1000=3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
2304 select to 1000=3875
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times limit ?, ?
2401 select to 1000=3875
Hibernate: insert into test_table (date_Times, descriptions, names) values (?, ?, ?)
insert one=203
=================================================
测试结果
没有任何关联但表
普通查询 第一次 1300多毫秒
其他平均 450毫秒
使用like进行查询
第一次 4829毫秒
其他平均 4000毫秒
这是没有经过任何的优化过程
======================================================
Hibernate: insert into test_table (date_Times, descriptions, names) values (?, ?, ?)
Hibernate: select testtable0_.autoId as autoId9_, testtable0_.date_Times as date2_9_, testtable0_.descriptions as descript3_9_, testtable0_.names as names9_ from test_table testtable0_ where testtable0_.names like ? order by testtable0_.date_Times desc limit ?, ?
1 select to 1000=188
加了ehcahe二级缓存,第二查询用了 188毫秒
188毫秒==========这个才是可以接受
如果用户查询要花个4-5秒的时间等待那是一个很长的时间 或许蹲厕所的人不知道等厕所的人着急吧
但怎么在用户查询之前缓存呢
这个是个大问题
发表评论
-
以产品化开发的企业一直在自掘坟墓
2010-05-30 15:04 0随之扩招及培训机构,使得编程已经是纯粹的软件生产 ... -
你越软弱,别人越欺负你
2010-04-22 22:16 0你越软弱,别人越欺负你 或许很多人都很容易体会得到, ... -
如果有下辈子绝对不会当程序员
2009-11-15 22:06 1203如果有下辈子绝对不会当程序员 不是说不喜欢编成,但人总要吃饭 ... -
AOP(observable) aop的轮子,访问者结合代理模式的应用
2009-11-03 13:38 1482在Web系统中,经常用到session,然后再session的 ... -
最近好迷茫
2009-03-21 15:19 9671 第一次接触java是在上大学三年级,我也不知道为什么要选择 ... -
Struts2/webwork的分页实现(tag)
2009-03-21 14:57 2632在每次使用struts2/webwork中使用分页的时候都感觉 ... -
Struts2/webwork与tapestry的区别(二)
2009-02-04 20:23 2026五、从国际化管理角度来说 tapestry支持多个pro ... -
Struts2/webwork与tapestry的区别(一)
2009-02-04 19:30 1279用了webwork1.5年时间,也用了tapestry1年的时 ... -
各国皇帝号召武将大臣们进行练武表演
2008-12-13 23:57 887各国皇帝号召武将大臣们进行练武表演,一个皇帝就是太监侍候 ...
相关推荐
Struts2+Hibernate3.0+mysql5.0 二个完整整合在一起,并带了所需的lib 开发工具只用到了eclipse
1,这个项目是strut2.0 + hibernate3.0 + jquery.datatables+mysql 5.0实现的 hibernate分页(无排序,搜索,仅仅分页显示),服务器端分页在datatables上展现,有关 datatables的知识请关注它的官网...
一个用Struts+Hibernate+MySQL5.0写的OA系统,有些错误的地方没有来得及改
Springmvc5.0+Hibernate 5.2.12 + mysql jar整合 内置全套整合jar 测试可用 欢迎下载
在学习的时候为了搭建hibernate学习环境,费劲了脑筋,搭建成功了将过程记录下来,希望能带给其他人帮助。
环境:Windows Professional XP, JDK 1.6, Ant 1.7, jboss-4.2.1.GA, MySQL 5.0, 连接池C3P0. 使用步骤: 1. 下载之后先运行ant hibernatetool命令 2. 如果构建成功,那么运行ant compress命令 3. 把在lib目录下...
Hibernate5连接MySQL数据库的JAR包, 同时里面有Junit4所需的JAR包
本系统采用SSH核心技术,由于上传文件大小限制的原因!本包中没有保留SSH集成的包!自己导入SSH的包就可以运行此项目!!含有40多张页面!基本SSH的功能都运用进去了!前台+后台管理电子商务!可以实现购物车,订单...
环境:jdk5.0 eclipse3.2 struts1.1 spring1.2 hibernate3.1 mysql5.0 1. 新建一个starssh的web工程 2. 添加struts框架包。 3. 添加spring框架包。注意spring的配置文件要放到WEB-INF下。 4. 添加hibernate框架...
开发环境: <br>Eclipse3.01+myeclipse3.84+mysql5.0(oracle、ms sqlserver2000)。 <br>压缩包里包含了所有的组件、源码和SQL脚本以及工程文件。 <br>这个系统也是花了点时间和精力才做好的,现在把源码给...
用SWT和HIBERNATE在MYSQL5.0上做的一个车险计算器小程序,适合SWT、HIBERNATE入门,其中HIBERNATE查询部分都是用Criteria对象做的。 压缩包中的car文件夹是mysql的数据库,请导入到mysql中相应文件夹中 car.rar是...
显示界面,JSP 2.0 JAVA容器:Tomcat 5.X MVC构架:Struts 1.2 ORM工具:Hibernate 3 数据库:MySQL 5.0 编译IDE:MyEclipse 5.0
对象持久层框架Hibernate和业务逻辑层框架spring的源代码,相信会对大家有帮助的,另外上传的还有struts1和struts2的源码,需要的人请搜索
程序测试环境: MyEclipse8.5编程软件 + Win7操作系统 + MySql5.0数据库 本系统使用Struts2.0 + Spring2.0 +Hibernate 3.2 (即:SSH)及以上版本架构整合模式开发 本系统作为学生学习SSH很有参考价值,实现了图书...
2、开发环境 tomcat6.0 + jdk1.5 + eclipse + MySQL5.0 3、根据你的需要开放自主交易和寄售交易 4、在线订单即时提醒,让你更快,更准确的发货 5、整合易宝最新支付接口 6、在安装好数据库后依次将:数据表语句、...
java struts2+hibernate图书管理系统 系统开发环境: MyEclipse8.5 + Tomcat6.0 + mysql5.0 系统后台技术: struts 2 + hibernate 3 代码有详细注释和运行视频教程
程序测试环境: MyEclipse8.5编程软件 + Win7操作系统 + MySql5.0数据库 本系统使用Struts2.0 + Spring2.0 +Hibernate 3.2 (即:SSH)及以上版本架构整合模式开发 本系统作为学生学习SSH很有参考价值,实现了图书...
如果你没有安装mysql5.0,在安装数据库时,请把root密码设置为neostudio 如果已安装请找到HotelMaster\war\WEB-INFhotel-hibernate.xml该文件 修改数据库密码 <property name="driverClassName" value="com.mysql....
包括:测试mysql5.0连接的例子和hibernate应用的例子. 内附note目录:有详尽的说明. 注意: note中有一个错误: TestJDBC执行前,要把web-inf\lib\mysql dirver 复制到Tcomcat中的common\lib中才可以.
hibernate-release-5.0.7.Final压缩包 -document -lib -project 内部Hibernate依赖库: antlr-2.7.7.jar dom4j-1.6.1.jar geronimo-jta_1.1_spec-1.1.1.jar hibernate-commons-annotations-5.0.1.Final.jar ...