CRMFileRead.java 3.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889
  1. package com.miniframe.tools.file;
  2. import com.google.gson.Gson;
  3. import com.miniframe.core.ext.UtilTools;
  4. import com.miniframe.model.mdo.MdoProComval;
  5. import com.miniframe.model.mdo.MdoProComvalSQLBuilder;
  6. import com.miniframe.model.mdo.dao.MdoProComvalMapper;
  7. import com.miniframe.websocket.WebsocketEndPoint;
  8. import java.io.BufferedReader;
  9. import java.io.File;
  10. import java.io.FileReader;
  11. import java.io.IOException;
  12. import java.util.List;
  13. public class CRMFileRead {
  14. public static void readFile(File file, String pid) {
  15. String line1="";
  16. MdoProComvalMapper comvalDao = UtilTools.getBean(MdoProComvalMapper.class);
  17. MdoProComvalSQLBuilder sb =new MdoProComvalSQLBuilder();
  18. MdoProComvalSQLBuilder.Criteria sc = sb.createCriteria();
  19. sc.andPidEqualTo(pid);
  20. sc.andTypeEqualTo(2);
  21. sb.setOrderByClause("step asc");
  22. List<MdoProComval> comvals =comvalDao.selectByExample(sb);
  23. int con =0;
  24. if(comvals!=null||!comvals.isEmpty()){
  25. con=comvals.size();
  26. }
  27. int i= 0;
  28. String line;
  29. // 使用try-with-resources语句确保资源被正确关闭
  30. try (BufferedReader br = new BufferedReader(new FileReader(file))) {
  31. int size=0;
  32. // 逐行读取,直到文件末尾
  33. while ((line = br.readLine()) != null) {
  34. line=line.trim().replaceAll("\\s+"," ");//替换多个空格为一个空格
  35. if(line.startsWith("Zone")||line.startsWith("Title")){
  36. continue;
  37. }
  38. if(line.startsWith("Variables")){
  39. // line=line.replace("\"","");
  40. // line=line.replace("Variables =","").trim();
  41. continue;
  42. }
  43. if(line.startsWith("Nodes")){
  44. // line=line.replace("Nodes = ","").trim();
  45. size =Integer.valueOf(line.split(" ")[0]);
  46. continue;
  47. }
  48. if(i>=size){
  49. break;
  50. }
  51. if(i>con && i<size){
  52. String tvals=line.trim().replaceAll("\\s+"," ");//替换多个空格为一个空格
  53. String[] vals = tvals.split(" ");
  54. MdoProComval comval =new MdoProComval();
  55. comval.setId(UtilTools.getUUid());
  56. comval.setPid(pid);
  57. comval.setStep(i);
  58. comval.setVars("v1 v2");
  59. comval.setVals(vals[0]+" "+vals[1]);
  60. comval.setType(2);//"1-列表数据 2-几何数据 3-压力数据"
  61. comvalDao.insert(comval);
  62. WebsocketEndPoint webs = (WebsocketEndPoint) UtilTools.getBean("websocketEndPoint");
  63. Gson gson = new Gson();
  64. webs.sendMessageToUser(String.valueOf(pid),gson.toJson(comval));
  65. MdoProComval comval2 =new MdoProComval();
  66. comval2.setId(UtilTools.getUUid());
  67. comval2.setPid(pid);
  68. comval2.setStep(i);
  69. comval2.setVars("v1 v2");
  70. comval2.setVals(vals[0]+" "+vals[9]);
  71. comval2.setType(3);//"1-列表数据 2-几何数据 3-压力数据"
  72. comvalDao.insert(comval2);
  73. webs.sendMessageToUser(String.valueOf(pid),gson.toJson(comval2));
  74. }
  75. i++;
  76. }
  77. } catch (IOException e) {
  78. // 异常处理
  79. e.printStackTrace();
  80. }
  81. }
  82. }