CommonTest.java 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626
  1. package com.izouma.nineth;
  2. import com.alibaba.excel.EasyExcel;
  3. import com.alibaba.fastjson.JSON;
  4. import com.alibaba.fastjson.serializer.SerializerFeature;
  5. import com.github.kevinsawicki.http.HttpRequest;
  6. import com.google.common.base.Splitter;
  7. import com.izouma.nineth.config.Constants;
  8. import com.izouma.nineth.domain.BaseEntity;
  9. import com.izouma.nineth.domain.BlindBoxItem;
  10. import com.izouma.nineth.domain.SettleRecord;
  11. import com.izouma.nineth.domain.User;
  12. import com.izouma.nineth.dto.PageQuery;
  13. import com.izouma.nineth.dto.SandPaySettle;
  14. import com.izouma.nineth.dto.UserWithdraw;
  15. import com.izouma.nineth.utils.AESEncryptUtil;
  16. import com.izouma.nineth.utils.TokenUtils;
  17. import com.izouma.nineth.web.BaseController;
  18. import io.ipfs.api.IPFS;
  19. import io.ipfs.api.MerkleNode;
  20. import io.ipfs.api.NamedStreamable;
  21. import io.ipfs.multihash.Multihash;
  22. import io.jsonwebtoken.Claims;
  23. import io.jsonwebtoken.Jwts;
  24. import io.jsonwebtoken.SignatureAlgorithm;
  25. import lombok.SneakyThrows;
  26. import net.coobird.thumbnailator.Thumbnails;
  27. import org.apache.commons.codec.EncoderException;
  28. import org.apache.commons.codec.net.URLCodec;
  29. import org.apache.commons.io.FileUtils;
  30. import org.apache.commons.lang3.RandomStringUtils;
  31. import org.apache.commons.lang3.RandomUtils;
  32. import org.apache.commons.lang3.Range;
  33. import org.apache.commons.text.CaseUtils;
  34. import org.apache.http.NameValuePair;
  35. import org.apache.http.client.utils.URLEncodedUtils;
  36. import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
  37. import org.apache.poi.ss.usermodel.*;
  38. import org.apache.poi.util.TempFile;
  39. import org.bouncycastle.util.encoders.Base64;
  40. import org.bytedeco.javacv.FFmpegFrameGrabber;
  41. import org.bytedeco.javacv.Frame;
  42. import org.bytedeco.javacv.Java2DFrameConverter;
  43. import org.junit.jupiter.api.Test;
  44. import org.libjpegturbo.turbojpeg.processor.api.ImageProcessException;
  45. import org.libjpegturbo.turbojpeg.processor.api.ImageProcessInfo;
  46. import org.libjpegturbo.turbojpeg.processor.api.ImageProcessor;
  47. import org.libjpegturbo.turbojpeg.processor.impl.ImageProcessorImpl;
  48. import org.libjpegturbo.turbojpeg.processor.utils.ImageProcessorUtils;
  49. import org.pngquant.PngQuant;
  50. import org.reflections.ReflectionUtils;
  51. import org.reflections.Reflections;
  52. import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;
  53. import org.springframework.util.FileCopyUtils;
  54. import org.springframework.web.bind.annotation.GetMapping;
  55. import org.springframework.web.bind.annotation.PostMapping;
  56. import org.springframework.web.bind.annotation.RequestMapping;
  57. import org.springframework.web.bind.annotation.RestController;
  58. import javax.imageio.ImageIO;
  59. import java.awt.*;
  60. import java.awt.Font;
  61. import java.awt.font.FontRenderContext;
  62. import java.awt.geom.AffineTransform;
  63. import java.awt.image.BufferedImage;
  64. import java.io.*;
  65. import java.lang.reflect.Method;
  66. import java.math.BigDecimal;
  67. import java.math.BigInteger;
  68. import java.math.RoundingMode;
  69. import java.nio.charset.StandardCharsets;
  70. import java.nio.file.Files;
  71. import java.nio.file.Paths;
  72. import java.security.NoSuchAlgorithmException;
  73. import java.text.DecimalFormat;
  74. import java.text.DecimalFormatSymbols;
  75. import java.text.NumberFormat;
  76. import java.util.List;
  77. import java.util.*;
  78. import java.util.concurrent.ExecutorService;
  79. import java.util.concurrent.Executors;
  80. import java.util.concurrent.ForkJoinPool;
  81. import java.util.regex.Matcher;
  82. import java.util.regex.Pattern;
  83. import java.util.stream.IntStream;
  84. import static java.nio.file.StandardOpenOption.CREATE;
  85. import static java.nio.file.StandardOpenOption.TRUNCATE_EXISTING;
  86. public class CommonTest {
  87. @Test
  88. public void getGenericsClass() {
  89. List<User> data = new ArrayList<>();
  90. data.add(new User());
  91. System.out.println(data.get(0).getClass().getSimpleName());
  92. System.out.println(data.getClass());
  93. Reflections reflections = new Reflections(this.getClass().getPackage().getName() + ".domain");
  94. Set<Class<? extends BaseEntity>> allClasses = reflections.getSubTypesOf(BaseEntity.class);
  95. for (Class<? extends BaseEntity> allClass : allClasses) {
  96. System.out.println(allClass.getName());
  97. }
  98. }
  99. @Test
  100. public void getapis() {
  101. List<Map<String, String>> entities = new ArrayList<>();
  102. Reflections classReflections = new Reflections(this.getClass().getPackage().getName());
  103. Set<Class<? extends BaseController>> controllers = classReflections.getSubTypesOf(BaseController.class);
  104. Set<Class<? extends BaseController>> list = ReflectionUtils
  105. .getAll(controllers, ReflectionUtils.withAnnotation(RestController.class));
  106. System.out.println(list);
  107. for (Class<? extends BaseController> aClass : list) {
  108. RequestMapping requestMapping = aClass.getAnnotation(RequestMapping.class);
  109. String baseUrl = requestMapping.value()[0];
  110. for (Method method : ReflectionUtils.getMethods(aClass, ReflectionUtils.withAnnotation(GetMapping.class))) {
  111. GetMapping getMapping = method.getAnnotation(GetMapping.class);
  112. System.out.println(getMapping.value()[0]);
  113. }
  114. for (Method method : ReflectionUtils
  115. .getMethods(aClass, ReflectionUtils.withAnnotation(PostMapping.class))) {
  116. PostMapping postMapping = method.getAnnotation(PostMapping.class);
  117. System.out.println(postMapping.value()[0]);
  118. }
  119. }
  120. }
  121. @Test
  122. public void testCaseUtils() {
  123. System.out.println(CaseUtils.toCamelCase("test_Model", true, '_'));
  124. }
  125. @Test
  126. public void testMeasureText() throws IOException, FontFormatException {
  127. AffineTransform affinetransform = new AffineTransform();
  128. FontRenderContext frc = new FontRenderContext(affinetransform, true, true);
  129. Font font = Font.createFont(Font.TRUETYPE_FONT, this.getClass()
  130. .getResourceAsStream("/font/SourceHanSansCN-Normal.ttf"));
  131. System.out.println((int) (font.deriveFont(14f).getStringBounds("aaa", frc).getWidth()));
  132. }
  133. @Test
  134. public void testIdNoRegexp() {
  135. boolean b = Pattern
  136. .matches("^[1-9]\\d{7}((0\\d)|(1[0-2]))(([0-2]\\d)|3[0-1])\\d{3}$|^[1-9]\\d{5}[1-9]\\d{3}((0\\d)|(1[0-2]))(([0-2]\\d)|3[0-1])\\d{3}[0-9xX]$", "32100219950830461X");
  137. System.out.println(b);
  138. }
  139. @Test
  140. public void tesSms() throws IOException {
  141. Reflections reflections = new Reflections(this.getClass().getPackage().getName() + ".enums");
  142. Set<Class<? extends Enum>> entitySet = reflections.getSubTypesOf(Enum.class);
  143. StringBuilder idxJs = new StringBuilder();
  144. for (Class<? extends Enum> entity : entitySet) {
  145. idxJs.append("import ").append(entity.getSimpleName()).append(" from \"./").append(entity.getSimpleName())
  146. .append("\";\n");
  147. StringBuilder str = new StringBuilder("export default {\n");
  148. for (Enum enumConstant : entity.getEnumConstants()) {
  149. str.append(" ").append(enumConstant.name()).append(": \"").append(enumConstant.name())
  150. .append("\",\n");
  151. }
  152. str.append("}");
  153. Files.write(Paths.get(System.getProperty("user.dir"), "src", "main", "vue", "src", "constants", entity
  154. .getSimpleName() + ".js"), str.toString()
  155. .getBytes(StandardCharsets.UTF_8), CREATE, TRUNCATE_EXISTING);
  156. Files.write(Paths.get(System.getProperty("user.dir"), "src", "main", "zmj_mp", "src", "constants", entity
  157. .getSimpleName() + ".js"), str.toString()
  158. .getBytes(StandardCharsets.UTF_8), CREATE, TRUNCATE_EXISTING);
  159. }
  160. idxJs.append("export default {\n");
  161. for (Class<? extends Enum> entity : entitySet) {
  162. idxJs.append(" ").append(entity.getSimpleName()).append(": ").append(entity.getSimpleName())
  163. .append(",\n");
  164. }
  165. idxJs.append("}");
  166. System.out.println(idxJs.toString());
  167. Files.write(Paths
  168. .get(System.getProperty("user.dir"), "src", "main", "vue", "src", "constants", "index.js"), idxJs
  169. .toString().getBytes(StandardCharsets.UTF_8), CREATE, TRUNCATE_EXISTING);
  170. Files.write(Paths
  171. .get(System.getProperty("user.dir"), "src", "main", "zmj_mp", "src", "constants", "index.js"), idxJs
  172. .toString().getBytes(StandardCharsets.UTF_8), CREATE, TRUNCATE_EXISTING);
  173. }
  174. @Test
  175. public void gen() {
  176. System.out.println(RandomStringUtils.randomAlphabetic(32));
  177. }
  178. @Test
  179. public void password() {
  180. String password = new BCryptPasswordEncoder().encode("123456");
  181. System.out.println(password);
  182. }
  183. @SneakyThrows
  184. @Test
  185. public void pngquant() {
  186. PngQuant pngQuant = new PngQuant();
  187. ImageIO.write(pngQuant
  188. .getRemapped(ImageIO.read(new File("/Users/drew/Downloads/2021-11-01-18-07-04JCDfFxKb.HEIC"))),
  189. "jpg", new File("/Users/drew/Downloads/111.jpg"));
  190. }
  191. @SneakyThrows
  192. @Test
  193. public void mozjpeg() {
  194. File out = TempFile.createTempFile("kljasdlkhfasldg", ".jpg");
  195. ImageProcessor processor = new ImageProcessorImpl();
  196. ImageProcessInfo processInfo = ImageProcessInfo.fromMap(ImageProcessorUtils.compressImage(processor,
  197. new File("/Users/drew/Downloads/2020-09-08-17-07-21zwBhaHeQ.jpg"),
  198. out, 75));
  199. FileCopyUtils.copy(out, new File("/Users/drew/Desktop/111.jpg"));
  200. System.out.println(out);
  201. }
  202. @Test
  203. public void thumbnailator() throws IOException, ImageProcessException {
  204. Thumbnails.of(new File("/Users/drew/Downloads/2021-11-01-17-47-55zMwbSlgJ.jpeg"))
  205. .size(3000, 3000)
  206. .outputFormat("jpg")
  207. .toFile("/Users/drew/Desktop/1.jpg");
  208. PngQuant pngQuant = new PngQuant();
  209. ImageIO.write(pngQuant
  210. .getRemapped(ImageIO.read(new File("/Users/drew/Desktop/1.jpg"))),
  211. "jpg", new File("/Users/drew/Desktop/2.jpg"));
  212. ImageProcessor processor = new ImageProcessorImpl();
  213. ImageProcessInfo processInfo = ImageProcessInfo.fromMap(ImageProcessorUtils.compressImage(processor,
  214. new File("/Users/drew/Desktop/1.jpg"),
  215. new File("/Users/drew/Desktop/3.jpg"), 75));
  216. }
  217. @Test
  218. public void base64() {
  219. System.out.println(Base64.decode("e6e6vQJYhGmIkcA1pfnsipTovp10wJ"));
  220. }
  221. @Test
  222. public void resolveUrl() {
  223. try {
  224. System.out.println(new URLCodec().encode("http://www.baidu.com"));
  225. } catch (EncoderException e) {
  226. e.printStackTrace();
  227. }
  228. }
  229. @Test
  230. public void testIPFS() throws IOException {
  231. IPFS ipfs = new IPFS("121.40.132.44", 5001);
  232. HttpRequest request = HttpRequest.get("https://awesomeadmin.oss-cn-hangzhou.aliyuncs.com/image/2021-10-21-16-44-52kZqxuwhH.gif");
  233. File file = File.createTempFile("ipfs", ".tmp");
  234. request.receive(file);
  235. NamedStreamable.FileWrapper file1 = new NamedStreamable.FileWrapper(file);
  236. MerkleNode put = ipfs.add(file1).get(0);
  237. Multihash multihash = ipfs.pin.add(put.hash).get(0);
  238. System.out.println(put.hash.toBase58());
  239. System.out.println(multihash.toBase58());
  240. }
  241. @Test
  242. public void testWin() {
  243. List<BlindBoxItem> items = new ArrayList<>();
  244. items.add(BlindBoxItem.builder()
  245. .name("普通1")
  246. .total(100)
  247. .stock(100)
  248. .build());
  249. items.add(BlindBoxItem.builder()
  250. .name("普通2")
  251. .total(100)
  252. .stock(100)
  253. .build());
  254. items.add(BlindBoxItem.builder()
  255. .name("稀有1")
  256. .total(5)
  257. .stock(5)
  258. .rare(true)
  259. .build());
  260. items.add(BlindBoxItem.builder()
  261. .name("稀有2")
  262. .total(5)
  263. .stock(5)
  264. .rare(true)
  265. .build());
  266. for (int k = 0; k < items.stream().mapToInt(BlindBoxItem::getTotal).sum(); k++) {
  267. Map<BlindBoxItem, Range<Integer>> randomRange = new HashMap<>();
  268. int c = 0, sum = 0;
  269. for (BlindBoxItem item : items) {
  270. randomRange.put(item, Range.between(c, c + item.getStock()));
  271. c += item.getStock();
  272. sum += item.getStock();
  273. }
  274. boolean win = false;
  275. int retry = 0;
  276. BlindBoxItem winItem = null;
  277. while (winItem == null) {
  278. int rand = RandomUtils.nextInt(0, sum + 1);
  279. for (Map.Entry<BlindBoxItem, Range<Integer>> entry : randomRange.entrySet()) {
  280. BlindBoxItem item = entry.getKey();
  281. Range<Integer> range = entry.getValue();
  282. if (rand >= range.getMinimum() && rand < range.getMaximum()) {
  283. int total = items.stream().filter(i -> !i.isRare())
  284. .mapToInt(BlindBoxItem::getTotal).sum();
  285. int stock = items.stream().filter(i -> !i.isRare())
  286. .mapToInt(BlindBoxItem::getStock).sum();
  287. if (item.isRare()) {
  288. double nRate = stock / (double) total;
  289. double rRate = (item.getStock() - 1) / (double) item.getTotal();
  290. if (Math.abs(nRate - rRate) < (1 / (double) item.getTotal()) || retry > 1 || rRate == 0) {
  291. if (!(nRate > 0.1 && item.getStock() == 1)) {
  292. winItem = item;
  293. }
  294. } else {
  295. retry++;
  296. }
  297. } else {
  298. double nRate = (stock - 1) / (double) total;
  299. double rRate = item.getStock() / (double) item.getTotal();
  300. if (Math.abs(nRate - rRate) < 0.2 || retry > 1 || nRate == 0) {
  301. winItem = item;
  302. } else {
  303. retry++;
  304. }
  305. }
  306. }
  307. }
  308. }
  309. winItem.setStock(winItem.getStock() - 1);
  310. System.out.println(winItem.getName() + (winItem.isRare() ? "\t+++" : ""));
  311. }
  312. }
  313. @Test
  314. public void testGrabFrame() throws IOException {
  315. FFmpegFrameGrabber frameGrabber = new FFmpegFrameGrabber("/Users/drew/Downloads/video1627914878375.mp4");
  316. frameGrabber.start();
  317. Java2DFrameConverter aa = new Java2DFrameConverter();
  318. int length = frameGrabber.getLengthInVideoFrames();
  319. Frame frame = null;
  320. int i = 0;
  321. while (frame == null && i < length) {
  322. frame = frameGrabber.grabKeyFrame();
  323. i++;
  324. }
  325. Objects.requireNonNull(frame);
  326. BufferedImage thumbBi = aa.convert(frame);
  327. ImageIO.write(thumbBi, "jpg", new File("/Users/drew/Desktop/1.jpg"));
  328. }
  329. @Test
  330. public void testQuality() throws IOException {
  331. Thumbnails.of("/Users/drew/Desktop/2021-11-04-11-28-36VAOoasUd.jpeg")
  332. .size(1000, 1000)
  333. .outputFormat("jpg")
  334. .outputQuality(1)
  335. .toFile("/Users/drew/Desktop/1.jpg");
  336. Thumbnails.of("/Users/drew/Desktop/2021-11-04-11-28-36VAOoasUd.jpeg")
  337. .size(1000, 1000)
  338. .outputFormat("jpg")
  339. .outputQuality(0.6)
  340. .toFile("/Users/drew/Desktop/2.jpg");
  341. }
  342. @Test
  343. public void testJwt() {
  344. String token = Jwts.builder()
  345. .setClaims(new HashMap<>())
  346. .setSubject("15077886171")
  347. .setIssuedAt(new Date())
  348. .setExpiration(new Date(new Date().getTime() + 10 * 60 * 1000)) //10min
  349. .signWith(SignatureAlgorithm.HS512, Constants.SMS_TOKEN_SECRET)
  350. .compact();
  351. System.out.println(token);
  352. Claims claims = Jwts.parser()
  353. .setSigningKey(Constants.SMS_TOKEN_SECRET)
  354. .parseClaimsJws(token)
  355. .getBody();
  356. System.out.println(claims.getSubject());
  357. System.out.println(claims.getExpiration());
  358. }
  359. @Test
  360. public void testReplace() {
  361. System.out.println("15077886171".replaceAll("(?<=.{3}).*(?=.{4})", "**"));
  362. }
  363. @Test
  364. public void sfsdf() {
  365. System.out.println(BigDecimal.valueOf(11111110.5).setScale(2, RoundingMode.HALF_UP).toPlainString());
  366. }
  367. @Test
  368. public void random256() throws NoSuchAlgorithmException {
  369. String tokenId = TokenUtils.genTokenId();
  370. System.out.println(tokenId);
  371. System.out.println(new BigInteger(tokenId, 16));
  372. }
  373. @Test
  374. public void dd() throws IOException {
  375. String[] arr1 = FileUtils.readFileToString(new File("/Users/drew/Desktop/未命名文件夹 2/111")).split("\n");
  376. List<String> arr2 = Arrays.asList(FileUtils.readFileToString(new File("/Users/drew/Desktop/未命名文件夹 2/222"))
  377. .split("\n"));
  378. for (String s : arr1) {
  379. if (!arr2.contains(s)) {
  380. System.out.println(s);
  381. }
  382. }
  383. }
  384. @Test
  385. public void jj() {
  386. final int parallelism = 4;
  387. ForkJoinPool forkJoinPool = null;
  388. try {
  389. forkJoinPool = new ForkJoinPool(parallelism);
  390. forkJoinPool.submit(() ->
  391. // Parallel task here, for example
  392. IntStream.range(1, 1_000_000).parallel()
  393. .forEach(i -> {
  394. })
  395. );
  396. } finally {
  397. if (forkJoinPool != null) {
  398. forkJoinPool.shutdown();
  399. }
  400. }
  401. }
  402. @Test
  403. public void testnewSingleThreadScheduledExecutor() throws InterruptedException {
  404. ExecutorService service = Executors.newFixedThreadPool(10);
  405. final int[] c = {0};
  406. for (int i = 0; i < 1000; i++) {
  407. service.submit(new Runnable() {
  408. @SneakyThrows
  409. @Override
  410. public void run() {
  411. Thread.sleep(300);
  412. System.out.println(++c[0]);
  413. }
  414. });
  415. }
  416. Thread.sleep(20000);
  417. }
  418. @Test
  419. public void testaes() throws Exception {
  420. String encrypted = "ccd97379f001d47895eb4293144b74f28de4fcf5b56daf4ce73d2db34f381984b2c2260f821593968e387dccdc11713a5b558a571b17aaae3e9e91a0b9dc576e";
  421. String qs = AESEncryptUtil.decrypt(encrypted);
  422. System.out.println(qs);
  423. List<NameValuePair> list = URLEncodedUtils.parse(qs, StandardCharsets.UTF_8);
  424. System.out.println(JSON.toJSONString(list, SerializerFeature.PrettyFormat));
  425. final Map<String, String> map = Splitter.on('&').trimResults().withKeyValueSeparator('=').split(qs);
  426. System.out.println(map);
  427. }
  428. @Test
  429. public void aasdf() {
  430. System.out.println(new BCryptPasswordEncoder().matches("123456", "$2a$10$hYKQk3SKDqpK2QPDFqGdLekKWFcHs8rvou0hV4TxFy.ylL8PTBo5a"));
  431. }
  432. @Test
  433. public void testBCrypt() {
  434. BCryptPasswordEncoder encoder1 = new BCryptPasswordEncoder(4);
  435. BCryptPasswordEncoder encoder2 = new BCryptPasswordEncoder(4);
  436. String pwd = "$2a$10$oAWnGIHR2Cvc0BsMN7YCtOjvXsBLBygYxiVG3E1fuUmhM3sEOYhQe";
  437. System.out.println(encoder1.matches("123456", pwd));
  438. System.out.println(encoder2.matches("123456", pwd));
  439. System.out.println(encoder1.matches("1234561", pwd));
  440. System.out.println(encoder2.matches("1234561", pwd));
  441. long encode1 = 0;
  442. long match1 = 0;
  443. for (int i = 0; i < 10; i++) {
  444. long t = System.currentTimeMillis();
  445. encoder1.encode("123456");
  446. encode1 += System.currentTimeMillis() - t;
  447. t = System.currentTimeMillis();
  448. encoder1.matches("123456", pwd);
  449. match1 += System.currentTimeMillis() - t;
  450. }
  451. System.out.println("avg encode = " + encode1 / 10 + "ms");
  452. System.out.println("avg match = " + match1 / 10 + "ms");
  453. long encode2 = 0;
  454. long match2 = 0;
  455. for (int i = 0; i < 10; i++) {
  456. long t = System.currentTimeMillis();
  457. encoder2.encode("123456");
  458. encode2 += System.currentTimeMillis() - t;
  459. t = System.currentTimeMillis();
  460. encoder2.matches("123456", pwd);
  461. match2 += System.currentTimeMillis() - t;
  462. }
  463. System.out.println("avg encode = " + encode2 / 10 + "ms");
  464. System.out.println("avg match = " + match2 / 10 + "ms");
  465. }
  466. @Test
  467. public void testParseToken() {
  468. long t1 = 0;
  469. long t2 = 0;
  470. for (int i = 0; i < 1000; i++) {
  471. long t = System.currentTimeMillis();
  472. String token = Jwts.builder()
  473. .setClaims(new HashMap<>())
  474. .setSubject("a" + i)
  475. .setIssuedAt(new Date())
  476. .setExpiration(new Date(new Date().getTime() + 10000000))
  477. .signWith(SignatureAlgorithm.HS256, "123456")
  478. .compact();
  479. t1 += System.currentTimeMillis() - t;
  480. System.out.println(token);
  481. t = System.currentTimeMillis();
  482. Claims claims = Jwts.parser()
  483. .setSigningKey("123456")
  484. .parseClaimsJws(token)
  485. .getBody();
  486. System.out.println(claims.getSubject());
  487. t2 += System.currentTimeMillis() - t;
  488. }
  489. System.out.println(t1);
  490. System.out.println(t2);
  491. System.out.println(t1 / 1000);
  492. System.out.println(t2 / 1000);
  493. }
  494. @Test
  495. public void testHashCode() {
  496. long t = System.currentTimeMillis();
  497. new PageQuery().hashCode();
  498. System.out.println(System.currentTimeMillis() - t);
  499. }
  500. @Test
  501. public void testversion() {
  502. String version = "1.2.321";
  503. String[] arr = version.split("\\.");
  504. StringBuilder str = new StringBuilder();
  505. for (int i = 0; i < arr.length; i++) {
  506. str.insert(0, String.format("%03d", Integer.parseInt(arr[arr.length - 1 - i])));
  507. }
  508. System.out.println(Integer.parseInt(str.toString()));
  509. }
  510. @Test
  511. public void testNumberFormat() {
  512. DecimalFormat df = new DecimalFormat("000000", DecimalFormatSymbols.getInstance(Locale.US));
  513. System.out.println(df.format(new BigDecimal("199.11"))); // prints: 001.0
  514. }
  515. @Test
  516. public void testWriteExcel() throws IOException, InvalidFormatException {
  517. // Creating file object of existing excel file
  518. File xlsxFile = new File("/Users/drew/Downloads/批量付款到对私银行账户模板的副本.xls");
  519. InputStream inputStream = getClass().getResourceAsStream("/批量付款到对私银行账户模板.xls");
  520. //Creating workbook from input stream
  521. Workbook workbook = WorkbookFactory.create(inputStream);
  522. //Reading first sheet of excel file
  523. Sheet sheet = workbook.getSheetAt(0);
  524. for (int i = 0; i < 100; i++) {
  525. Row row = sheet.getRow(i + 1);
  526. if (row == null) {
  527. row = sheet.createRow(i + 1);
  528. }
  529. Optional.ofNullable(row.getCell(1)).orElse(row.createCell(1)).setCellValue("1");
  530. Optional.ofNullable(row.getCell(2)).orElse(row.createCell(2)).setCellValue("2");
  531. Optional.ofNullable(row.getCell(3)).orElse(row.createCell(3))
  532. .setCellValue(new BigDecimal("1").doubleValue());
  533. }
  534. //Close input stream
  535. inputStream.close();
  536. FileOutputStream os = new FileOutputStream(xlsxFile);
  537. workbook.write(os);
  538. //Close the workbook and output stream
  539. workbook.close();
  540. }
  541. @Test
  542. public void testSandImport() {
  543. List<SandPaySettle> failSettleList = EasyExcel.read("/Users/drew/Downloads/0411失败.csv")
  544. .head(SandPaySettle.class).sheet()
  545. .doReadSync();
  546. List<UserWithdraw> withdrawList = EasyExcel.read("/Users/drew/Downloads/0411.xlsx")
  547. .head(UserWithdraw.class).sheet()
  548. .doReadSync();
  549. List<UserWithdraw> failWithdraw = new ArrayList<>();
  550. for (SandPaySettle sandPaySettle : failSettleList) {
  551. withdrawList.stream().filter(i -> i.getBankNo().equals(sandPaySettle.getBankNo()))
  552. .findAny().ifPresent(failWithdraw::add);
  553. }
  554. System.out.println(failSettleList.size());
  555. System.out.println(failWithdraw.size());
  556. }
  557. }