实现按id递增顺序依次读取数据

来源：互联网发布：js formatnumber函数编辑：程序博客网时间：2024/05/02 22:51

@RunWith(SpringJUnit4ClassRunner.class)@ContextConfiguration("classpath:config/spring-common.xml")public class UserTest {@Resourceprivate UserService userService;@Resourceprivate JdbcTemplate jdbcTemplate;private static final String query_sql = "select * from user where access = 0 order by ID limit 20";@Testpublic void testFindAll(){/*List<Map<String, Object>> list = jdbcTemplate.queryForList(query_sql);System.out.println(Thread.currentThread().getName()+":"+list.size());for(Map<String, Object> map : list) {int user = (Integer) map.get("id");System.out.println(user);}*/while(true){List<Map<String, Object>> list = jdbcTemplate.queryForList(query_sql);System.out.println(Thread.currentThread().getName()+":"+list.size());if(null == list || list.isEmpty()) {break;}for(Map<String, Object> map : list) {int id = (Integer) map.get("ID");System.out.println(id);try {// 锁定if(!lock(id)) {System.out.println("cant lock the execute plan, " + id);continue;}} catch(Exception e) {System.out.println("error at process " + id);}}/*try {Thread.sleep(5000);} catch (InterruptedException e) {e.printStackTrace();}*/}}private static final String modify_lock_sql = "update user set access = 1 where access = 0 and ID = ?";    //可实现按id递增每次取出20条数据private boolean lock(int id) {int result = jdbcTemplate.update(modify_lock_sql, id);if(1 == result) {return true;}return false;}}

<bean id="testdataSource"class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName" value="com.mysql.jdbc.Driver" /><property name="url" value="jdbc:mysql://localhost:3306/shop?characterEncoding=utf-8" /><property name="username" value="root" /><property name="password" value="" /></bean><!-- 1. 数据源 : JDBC --><bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">          <property name="dataSource" ref="testdataSource"></property></bean>  <bean id="dataSource"class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName" value="com.mysql.jdbc.Driver" /><property name="url" value="jdbc:mysql://localhost:3306/shop?characterEncoding=utf-8" /><property name="username" value="root" /><property name="password" value="" /></bean><!-- 2. 数据源 : mybatis --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource"></property><property name="configLocation" value="classpath:config/mybatis-config.xml" /> </bean>

0 0