資源簡介
java 分頁查詢
在開發過程中,經常做的一件事,也是最基本的事,就是從數據庫中查詢數據,然后在客戶端顯示出來。當數據少時,可以在一個頁面內顯示完成。然而,如果查詢記錄是幾百條、上千條呢?直接一個頁面顯示完全的話,表格得多長啊。。。。。。這時,我們可以用分頁技術。

代碼片段和文件信息
package?com.iflytek.alumnibook.config;
import?javax.sql.DataSource;
import?org.apache.commons.dbcp2.BasicDataSource;
import?org.apache.ibatis.logging.LogFactory;
import?org.apache.ibatis.session.Configuration;
import?org.mybatis.spring.SqlSessionFactoryBean;
import?org.mybatis.spring.mapper.MapperScannerConfigurer;
import?org.springframework.context.annotation.Bean;
import?org.springframework.context.annotation.ComponentScan;
import?org.springframework.jdbc.datasource.DataSourceTransactionManager;
import?org.springframework.transaction.annotation.EnableTransactionManagement;
import?com.iflytek.alumnibook.service.ServiceHook;
@org.springframework.context.annotation.Configuration
@ComponentScan(basePackageClasses={ServiceHook.class})
@EnableTransactionManagement
public?class?RootConfig?{
@Bean
public?DataSource?buildDataSource()?{
BasicDataSource?ds?=?new?BasicDataSource();
ds.setDriverClassName(“com.mysql.jdbc.Driver“);
ds.setUrl(“jdbc:mysql://localhost:3306/alumnibook“);
ds.setUsername(“root“);
ds.setPassword(“123456“);
return?ds;
}
@Bean
public?Configuration?buildMyBatisConfig()?{
// LogFactory.useLog4J2Logging();
Configuration?configuration?=?new?Configuration();
return?configuration;
}
@Bean(name=“sqlSessionFactory“)
public?SqlSessionFactoryBean?buildSessionFactory(
DataSource?datasource?Configuration?config)?{
SqlSessionFactoryBean?factory?=?new?SqlSessionFactoryBean();
factory.setDataSource(datasource);
factory.setConfiguration(config);
return?factory;
}
@Bean
public?MapperScannerConfigurer?buildMybatisMapperSacnConfig()?{
MapperScannerConfigurer?msc?=?new?MapperScannerConfigurer();
msc.setSqlSessionFactoryBeanName(“sqlSessionFactory“);
msc.setbasePackage(“com.iflytek.alumnibook.model.mapper“);
return?msc;
}
@Bean
public?DataSourceTransactionManager?transactionManager(
BasicDataSource?datasource)?{
return??new?DataSourceTransactionManager(datasource);
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????2031??2017-05-18?20:49??分頁查詢\java\config\RootConfig.java
?????文件????????810??2017-05-18?20:49??分頁查詢\java\config\WebAppInitializer.java
?????文件???????1363??2017-05-18?20:49??分頁查詢\java\config\WebConfig.java
?????文件???????2786??2017-05-18?20:49??分頁查詢\java\controller\WorkerController.java
?????文件????????704??2017-05-18?20:49??分頁查詢\java\model\mapper\WorkerMapper.java
?????文件???????1451??2017-05-18?20:49??分頁查詢\java\model\WorkerModel.java
?????文件????????942??2017-05-18?20:49??分頁查詢\java\service\WorkerService.java
?????文件???????1324??2017-05-18?20:49??分頁查詢\java\util\Page.java
?????文件???????1932??2017-05-18?20:49??分頁查詢\sql\worker.sql
?????文件???????2354??2017-05-18?20:49??分頁查詢\web\showWorkerListToPage.jsp
?????目錄??????????0??2017-05-18?20:49??分頁查詢\java\model\mapper
?????目錄??????????0??2017-05-18?20:49??分頁查詢\java\config
?????目錄??????????0??2017-05-18?20:49??分頁查詢\java\controller
?????目錄??????????0??2017-05-18?20:49??分頁查詢\java\model
?????目錄??????????0??2017-05-18?20:49??分頁查詢\java\service
?????目錄??????????0??2017-05-18?20:49??分頁查詢\java\util
?????目錄??????????0??2017-05-18?20:49??分頁查詢\java
?????目錄??????????0??2017-05-18?20:49??分頁查詢\sql
?????目錄??????????0??2017-05-18?20:49??分頁查詢\web
?????目錄??????????0??2017-05-18?20:49??分頁查詢
-----------?---------??----------?-----??----
????????????????15697????????????????????20
- 上一篇:android studio 天氣預報
- 下一篇:java實習生實習報告
評論
共有 條評論