package?com.tuyu.sharding;

import?com.tuyu.sharding.entity.ActionLog;
import?com.tuyu.sharding.mappper.ActionLogMapper;
import?com.tuyu.sharding.repository.ActionLogRepository;
import?com.tuyu.sharding.service.ActionLogService;
import?com.tuyu.sharding.sql.SqlMapper;
import?com.tuyu.sharding.util.MyMapper;
import?org.mybatis.spring.annotation.MapperScan;
import?org.springframework.beans.factory.annotation.Autowired;
import?org.springframework.beans.factory.annotation.Qualifier;
import?org.springframework.boot.CommandLineRunner;
import?org.springframework.boot.SpringApplication;
import?org.springframework.boot.autoconfigure.SpringBootApplication;
import?org.springframework.boot.context.properties.ConfigurationProperties;
import?org.springframework.jdbc.core.JdbcTemplate;
import?org.springframework.scheduling.annotation.EnableScheduling;

import?javax.sql.DataSource;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.util.*;

@SpringBootApplication
@EnableScheduling
//@MapperScan（basePackages?=?“com.tuyu.sharding.mapper“markerInterface?=?MyMapper.class）
public?class?SpringBootShardingJdbcApplication{


	@Autowired
	ActionLogService?actionLogService;

	@Autowired
	SqlMapper?sqlMapper;

	@Autowired
	ActionLogRepository?actionLogRepository;

	@Autowired
			@Qualifier（“acDataSource“）
	DataSource?dataSource;

//	@Autowired
//	ActionLogMapper?actionLogMapper;

	public?static?void?main（String[]?args）?{
		SpringApplication.run（SpringBootShardingJdbcApplication.class?args）;
	}

//	@Override
//	public?void?run（String...?strings）?throws?Exception?{
//		//查詢邏輯表數據——測試通過
////		actionLogService.selectAll（）;
//		//根據時間和租戶Id查找所有行為日志
////		List?list?=?sqlMapper.selectAll（“20161226““20161227““30“）;
////		for?（ActionLog?actionLog?:?list）{
////			System.out.println（actionLog）;
////		}
//		//根據時間、租戶Id進行serv排行需要自己合并，排序
////		Listject>>?sorvSortlist?=?sqlMapper.servSortEnhance（“20161226““20161227““30“）;
////		Map?servSortMap?=?formateServOrApp（sorvSortlist“serv“）;
////		List>?sortList?=?new?ArrayList>（servSortMap.entrySet（））;
////		Collections.sort（sortList?new?Comparator>（）?{
////			@Override
////			public?int?compare（Map.Entry?o1?Map.Entry?o2）?{
////				return?o2.getValue（）.compareTo（o1.getValue（））;
////			}
////		}）;
////		int?i?=?0?;
////		Mapject>?returnMap?=?new?linkedHashMapject>（）;
////		for?（Map.Entry?entry?:?sortList）{
////			if?（i<5）{
////				returnMap.put（entry.getKey（）entry.getValue（））;
////				i++;
////			}
////		}
////		System.out.println（returnMap）;
//		//根據時間、租戶Id對于流量的serv進行排行
////		Listject>>?fluxServSortList?=?sqlMapper.fluxServSort（“20161226““20161227““30“）;
////		for（Mapject>?map?:?fluxServSortList）{
////			System.out.println（map）;
////		}
//		//用戶排行
////		List